/// <summary> /// 由一行数据得到一个实体 /// </summary> private Hi.Model.Pay_PaymentSettings GetModel(DataRow r) { Hi.Model.Pay_PaymentSettings model = new Hi.Model.Pay_PaymentSettings(); model.ID = SqlHelper.GetInt(r["ID"]); model.CompID = SqlHelper.GetInt(r["CompID"]); model.pay_sxfsq = SqlHelper.GetInt(r["pay_sxfsq"]); model.pay_zffs = SqlHelper.GetInt(r["pay_zffs"]); model.pay_kjzfbl = SqlHelper.GetDecimal(r["pay_kjzfbl"]); model.pay_kjzfstart = SqlHelper.GetDecimal(r["pay_kjzfstart"]); model.pay_kjzfend = SqlHelper.GetDecimal(r["pay_kjzfend"]); model.pay_ylzfbl = SqlHelper.GetDecimal(r["pay_ylzfbl"]); model.pay_ylzfstart = SqlHelper.GetDecimal(r["pay_ylzfstart"]); model.pay_ylzfend = SqlHelper.GetDecimal(r["pay_ylzfend"]); model.pay_b2cwyzfbl = SqlHelper.GetDecimal(r["pay_b2cwyzfbl"]); model.pay_b2bwyzf = SqlHelper.GetDecimal(r["pay_b2bwyzf"]); model.Pay_mfcs = SqlHelper.GetInt(r["Pay_mfcs"]); model.createUser = SqlHelper.GetInt(r["createUser"]); model.createDate = SqlHelper.GetDateTime(r["createDate"]); model.Start = SqlHelper.GetInt(r["Start"]); model.remark = SqlHelper.GetString(r["remark"]); model.vdef1 = SqlHelper.GetString(r["vdef1"]); model.vdef2 = SqlHelper.GetString(r["vdef2"]); model.vdef3 = SqlHelper.GetString(r["vdef3"]); model.vdef4 = SqlHelper.GetString(r["vdef4"]); model.vdef5 = SqlHelper.GetString(r["vdef5"]); model.vdef6 = SqlHelper.GetString(r["vdef6"]); model.vdef7 = SqlHelper.GetString(r["vdef7"]); model.vdef8 = SqlHelper.GetString(r["vdef8"]); model.vdef9 = SqlHelper.GetString(r["vdef9"]); model.vdef10 = SqlHelper.GetString(r["vdef10"]); model.vdef11 = SqlHelper.GetString(r["vdef11"]); model.vdef12 = SqlHelper.GetString(r["vdef12"]); model.vdef13 = SqlHelper.GetString(r["vdef13"]); model.vdef14 = SqlHelper.GetString(r["vdef14"]); model.vdef15 = SqlHelper.GetString(r["vdef15"]); model.ts = SqlHelper.GetDateTime(r["ts"]); model.dr = SqlHelper.GetInt(r["dr"]); model.modifyuser = SqlHelper.GetInt(r["modifyuser"]); return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Hi.Model.Pay_PaymentSettings model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [Pay_PaymentSettings]("); strSql.Append("[CompID],[pay_sxfsq],[pay_zffs],[pay_kjzfbl],[pay_kjzfstart],[pay_kjzfend],[pay_ylzfbl],[pay_ylzfstart],[pay_ylzfend],[pay_b2cwyzfbl],[pay_b2bwyzf],[Pay_mfcs],[createUser],[createDate],[Start],[remark],[vdef1],[vdef2],[vdef3],[vdef4],[vdef5],[vdef6],[vdef7],[vdef8],[vdef9],[vdef10],[vdef11],[vdef12],[vdef13],[vdef14],[vdef15],[ts],[dr],[modifyuser])"); strSql.Append(" values ("); strSql.Append("@CompID,@pay_sxfsq,@pay_zffs,@pay_kjzfbl,@pay_kjzfstart,@pay_kjzfend,@pay_ylzfbl,@pay_ylzfstart,@pay_ylzfend,@pay_b2cwyzfbl,@pay_b2bwyzf,@Pay_mfcs,@createUser,@createDate,@Start,@remark,@vdef1,@vdef2,@vdef3,@vdef4,@vdef5,@vdef6,@vdef7,@vdef8,@vdef9,@vdef10,@vdef11,@vdef12,@vdef13,@vdef14,@vdef15,@ts,@dr,@modifyuser)"); strSql.Append(";select @@Identity"); SqlParameter[] parameters = { new SqlParameter("@CompID", SqlDbType.BigInt), new SqlParameter("@pay_sxfsq", SqlDbType.Int), new SqlParameter("@pay_zffs", SqlDbType.Int), new SqlParameter("@pay_kjzfbl", SqlDbType.Decimal), new SqlParameter("@pay_kjzfstart", SqlDbType.Decimal), new SqlParameter("@pay_kjzfend", SqlDbType.Decimal), new SqlParameter("@pay_ylzfbl", SqlDbType.Decimal), new SqlParameter("@pay_ylzfstart", SqlDbType.Decimal), new SqlParameter("@pay_ylzfend", SqlDbType.Decimal), new SqlParameter("@pay_b2cwyzfbl", SqlDbType.Decimal), new SqlParameter("@pay_b2bwyzf", SqlDbType.Decimal), new SqlParameter("@Pay_mfcs", SqlDbType.Int), new SqlParameter("@createUser", SqlDbType.Int), new SqlParameter("@createDate", SqlDbType.DateTime), new SqlParameter("@Start", SqlDbType.Int), new SqlParameter("@remark", SqlDbType.NVarChar, 200), new SqlParameter("@vdef1", SqlDbType.NVarChar, 128), new SqlParameter("@vdef2", SqlDbType.NVarChar, 128), new SqlParameter("@vdef3", SqlDbType.NVarChar, 128), new SqlParameter("@vdef4", SqlDbType.NVarChar, 128), new SqlParameter("@vdef5", SqlDbType.NVarChar, 128), new SqlParameter("@vdef6", SqlDbType.NVarChar, 128), new SqlParameter("@vdef7", SqlDbType.NVarChar, 128), new SqlParameter("@vdef8", SqlDbType.NVarChar, 128), new SqlParameter("@vdef9", SqlDbType.NVarChar, 128), new SqlParameter("@vdef10", SqlDbType.NVarChar, 128), new SqlParameter("@vdef11", SqlDbType.NVarChar, 128), new SqlParameter("@vdef12", SqlDbType.NVarChar, 128), new SqlParameter("@vdef13", SqlDbType.NVarChar, 128), new SqlParameter("@vdef14", SqlDbType.NVarChar, 128), new SqlParameter("@vdef15", SqlDbType.NVarChar, 128), new SqlParameter("@ts", SqlDbType.DateTime), new SqlParameter("@dr", SqlDbType.Int), new SqlParameter("@modifyuser", SqlDbType.Int) }; parameters[0].Value = model.CompID; parameters[1].Value = model.pay_sxfsq; parameters[2].Value = model.pay_zffs; parameters[3].Value = model.pay_kjzfbl; parameters[4].Value = model.pay_kjzfstart; parameters[5].Value = model.pay_kjzfend; parameters[6].Value = model.pay_ylzfbl; parameters[7].Value = model.pay_ylzfstart; parameters[8].Value = model.pay_ylzfend; parameters[9].Value = model.pay_b2cwyzfbl; parameters[10].Value = model.pay_b2bwyzf; parameters[11].Value = model.Pay_mfcs; parameters[12].Value = model.createUser; if (model.createDate != DateTime.MinValue) { parameters[13].Value = model.createDate; } else { parameters[13].Value = DBNull.Value; } parameters[14].Value = model.Start; if (model.remark != null) { parameters[15].Value = model.remark; } else { parameters[15].Value = DBNull.Value; } if (model.vdef1 != null) { parameters[16].Value = model.vdef1; } else { parameters[16].Value = DBNull.Value; } if (model.vdef2 != null) { parameters[17].Value = model.vdef2; } else { parameters[17].Value = DBNull.Value; } if (model.vdef3 != null) { parameters[18].Value = model.vdef3; } else { parameters[18].Value = DBNull.Value; } if (model.vdef4 != null) { parameters[19].Value = model.vdef4; } else { parameters[19].Value = DBNull.Value; } if (model.vdef5 != null) { parameters[20].Value = model.vdef5; } else { parameters[20].Value = DBNull.Value; } if (model.vdef6 != null) { parameters[21].Value = model.vdef6; } else { parameters[21].Value = DBNull.Value; } if (model.vdef7 != null) { parameters[22].Value = model.vdef7; } else { parameters[22].Value = DBNull.Value; } if (model.vdef8 != null) { parameters[23].Value = model.vdef8; } else { parameters[23].Value = DBNull.Value; } if (model.vdef9 != null) { parameters[24].Value = model.vdef9; } else { parameters[24].Value = DBNull.Value; } if (model.vdef10 != null) { parameters[25].Value = model.vdef10; } else { parameters[25].Value = DBNull.Value; } if (model.vdef11 != null) { parameters[26].Value = model.vdef11; } else { parameters[26].Value = DBNull.Value; } if (model.vdef12 != null) { parameters[27].Value = model.vdef12; } else { parameters[27].Value = DBNull.Value; } if (model.vdef13 != null) { parameters[28].Value = model.vdef13; } else { parameters[28].Value = DBNull.Value; } if (model.vdef14 != null) { parameters[29].Value = model.vdef14; } else { parameters[29].Value = DBNull.Value; } if (model.vdef15 != null) { parameters[30].Value = model.vdef15; } else { parameters[30].Value = DBNull.Value; } if (model.ts != DateTime.MinValue) { parameters[31].Value = model.ts; } else { parameters[31].Value = DBNull.Value; } parameters[32].Value = model.dr; parameters[33].Value = model.modifyuser; return(SqlHelper.GetInt(SqlHelper.GetSingle(SqlHelper.LocalSqlServer, strSql.ToString(), parameters))); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Hi.Model.Pay_PaymentSettings model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update [Pay_PaymentSettings] set "); strSql.Append("[CompID]=@CompID,"); strSql.Append("[pay_sxfsq]=@pay_sxfsq,"); strSql.Append("[pay_zffs]=@pay_zffs,"); strSql.Append("[pay_kjzfbl]=@pay_kjzfbl,"); strSql.Append("[pay_kjzfstart]=@pay_kjzfstart,"); strSql.Append("[pay_kjzfend]=@pay_kjzfend,"); strSql.Append("[pay_ylzfbl]=@pay_ylzfbl,"); strSql.Append("[pay_ylzfstart]=@pay_ylzfstart,"); strSql.Append("[pay_ylzfend]=@pay_ylzfend,"); strSql.Append("[pay_b2cwyzfbl]=@pay_b2cwyzfbl,"); strSql.Append("[pay_b2bwyzf]=@pay_b2bwyzf,"); strSql.Append("[Pay_mfcs]=@Pay_mfcs,"); strSql.Append("[createUser]=@createUser,"); strSql.Append("[createDate]=@createDate,"); strSql.Append("[Start]=@Start,"); strSql.Append("[remark]=@remark,"); strSql.Append("[vdef1]=@vdef1,"); strSql.Append("[vdef2]=@vdef2,"); strSql.Append("[vdef3]=@vdef3,"); strSql.Append("[vdef4]=@vdef4,"); strSql.Append("[vdef5]=@vdef5,"); strSql.Append("[vdef6]=@vdef6,"); strSql.Append("[vdef7]=@vdef7,"); strSql.Append("[vdef8]=@vdef8,"); strSql.Append("[vdef9]=@vdef9,"); strSql.Append("[vdef10]=@vdef10,"); strSql.Append("[vdef11]=@vdef11,"); strSql.Append("[vdef12]=@vdef12,"); strSql.Append("[vdef13]=@vdef13,"); strSql.Append("[vdef14]=@vdef14,"); strSql.Append("[vdef15]=@vdef15,"); strSql.Append("[ts]=@ts,"); strSql.Append("[dr]=@dr,"); strSql.Append("[modifyuser]=@modifyuser"); strSql.Append(" where [ID]=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.BigInt), new SqlParameter("@CompID", SqlDbType.BigInt), new SqlParameter("@pay_sxfsq", SqlDbType.Int), new SqlParameter("@pay_zffs", SqlDbType.Int), new SqlParameter("@pay_kjzfbl", SqlDbType.Decimal), new SqlParameter("@pay_kjzfstart", SqlDbType.Decimal), new SqlParameter("@pay_kjzfend", SqlDbType.Decimal), new SqlParameter("@pay_ylzfbl", SqlDbType.Decimal), new SqlParameter("@pay_ylzfstart", SqlDbType.Decimal), new SqlParameter("@pay_ylzfend", SqlDbType.Decimal), new SqlParameter("@pay_b2cwyzfbl", SqlDbType.Decimal), new SqlParameter("@pay_b2bwyzf", SqlDbType.Decimal), new SqlParameter("@Pay_mfcs", SqlDbType.Int), new SqlParameter("@createUser", SqlDbType.Int), new SqlParameter("@createDate", SqlDbType.DateTime), new SqlParameter("@Start", SqlDbType.Int), new SqlParameter("@remark", SqlDbType.NVarChar, 200), new SqlParameter("@vdef1", SqlDbType.NVarChar, 128), new SqlParameter("@vdef2", SqlDbType.NVarChar, 128), new SqlParameter("@vdef3", SqlDbType.NVarChar, 128), new SqlParameter("@vdef4", SqlDbType.NVarChar, 128), new SqlParameter("@vdef5", SqlDbType.NVarChar, 128), new SqlParameter("@vdef6", SqlDbType.NVarChar, 128), new SqlParameter("@vdef7", SqlDbType.NVarChar, 128), new SqlParameter("@vdef8", SqlDbType.NVarChar, 128), new SqlParameter("@vdef9", SqlDbType.NVarChar, 128), new SqlParameter("@vdef10", SqlDbType.NVarChar, 128), new SqlParameter("@vdef11", SqlDbType.NVarChar, 128), new SqlParameter("@vdef12", SqlDbType.NVarChar, 128), new SqlParameter("@vdef13", SqlDbType.NVarChar, 128), new SqlParameter("@vdef14", SqlDbType.NVarChar, 128), new SqlParameter("@vdef15", SqlDbType.NVarChar, 128), new SqlParameter("@ts", SqlDbType.DateTime), new SqlParameter("@dr", SqlDbType.Int), new SqlParameter("@modifyuser", SqlDbType.Int) }; parameters[0].Value = model.ID; parameters[1].Value = model.CompID; parameters[2].Value = model.pay_sxfsq; parameters[3].Value = model.pay_zffs; parameters[4].Value = model.pay_kjzfbl; parameters[5].Value = model.pay_kjzfstart; parameters[6].Value = model.pay_kjzfend; parameters[7].Value = model.pay_ylzfbl; parameters[8].Value = model.pay_ylzfstart; parameters[9].Value = model.pay_ylzfend; parameters[10].Value = model.pay_b2cwyzfbl; parameters[11].Value = model.pay_b2bwyzf; parameters[12].Value = model.Pay_mfcs; parameters[13].Value = model.createUser; if (model.createDate != DateTime.MinValue) { parameters[14].Value = model.createDate; } else { parameters[14].Value = DBNull.Value; } parameters[15].Value = model.Start; if (model.remark != null) { parameters[16].Value = model.remark; } else { parameters[16].Value = DBNull.Value; } if (model.vdef1 != null) { parameters[17].Value = model.vdef1; } else { parameters[17].Value = DBNull.Value; } if (model.vdef2 != null) { parameters[18].Value = model.vdef2; } else { parameters[18].Value = DBNull.Value; } if (model.vdef3 != null) { parameters[19].Value = model.vdef3; } else { parameters[19].Value = DBNull.Value; } if (model.vdef4 != null) { parameters[20].Value = model.vdef4; } else { parameters[20].Value = DBNull.Value; } if (model.vdef5 != null) { parameters[21].Value = model.vdef5; } else { parameters[21].Value = DBNull.Value; } if (model.vdef6 != null) { parameters[22].Value = model.vdef6; } else { parameters[22].Value = DBNull.Value; } if (model.vdef7 != null) { parameters[23].Value = model.vdef7; } else { parameters[23].Value = DBNull.Value; } if (model.vdef8 != null) { parameters[24].Value = model.vdef8; } else { parameters[24].Value = DBNull.Value; } if (model.vdef9 != null) { parameters[25].Value = model.vdef9; } else { parameters[25].Value = DBNull.Value; } if (model.vdef10 != null) { parameters[26].Value = model.vdef10; } else { parameters[26].Value = DBNull.Value; } if (model.vdef11 != null) { parameters[27].Value = model.vdef11; } else { parameters[27].Value = DBNull.Value; } if (model.vdef12 != null) { parameters[28].Value = model.vdef12; } else { parameters[28].Value = DBNull.Value; } if (model.vdef13 != null) { parameters[29].Value = model.vdef13; } else { parameters[29].Value = DBNull.Value; } if (model.vdef14 != null) { parameters[30].Value = model.vdef14; } else { parameters[30].Value = DBNull.Value; } if (model.vdef15 != null) { parameters[31].Value = model.vdef15; } else { parameters[31].Value = DBNull.Value; } if (model.ts != DateTime.MinValue) { parameters[32].Value = model.ts; } else { parameters[32].Value = DBNull.Value; } parameters[33].Value = model.dr; parameters[34].Value = model.modifyuser; return(SqlHelper.ExecuteSql(SqlHelper.LocalSqlServer, strSql.ToString(), parameters) > 0); }