using System; using System.Data; using System.Text; using System.Data.SqlClient; using CallCenterApi.DB; namespace CallCenterApi.DAL { /// /// 数据访问类:T_Wo_WorkOrder /// public partial class T_Wo_WorkOrder { public T_Wo_WorkOrder() { } #region BasicMethod /// /// 是否存在该记录 /// public bool Exists(long ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) from T_Wo_WorkOrder"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.BigInt) }; parameters[0].Value = ID; return DbHelperSQL.Exists(strSql.ToString(), parameters); } /// /// 是否存在该记录 /// public bool Exists(string OrderID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) from T_Wo_WorkOrder"); strSql.Append(" where WorkOrderID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.BigInt) }; parameters[0].Value = OrderID; return DbHelperSQL.Exists(strSql.ToString(), parameters); } /// /// 增加一条数据 /// public int Add(CallCenterApi.Model.T_Wo_WorkOrder model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_Wo_WorkOrder("); strSql.Append("F_WorkOrderCode,F_CallID,F_Source,F_Type,F_IncidentProvince,F_IncidentCity,F_IncidentCountry,F_IncidentTownship,F_IncidentDetailed,F_SalesBase,F_Description,F_Files,F_DealType,F_CustomerID,F_MaterialID,F_QuestionType,F_BatchNumber,F_TS_Formula,F_TS_Category,F_TS_Quantity,F_TS_Level,F_ZX_ProName,F_ZX_Quantity,F_ZX_Area,F_ZX_Branch,F_CJ_Time,F_CJ_Level,F_CJ_Unit,F_CJ_TestUnit,F_CJ_Tonnage,F_CJ_BagNo,F_CJ_Outlay,F_State,F_SC_ProductBase,F_SC_PreliminaryOpinion,F_SC_QualityMonth,F_SC_CJ_SpotResult,F_SC_CJ_SelfResult,F_SC_CJ_ApprovalNo,F_SC_CJ_ReturnAccount,F_ZL_QualityEventLevel,F_ZL_ClaimAmount,F_ZL_ResponsibleUnit,F_ZL_ApprovalOpinions,F_ZL_ApprovalDisagree,F_ZL_CompensationMethod,F_ZL_CompensationMoney,F_ZL_CResponsibleUnits,F_ZL_Fquantity,F_ZL_ImprovementRequirements,F_ZL_CApprovalNo,F_ZL_CJ_IsRecord,F_IsAudit,F_AuditState,F_AuditBy,F_AuditOn,F_AuditCont,F_IsOver,F_DealBy,F_DealTime,F_DealContent,F_DealResult,F_DealReasons,F_IsVisit,F_VisitOn,F_VisitBy,F_VisitResult,F_VisitReason,F_CreateBy,F_CreateOn,F_UpdateCount,F_UpdateBy,F_UpdateOn,F_IsDelete,F_DeleteBy,F_DeleteOn,F_CusName,F_CusPhone,F_WxOpenId,F_CompanyName,F_Callresults,F_Highopinions,F_limit,F_Reasontimeout)"); strSql.Append(" values ("); strSql.Append("@F_WorkOrderCode,@F_CallID,@F_Source,@F_Type,@F_IncidentProvince,@F_IncidentCity,@F_IncidentCountry,@F_IncidentTownship,@F_IncidentDetailed,@F_SalesBase,@F_Description,@F_Files,@F_DealType,@F_CustomerID,@F_MaterialID,@F_QuestionType,@F_BatchNumber,@F_TS_Formula,@F_TS_Category,@F_TS_Quantity,@F_TS_Level,@F_ZX_ProName,@F_ZX_Quantity,@F_ZX_Area,@F_ZX_Branch,@F_CJ_Time,@F_CJ_Level,@F_CJ_Unit,@F_CJ_TestUnit,@F_CJ_Tonnage,@F_CJ_BagNo,@F_CJ_Outlay,@F_State,@F_SC_ProductBase,@F_SC_PreliminaryOpinion,@F_SC_QualityMonth,@F_SC_CJ_SpotResult,@F_SC_CJ_SelfResult,@F_SC_CJ_ApprovalNo,@F_SC_CJ_ReturnAccount,@F_ZL_QualityEventLevel,@F_ZL_ClaimAmount,@F_ZL_ResponsibleUnit,@F_ZL_ApprovalOpinions,@F_ZL_ApprovalDisagree,@F_ZL_CompensationMethod,@F_ZL_CompensationMoney,@F_ZL_CResponsibleUnits,@F_ZL_Fquantity,@F_ZL_ImprovementRequirements,@F_ZL_CApprovalNo,@F_ZL_CJ_IsRecord,@F_IsAudit,@F_AuditState,@F_AuditBy,@F_AuditOn,@F_AuditCont,@F_IsOver,@F_DealBy,@F_DealTime,@F_DealContent,@F_DealResult,@F_DealReasons,@F_IsVisit,@F_VisitOn,@F_VisitBy,@F_VisitResult,@F_VisitReason,@F_CreateBy,@F_CreateOn,@F_UpdateCount,@F_UpdateBy,@F_UpdateOn,@F_IsDelete,@F_DeleteBy,@F_DeleteOn,@F_CusName,@F_CusPhone,@F_WxOpenId,@F_CompanyName,@F_Callresults,@F_Highopinions,@F_limit,@F_Reasontimeout)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@F_WorkOrderCode", SqlDbType.VarChar,50), new SqlParameter("@F_CallID", SqlDbType.VarChar,50), new SqlParameter("@F_Source", SqlDbType.NVarChar,200), new SqlParameter("@F_Type", SqlDbType.NVarChar,200), new SqlParameter("@F_IncidentProvince", SqlDbType.NVarChar,200), new SqlParameter("@F_IncidentCity", SqlDbType.NVarChar,200), new SqlParameter("@F_IncidentCountry", SqlDbType.NVarChar,200), new SqlParameter("@F_IncidentTownship", SqlDbType.NVarChar,200), new SqlParameter("@F_IncidentDetailed", SqlDbType.NVarChar,200), new SqlParameter("@F_SalesBase", SqlDbType.NVarChar,200), new SqlParameter("@F_Description", SqlDbType.NText), new SqlParameter("@F_Files", SqlDbType.NVarChar,-1), new SqlParameter("@F_DealType", SqlDbType.NVarChar,200), new SqlParameter("@F_CustomerID", SqlDbType.NVarChar,100), new SqlParameter("@F_MaterialID", SqlDbType.NVarChar,200), new SqlParameter("@F_QuestionType", SqlDbType.NVarChar,200), new SqlParameter("@F_BatchNumber", SqlDbType.NVarChar,200), new SqlParameter("@F_TS_Formula", SqlDbType.NText), new SqlParameter("@F_TS_Category", SqlDbType.NVarChar,200), new SqlParameter("@F_TS_Quantity", SqlDbType.NVarChar,200), new SqlParameter("@F_TS_Level", SqlDbType.NVarChar,200), new SqlParameter("@F_ZX_ProName", SqlDbType.NVarChar,200), new SqlParameter("@F_ZX_Quantity", SqlDbType.NVarChar,200), new SqlParameter("@F_ZX_Area", SqlDbType.NVarChar,200), new SqlParameter("@F_ZX_Branch", SqlDbType.NVarChar,200), new SqlParameter("@F_CJ_Time", SqlDbType.DateTime), new SqlParameter("@F_CJ_Level", SqlDbType.NVarChar,200), new SqlParameter("@F_CJ_Unit", SqlDbType.NVarChar,200), new SqlParameter("@F_CJ_TestUnit", SqlDbType.NVarChar,200), new SqlParameter("@F_CJ_Tonnage", SqlDbType.NVarChar,200), new SqlParameter("@F_CJ_BagNo", SqlDbType.NVarChar,200), new SqlParameter("@F_CJ_Outlay", SqlDbType.NVarChar,200), new SqlParameter("@F_State", SqlDbType.Int,4), new SqlParameter("@F_SC_ProductBase", SqlDbType.NVarChar,200), new SqlParameter("@F_SC_PreliminaryOpinion", SqlDbType.NVarChar,-1), new SqlParameter("@F_SC_QualityMonth", SqlDbType.NVarChar,200), new SqlParameter("@F_SC_CJ_SpotResult", SqlDbType.NVarChar,200), new SqlParameter("@F_SC_CJ_SelfResult", SqlDbType.NVarChar,200), new SqlParameter("@F_SC_CJ_ApprovalNo", SqlDbType.NVarChar,200), new SqlParameter("@F_SC_CJ_ReturnAccount", SqlDbType.NVarChar,200), new SqlParameter("@F_ZL_QualityEventLevel", SqlDbType.NVarChar,200), new SqlParameter("@F_ZL_ClaimAmount", SqlDbType.NVarChar,200), new SqlParameter("@F_ZL_ResponsibleUnit", SqlDbType.NVarChar,-1), new SqlParameter("@F_ZL_ApprovalOpinions", SqlDbType.NVarChar,200), new SqlParameter("@F_ZL_ApprovalDisagree", SqlDbType.NVarChar,-1), new SqlParameter("@F_ZL_CompensationMethod", SqlDbType.NVarChar,200), new SqlParameter("@F_ZL_CompensationMoney", SqlDbType.NVarChar,200), new SqlParameter("@F_ZL_CResponsibleUnits", SqlDbType.NVarChar,-1), new SqlParameter("@F_ZL_Fquantity", SqlDbType.NVarChar,200), new SqlParameter("@F_ZL_ImprovementRequirements", SqlDbType.NVarChar,-1), new SqlParameter("@F_ZL_CApprovalNo", SqlDbType.NVarChar,200), new SqlParameter("@F_ZL_CJ_IsRecord", SqlDbType.NVarChar,200), new SqlParameter("@F_IsAudit", SqlDbType.Int,4), new SqlParameter("@F_AuditState", SqlDbType.Int,4), new SqlParameter("@F_AuditBy", SqlDbType.VarChar,50), new SqlParameter("@F_AuditOn", SqlDbType.DateTime), new SqlParameter("@F_AuditCont", SqlDbType.NText), new SqlParameter("@F_IsOver", SqlDbType.Int,4), new SqlParameter("@F_DealBy", SqlDbType.VarChar,50), new SqlParameter("@F_DealTime", SqlDbType.DateTime), new SqlParameter("@F_DealContent", SqlDbType.NText), new SqlParameter("@F_DealResult", SqlDbType.NVarChar,200), new SqlParameter("@F_DealReasons", SqlDbType.NVarChar,-1), new SqlParameter("@F_IsVisit", SqlDbType.Int,4), new SqlParameter("@F_VisitOn", SqlDbType.DateTime), new SqlParameter("@F_VisitBy", SqlDbType.VarChar,50), new SqlParameter("@F_VisitResult", SqlDbType.VarChar,50), new SqlParameter("@F_VisitReason", SqlDbType.NText), new SqlParameter("@F_CreateBy", SqlDbType.VarChar,50), new SqlParameter("@F_CreateOn", SqlDbType.DateTime), new SqlParameter("@F_UpdateCount", SqlDbType.Int,4), new SqlParameter("@F_UpdateBy", SqlDbType.VarChar,50), new SqlParameter("@F_UpdateOn", SqlDbType.DateTime), new SqlParameter("@F_IsDelete", SqlDbType.Int,4), new SqlParameter("@F_DeleteBy", SqlDbType.VarChar,50), new SqlParameter("@F_DeleteOn", SqlDbType.DateTime), new SqlParameter("@F_CusName", SqlDbType.NVarChar,200), new SqlParameter("@F_CusPhone", SqlDbType.NVarChar,200), new SqlParameter("@F_WxOpenId", SqlDbType.NVarChar,300), new SqlParameter("@F_Callresults", SqlDbType.NVarChar,100), new SqlParameter("@F_Highopinions", SqlDbType.NVarChar,200), new SqlParameter("@F_Reasontimeout", SqlDbType.NVarChar,200), new SqlParameter("@F_limit", SqlDbType.Int,4), new SqlParameter("@F_CompanyName", SqlDbType.NVarChar, 200)}; parameters[0].Value = model.F_WorkOrderCode; parameters[1].Value = model.F_CallID; parameters[2].Value = model.F_Source; parameters[3].Value = model.F_Type; parameters[4].Value = model.F_IncidentProvince; parameters[5].Value = model.F_IncidentCity; parameters[6].Value = model.F_IncidentCountry; parameters[7].Value = model.F_IncidentTownship; parameters[8].Value = model.F_IncidentDetailed; parameters[9].Value = model.F_SalesBase; parameters[10].Value = model.F_Description; parameters[11].Value = model.F_Files; parameters[12].Value = model.F_DealType; parameters[13].Value = model.F_CustomerID; parameters[14].Value = model.F_MaterialID; parameters[15].Value = model.F_QuestionType; parameters[16].Value = model.F_BatchNumber; parameters[17].Value = model.F_TS_Formula; parameters[18].Value = model.F_TS_Category; parameters[19].Value = model.F_TS_Quantity; parameters[20].Value = model.F_TS_Level; parameters[21].Value = model.F_ZX_ProName; parameters[22].Value = model.F_ZX_Quantity; parameters[23].Value = model.F_ZX_Area; parameters[24].Value = model.F_ZX_Branch; parameters[25].Value = model.F_CJ_Time; parameters[26].Value = model.F_CJ_Level; parameters[27].Value = model.F_CJ_Unit; parameters[28].Value = model.F_CJ_TestUnit; parameters[29].Value = model.F_CJ_Tonnage; parameters[30].Value = model.F_CJ_BagNo; parameters[31].Value = model.F_CJ_Outlay; parameters[32].Value = model.F_State; parameters[33].Value = model.F_SC_ProductBase; parameters[34].Value = model.F_SC_PreliminaryOpinion; parameters[35].Value = model.F_SC_QualityMonth; parameters[36].Value = model.F_SC_CJ_SpotResult; parameters[37].Value = model.F_SC_CJ_SelfResult; parameters[38].Value = model.F_SC_CJ_ApprovalNo; parameters[39].Value = model.F_SC_CJ_ReturnAccount; parameters[40].Value = model.F_ZL_QualityEventLevel; parameters[41].Value = model.F_ZL_ClaimAmount; parameters[42].Value = model.F_ZL_ResponsibleUnit; parameters[43].Value = model.F_ZL_ApprovalOpinions; parameters[44].Value = model.F_ZL_ApprovalDisagree; parameters[45].Value = model.F_ZL_CompensationMethod; parameters[46].Value = model.F_ZL_CompensationMoney; parameters[47].Value = model.F_ZL_CResponsibleUnits; parameters[48].Value = model.F_ZL_Fquantity; parameters[49].Value = model.F_ZL_ImprovementRequirements; parameters[50].Value = model.F_ZL_CApprovalNo; parameters[51].Value = model.F_ZL_CJ_IsRecord; parameters[52].Value = model.F_IsAudit; parameters[53].Value = model.F_AuditState; parameters[54].Value = model.F_AuditBy; parameters[55].Value = model.F_AuditOn; parameters[56].Value = model.F_AuditCont; parameters[57].Value = model.F_IsOver; parameters[58].Value = model.F_DealBy; parameters[59].Value = model.F_DealTime; parameters[60].Value = model.F_DealContent; parameters[61].Value = model.F_DealResult; parameters[62].Value = model.F_DealReasons; parameters[63].Value = model.F_IsVisit; parameters[64].Value = model.F_VisitOn; parameters[65].Value = model.F_VisitBy; parameters[66].Value = model.F_VisitResult; parameters[67].Value = model.F_VisitReason; parameters[68].Value = model.F_CreateBy; parameters[69].Value = model.F_CreateOn; parameters[70].Value = model.F_UpdateCount; parameters[71].Value = model.F_UpdateBy; parameters[72].Value = model.F_UpdateOn; parameters[73].Value = model.F_IsDelete; parameters[74].Value = model.F_DeleteBy; parameters[75].Value = model.F_DeleteOn; parameters[76].Value = model.F_CusName; parameters[77].Value = model.F_CusPhone; parameters[78].Value = model.F_WxOpenId; parameters[79].Value = model.F_Callresults; parameters[80].Value = model.F_Highopinions; parameters[81].Value = model.F_Reasontimeout; parameters[82].Value = model.F_limit; parameters[83].Value = model.F_CompanyName; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } } /// /// 更新一条数据 /// public bool Update(CallCenterApi.Model.T_Wo_WorkOrder model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_Wo_WorkOrder set "); strSql.Append("F_WorkOrderCode=@F_WorkOrderCode,"); strSql.Append("F_CallID=@F_CallID,"); strSql.Append("F_Source=@F_Source,"); strSql.Append("F_Type=@F_Type,"); strSql.Append("F_IncidentProvince=@F_IncidentProvince,"); strSql.Append("F_IncidentCity=@F_IncidentCity,"); strSql.Append("F_IncidentCountry=@F_IncidentCountry,"); strSql.Append("F_IncidentTownship=@F_IncidentTownship,"); strSql.Append("F_IncidentDetailed=@F_IncidentDetailed,"); strSql.Append("F_SalesBase=@F_SalesBase,"); strSql.Append("F_Description=@F_Description,"); strSql.Append("F_Files=@F_Files,"); strSql.Append("F_DealType=@F_DealType,"); strSql.Append("F_CustomerID=@F_CustomerID,"); strSql.Append("F_MaterialID=@F_MaterialID,"); strSql.Append("F_QuestionType=@F_QuestionType,"); strSql.Append("F_BatchNumber=@F_BatchNumber,"); strSql.Append("F_TS_Formula=@F_TS_Formula,"); strSql.Append("F_TS_Category=@F_TS_Category,"); strSql.Append("F_TS_Quantity=@F_TS_Quantity,"); strSql.Append("F_TS_Level=@F_TS_Level,"); strSql.Append("F_ZX_ProName=@F_ZX_ProName,"); strSql.Append("F_ZX_Quantity=@F_ZX_Quantity,"); strSql.Append("F_ZX_Area=@F_ZX_Area,"); strSql.Append("F_ZX_Branch=@F_ZX_Branch,"); strSql.Append("F_CJ_Time=@F_CJ_Time,"); strSql.Append("F_CJ_Level=@F_CJ_Level,"); strSql.Append("F_CJ_Unit=@F_CJ_Unit,"); strSql.Append("F_CJ_TestUnit=@F_CJ_TestUnit,"); strSql.Append("F_CJ_Tonnage=@F_CJ_Tonnage,"); strSql.Append("F_CJ_BagNo=@F_CJ_BagNo,"); strSql.Append("F_CJ_Outlay=@F_CJ_Outlay,"); strSql.Append("F_State=@F_State,"); strSql.Append("F_SC_ProductBase=@F_SC_ProductBase,"); strSql.Append("F_SC_PreliminaryOpinion=@F_SC_PreliminaryOpinion,"); strSql.Append("F_SC_QualityMonth=@F_SC_QualityMonth,"); strSql.Append("F_SC_CJ_SpotResult=@F_SC_CJ_SpotResult,"); strSql.Append("F_SC_CJ_SelfResult=@F_SC_CJ_SelfResult,"); strSql.Append("F_SC_CJ_ApprovalNo=@F_SC_CJ_ApprovalNo,"); strSql.Append("F_SC_CJ_ReturnAccount=@F_SC_CJ_ReturnAccount,"); strSql.Append("F_ZL_QualityEventLevel=@F_ZL_QualityEventLevel,"); strSql.Append("F_ZL_ClaimAmount=@F_ZL_ClaimAmount,"); strSql.Append("F_ZL_ResponsibleUnit=@F_ZL_ResponsibleUnit,"); strSql.Append("F_ZL_ApprovalOpinions=@F_ZL_ApprovalOpinions,"); strSql.Append("F_ZL_ApprovalDisagree=@F_ZL_ApprovalDisagree,"); strSql.Append("F_ZL_CompensationMethod=@F_ZL_CompensationMethod,"); strSql.Append("F_ZL_CompensationMoney=@F_ZL_CompensationMoney,"); strSql.Append("F_ZL_CResponsibleUnits=@F_ZL_CResponsibleUnits,"); strSql.Append("F_ZL_Fquantity=@F_ZL_Fquantity,"); strSql.Append("F_ZL_ImprovementRequirements=@F_ZL_ImprovementRequirements,"); strSql.Append("F_ZL_CApprovalNo=@F_ZL_CApprovalNo,"); strSql.Append("F_ZL_CJ_IsRecord=@F_ZL_CJ_IsRecord,"); strSql.Append("F_IsAudit=@F_IsAudit,"); strSql.Append("F_AuditState=@F_AuditState,"); strSql.Append("F_AuditBy=@F_AuditBy,"); strSql.Append("F_AuditOn=@F_AuditOn,"); strSql.Append("F_AuditCont=@F_AuditCont,"); strSql.Append("F_IsOver=@F_IsOver,"); strSql.Append("F_DealBy=@F_DealBy,"); strSql.Append("F_DealTime=@F_DealTime,"); strSql.Append("F_DealContent=@F_DealContent,"); strSql.Append("F_DealResult=@F_DealResult,"); strSql.Append("F_DealReasons=@F_DealReasons,"); strSql.Append("F_IsVisit=@F_IsVisit,"); strSql.Append("F_VisitOn=@F_VisitOn,"); strSql.Append("F_VisitBy=@F_VisitBy,"); strSql.Append("F_VisitResult=@F_VisitResult,"); strSql.Append("F_VisitReason=@F_VisitReason,"); strSql.Append("F_CreateBy=@F_CreateBy,"); strSql.Append("F_CreateOn=@F_CreateOn,"); strSql.Append("F_UpdateCount=@F_UpdateCount,"); strSql.Append("F_UpdateBy=@F_UpdateBy,"); strSql.Append("F_UpdateOn=@F_UpdateOn,"); strSql.Append("F_IsDelete=@F_IsDelete,"); strSql.Append("F_DeleteBy=@F_DeleteBy,"); strSql.Append("F_DeleteOn=@F_DeleteOn,"); strSql.Append("F_CusName=@F_CusName,"); strSql.Append("F_CusPhone=@F_CusPhone,"); strSql.Append("F_WxOpenId=@F_WxOpenId,"); strSql.Append("F_Callresults=@F_Callresults,"); strSql.Append("F_Highopinions=@F_Highopinions,"); strSql.Append("F_Reasontimeout=@F_Reasontimeout,"); strSql.Append("F_limit=@F_limit,"); strSql.Append("F_CompanyName=@F_CompanyName"); strSql.Append(" where F_ID=@F_ID"); SqlParameter[] parameters = { new SqlParameter("@F_WorkOrderCode", SqlDbType.VarChar,50), new SqlParameter("@F_CallID", SqlDbType.VarChar,50), new SqlParameter("@F_Source", SqlDbType.NVarChar,200), new SqlParameter("@F_Type", SqlDbType.NVarChar,200), new SqlParameter("@F_IncidentProvince", SqlDbType.NVarChar,200), new SqlParameter("@F_IncidentCity", SqlDbType.NVarChar,200), new SqlParameter("@F_IncidentCountry", SqlDbType.NVarChar,200), new SqlParameter("@F_IncidentTownship", SqlDbType.NVarChar,200), new SqlParameter("@F_IncidentDetailed", SqlDbType.NVarChar,200), new SqlParameter("@F_SalesBase", SqlDbType.NVarChar,200), new SqlParameter("@F_Description", SqlDbType.NText), new SqlParameter("@F_Files", SqlDbType.NVarChar,-1), new SqlParameter("@F_DealType", SqlDbType.NVarChar,200), new SqlParameter("@F_CustomerID", SqlDbType.NVarChar,100), new SqlParameter("@F_MaterialID", SqlDbType.NVarChar,200), new SqlParameter("@F_QuestionType", SqlDbType.NVarChar,200), new SqlParameter("@F_BatchNumber", SqlDbType.NVarChar,200), new SqlParameter("@F_TS_Formula", SqlDbType.NText), new SqlParameter("@F_TS_Category", SqlDbType.NVarChar,200), new SqlParameter("@F_TS_Quantity", SqlDbType.NVarChar,200), new SqlParameter("@F_TS_Level", SqlDbType.NVarChar,200), new SqlParameter("@F_ZX_ProName", SqlDbType.NVarChar,200), new SqlParameter("@F_ZX_Quantity", SqlDbType.NVarChar,200), new SqlParameter("@F_ZX_Area", SqlDbType.NVarChar,200), new SqlParameter("@F_ZX_Branch", SqlDbType.NVarChar,200), new SqlParameter("@F_CJ_Time", SqlDbType.DateTime), new SqlParameter("@F_CJ_Level", SqlDbType.NVarChar,200), new SqlParameter("@F_CJ_Unit", SqlDbType.NVarChar,200), new SqlParameter("@F_CJ_TestUnit", SqlDbType.NVarChar,200), new SqlParameter("@F_CJ_Tonnage", SqlDbType.NVarChar,200), new SqlParameter("@F_CJ_BagNo", SqlDbType.NVarChar,200), new SqlParameter("@F_CJ_Outlay", SqlDbType.NVarChar,200), new SqlParameter("@F_State", SqlDbType.Int,4), new SqlParameter("@F_SC_ProductBase", SqlDbType.NVarChar,200), new SqlParameter("@F_SC_PreliminaryOpinion", SqlDbType.NVarChar,-1), new SqlParameter("@F_SC_QualityMonth", SqlDbType.NVarChar,200), new SqlParameter("@F_SC_CJ_SpotResult", SqlDbType.NVarChar,200), new SqlParameter("@F_SC_CJ_SelfResult", SqlDbType.NVarChar,200), new SqlParameter("@F_SC_CJ_ApprovalNo", SqlDbType.NVarChar,200), new SqlParameter("@F_SC_CJ_ReturnAccount", SqlDbType.NVarChar,200), new SqlParameter("@F_ZL_QualityEventLevel", SqlDbType.NVarChar,200), new SqlParameter("@F_ZL_ClaimAmount", SqlDbType.NVarChar,200), new SqlParameter("@F_ZL_ResponsibleUnit", SqlDbType.NVarChar,-1), new SqlParameter("@F_ZL_ApprovalOpinions", SqlDbType.NVarChar,200), new SqlParameter("@F_ZL_ApprovalDisagree", SqlDbType.NVarChar,-1), new SqlParameter("@F_ZL_CompensationMethod", SqlDbType.NVarChar,200), new SqlParameter("@F_ZL_CompensationMoney", SqlDbType.NVarChar,200), new SqlParameter("@F_ZL_CResponsibleUnits", SqlDbType.NVarChar,-1), new SqlParameter("@F_ZL_Fquantity", SqlDbType.NVarChar,200), new SqlParameter("@F_ZL_ImprovementRequirements", SqlDbType.NVarChar,-1), new SqlParameter("@F_ZL_CApprovalNo", SqlDbType.NVarChar,200), new SqlParameter("@F_ZL_CJ_IsRecord", SqlDbType.NVarChar,200), new SqlParameter("@F_IsAudit", SqlDbType.Int,4), new SqlParameter("@F_AuditState", SqlDbType.Int,4), new SqlParameter("@F_AuditBy", SqlDbType.VarChar,50), new SqlParameter("@F_AuditOn", SqlDbType.DateTime), new SqlParameter("@F_AuditCont", SqlDbType.NText), new SqlParameter("@F_IsOver", SqlDbType.Int,4), new SqlParameter("@F_DealBy", SqlDbType.VarChar,50), new SqlParameter("@F_DealTime", SqlDbType.DateTime), new SqlParameter("@F_DealContent", SqlDbType.NText), new SqlParameter("@F_DealResult", SqlDbType.NVarChar,200), new SqlParameter("@F_DealReasons", SqlDbType.NVarChar,-1), new SqlParameter("@F_IsVisit", SqlDbType.Int,4), new SqlParameter("@F_VisitOn", SqlDbType.DateTime), new SqlParameter("@F_VisitBy", SqlDbType.VarChar,50), new SqlParameter("@F_VisitResult", SqlDbType.VarChar,50), new SqlParameter("@F_VisitReason", SqlDbType.NText), new SqlParameter("@F_CreateBy", SqlDbType.VarChar,50), new SqlParameter("@F_CreateOn", SqlDbType.DateTime), new SqlParameter("@F_UpdateCount", SqlDbType.Int,4), new SqlParameter("@F_UpdateBy", SqlDbType.VarChar,50), new SqlParameter("@F_UpdateOn", SqlDbType.DateTime), new SqlParameter("@F_IsDelete", SqlDbType.Int,4), new SqlParameter("@F_DeleteBy", SqlDbType.VarChar,50), new SqlParameter("@F_DeleteOn", SqlDbType.DateTime), new SqlParameter("@F_CusName", SqlDbType.NVarChar,200), new SqlParameter("@F_CusPhone", SqlDbType.NVarChar,200), new SqlParameter("@F_WxOpenId", SqlDbType.NVarChar,300), new SqlParameter("@F_CompanyName", SqlDbType.NVarChar,200), new SqlParameter("@F_Callresults", SqlDbType.NVarChar,100), new SqlParameter("@F_Highopinions", SqlDbType.NVarChar,200), new SqlParameter("@F_limit", SqlDbType.Int,4), new SqlParameter("@F_Reasontimeout", SqlDbType.NVarChar,200), new SqlParameter("@F_ID", SqlDbType.Int,4) }; parameters[0].Value = model.F_WorkOrderCode; parameters[1].Value = model.F_CallID; parameters[2].Value = model.F_Source; parameters[3].Value = model.F_Type; parameters[4].Value = model.F_IncidentProvince; parameters[5].Value = model.F_IncidentCity; parameters[6].Value = model.F_IncidentCountry; parameters[7].Value = model.F_IncidentTownship; parameters[8].Value = model.F_IncidentDetailed; parameters[9].Value = model.F_SalesBase; parameters[10].Value = model.F_Description; parameters[11].Value = model.F_Files; parameters[12].Value = model.F_DealType; parameters[13].Value = model.F_CustomerID; parameters[14].Value = model.F_MaterialID; parameters[15].Value = model.F_QuestionType; parameters[16].Value = model.F_BatchNumber; parameters[17].Value = model.F_TS_Formula; parameters[18].Value = model.F_TS_Category; parameters[19].Value = model.F_TS_Quantity; parameters[20].Value = model.F_TS_Level; parameters[21].Value = model.F_ZX_ProName; parameters[22].Value = model.F_ZX_Quantity; parameters[23].Value = model.F_ZX_Area; parameters[24].Value = model.F_ZX_Branch; parameters[25].Value = model.F_CJ_Time; parameters[26].Value = model.F_CJ_Level; parameters[27].Value = model.F_CJ_Unit; parameters[28].Value = model.F_CJ_TestUnit; parameters[29].Value = model.F_CJ_Tonnage; parameters[30].Value = model.F_CJ_BagNo; parameters[31].Value = model.F_CJ_Outlay; parameters[32].Value = model.F_State; parameters[33].Value = model.F_SC_ProductBase; parameters[34].Value = model.F_SC_PreliminaryOpinion; parameters[35].Value = model.F_SC_QualityMonth; parameters[36].Value = model.F_SC_CJ_SpotResult; parameters[37].Value = model.F_SC_CJ_SelfResult; parameters[38].Value = model.F_SC_CJ_ApprovalNo; parameters[39].Value = model.F_SC_CJ_ReturnAccount; parameters[40].Value = model.F_ZL_QualityEventLevel; parameters[41].Value = model.F_ZL_ClaimAmount; parameters[42].Value = model.F_ZL_ResponsibleUnit; parameters[43].Value = model.F_ZL_ApprovalOpinions; parameters[44].Value = model.F_ZL_ApprovalDisagree; parameters[45].Value = model.F_ZL_CompensationMethod; parameters[46].Value = model.F_ZL_CompensationMoney; parameters[47].Value = model.F_ZL_CResponsibleUnits; parameters[48].Value = model.F_ZL_Fquantity; parameters[49].Value = model.F_ZL_ImprovementRequirements; parameters[50].Value = model.F_ZL_CApprovalNo; parameters[51].Value = model.F_ZL_CJ_IsRecord; parameters[52].Value = model.F_IsAudit; parameters[53].Value = model.F_AuditState; parameters[54].Value = model.F_AuditBy; parameters[55].Value = model.F_AuditOn; parameters[56].Value = model.F_AuditCont; parameters[57].Value = model.F_IsOver; parameters[58].Value = model.F_DealBy; parameters[59].Value = model.F_DealTime; parameters[60].Value = model.F_DealContent; parameters[61].Value = model.F_DealResult; parameters[62].Value = model.F_DealReasons; parameters[63].Value = model.F_IsVisit; parameters[64].Value = model.F_VisitOn; parameters[65].Value = model.F_VisitBy; parameters[66].Value = model.F_VisitResult; parameters[67].Value = model.F_VisitReason; parameters[68].Value = model.F_CreateBy; parameters[69].Value = model.F_CreateOn; parameters[70].Value = model.F_UpdateCount; parameters[71].Value = model.F_UpdateBy; parameters[72].Value = model.F_UpdateOn; parameters[73].Value = model.F_IsDelete; parameters[74].Value = model.F_DeleteBy; parameters[75].Value = model.F_DeleteOn; parameters[76].Value = model.F_CusName; parameters[77].Value = model.F_CusPhone; parameters[78].Value = model.F_WxOpenId; parameters[79].Value = model.F_CompanyName; parameters[80].Value = model.F_Callresults; parameters[81].Value = model.F_Highopinions; parameters[82].Value = model.F_limit; parameters[83].Value = model.F_Reasontimeout; parameters[84].Value = model.F_ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return true; } else { return false; } } /// /// 删除一条数据 /// public bool Delete(long ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from T_Wo_WorkOrder "); strSql.Append(" where F_ID=@F_ID"); SqlParameter[] parameters = { new SqlParameter("@F_ID", SqlDbType.BigInt) }; parameters[0].Value = ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return true; } else { return false; } } /// /// 批量删除数据 /// public bool DeleteList(string IDlist) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_Wo_WorkOrder set F_IsDelete=1 "); // strSql.Append("delete from T_Wo_WorkOrder "); strSql.Append(" where F_ID in (" + IDlist + ") "); int rows = DbHelperSQL.ExecuteSql(strSql.ToString()); if (rows > 0) { return true; } else { return false; } } /// /// 得到一个对象实体 /// public CallCenterApi.Model.T_Wo_WorkOrder GetModel(long ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from T_Wo_WorkOrder "); strSql.Append(" where F_ID=@F_ID"); SqlParameter[] parameters = { new SqlParameter("@F_ID", SqlDbType.BigInt) }; parameters[0].Value = ID; CallCenterApi.Model.T_Wo_WorkOrder model = new CallCenterApi.Model.T_Wo_WorkOrder(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } } /// /// 得到一个对象实体 /// public CallCenterApi.Model.T_Wo_WorkOrder GetModel(string WorkOrderId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from T_Wo_WorkOrder "); strSql.Append(" where WorkOrderId=@WorkOrderId"); SqlParameter[] parameters = { new SqlParameter("@WorkOrderId", SqlDbType.BigInt) }; parameters[0].Value = WorkOrderId; CallCenterApi.Model.T_Wo_WorkOrder model = new CallCenterApi.Model.T_Wo_WorkOrder(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } } /// /// 得到一个对象实体 /// public CallCenterApi.Model.T_Wo_WorkOrder DataRowToModel(DataRow row) { CallCenterApi.Model.T_Wo_WorkOrder model = new CallCenterApi.Model.T_Wo_WorkOrder(); if (row != null) { if (row["F_ID"] != null && row["F_ID"].ToString() != "") { model.F_ID = int.Parse(row["F_ID"].ToString()); } if (row["F_WorkOrderCode"] != null) { model.F_WorkOrderCode = row["F_WorkOrderCode"].ToString(); } if (row["F_Callresults"] != null) { model.F_Callresults = row["F_Callresults"].ToString(); } if (row["F_CallID"] != null) { model.F_CallID = row["F_CallID"].ToString(); } if (row["F_Source"] != null) { model.F_Source = row["F_Source"].ToString(); } if (row["F_Type"] != null) { model.F_Type = row["F_Type"].ToString(); } if (row["F_IncidentProvince"] != null) { model.F_IncidentProvince = row["F_IncidentProvince"].ToString(); } if (row["F_IncidentCity"] != null) { model.F_IncidentCity = row["F_IncidentCity"].ToString(); } if (row["F_IncidentCountry"] != null) { model.F_IncidentCountry = row["F_IncidentCountry"].ToString(); } if (row["F_IncidentTownship"] != null) { model.F_IncidentTownship = row["F_IncidentTownship"].ToString(); } if (row["F_IncidentDetailed"] != null) { model.F_IncidentDetailed = row["F_IncidentDetailed"].ToString(); } if (row["F_CusName"] != null) { model.F_CusName = row["F_CusName"].ToString(); } if (row["F_CusPhone"] != null) { model.F_CusPhone = row["F_CusPhone"].ToString(); } if (row["F_CompanyName"] != null) { model.F_CompanyName = row["F_CompanyName"].ToString(); } if (row["F_SalesBase"] != null) { model.F_SalesBase = row["F_SalesBase"].ToString(); } if (row["F_Description"] != null) { model.F_Description = row["F_Description"].ToString(); } if (row["F_Files"] != null) { model.F_Files = row["F_Files"].ToString(); } if (row["F_DealType"] != null) { model.F_DealType = row["F_DealType"].ToString(); } if (row["F_CustomerID"] != null && row["F_CustomerID"].ToString() != "") { model.F_CustomerID = row["F_CustomerID"].ToString(); } if (row["F_MaterialID"] != null) { model.F_MaterialID = row["F_MaterialID"].ToString(); } if (row["F_QuestionType"] != null) { model.F_QuestionType = row["F_QuestionType"].ToString(); } if (row["F_BatchNumber"] != null) { model.F_BatchNumber = row["F_BatchNumber"].ToString(); } if (row["F_TS_Formula"] != null) { model.F_TS_Formula = row["F_TS_Formula"].ToString(); } if (row["F_TS_Category"] != null) { model.F_TS_Category = row["F_TS_Category"].ToString(); } if (row["F_TS_Quantity"] != null) { model.F_TS_Quantity = row["F_TS_Quantity"].ToString(); } if (row["F_TS_Level"] != null) { model.F_TS_Level = row["F_TS_Level"].ToString(); } if (row["F_ZX_ProName"] != null) { model.F_ZX_ProName = row["F_ZX_ProName"].ToString(); } if (row["F_ZX_Quantity"] != null) { model.F_ZX_Quantity = row["F_ZX_Quantity"].ToString(); } if (row["F_ZX_Area"] != null) { model.F_ZX_Area = row["F_ZX_Area"].ToString(); } if (row["F_ZX_Branch"] != null) { model.F_ZX_Branch = row["F_ZX_Branch"].ToString(); } if (row["F_CJ_Time"] != null && row["F_CJ_Time"].ToString() != "") { model.F_CJ_Time = DateTime.Parse(row["F_CJ_Time"].ToString()); } if (row["F_CJ_Level"] != null) { model.F_CJ_Level = row["F_CJ_Level"].ToString(); } if (row["F_CJ_Unit"] != null) { model.F_CJ_Unit = row["F_CJ_Unit"].ToString(); } if (row["F_CJ_TestUnit"] != null) { model.F_CJ_TestUnit = row["F_CJ_TestUnit"].ToString(); } if (row["F_CJ_Tonnage"] != null) { model.F_CJ_Tonnage = row["F_CJ_Tonnage"].ToString(); } if (row["F_CJ_BagNo"] != null) { model.F_CJ_BagNo = row["F_CJ_BagNo"].ToString(); } if (row["F_CJ_Outlay"] != null) { model.F_CJ_Outlay = row["F_CJ_Outlay"].ToString(); } if (row["F_State"] != null && row["F_State"].ToString() != "") { model.F_State = int.Parse(row["F_State"].ToString()); } if (row["F_SC_ProductBase"] != null) { model.F_SC_ProductBase = row["F_SC_ProductBase"].ToString(); } if (row["F_SC_PreliminaryOpinion"] != null) { model.F_SC_PreliminaryOpinion = row["F_SC_PreliminaryOpinion"].ToString(); } if (row["F_SC_QualityMonth"] != null) { model.F_SC_QualityMonth = row["F_SC_QualityMonth"].ToString(); } if (row["F_SC_CJ_SpotResult"] != null) { model.F_SC_CJ_SpotResult = row["F_SC_CJ_SpotResult"].ToString(); } if (row["F_SC_CJ_SelfResult"] != null) { model.F_SC_CJ_SelfResult = row["F_SC_CJ_SelfResult"].ToString(); } if (row["F_SC_CJ_ApprovalNo"] != null) { model.F_SC_CJ_ApprovalNo = row["F_SC_CJ_ApprovalNo"].ToString(); } if (row["F_SC_CJ_ReturnAccount"] != null) { model.F_SC_CJ_ReturnAccount = row["F_SC_CJ_ReturnAccount"].ToString(); } if (row["F_ZL_QualityEventLevel"] != null) { model.F_ZL_QualityEventLevel = row["F_ZL_QualityEventLevel"].ToString(); } if (row["F_ZL_ClaimAmount"] != null) { model.F_ZL_ClaimAmount = row["F_ZL_ClaimAmount"].ToString(); } if (row["F_ZL_ResponsibleUnit"] != null) { model.F_ZL_ResponsibleUnit = row["F_ZL_ResponsibleUnit"].ToString(); } if (row["F_ZL_ApprovalOpinions"] != null) { model.F_ZL_ApprovalOpinions = row["F_ZL_ApprovalOpinions"].ToString(); } if (row["F_ZL_ApprovalDisagree"] != null) { model.F_ZL_ApprovalDisagree = row["F_ZL_ApprovalDisagree"].ToString(); } if (row["F_ZL_CompensationMethod"] != null) { model.F_ZL_CompensationMethod = row["F_ZL_CompensationMethod"].ToString(); } if (row["F_ZL_CompensationMoney"] != null) { model.F_ZL_CompensationMoney = row["F_ZL_CompensationMoney"].ToString(); } if (row["F_ZL_CResponsibleUnits"] != null) { model.F_ZL_CResponsibleUnits = row["F_ZL_CResponsibleUnits"].ToString(); } if (row["F_ZL_Fquantity"] != null) { model.F_ZL_Fquantity = row["F_ZL_Fquantity"].ToString(); } if (row["F_ZL_ImprovementRequirements"] != null) { model.F_ZL_ImprovementRequirements = row["F_ZL_ImprovementRequirements"].ToString(); } if (row["F_ZL_CApprovalNo"] != null) { model.F_ZL_CApprovalNo = row["F_ZL_CApprovalNo"].ToString(); } if (row["F_ZL_CJ_IsRecord"] != null) { model.F_ZL_CJ_IsRecord = row["F_ZL_CJ_IsRecord"].ToString(); } if (row["F_IsAudit"] != null && row["F_IsAudit"].ToString() != "") { model.F_IsAudit = int.Parse(row["F_IsAudit"].ToString()); } if (row["F_AuditState"] != null && row["F_AuditState"].ToString() != "") { model.F_AuditState = int.Parse(row["F_AuditState"].ToString()); } if (row["F_AuditBy"] != null) { model.F_AuditBy = row["F_AuditBy"].ToString(); } if (row["F_AuditOn"] != null && row["F_AuditOn"].ToString() != "") { model.F_AuditOn = DateTime.Parse(row["F_AuditOn"].ToString()); } if (row["F_AuditCont"] != null) { model.F_AuditCont = row["F_AuditCont"].ToString(); } if (row["F_IsOver"] != null && row["F_IsOver"].ToString() != "") { model.F_IsOver = int.Parse(row["F_IsOver"].ToString()); } if (row["F_DealBy"] != null) { model.F_DealBy = row["F_DealBy"].ToString(); } if (row["F_DealTime"] != null && row["F_DealTime"].ToString() != "") { model.F_DealTime = DateTime.Parse(row["F_DealTime"].ToString()); } if (row["F_DealContent"] != null) { model.F_DealContent = row["F_DealContent"].ToString(); } if (row["F_DealResult"] != null) { model.F_DealResult = row["F_DealResult"].ToString(); } if (row["F_Reasontimeout"] != null) { model.F_Reasontimeout = row["F_Reasontimeout"].ToString(); } if (row["F_DealReasons"] != null) { model.F_DealReasons = row["F_DealReasons"].ToString(); } if (row["F_IsVisit"] != null && row["F_IsVisit"].ToString() != "") { model.F_IsVisit = int.Parse(row["F_IsVisit"].ToString()); } if (row["F_VisitOn"] != null && row["F_VisitOn"].ToString() != "") { model.F_VisitOn = DateTime.Parse(row["F_VisitOn"].ToString()); } if (row["F_VisitBy"] != null) { model.F_VisitBy = row["F_VisitBy"].ToString(); } if (row["F_VisitResult"] != null) { model.F_VisitResult = row["F_VisitResult"].ToString(); } if (row["F_VisitReason"] != null) { model.F_VisitReason = row["F_VisitReason"].ToString(); } if (row["F_CreateBy"] != null) { model.F_CreateBy = row["F_CreateBy"].ToString(); } if (row["F_CreateOn"] != null && row["F_CreateOn"].ToString() != "") { model.F_CreateOn = DateTime.Parse(row["F_CreateOn"].ToString()); } if (row["F_UpdateCount"] != null && row["F_UpdateCount"].ToString() != "") { model.F_UpdateCount = int.Parse(row["F_UpdateCount"].ToString()); } if (row["F_UpdateBy"] != null) { model.F_UpdateBy = row["F_UpdateBy"].ToString(); } if (row["F_UpdateOn"] != null && row["F_UpdateOn"].ToString() != "") { model.F_UpdateOn = DateTime.Parse(row["F_UpdateOn"].ToString()); } if (row["F_IsDelete"] != null && row["F_IsDelete"].ToString() != "") { model.F_IsDelete = int.Parse(row["F_IsDelete"].ToString()); } if (row["F_limit"] != null && row["F_limit"].ToString() != "") { model.F_limit = int.Parse(row["F_limit"].ToString()); } if (row["F_DeleteBy"] != null) { model.F_DeleteBy = row["F_DeleteBy"].ToString(); } if (row["F_DeleteOn"] != null && row["F_DeleteOn"].ToString() != "") { model.F_DeleteOn = DateTime.Parse(row["F_DeleteOn"].ToString()); } if (row["F_WxOpenId"] != null) { model.F_DeleteBy = row["F_WxOpenId"].ToString(); } } return model; } /// /// 获得数据列表 /// public DataSet GetList(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * "); strSql.Append(" FROM T_Wo_WorkOrder "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } return DbHelperSQL.Query(strSql.ToString()); } /// /// 获得前几行数据 /// public DataSet GetList(int Top, string strWhere, string filedOrder) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); if (Top > 0) { strSql.Append(" top " + Top.ToString()); } strSql.Append(" * "); strSql.Append(" FROM T_Wo_WorkOrder "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } strSql.Append(" order by " + filedOrder); return DbHelperSQL.Query(strSql.ToString()); } /// /// 获取记录总数 /// public int GetRecordCount(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) FROM T_Wo_WorkOrder "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } object obj = DbHelperSQL.GetSingle(strSql.ToString()); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } } /// /// 分页获取数据列表 /// public DataSet GetListByPage(string strWhere, string orderby, int startIndex, int endIndex) { StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT * FROM ( "); strSql.Append(" SELECT ROW_NUMBER() OVER ("); if (!string.IsNullOrEmpty(orderby.Trim())) { strSql.Append("order by T." + orderby); } else { strSql.Append("order by T.ID desc"); } strSql.Append(")AS Row, T.* from T_Wo_WorkOrder T "); if (!string.IsNullOrEmpty(strWhere.Trim())) { strSql.Append(" WHERE " + strWhere); } strSql.Append(" ) TT"); strSql.AppendFormat(" WHERE TT.Row between {0} and {1}", startIndex, endIndex); return DbHelperSQL.Query(strSql.ToString()); } /* /// /// 分页获取数据列表 /// public DataSet GetList(int PageSize,int PageIndex,string strWhere) { SqlParameter[] parameters = { new SqlParameter("@tblName", SqlDbType.VarChar, 255), new SqlParameter("@fldName", SqlDbType.VarChar, 255), new SqlParameter("@PageSize", SqlDbType.Int), new SqlParameter("@PageIndex", SqlDbType.Int), new SqlParameter("@IsReCount", SqlDbType.Bit), new SqlParameter("@OrderType", SqlDbType.Bit), new SqlParameter("@strWhere", SqlDbType.VarChar,1000), }; parameters[0].Value = "T_Wo_WorkOrder"; parameters[1].Value = "ID"; parameters[2].Value = PageSize; parameters[3].Value = PageIndex; parameters[4].Value = 0; parameters[5].Value = 0; parameters[6].Value = strWhere; return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds"); }*/ #endregion BasicMethod #region ExtensionMethod /// /// 处理工单 /// public int DealWorkOrder(string strorderid, int isend, string strcont, int jsbm, string jsgh, string clgh) { SqlParameter[] parameters = { new SqlParameter("@orderid", SqlDbType.VarChar, 50), new SqlParameter("@isend", SqlDbType.Int), new SqlParameter("@cont", SqlDbType.NVarChar,-1), new SqlParameter("@jsbm", SqlDbType.Int), new SqlParameter("@jsgh", SqlDbType.VarChar,-1), new SqlParameter("@clgh", SqlDbType.VarChar,50) }; parameters[0].Value = strorderid; parameters[1].Value = isend; parameters[2].Value = strcont; parameters[3].Value = jsbm; parameters[4].Value = jsgh; parameters[5].Value = clgh; int n = 0; return DbHelperSQL.RunProcedure("DealWorkOrder", parameters, out n); } #endregion ExtensionMethod } }