private void btSave_Click(object sender, EventArgs e)
{
if (tbName.Text == "")
{
//MessageBox.Show("名称未填写，不能保存");
tbName.Focus();
return;
}
if (txtOTHER_LANGUAGE_DESCR.Text == "")
{
//MessageBox.Show("名称未填写，不能保存");
txtOTHER_LANGUAGE_DESCR.Focus();
return;
}
frmFlow.sPackName = tbName.Text;
if (frmFlow.iPackNo > 0)
{
StringBuilder strBuild = new StringBuilder();
strBuild.Append("UPDATE DMIS_SYS_PACKTYPE SET ");
strBuild.Append(" F_NAME='" + ValueToField.StringToField(tbName.Text) + "',");
strBuild.Append(" F_ISFLOW=" + Convert.ToInt16(cbflow.Checked) + ",");
strBuild.Append(" F_ISCHECK=" + Convert.ToInt16(cbcheck.Checked) + ",");
strBuild.Append(" F_ISARCHIEVE=" + Convert.ToInt16(cbarchive.Checked) + ",");
strBuild.Append(" OTHER_LANGUAGE_DESCR='" + ValueToField.StringToField(txtOTHER_LANGUAGE_DESCR.Text) + "'");
strBuild.Append(" WHERE F_NO=" + frmFlow.iPackNo);
DBOpt.dbHelper.ExecuteSql(strBuild.ToString());
}
else
{
uint iMax = DBOpt.dbHelper.GetMaxNum("DMIS_SYS_PACKTYPE", "F_NO");
StringBuilder strBuild = new StringBuilder();
strBuild.Append("INSERT INTO DMIS_SYS_PACKTYPE(F_NO,F_NAME,F_ISFLOW,F_ISCHECK,F_ISARCHIEVE,OTHER_LANGUAGE_DESCR) VALUES(");
strBuild.Append(iMax + ",");
strBuild.Append("'" + ValueToField.StringToField(tbName.Text) + "',"); //ValueToField.StringToField函数已经去掉'
strBuild.Append(Convert.ToInt16(cbflow.Checked) + ",");
strBuild.Append(Convert.ToInt16(cbcheck.Checked) + ",");
strBuild.Append(Convert.ToInt16(cbarchive.Checked) + ",");
strBuild.Append("'" + ValueToField.StringToField(txtOTHER_LANGUAGE_DESCR.Text) + "'");
strBuild.Append(")");
DBOpt.dbHelper.ExecuteSql(strBuild.ToString());
frmFlow.iPackNo = Convert.ToInt16(iMax);
}
this.DialogResult = DialogResult.OK;
}
private void btSave_Click(object sender, EventArgs e)
{
if (txtName.Text.Trim() == "")
{
//MessageBox.Show();
txtName.Focus();
return;
}
if (txtOTHER_LANGUAGE_DESCR.Text.Trim() == "")
{
//MessageBox.Show();
txtOTHER_LANGUAGE_DESCR.Focus();
return;
}
//DataTable dtTmp;
//dtTmp = DBOpt.dbHelper.GetDataTable("select F_NO FROM DMIS_SYS_DOCTYPE WHERE F_PACKTYPEDEF=1 AND F_PACKTYPENO="
// + frmFlow.iPackNo);
//if (dtTmp != null)
//{
// if (dtTmp.Rows.Count > 0)
// {
// if ((FieldToValue.FieldToInt(dtTmp.Rows[0]["F_NO"]) != frmFlow.iDocNo))
// {
// if (cbAutoCreate.Checked)
// {
// MessageBox.Show("一个业务自动创建文档只能唯一");
// return;
// }
// }
// }
//}
frmFlow.sDocName = txtName.Text;
if (frmFlow.iDocNo > 0)
{
StringBuilder strBuild = new StringBuilder();
strBuild.Append("UPDATE DMIS_SYS_DOCTYPE SET ");
strBuild.Append(" F_NAME='" + ValueToField.StringToField(txtName.Text) + "',");
strBuild.Append(" F_DOCCAT='" + ValueToField.StringToField(cbbType.Text) + "',");
strBuild.Append(" F_FORMFILE='" + ValueToField.StringToField(txtForm.Text) + "',");
//***** Modify Start v2.00 liujp 2010/01/14 报表文本框改为下拉框 *****
strBuild.Append(" F_REPORTFILE='" + ValueToField.StringToField(cbbReport.SelectedValue) + "',");
//***** Modify End *****
strBuild.Append(" F_ICONFILE='" + ValueToField.StringToField(txtIcon.Text) + "',");
strBuild.Append(" F_OPENICON='" + ValueToField.StringToField(txtOpenIcon.Text) + "',");
strBuild.Append(" F_TABLENAME='" + ValueToField.StringToField(cbbTable.Text) + "',");
strBuild.Append(" OTHER_LANGUAGE_DESCR='" + ValueToField.StringToField(txtOTHER_LANGUAGE_DESCR.Text) + "'");
//strBuild.Append(" F_PACKTYPEDEF=" + Convert.ToInt16(cbAutoCreate.Checked));
strBuild.Append(" WHERE F_NO=" + frmFlow.iDocNo);
DBOpt.dbHelper.ExecuteSql(strBuild.ToString());
}
else
{
uint iMax = 1;
string sTmp = DBOpt.dbHelper.ExecuteScalar("SELECT MAX(F_NO) FROM DMIS_SYS_DOCTYPE").ToString();
if (sTmp != "")
{
iMax = Convert.ToUInt32(sTmp) + 1;
}
StringBuilder strBuild = new StringBuilder();
strBuild.Append("INSERT INTO DMIS_SYS_DOCTYPE(F_NO,F_PACKTYPENO,F_NAME,F_DOCCAT,");
strBuild.Append("F_FORMFILE,F_REPORTFILE,F_ICONFILE,F_OPENICON,F_TABLENAME,OTHER_LANGUAGE_DESCR) VALUES(");
strBuild.Append(iMax + ",");
strBuild.Append(frmFlow.iPackNo + ",'");
strBuild.Append(ValueToField.StringToField(txtName.Text) + "','");
strBuild.Append(ValueToField.StringToField(cbbType.Text) + "','");
strBuild.Append(ValueToField.StringToField(txtForm.Text) + "','");
//***** Modify Start v2.00 liujp 2010/01/14 报表文本框改为下拉框 *****
strBuild.Append(ValueToField.StringToField(cbbReport.SelectedValue) + "','");
//***** Modify End *****
strBuild.Append(ValueToField.StringToField(txtIcon.Text) + "','");
strBuild.Append(ValueToField.StringToField(txtOpenIcon.Text) + "','");
strBuild.Append(ValueToField.StringToField(cbbTable.Text) + "','");
strBuild.Append(ValueToField.StringToField(txtOTHER_LANGUAGE_DESCR.Text) + "'");
//strBuild.Append( Convert.ToInt16(cbAutoCreate.Checked));
strBuild.Append(")");
DBOpt.dbHelper.ExecuteSql(strBuild.ToString());
frmFlow.iDocNo = Convert.ToInt16(iMax);
}
this.DialogResult = DialogResult.OK;
}