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();
}
