/// <summary> /// 得到一个对象实体 /// </summary> public viviapi.Model.Finance.PayRate GetModel(byte rateType, int billId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,rateType,billId,billame,p100,p101,p102,p103,p104,p105,p106,p107,p108,p109,p110,p111,p112,p113,p114,p115,p116,p117,p118,p119,p300,p200,p201,p202,p203,p204,p205,p207,p208,p209,p210,p206 from PayRate "); strSql.Append(" where rateType=@rateType and billId=@billId"); SqlParameter[] parameters = { new SqlParameter("@rateType", SqlDbType.TinyInt, 1) , new SqlParameter("@billId", SqlDbType.Int, 4) }; parameters[0].Value = rateType; parameters[1].Value = billId; viviapi.Model.Finance.PayRate model = new viviapi.Model.Finance.PayRate(); 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 int Insert(viviapi.Model.Finance.PayRate model) { try { return(dal.Insert(model)); } catch (Exception ex) { ExceptionHandler.HandleException(ex); return(0); } }
/// <summary> /// 得到一个对象实体 /// </summary> public viviapi.Model.Finance.PayRate GetModelByUser(int userId) { SqlParameter[] parameters = { new SqlParameter("@userid", SqlDbType.Int, 4) }; parameters[0].Value = userId; viviapi.Model.Finance.PayRate model = new viviapi.Model.Finance.PayRate(); DataSet ds = DataBase.ExecuteDataset(CommandType.StoredProcedure, "proc_payrate_getmodelbyuser", parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
protected void btnCopy_Click(object sender, EventArgs e) { viviapi.Model.Finance.PayRate _model = viviapi.BLL.Finance.PayRate.Instance.GetModelByUser(this.ItemInfoId); if (_model != null) { this.txtp100.Text = (Convert.ToDecimal(_model.p100) * 100).ToString("0.00"); this.txtp101.Text = (Convert.ToDecimal(_model.p101) * 100).ToString("0.00"); this.txtp102.Text = (Convert.ToDecimal(_model.p102) * 100).ToString("0.00"); this.txtp103.Text = (Convert.ToDecimal(_model.p103) * 100).ToString("0.00"); this.txtp104.Text = (Convert.ToDecimal(_model.p104) * 100).ToString("0.00"); this.txtp105.Text = (Convert.ToDecimal(_model.p105) * 100).ToString("0.00"); this.txtp106.Text = (Convert.ToDecimal(_model.p106) * 100).ToString("0.00"); this.txtp107.Text = (Convert.ToDecimal(_model.p107) * 100).ToString("0.00"); this.txtp108.Text = (Convert.ToDecimal(_model.p108) * 100).ToString("0.00"); this.txtp109.Text = (Convert.ToDecimal(_model.p109) * 100).ToString("0.00"); this.txtp110.Text = (Convert.ToDecimal(_model.p110) * 100).ToString("0.00"); this.txtp111.Text = (Convert.ToDecimal(_model.p111) * 100).ToString("0.00"); this.txtp112.Text = (Convert.ToDecimal(_model.p112) * 100).ToString("0.00"); this.txtp113.Text = (Convert.ToDecimal(_model.p113) * 100).ToString("0.00"); this.txtp114.Text = (Convert.ToDecimal(_model.p114) * 100).ToString("0.00"); this.txtp115.Text = (Convert.ToDecimal(_model.p115) * 100).ToString("0.00"); this.txtp116.Text = (Convert.ToDecimal(_model.p116) * 100).ToString("0.00"); this.txtp117.Text = (Convert.ToDecimal(_model.p117) * 100).ToString("0.00"); this.txtp118.Text = (Convert.ToDecimal(_model.p118) * 100).ToString("0.00"); this.txtp119.Text = (Convert.ToDecimal(_model.p119) * 100).ToString("0.00"); this.txtp200.Text = (Convert.ToDecimal(_model.p200) * 100).ToString("0.00"); this.txtp201.Text = (Convert.ToDecimal(_model.p201) * 100).ToString("0.00"); this.txtp202.Text = (Convert.ToDecimal(_model.p202) * 100).ToString("0.00"); this.txtp203.Text = (Convert.ToDecimal(_model.p203) * 100).ToString("0.00"); this.txtp204.Text = (Convert.ToDecimal(_model.p204) * 100).ToString("0.00"); this.txtp205.Text = (Convert.ToDecimal(_model.p205) * 100).ToString("0.00"); this.txtp208.Text = (Convert.ToDecimal(_model.p208) * 100).ToString("0.00"); this.txtp209.Text = (Convert.ToDecimal(_model.p209) * 100).ToString("0.00"); this.txtp300.Text = (Convert.ToDecimal(_model.p300) * 100).ToString("0.00"); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(viviapi.Model.Finance.PayRate model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(viviapi.Model.Finance.PayRate model) { return(dal.Add(model)); }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { var userInfo = viviapi.BLL.User.Factory.GetModel(this.UserId); if (userInfo == null) { ShowMessageBox("商户不存在"); return; } var amtInfo = AmtInfo; if (amtInfo == null) { amtInfo = new UserSettingInfo { userid = UserId, special = (byte)(this.ckb_isopen.Checked ? 1 : 0) }; } else { amtInfo.userid = UserId; amtInfo.special = (byte)(this.ckb_isopen.Checked ? 1 : 0); } amtInfo.payrate = 0; if (amtInfo.special == 1) { #region check value string strErr = string.Empty; if (!viviLib.Text.Validate.IsNumber(txtp100.Text)) { strErr += "p100格式错误!\n"; } if (!viviLib.Text.Validate.IsNumber(txtp101.Text)) { strErr += "p101格式错误!\n"; } if (!viviLib.Text.Validate.IsNumber(txtp102.Text)) { strErr += "p102格式错误!\n"; } if (!viviLib.Text.Validate.IsNumber(txtp103.Text)) { strErr += "p103格式错误!\n"; } if (!viviLib.Text.Validate.IsNumber(txtp104.Text)) { strErr += "p104格式错误!\n"; } if (!viviLib.Text.Validate.IsNumber(txtp105.Text)) { strErr += "p105格式错误!\n"; } if (!viviLib.Text.Validate.IsNumber(txtp106.Text)) { strErr += "p106格式错误!\n"; } if (!viviLib.Text.Validate.IsNumber(txtp107.Text)) { strErr += "p107格式错误!\n"; } if (!viviLib.Text.Validate.IsNumber(txtp108.Text)) { strErr += "p108格式错误!\n"; } if (!viviLib.Text.Validate.IsNumber(txtp109.Text)) { strErr += "p109格式错误!\n"; } if (!viviLib.Text.Validate.IsNumber(txtp110.Text)) { strErr += "p110格式错误!\n"; } if (!viviLib.Text.Validate.IsNumber(txtp111.Text)) { strErr += "p111格式错误!\n"; } if (!viviLib.Text.Validate.IsNumber(txtp112.Text)) { strErr += "p112格式错误!\n"; } if (!viviLib.Text.Validate.IsNumber(txtp113.Text)) { strErr += "p113格式错误!\n"; } //if (!viviLib.Text.Validate.IsNumber(txtp114.Text)) //{ // strErr += "p114格式错误!\n"; //} //if (!viviLib.Text.Validate.IsNumber(txtp115.Text)) //{ // strErr += "p115格式错误!\n"; //} //if (!viviLib.Text.Validate.IsNumber(txtp116.Text)) //{ // strErr += "p116格式错误!\n"; //} if (!viviLib.Text.Validate.IsNumber(txtp117.Text)) { strErr += "p117格式错误!\n"; } if (!viviLib.Text.Validate.IsNumber(txtp118.Text)) { strErr += "p118格式错误!\n"; } if (!viviLib.Text.Validate.IsNumber(txtp119.Text)) { strErr += "p119格式错误!\n"; } //if (!viviLib.Text.Validate.IsNumber(txtp200.Text)) //{ // strErr += "p200格式错误!\n"; //} //if (!viviLib.Text.Validate.IsNumber(txtp201.Text)) //{ // strErr += "p201格式错误!\n"; //} //if (!viviLib.Text.Validate.IsNumber(txtp202.Text)) //{ // strErr += "p202格式错误!\n"; //} if (!viviLib.Text.Validate.IsNumber(txtp203.Text)) { strErr += "p203格式错误!\n"; } if (!viviLib.Text.Validate.IsNumber(txtp204.Text)) { strErr += "p204格式错误!\n"; } if (!viviLib.Text.Validate.IsNumber(txtp205.Text)) { strErr += "p205格式错误!\n"; } if (!viviLib.Text.Validate.IsNumber(txtp207.Text)) { strErr += "p207格式错误!\n"; } if (!viviLib.Text.Validate.IsNumber(txtp208.Text)) { strErr += "p208格式错误!\n"; } if (!viviLib.Text.Validate.IsNumber(txtp209.Text)) { strErr += "p209格式错误!\n"; } if (!viviLib.Text.Validate.IsNumber(txtp300.Text)) { strErr += "p300格式错误!\n"; } #endregion if (strErr != "") { ShowMessageBox(strErr); return; } #region decimal p100 = decimal.Parse(this.txtp100.Text) / 100; decimal p101 = decimal.Parse(this.txtp101.Text) / 100; decimal p102 = decimal.Parse(this.txtp102.Text) / 100; decimal p103 = decimal.Parse(this.txtp103.Text) / 100; decimal p104 = decimal.Parse(this.txtp104.Text) / 100; decimal p105 = decimal.Parse(this.txtp105.Text) / 100; decimal p106 = decimal.Parse(this.txtp106.Text) / 100; decimal p107 = decimal.Parse(this.txtp107.Text) / 100; decimal p108 = decimal.Parse(this.txtp108.Text) / 100; decimal p109 = decimal.Parse(this.txtp109.Text) / 100; decimal p110 = decimal.Parse(this.txtp110.Text) / 100; decimal p111 = decimal.Parse(this.txtp111.Text) / 100; decimal p112 = decimal.Parse(this.txtp112.Text) / 100; decimal p113 = decimal.Parse(this.txtp113.Text) / 100; //decimal p114 = decimal.Parse(this.txtp114.Text) / 100; //decimal p115 = decimal.Parse(this.txtp115.Text) / 100; //decimal p116 = decimal.Parse(this.txtp116.Text) / 100; decimal p117 = decimal.Parse(this.txtp117.Text) / 100; decimal p118 = decimal.Parse(this.txtp118.Text) / 100; decimal p119 = decimal.Parse(this.txtp119.Text) / 100; decimal p200 = decimal.Parse(this.txtp200.Text) / 100; //decimal p201 = decimal.Parse(this.txtp201.Text) / 100; //decimal p202 = decimal.Parse(this.txtp202.Text) / 100; decimal p203 = decimal.Parse(this.txtp203.Text) / 100; decimal p204 = decimal.Parse(this.txtp204.Text) / 100; decimal p205 = decimal.Parse(this.txtp205.Text) / 100; // decimal p206 = decimal.Parse(this.txtp206.Text) / 100; decimal p207 = decimal.Parse(this.txtp207.Text) / 100; decimal p208 = decimal.Parse(this.txtp208.Text) / 100; decimal p209 = decimal.Parse(this.txtp209.Text) / 100; decimal p210 = decimal.Parse(this.txtp210.Text) / 100; decimal p300 = decimal.Parse(this.txtp300.Text) / 100; //decimal p100 = decimal.Parse(this.txtp100.Text) / 100; //decimal p101 = decimal.Parse(this.txtp101.Text) / 100; //decimal p102 = decimal.Parse(this.txtp102.Text) / 100; //decimal p103 = decimal.Parse(this.txtp103.Text) / 100; //decimal p104 = decimal.Parse(this.txtp104.Text) / 100; //decimal p105 = decimal.Parse(this.txtp105.Text) / 100; //decimal p106 = decimal.Parse(this.txtp106.Text) / 100; //decimal p107 = decimal.Parse(this.txtp107.Text) / 100; //decimal p108 = decimal.Parse(this.txtp108.Text) / 100; //decimal p109 = decimal.Parse(this.txtp109.Text) / 100; //decimal p110 = decimal.Parse(this.txtp110.Text) / 100; //decimal p111 = decimal.Parse(this.txtp111.Text) / 100; //decimal p112 = decimal.Parse(this.txtp112.Text) / 100; //decimal p113 = decimal.Parse(this.txtp113.Text) / 100; ////decimal p114 = decimal.Parse(this.txtp114.Text) / 100; ////decimal p115 = decimal.Parse(this.txtp115.Text) / 100; ////decimal p116 = decimal.Parse(this.txtp116.Text) / 100; //decimal p117 = decimal.Parse(this.txtp117.Text) / 100; //decimal p118 = decimal.Parse(this.txtp118.Text) / 100; //decimal p119 = decimal.Parse(this.txtp119.Text) / 100; ////decimal p200 = decimal.Parse(this.txtp200.Text) / 100; ////decimal p201 = decimal.Parse(this.txtp201.Text) / 100; ////decimal p202 = decimal.Parse(this.txtp202.Text) / 100; //decimal p203 = decimal.Parse(this.txtp203.Text) / 100; //decimal p204 = decimal.Parse(this.txtp204.Text) / 100; //decimal p205 = decimal.Parse(this.txtp205.Text) / 100; //decimal p206 = decimal.Parse(this.txtp206.Text) / 100; //decimal p207 = decimal.Parse(this.txtp207.Text) / 100; //decimal p208 = decimal.Parse(this.txtp208.Text) / 100; //decimal p209 = decimal.Parse(this.txtp209.Text) / 100; //decimal p210 = decimal.Parse(this.txtp210.Text) / 100; //decimal p300 = decimal.Parse(this.txtp300.Text) / 100; #endregion #region var rateInfo = new viviapi.Model.Finance.PayRate { rateType = 2, billId = UserId, billame = userInfo.UserName, p100 = p100, p101 = p101, p102 = p102, p103 = p103, p104 = p104, p105 = p105, p106 = p106, p107 = p107, p108 = p108, p109 = p109, p110 = p110, p111 = p111, p112 = p112, p113 = p113, //p114 = p114, //p115 = p115, //p116 = p116, p117 = p117, p118 = p118, p119 = p119, p200 = p200, //p201 = p201, //p202 = p202, p203 = p203, p204 = p204, p205 = p205, // p206 = p206, p207 = p207, p208 = p208, p209 = p209, p210 = p210, p300 = p300 }; if (MuserPayRate != null) { rateInfo.id = MuserPayRate.id; } int id = viviapi.BLL.Finance.PayRate.Instance.Insert(rateInfo); if (id <= 0) { ShowMessageBox("保存失败"); return; } #endregion amtInfo.payrate = id; } bool result = viviapi.BLL.User.UserSetting.Instance.PayRateConfig(amtInfo); if (result) { ShowMessageBox("操作成功"); } else { ShowMessageBox("操作失败"); } }
public int Insert(viviapi.Model.Finance.PayRate model) { SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@rateType", SqlDbType.TinyInt, 1), new SqlParameter("@billId", SqlDbType.Int, 4), new SqlParameter("@billame", SqlDbType.VarChar, 50), new SqlParameter("@p100", SqlDbType.Decimal, 9), new SqlParameter("@p101", SqlDbType.Decimal, 9), new SqlParameter("@p102", SqlDbType.Decimal, 9), new SqlParameter("@p103", SqlDbType.Decimal, 9), new SqlParameter("@p104", SqlDbType.Decimal, 9), new SqlParameter("@p105", SqlDbType.Decimal, 9), new SqlParameter("@p106", SqlDbType.Decimal, 9), new SqlParameter("@p107", SqlDbType.Decimal, 9), new SqlParameter("@p108", SqlDbType.Decimal, 9), new SqlParameter("@p109", SqlDbType.Decimal, 9), new SqlParameter("@p110", SqlDbType.Decimal, 9), new SqlParameter("@p111", SqlDbType.Decimal, 9), new SqlParameter("@p112", SqlDbType.Decimal, 9), new SqlParameter("@p113", SqlDbType.Decimal, 9), new SqlParameter("@p114", SqlDbType.Decimal, 9), new SqlParameter("@p115", SqlDbType.Decimal, 9), new SqlParameter("@p116", SqlDbType.Decimal, 9), new SqlParameter("@p117", SqlDbType.Decimal, 9), new SqlParameter("@p118", SqlDbType.Decimal, 9), new SqlParameter("@p119", SqlDbType.Decimal, 9), new SqlParameter("@p300", SqlDbType.Decimal, 9), new SqlParameter("@p200", SqlDbType.Decimal, 9), new SqlParameter("@p201", SqlDbType.Decimal, 9), new SqlParameter("@p202", SqlDbType.Decimal, 9), new SqlParameter("@p203", SqlDbType.Decimal, 9), new SqlParameter("@p204", SqlDbType.Decimal, 9), new SqlParameter("@p205", SqlDbType.Decimal, 9), new SqlParameter("@p207", SqlDbType.Decimal, 9), new SqlParameter("@p208", SqlDbType.Decimal, 9), new SqlParameter("@p209", SqlDbType.Decimal, 9), new SqlParameter("@p210", SqlDbType.Decimal, 9), new SqlParameter("@p206", SqlDbType.Decimal, 9) }; parameters[0].Value = model.id; parameters[1].Value = model.rateType; parameters[2].Value = model.billId; parameters[3].Value = model.billame; parameters[4].Value = model.p100; parameters[5].Value = model.p101; parameters[6].Value = model.p102; parameters[7].Value = model.p103; parameters[8].Value = model.p104; parameters[9].Value = model.p105; parameters[10].Value = model.p106; parameters[11].Value = model.p107; parameters[12].Value = model.p108; parameters[13].Value = model.p109; parameters[14].Value = model.p110; parameters[15].Value = model.p111; parameters[16].Value = model.p112; parameters[17].Value = model.p113; parameters[18].Value = model.p114; parameters[19].Value = model.p115; parameters[20].Value = model.p116; parameters[21].Value = model.p117; parameters[22].Value = model.p118; parameters[23].Value = model.p119; parameters[24].Value = model.p300; parameters[25].Value = model.p200; parameters[26].Value = model.p201; parameters[27].Value = model.p202; parameters[28].Value = model.p203; parameters[29].Value = model.p204; parameters[30].Value = model.p205; parameters[31].Value = model.p207; parameters[32].Value = model.p208; parameters[33].Value = model.p209; parameters[34].Value = model.p210; parameters[35].Value = model.p206; object obj = DataBase.ExecuteScalar(CommandType.StoredProcedure, "proc_payrate_insert", parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public viviapi.Model.Finance.PayRate DataRowToModel(DataRow row) { viviapi.Model.Finance.PayRate model = new viviapi.Model.Finance.PayRate(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["rateType"] != null && row["rateType"].ToString() != "") { model.rateType = int.Parse(row["rateType"].ToString()); } if (row["billId"] != null && row["billId"].ToString() != "") { model.billId = int.Parse(row["billId"].ToString()); } if (row["billame"] != null) { model.billame = row["billame"].ToString(); } if (row["p100"] != null && row["p100"].ToString() != "") { model.p100 = decimal.Parse(row["p100"].ToString()); } if (row["p101"] != null && row["p101"].ToString() != "") { model.p101 = decimal.Parse(row["p101"].ToString()); } if (row["p102"] != null && row["p102"].ToString() != "") { model.p102 = decimal.Parse(row["p102"].ToString()); } if (row["p103"] != null && row["p103"].ToString() != "") { model.p103 = decimal.Parse(row["p103"].ToString()); } if (row["p104"] != null && row["p104"].ToString() != "") { model.p104 = decimal.Parse(row["p104"].ToString()); } if (row["p105"] != null && row["p105"].ToString() != "") { model.p105 = decimal.Parse(row["p105"].ToString()); } if (row["p106"] != null && row["p106"].ToString() != "") { model.p106 = decimal.Parse(row["p106"].ToString()); } if (row["p107"] != null && row["p107"].ToString() != "") { model.p107 = decimal.Parse(row["p107"].ToString()); } if (row["p108"] != null && row["p108"].ToString() != "") { model.p108 = decimal.Parse(row["p108"].ToString()); } if (row["p109"] != null && row["p109"].ToString() != "") { model.p109 = decimal.Parse(row["p109"].ToString()); } if (row["p110"] != null && row["p110"].ToString() != "") { model.p110 = decimal.Parse(row["p110"].ToString()); } if (row["p111"] != null && row["p111"].ToString() != "") { model.p111 = decimal.Parse(row["p111"].ToString()); } if (row["p112"] != null && row["p112"].ToString() != "") { model.p112 = decimal.Parse(row["p112"].ToString()); } if (row["p113"] != null && row["p113"].ToString() != "") { model.p113 = decimal.Parse(row["p113"].ToString()); } if (row["p114"] != null && row["p114"].ToString() != "") { model.p114 = decimal.Parse(row["p114"].ToString()); } if (row["p115"] != null && row["p115"].ToString() != "") { model.p115 = decimal.Parse(row["p115"].ToString()); } if (row["p116"] != null && row["p116"].ToString() != "") { model.p116 = decimal.Parse(row["p116"].ToString()); } if (row["p117"] != null && row["p117"].ToString() != "") { model.p117 = decimal.Parse(row["p117"].ToString()); } if (row["p118"] != null && row["p118"].ToString() != "") { model.p118 = decimal.Parse(row["p118"].ToString()); } if (row["p119"] != null && row["p119"].ToString() != "") { model.p119 = decimal.Parse(row["p119"].ToString()); } if (row["p300"] != null && row["p300"].ToString() != "") { model.p300 = decimal.Parse(row["p300"].ToString()); } if (row["p200"] != null && row["p200"].ToString() != "") { model.p200 = decimal.Parse(row["p200"].ToString()); } if (row["p201"] != null && row["p201"].ToString() != "") { model.p201 = decimal.Parse(row["p201"].ToString()); } if (row["p202"] != null && row["p202"].ToString() != "") { model.p202 = decimal.Parse(row["p202"].ToString()); } if (row["p203"] != null && row["p203"].ToString() != "") { model.p203 = decimal.Parse(row["p203"].ToString()); } if (row["p204"] != null && row["p204"].ToString() != "") { model.p204 = decimal.Parse(row["p204"].ToString()); } if (row["p205"] != null && row["p205"].ToString() != "") { model.p205 = decimal.Parse(row["p205"].ToString()); } if (row["p207"] != null && row["p207"].ToString() != "") { model.p207 = decimal.Parse(row["p207"].ToString()); } if (row["p208"] != null && row["p208"].ToString() != "") { model.p208 = decimal.Parse(row["p208"].ToString()); } if (row["p209"] != null && row["p209"].ToString() != "") { model.p209 = decimal.Parse(row["p209"].ToString()); } if (row["p210"] != null && row["p210"].ToString() != "") { model.p210 = decimal.Parse(row["p210"].ToString()); } if (row["p206"] != null && row["p206"].ToString() != "") { model.p206 = decimal.Parse(row["p206"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(viviapi.Model.Finance.PayRate model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update PayRate set "); strSql.Append("rateType=@rateType,"); strSql.Append("billId=@billId,"); strSql.Append("billame=@billame,"); strSql.Append("p100=@p100,"); strSql.Append("p101=@p101,"); strSql.Append("p102=@p102,"); strSql.Append("p103=@p103,"); strSql.Append("p104=@p104,"); strSql.Append("p105=@p105,"); strSql.Append("p106=@p106,"); strSql.Append("p107=@p107,"); strSql.Append("p108=@p108,"); strSql.Append("p109=@p109,"); strSql.Append("p110=@p110,"); strSql.Append("p111=@p111,"); strSql.Append("p112=@p112,"); strSql.Append("p113=@p113,"); strSql.Append("p114=@p114,"); strSql.Append("p115=@p115,"); strSql.Append("p116=@p116,"); strSql.Append("p117=@p117,"); strSql.Append("p118=@p118,"); strSql.Append("p119=@p119,"); strSql.Append("p300=@p300,"); strSql.Append("p200=@p200,"); strSql.Append("p201=@p201,"); strSql.Append("p202=@p202,"); strSql.Append("p203=@p203,"); strSql.Append("p204=@p204,"); strSql.Append("p205=@p205,"); strSql.Append("p207=@p207,"); strSql.Append("p208=@p208,"); strSql.Append("p209=@p209,"); strSql.Append("p210=@p210,"); strSql.Append("p206=@p206"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@rateType", SqlDbType.TinyInt, 1), new SqlParameter("@billId", SqlDbType.Int, 4), new SqlParameter("@billame", SqlDbType.VarChar, 50), new SqlParameter("@p100", SqlDbType.Decimal, 9), new SqlParameter("@p101", SqlDbType.Decimal, 9), new SqlParameter("@p102", SqlDbType.Decimal, 9), new SqlParameter("@p103", SqlDbType.Decimal, 9), new SqlParameter("@p104", SqlDbType.Decimal, 9), new SqlParameter("@p105", SqlDbType.Decimal, 9), new SqlParameter("@p106", SqlDbType.Decimal, 9), new SqlParameter("@p107", SqlDbType.Decimal, 9), new SqlParameter("@p108", SqlDbType.Decimal, 9), new SqlParameter("@p109", SqlDbType.Decimal, 9), new SqlParameter("@p110", SqlDbType.Decimal, 9), new SqlParameter("@p111", SqlDbType.Decimal, 9), new SqlParameter("@p112", SqlDbType.Decimal, 9), new SqlParameter("@p113", SqlDbType.Decimal, 9), new SqlParameter("@p114", SqlDbType.Decimal, 9), new SqlParameter("@p115", SqlDbType.Decimal, 9), new SqlParameter("@p116", SqlDbType.Decimal, 9), new SqlParameter("@p117", SqlDbType.Decimal, 9), new SqlParameter("@p118", SqlDbType.Decimal, 9), new SqlParameter("@p119", SqlDbType.Decimal, 9), new SqlParameter("@p300", SqlDbType.Decimal, 9), new SqlParameter("@p200", SqlDbType.Decimal, 9), new SqlParameter("@p201", SqlDbType.Decimal, 9), new SqlParameter("@p202", SqlDbType.Decimal, 9), new SqlParameter("@p203", SqlDbType.Decimal, 9), new SqlParameter("@p204", SqlDbType.Decimal, 9), new SqlParameter("@p205", SqlDbType.Decimal, 9), new SqlParameter("@p207", SqlDbType.Decimal, 9), new SqlParameter("@p208", SqlDbType.Decimal, 9), new SqlParameter("@p209", SqlDbType.Decimal, 9), new SqlParameter("@p210", SqlDbType.Decimal, 9), new SqlParameter("@p206", SqlDbType.Decimal, 9), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.rateType; parameters[1].Value = model.billId; parameters[2].Value = model.billame; parameters[3].Value = model.p100; parameters[4].Value = model.p101; parameters[5].Value = model.p102; parameters[6].Value = model.p103; parameters[7].Value = model.p104; parameters[8].Value = model.p105; parameters[9].Value = model.p106; parameters[10].Value = model.p107; parameters[11].Value = model.p108; parameters[12].Value = model.p109; parameters[13].Value = model.p110; parameters[14].Value = model.p111; parameters[15].Value = model.p112; parameters[16].Value = model.p113; parameters[17].Value = model.p114; parameters[18].Value = model.p115; parameters[19].Value = model.p116; parameters[20].Value = model.p117; parameters[21].Value = model.p118; parameters[22].Value = model.p119; parameters[23].Value = model.p300; parameters[24].Value = model.p200; parameters[25].Value = model.p201; parameters[26].Value = model.p202; parameters[27].Value = model.p203; parameters[28].Value = model.p204; parameters[29].Value = model.p205; parameters[30].Value = model.p207; parameters[31].Value = model.p208; parameters[32].Value = model.p209; parameters[33].Value = model.p210; parameters[34].Value = model.p206; parameters[35].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(viviapi.Model.Finance.PayRate model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into PayRate("); strSql.Append("rateType,billId,billame,p100,p101,p102,p103,p104,p105,p106,p107,p108,p109,p110,p111,p112,p113,p114,p115,p116,p117,p118,p119,p300,p200,p201,p202,p203,p204,p205,p207,p208,p209,p210,p206)"); strSql.Append(" values ("); strSql.Append("@rateType,@billId,@billame,@p100,@p101,@p102,@p103,@p104,@p105,@p106,@p107,@p108,@p109,@p110,@p111,@p112,@p113,@p114,@p115,@p116,@p117,@p118,@p119,@p300,@p200,@p201,@p202,@p203,@p204,@p205,@p207,@p208,@p209,@p210,@p206)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@rateType", SqlDbType.TinyInt, 1), new SqlParameter("@billId", SqlDbType.Int, 4), new SqlParameter("@billame", SqlDbType.VarChar, 50), new SqlParameter("@p100", SqlDbType.Decimal, 9), new SqlParameter("@p101", SqlDbType.Decimal, 9), new SqlParameter("@p102", SqlDbType.Decimal, 9), new SqlParameter("@p103", SqlDbType.Decimal, 9), new SqlParameter("@p104", SqlDbType.Decimal, 9), new SqlParameter("@p105", SqlDbType.Decimal, 9), new SqlParameter("@p106", SqlDbType.Decimal, 9), new SqlParameter("@p107", SqlDbType.Decimal, 9), new SqlParameter("@p108", SqlDbType.Decimal, 9), new SqlParameter("@p109", SqlDbType.Decimal, 9), new SqlParameter("@p110", SqlDbType.Decimal, 9), new SqlParameter("@p111", SqlDbType.Decimal, 9), new SqlParameter("@p112", SqlDbType.Decimal, 9), new SqlParameter("@p113", SqlDbType.Decimal, 9), new SqlParameter("@p114", SqlDbType.Decimal, 9), new SqlParameter("@p115", SqlDbType.Decimal, 9), new SqlParameter("@p116", SqlDbType.Decimal, 9), new SqlParameter("@p117", SqlDbType.Decimal, 9), new SqlParameter("@p118", SqlDbType.Decimal, 9), new SqlParameter("@p119", SqlDbType.Decimal, 9), new SqlParameter("@p300", SqlDbType.Decimal, 9), new SqlParameter("@p200", SqlDbType.Decimal, 9), new SqlParameter("@p201", SqlDbType.Decimal, 9), new SqlParameter("@p202", SqlDbType.Decimal, 9), new SqlParameter("@p203", SqlDbType.Decimal, 9), new SqlParameter("@p204", SqlDbType.Decimal, 9), new SqlParameter("@p205", SqlDbType.Decimal, 9), new SqlParameter("@p207", SqlDbType.Decimal, 9), new SqlParameter("@p208", SqlDbType.Decimal, 9), new SqlParameter("@p209", SqlDbType.Decimal, 9), new SqlParameter("@p210", SqlDbType.Decimal, 9), new SqlParameter("@p206", SqlDbType.Decimal, 9) }; parameters[0].Value = model.rateType; parameters[1].Value = model.billId; parameters[2].Value = model.billame; parameters[3].Value = model.p100; parameters[4].Value = model.p101; parameters[5].Value = model.p102; parameters[6].Value = model.p103; parameters[7].Value = model.p104; parameters[8].Value = model.p105; parameters[9].Value = model.p106; parameters[10].Value = model.p107; parameters[11].Value = model.p108; parameters[12].Value = model.p109; parameters[13].Value = model.p110; parameters[14].Value = model.p111; parameters[15].Value = model.p112; parameters[16].Value = model.p113; parameters[17].Value = model.p114; parameters[18].Value = model.p115; parameters[19].Value = model.p116; parameters[20].Value = model.p117; parameters[21].Value = model.p118; parameters[22].Value = model.p119; parameters[23].Value = model.p300; parameters[24].Value = model.p200; parameters[25].Value = model.p201; parameters[26].Value = model.p202; parameters[27].Value = model.p203; parameters[28].Value = model.p204; parameters[29].Value = model.p205; parameters[30].Value = model.p207; parameters[31].Value = model.p208; parameters[32].Value = model.p209; parameters[33].Value = model.p210; parameters[34].Value = model.p206; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }