public bool Update(MODELwaterUserType MODELwaterUserType) { StringBuilder str = new StringBuilder(); str.Append("UPDATE waterUserType SET waterUserTypeName=@waterUserTypeName,overDuechargeEnable=@overDuechargeEnable,overDuechargeStartMonth=@overDuechargeStartMonth,overDuechargeStartDay=@overDuechargeStartDay,overDuechargePercent=@overDuechargePercent,invoiceBillName=@invoiceBillName,MEMO=@MEMO "); str.Append("WHERE waterUserTypeId=@waterUserTypeId"); SqlParameter[] para = { new SqlParameter("@waterUserTypeName", SqlDbType.VarChar, 50), new SqlParameter("@overDuechargeEnable", SqlDbType.VarChar, 10), new SqlParameter("@overDuechargeStartMonth", SqlDbType.Int), new SqlParameter("@overDuechargeStartDay", SqlDbType.Int), new SqlParameter("@overDuechargePercent", SqlDbType.Float), new SqlParameter("@invoiceBillName", SqlDbType.VarChar, 50), new SqlParameter("@MEMO", SqlDbType.VarChar, 200), new SqlParameter("@waterUserTypeId", SqlDbType.VarChar, 30) }; para[0].Value = MODELwaterUserType.waterUserTypeName; para[1].Value = MODELwaterUserType.overDuechargeEnable; para[2].Value = MODELwaterUserType.overDuechargeStartMonth; para[3].Value = MODELwaterUserType.overDuechargeStartDay; para[4].Value = MODELwaterUserType.overDuechargePercent; para[5].Value = MODELwaterUserType.invoiceBillName; para[6].Value = MODELwaterUserType.MEMO; para[7].Value = MODELwaterUserType.waterUserTypeId; if (DBUtility.DbHelperSQL.ExecuteSql(str.ToString(), para) > 0) { return(true); } else { return(false); } }
public bool Insert(MODELwaterUserType MODELwaterUserType) { StringBuilder str = new StringBuilder(); str.Append("INSERT INTO waterUserType(waterUserTypeId,waterUserTypeName,overDuechargeEnable,overDuechargeStartMonth,overDuechargeStartDay,overDuechargePercent,invoiceBillName,MEMO) "); str.Append("VALUES(@waterUserTypeId,@waterUserTypeName,@overDuechargeEnable,@overDuechargeStartMonth,@overDuechargeStartDay,@overDuechargePercent,@invoiceBillName,@MEMO)"); SqlParameter[] para = { new SqlParameter("@waterUserTypeId", SqlDbType.VarChar, 30), new SqlParameter("@waterUserTypeName", SqlDbType.VarChar, 50), new SqlParameter("@overDuechargeEnable", SqlDbType.VarChar, 10), new SqlParameter("@overDuechargeStartMonth", SqlDbType.Int), new SqlParameter("@overDuechargeStartDay", SqlDbType.Int), new SqlParameter("@overDuechargePercent", SqlDbType.Float), new SqlParameter("@invoiceBillName", SqlDbType.VarChar, 50), new SqlParameter("@MEMO", SqlDbType.VarChar, 50) }; para[0].Value = MODELwaterUserType.waterUserTypeId; para[1].Value = MODELwaterUserType.waterUserTypeName; para[2].Value = MODELwaterUserType.overDuechargeEnable; para[3].Value = MODELwaterUserType.overDuechargeStartMonth; para[4].Value = MODELwaterUserType.overDuechargeStartDay; para[5].Value = MODELwaterUserType.overDuechargePercent; para[6].Value = MODELwaterUserType.invoiceBillName; para[7].Value = MODELwaterUserType.MEMO; if (DBUtility.DbHelperSQL.ExecuteSql(str.ToString(), para) > 0) { return(true); } else { return(false); } }
private void toolSave_Click(object sender, EventArgs e) { if (txtName.Text.Trim() == "") { mes.Show("类别名称不能为空!"); txtName.Focus(); return; } if (chkIsEnable.Checked) { if (txtStartMonth.Text.Trim() == "") { mes.Show("请输入开始月份!"); txtStartMonth.Focus(); return; } else { if (!Information.IsNumeric(txtStartMonth.Text.Trim())) { mes.Show("开始月份只能为整数!"); txtStartMonth.Focus(); return; } } if (txtStartDay.Text.Trim() == "") { mes.Show("请输入开始日期!"); txtStartDay.Focus(); return; } else { if (!Information.IsNumeric(txtStartDay.Text.Trim())) { mes.Show("开始日期只能为整数!"); txtStartDay.Focus(); return; } } if (txtPercent.Text.Trim() == "") { mes.Show("请输入滞纳金比率!"); txtPercent.Focus(); return; } else { if (!Information.IsNumeric(txtStartMonth.Text.Trim())) { mes.Show("滞纳金比率只能为数字!"); txtPercent.Focus(); return; } } } MODELwaterUserType MODELwaterUserType = new MODELwaterUserType(); MODELwaterUserType.waterUserTypeName = txtName.Text; MODELwaterUserType.invoiceBillName = txtInvioceBillName.Text; if (MODELwaterUserType.invoiceBillName != "") { string strFile = txtFilePath.Text; if (strFile != "") { if (File.Exists(strFile)) { if (!File.Exists(Application.StartupPath + @"\InvoiceModel\" + txtInvioceBillName.Text)) { File.Copy(strFile, Application.StartupPath + @"\InvoiceModel\" + txtInvioceBillName.Text, true); } } else { mes.Show("模板文件\"" + strFile + "\"不存在,请重新选择!"); return; } } } if (chkIsEnable.Checked) { MODELwaterUserType.overDuechargeEnable = "1"; MODELwaterUserType.overDuechargeStartMonth = Convert.ToInt32(txtStartMonth.Text); MODELwaterUserType.overDuechargeStartDay = Convert.ToInt32(txtStartDay.Text); MODELwaterUserType.overDuechargePercent = Convert.ToDecimal(txtPercent.Text); } else { MODELwaterUserType.overDuechargeEnable = "0"; } MODELwaterUserType.MEMO = txtMemo.Text; if (isAdd) { MODELwaterUserType.waterUserTypeId = GETTABLEID.GetTableID("", "WATERUSERTYPE"); if (BLLwaterUserType.Insert(MODELwaterUserType)) { Query(); } else { mes.Show("添加失败,请重新点击保存按钮!"); return; } } else { MODELwaterUserType.waterUserTypeId = txtID.Text; if (BLLwaterUserType.Update(MODELwaterUserType)) { Query(); dgList.ClearSelection(); for (int i = 0; i < dgList.Rows.Count; i++) { if (dgList.Rows[i].Cells["waterUserTypeId"].Value != null && dgList.CurrentRow.Cells["waterUserTypeId"].Value != DBNull.Value) { string strID = dgList.Rows[i].Cells["waterUserTypeId"].Value.ToString(); if (MODELwaterUserType.waterUserTypeId == strID) { dgList.CurrentCell = dgList.Rows[i].Cells["waterUserTypeName"]; dgList_SelectionChanged(null, null); } } } } else { mes.Show("修改失败,请重新点击保存按钮!"); return; } } dgList.Enabled = true; toolDel.Enabled = true; toolAdd.Text = "添加"; isAdd = false; txtFilePath.Clear(); }