/// <summary> /// 得到一个对象实体 /// </summary> public IPSP.Model.TCode_AgencyInfo GetModel(int n_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 n_ID,s_Name,s_OtherName,s_Contact,s_OtherContact,s_Password,s_AgentCode,s_Tel,s_Fax,n_Country,s_State,s_City,s_Street,s_ZipCode,s_OtherAddress,s_Notes,s_EmailName,s_EmailServer,s_Port,s_EmailUser,s_EmailPwd,s_Signature,dt_CreateDate,dt_EditDate,n_DefaultCurr,n_DefaultLan,n_GSTAgent,n_GSTDisb,s_GSTForNativeClient,s_TmOtherName,s_ClientCodeRule,n_ClientCodeFlowNumCount,n_TaxCN,s_NationalDefense,s_UnifiedSend,s_WeekEndForeColor,s_WeekEndBackColor,s_WorkWeekEndForeColor,s_WorkWeekEndBackColor,s_CorpID,s_Secret,s_CustomizeCode,s_UseHolidayConfig,s_UseOldConsole,img_Logo,n_AnnualFeeNotificationDay from TCode_AgencyInfo "); strSql.Append(" where n_ID=@n_ID"); SqlParameter[] parameters = { new SqlParameter("@n_ID", SqlDbType.Int, 4) }; parameters[0].Value = n_ID; IPSP.Model.TCode_AgencyInfo model = new IPSP.Model.TCode_AgencyInfo(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(IPSP.Model.TCode_AgencyInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TCode_AgencyInfo("); strSql.Append("s_Name,s_OtherName,s_Contact,s_OtherContact,s_Password,s_AgentCode,s_Tel,s_Fax,n_Country,s_State,s_City,s_Street,s_ZipCode,s_OtherAddress,s_Notes,s_EmailName,s_EmailServer,s_Port,s_EmailUser,s_EmailPwd,s_Signature,dt_CreateDate,dt_EditDate,n_DefaultCurr,n_DefaultLan,n_GSTAgent,n_GSTDisb,s_GSTForNativeClient,s_TmOtherName,s_ClientCodeRule,n_ClientCodeFlowNumCount,n_TaxCN,s_NationalDefense,s_UnifiedSend,s_WeekEndForeColor,s_WeekEndBackColor,s_WorkWeekEndForeColor,s_WorkWeekEndBackColor,s_CorpID,s_Secret,s_CustomizeCode,s_UseHolidayConfig,s_UseOldConsole,img_Logo,n_AnnualFeeNotificationDay)"); strSql.Append(" values ("); strSql.Append("@s_Name,@s_OtherName,@s_Contact,@s_OtherContact,@s_Password,@s_AgentCode,@s_Tel,@s_Fax,@n_Country,@s_State,@s_City,@s_Street,@s_ZipCode,@s_OtherAddress,@s_Notes,@s_EmailName,@s_EmailServer,@s_Port,@s_EmailUser,@s_EmailPwd,@s_Signature,@dt_CreateDate,@dt_EditDate,@n_DefaultCurr,@n_DefaultLan,@n_GSTAgent,@n_GSTDisb,@s_GSTForNativeClient,@s_TmOtherName,@s_ClientCodeRule,@n_ClientCodeFlowNumCount,@n_TaxCN,@s_NationalDefense,@s_UnifiedSend,@s_WeekEndForeColor,@s_WeekEndBackColor,@s_WorkWeekEndForeColor,@s_WorkWeekEndBackColor,@s_CorpID,@s_Secret,@s_CustomizeCode,@s_UseHolidayConfig,@s_UseOldConsole,@img_Logo,@n_AnnualFeeNotificationDay)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@s_Name", SqlDbType.NVarChar, 600), new SqlParameter("@s_OtherName", SqlDbType.NVarChar, 400), new SqlParameter("@s_Contact", SqlDbType.NVarChar, 400), new SqlParameter("@s_OtherContact", SqlDbType.NVarChar, 400), new SqlParameter("@s_Password", SqlDbType.NVarChar, 200), new SqlParameter("@s_AgentCode", SqlDbType.NVarChar, 100), new SqlParameter("@s_Tel", SqlDbType.NVarChar, 300), new SqlParameter("@s_Fax", SqlDbType.NVarChar, 300), new SqlParameter("@n_Country", SqlDbType.Int, 4), new SqlParameter("@s_State", SqlDbType.NVarChar, 200), new SqlParameter("@s_City", SqlDbType.NVarChar, 200), new SqlParameter("@s_Street", SqlDbType.NVarChar, 600), new SqlParameter("@s_ZipCode", SqlDbType.NVarChar, 100), new SqlParameter("@s_OtherAddress", SqlDbType.NVarChar, 1000), new SqlParameter("@s_Notes", SqlDbType.NVarChar, 1600), new SqlParameter("@s_EmailName", SqlDbType.NVarChar, 100), new SqlParameter("@s_EmailServer", SqlDbType.NVarChar, 100), new SqlParameter("@s_Port", SqlDbType.NVarChar, 100), new SqlParameter("@s_EmailUser", SqlDbType.NVarChar, 100), new SqlParameter("@s_EmailPwd", SqlDbType.NVarChar, 200), new SqlParameter("@s_Signature", SqlDbType.VarBinary, -1), new SqlParameter("@dt_CreateDate", SqlDbType.DateTime), new SqlParameter("@dt_EditDate", SqlDbType.DateTime), new SqlParameter("@n_DefaultCurr", SqlDbType.Int, 4), new SqlParameter("@n_DefaultLan", SqlDbType.Int, 4), new SqlParameter("@n_GSTAgent", SqlDbType.Decimal, 9), new SqlParameter("@n_GSTDisb", SqlDbType.Decimal, 9), new SqlParameter("@s_GSTForNativeClient", SqlDbType.NVarChar, 1), new SqlParameter("@s_TmOtherName", SqlDbType.NVarChar, 200), new SqlParameter("@s_ClientCodeRule", SqlDbType.NVarChar, 100), new SqlParameter("@n_ClientCodeFlowNumCount", SqlDbType.Int, 4), new SqlParameter("@n_TaxCN", SqlDbType.Money, 8), new SqlParameter("@s_NationalDefense", SqlDbType.NVarChar, 100), new SqlParameter("@s_UnifiedSend", SqlDbType.NVarChar, 100), new SqlParameter("@s_WeekEndForeColor", SqlDbType.NVarChar, 20), new SqlParameter("@s_WeekEndBackColor", SqlDbType.NVarChar, 20), new SqlParameter("@s_WorkWeekEndForeColor", SqlDbType.NVarChar, 20), new SqlParameter("@s_WorkWeekEndBackColor", SqlDbType.NVarChar, 20), new SqlParameter("@s_CorpID", SqlDbType.NVarChar, 50), new SqlParameter("@s_Secret", SqlDbType.NVarChar, 200), new SqlParameter("@s_CustomizeCode", SqlDbType.NVarChar, 50), new SqlParameter("@s_UseHolidayConfig", SqlDbType.NVarChar, 1), new SqlParameter("@s_UseOldConsole", SqlDbType.NVarChar, 1), new SqlParameter("@img_Logo", SqlDbType.VarBinary, -1), new SqlParameter("@n_AnnualFeeNotificationDay", SqlDbType.Int, 4) }; parameters[0].Value = model.s_Name; parameters[1].Value = model.s_OtherName; parameters[2].Value = model.s_Contact; parameters[3].Value = model.s_OtherContact; parameters[4].Value = model.s_Password; parameters[5].Value = model.s_AgentCode; parameters[6].Value = model.s_Tel; parameters[7].Value = model.s_Fax; parameters[8].Value = model.n_Country; parameters[9].Value = model.s_State; parameters[10].Value = model.s_City; parameters[11].Value = model.s_Street; parameters[12].Value = model.s_ZipCode; parameters[13].Value = model.s_OtherAddress; parameters[14].Value = model.s_Notes; parameters[15].Value = model.s_EmailName; parameters[16].Value = model.s_EmailServer; parameters[17].Value = model.s_Port; parameters[18].Value = model.s_EmailUser; parameters[19].Value = model.s_EmailPwd; parameters[20].Value = model.s_Signature; parameters[21].Value = model.dt_CreateDate; parameters[22].Value = model.dt_EditDate; parameters[23].Value = model.n_DefaultCurr; parameters[24].Value = model.n_DefaultLan; parameters[25].Value = model.n_GSTAgent; parameters[26].Value = model.n_GSTDisb; parameters[27].Value = model.s_GSTForNativeClient; parameters[28].Value = model.s_TmOtherName; parameters[29].Value = model.s_ClientCodeRule; parameters[30].Value = model.n_ClientCodeFlowNumCount; parameters[31].Value = model.n_TaxCN; parameters[32].Value = model.s_NationalDefense; parameters[33].Value = model.s_UnifiedSend; parameters[34].Value = model.s_WeekEndForeColor; parameters[35].Value = model.s_WeekEndBackColor; parameters[36].Value = model.s_WorkWeekEndForeColor; parameters[37].Value = model.s_WorkWeekEndBackColor; parameters[38].Value = model.s_CorpID; parameters[39].Value = model.s_Secret; parameters[40].Value = model.s_CustomizeCode; parameters[41].Value = model.s_UseHolidayConfig; parameters[42].Value = model.s_UseOldConsole; parameters[43].Value = model.img_Logo; parameters[44].Value = model.n_AnnualFeeNotificationDay; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public IPSP.Model.TCode_AgencyInfo DataRowToModel(DataRow row) { IPSP.Model.TCode_AgencyInfo model = new IPSP.Model.TCode_AgencyInfo(); if (row != null) { if (row["n_ID"] != null && row["n_ID"].ToString() != "") { model.n_ID = int.Parse(row["n_ID"].ToString()); } if (row["s_Name"] != null) { model.s_Name = row["s_Name"].ToString(); } if (row["s_OtherName"] != null) { model.s_OtherName = row["s_OtherName"].ToString(); } if (row["s_Contact"] != null) { model.s_Contact = row["s_Contact"].ToString(); } if (row["s_OtherContact"] != null) { model.s_OtherContact = row["s_OtherContact"].ToString(); } if (row["s_Password"] != null) { model.s_Password = row["s_Password"].ToString(); } if (row["s_AgentCode"] != null) { model.s_AgentCode = row["s_AgentCode"].ToString(); } if (row["s_Tel"] != null) { model.s_Tel = row["s_Tel"].ToString(); } if (row["s_Fax"] != null) { model.s_Fax = row["s_Fax"].ToString(); } if (row["n_Country"] != null && row["n_Country"].ToString() != "") { model.n_Country = int.Parse(row["n_Country"].ToString()); } if (row["s_State"] != null) { model.s_State = row["s_State"].ToString(); } if (row["s_City"] != null) { model.s_City = row["s_City"].ToString(); } if (row["s_Street"] != null) { model.s_Street = row["s_Street"].ToString(); } if (row["s_ZipCode"] != null) { model.s_ZipCode = row["s_ZipCode"].ToString(); } if (row["s_OtherAddress"] != null) { model.s_OtherAddress = row["s_OtherAddress"].ToString(); } if (row["s_Notes"] != null) { model.s_Notes = row["s_Notes"].ToString(); } if (row["s_EmailName"] != null) { model.s_EmailName = row["s_EmailName"].ToString(); } if (row["s_EmailServer"] != null) { model.s_EmailServer = row["s_EmailServer"].ToString(); } if (row["s_Port"] != null) { model.s_Port = row["s_Port"].ToString(); } if (row["s_EmailUser"] != null) { model.s_EmailUser = row["s_EmailUser"].ToString(); } if (row["s_EmailPwd"] != null) { model.s_EmailPwd = row["s_EmailPwd"].ToString(); } if (row["s_Signature"] != null && row["s_Signature"].ToString() != "") { model.s_Signature = (byte[])row["s_Signature"]; } if (row["dt_CreateDate"] != null && row["dt_CreateDate"].ToString() != "") { model.dt_CreateDate = DateTime.Parse(row["dt_CreateDate"].ToString()); } if (row["dt_EditDate"] != null && row["dt_EditDate"].ToString() != "") { model.dt_EditDate = DateTime.Parse(row["dt_EditDate"].ToString()); } if (row["n_DefaultCurr"] != null && row["n_DefaultCurr"].ToString() != "") { model.n_DefaultCurr = int.Parse(row["n_DefaultCurr"].ToString()); } if (row["n_DefaultLan"] != null && row["n_DefaultLan"].ToString() != "") { model.n_DefaultLan = int.Parse(row["n_DefaultLan"].ToString()); } if (row["n_GSTAgent"] != null && row["n_GSTAgent"].ToString() != "") { model.n_GSTAgent = decimal.Parse(row["n_GSTAgent"].ToString()); } if (row["n_GSTDisb"] != null && row["n_GSTDisb"].ToString() != "") { model.n_GSTDisb = decimal.Parse(row["n_GSTDisb"].ToString()); } if (row["s_GSTForNativeClient"] != null) { model.s_GSTForNativeClient = row["s_GSTForNativeClient"].ToString(); } if (row["s_TmOtherName"] != null) { model.s_TmOtherName = row["s_TmOtherName"].ToString(); } if (row["s_ClientCodeRule"] != null) { model.s_ClientCodeRule = row["s_ClientCodeRule"].ToString(); } if (row["n_ClientCodeFlowNumCount"] != null && row["n_ClientCodeFlowNumCount"].ToString() != "") { model.n_ClientCodeFlowNumCount = int.Parse(row["n_ClientCodeFlowNumCount"].ToString()); } if (row["n_TaxCN"] != null && row["n_TaxCN"].ToString() != "") { model.n_TaxCN = decimal.Parse(row["n_TaxCN"].ToString()); } if (row["s_NationalDefense"] != null) { model.s_NationalDefense = row["s_NationalDefense"].ToString(); } if (row["s_UnifiedSend"] != null) { model.s_UnifiedSend = row["s_UnifiedSend"].ToString(); } if (row["s_WeekEndForeColor"] != null) { model.s_WeekEndForeColor = row["s_WeekEndForeColor"].ToString(); } if (row["s_WeekEndBackColor"] != null) { model.s_WeekEndBackColor = row["s_WeekEndBackColor"].ToString(); } if (row["s_WorkWeekEndForeColor"] != null) { model.s_WorkWeekEndForeColor = row["s_WorkWeekEndForeColor"].ToString(); } if (row["s_WorkWeekEndBackColor"] != null) { model.s_WorkWeekEndBackColor = row["s_WorkWeekEndBackColor"].ToString(); } if (row["s_CorpID"] != null) { model.s_CorpID = row["s_CorpID"].ToString(); } if (row["s_Secret"] != null) { model.s_Secret = row["s_Secret"].ToString(); } if (row["s_CustomizeCode"] != null) { model.s_CustomizeCode = row["s_CustomizeCode"].ToString(); } if (row["s_UseHolidayConfig"] != null) { model.s_UseHolidayConfig = row["s_UseHolidayConfig"].ToString(); } if (row["s_UseOldConsole"] != null) { model.s_UseOldConsole = row["s_UseOldConsole"].ToString(); } if (row["img_Logo"] != null && row["img_Logo"].ToString() != "") { model.img_Logo = (byte[])row["img_Logo"]; } if (row["n_AnnualFeeNotificationDay"] != null && row["n_AnnualFeeNotificationDay"].ToString() != "") { model.n_AnnualFeeNotificationDay = int.Parse(row["n_AnnualFeeNotificationDay"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(IPSP.Model.TCode_AgencyInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TCode_AgencyInfo set "); strSql.Append("s_Name=@s_Name,"); strSql.Append("s_OtherName=@s_OtherName,"); strSql.Append("s_Contact=@s_Contact,"); strSql.Append("s_OtherContact=@s_OtherContact,"); strSql.Append("s_Password=@s_Password,"); strSql.Append("s_AgentCode=@s_AgentCode,"); strSql.Append("s_Tel=@s_Tel,"); strSql.Append("s_Fax=@s_Fax,"); strSql.Append("n_Country=@n_Country,"); strSql.Append("s_State=@s_State,"); strSql.Append("s_City=@s_City,"); strSql.Append("s_Street=@s_Street,"); strSql.Append("s_ZipCode=@s_ZipCode,"); strSql.Append("s_OtherAddress=@s_OtherAddress,"); strSql.Append("s_Notes=@s_Notes,"); strSql.Append("s_EmailName=@s_EmailName,"); strSql.Append("s_EmailServer=@s_EmailServer,"); strSql.Append("s_Port=@s_Port,"); strSql.Append("s_EmailUser=@s_EmailUser,"); strSql.Append("s_EmailPwd=@s_EmailPwd,"); strSql.Append("s_Signature=@s_Signature,"); strSql.Append("dt_CreateDate=@dt_CreateDate,"); strSql.Append("dt_EditDate=@dt_EditDate,"); strSql.Append("n_DefaultCurr=@n_DefaultCurr,"); strSql.Append("n_DefaultLan=@n_DefaultLan,"); strSql.Append("n_GSTAgent=@n_GSTAgent,"); strSql.Append("n_GSTDisb=@n_GSTDisb,"); strSql.Append("s_GSTForNativeClient=@s_GSTForNativeClient,"); strSql.Append("s_TmOtherName=@s_TmOtherName,"); strSql.Append("s_ClientCodeRule=@s_ClientCodeRule,"); strSql.Append("n_ClientCodeFlowNumCount=@n_ClientCodeFlowNumCount,"); strSql.Append("n_TaxCN=@n_TaxCN,"); strSql.Append("s_NationalDefense=@s_NationalDefense,"); strSql.Append("s_UnifiedSend=@s_UnifiedSend,"); strSql.Append("s_WeekEndForeColor=@s_WeekEndForeColor,"); strSql.Append("s_WeekEndBackColor=@s_WeekEndBackColor,"); strSql.Append("s_WorkWeekEndForeColor=@s_WorkWeekEndForeColor,"); strSql.Append("s_WorkWeekEndBackColor=@s_WorkWeekEndBackColor,"); strSql.Append("s_CorpID=@s_CorpID,"); strSql.Append("s_Secret=@s_Secret,"); strSql.Append("s_CustomizeCode=@s_CustomizeCode,"); strSql.Append("s_UseHolidayConfig=@s_UseHolidayConfig,"); strSql.Append("s_UseOldConsole=@s_UseOldConsole,"); strSql.Append("img_Logo=@img_Logo,"); strSql.Append("n_AnnualFeeNotificationDay=@n_AnnualFeeNotificationDay"); strSql.Append(" where n_ID=@n_ID"); SqlParameter[] parameters = { new SqlParameter("@s_Name", SqlDbType.NVarChar, 600), new SqlParameter("@s_OtherName", SqlDbType.NVarChar, 400), new SqlParameter("@s_Contact", SqlDbType.NVarChar, 400), new SqlParameter("@s_OtherContact", SqlDbType.NVarChar, 400), new SqlParameter("@s_Password", SqlDbType.NVarChar, 200), new SqlParameter("@s_AgentCode", SqlDbType.NVarChar, 100), new SqlParameter("@s_Tel", SqlDbType.NVarChar, 300), new SqlParameter("@s_Fax", SqlDbType.NVarChar, 300), new SqlParameter("@n_Country", SqlDbType.Int, 4), new SqlParameter("@s_State", SqlDbType.NVarChar, 200), new SqlParameter("@s_City", SqlDbType.NVarChar, 200), new SqlParameter("@s_Street", SqlDbType.NVarChar, 600), new SqlParameter("@s_ZipCode", SqlDbType.NVarChar, 100), new SqlParameter("@s_OtherAddress", SqlDbType.NVarChar, 1000), new SqlParameter("@s_Notes", SqlDbType.NVarChar, 1600), new SqlParameter("@s_EmailName", SqlDbType.NVarChar, 100), new SqlParameter("@s_EmailServer", SqlDbType.NVarChar, 100), new SqlParameter("@s_Port", SqlDbType.NVarChar, 100), new SqlParameter("@s_EmailUser", SqlDbType.NVarChar, 100), new SqlParameter("@s_EmailPwd", SqlDbType.NVarChar, 200), new SqlParameter("@s_Signature", SqlDbType.VarBinary, -1), new SqlParameter("@dt_CreateDate", SqlDbType.DateTime), new SqlParameter("@dt_EditDate", SqlDbType.DateTime), new SqlParameter("@n_DefaultCurr", SqlDbType.Int, 4), new SqlParameter("@n_DefaultLan", SqlDbType.Int, 4), new SqlParameter("@n_GSTAgent", SqlDbType.Decimal, 9), new SqlParameter("@n_GSTDisb", SqlDbType.Decimal, 9), new SqlParameter("@s_GSTForNativeClient", SqlDbType.NVarChar, 1), new SqlParameter("@s_TmOtherName", SqlDbType.NVarChar, 200), new SqlParameter("@s_ClientCodeRule", SqlDbType.NVarChar, 100), new SqlParameter("@n_ClientCodeFlowNumCount", SqlDbType.Int, 4), new SqlParameter("@n_TaxCN", SqlDbType.Money, 8), new SqlParameter("@s_NationalDefense", SqlDbType.NVarChar, 100), new SqlParameter("@s_UnifiedSend", SqlDbType.NVarChar, 100), new SqlParameter("@s_WeekEndForeColor", SqlDbType.NVarChar, 20), new SqlParameter("@s_WeekEndBackColor", SqlDbType.NVarChar, 20), new SqlParameter("@s_WorkWeekEndForeColor", SqlDbType.NVarChar, 20), new SqlParameter("@s_WorkWeekEndBackColor", SqlDbType.NVarChar, 20), new SqlParameter("@s_CorpID", SqlDbType.NVarChar, 50), new SqlParameter("@s_Secret", SqlDbType.NVarChar, 200), new SqlParameter("@s_CustomizeCode", SqlDbType.NVarChar, 50), new SqlParameter("@s_UseHolidayConfig", SqlDbType.NVarChar, 1), new SqlParameter("@s_UseOldConsole", SqlDbType.NVarChar, 1), new SqlParameter("@img_Logo", SqlDbType.VarBinary, -1), new SqlParameter("@n_AnnualFeeNotificationDay", SqlDbType.Int, 4), new SqlParameter("@n_ID", SqlDbType.Int, 4) }; parameters[0].Value = model.s_Name; parameters[1].Value = model.s_OtherName; parameters[2].Value = model.s_Contact; parameters[3].Value = model.s_OtherContact; parameters[4].Value = model.s_Password; parameters[5].Value = model.s_AgentCode; parameters[6].Value = model.s_Tel; parameters[7].Value = model.s_Fax; parameters[8].Value = model.n_Country; parameters[9].Value = model.s_State; parameters[10].Value = model.s_City; parameters[11].Value = model.s_Street; parameters[12].Value = model.s_ZipCode; parameters[13].Value = model.s_OtherAddress; parameters[14].Value = model.s_Notes; parameters[15].Value = model.s_EmailName; parameters[16].Value = model.s_EmailServer; parameters[17].Value = model.s_Port; parameters[18].Value = model.s_EmailUser; parameters[19].Value = model.s_EmailPwd; parameters[20].Value = model.s_Signature; parameters[21].Value = model.dt_CreateDate; parameters[22].Value = model.dt_EditDate; parameters[23].Value = model.n_DefaultCurr; parameters[24].Value = model.n_DefaultLan; parameters[25].Value = model.n_GSTAgent; parameters[26].Value = model.n_GSTDisb; parameters[27].Value = model.s_GSTForNativeClient; parameters[28].Value = model.s_TmOtherName; parameters[29].Value = model.s_ClientCodeRule; parameters[30].Value = model.n_ClientCodeFlowNumCount; parameters[31].Value = model.n_TaxCN; parameters[32].Value = model.s_NationalDefense; parameters[33].Value = model.s_UnifiedSend; parameters[34].Value = model.s_WeekEndForeColor; parameters[35].Value = model.s_WeekEndBackColor; parameters[36].Value = model.s_WorkWeekEndForeColor; parameters[37].Value = model.s_WorkWeekEndBackColor; parameters[38].Value = model.s_CorpID; parameters[39].Value = model.s_Secret; parameters[40].Value = model.s_CustomizeCode; parameters[41].Value = model.s_UseHolidayConfig; parameters[42].Value = model.s_UseOldConsole; parameters[43].Value = model.img_Logo; parameters[44].Value = model.n_AnnualFeeNotificationDay; parameters[45].Value = model.n_ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(IPSP.Model.TCode_AgencyInfo model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(IPSP.Model.TCode_AgencyInfo model) { return(dal.Add(model)); }