private void btnDeleteOrd_Click(object sender, EventArgs e)
{
if (grdTable.SelectedRows.Count == 0)
{
MessageBox.Show(@"请选择要停用的记录");
return;
}
if (grdTable.CurrentRow != null)
{
int id = Convert.ToInt32(grdTable.CurrentRow.Cells[0].Value.ToString().Trim());
SetOrdTable model = _orddal.GetModel(id);
model.State = 0;
bool flag = _orddal.Update(model);
if (flag)
{
MessageBox.Show(@"停用成功");
frmSetInfo_Load(null, null);
}
}
}
private void frmSetInfoEdit_Load(object sender, EventArgs e)
{
if (_id != 0)
{
SetOrdTable model = _dal.GetModel(_id);
txtSqlServer.Text = model.SetOrdText;
txtCode.Text = model.SetOrdKey;
txtMySql.Text = model.Remark;
//model.AllowWorkType = chkAllowType.Text;
string[] strArray = model.AllowWorkType.Split(',');
for (int i = 0; i < strArray.Length; i++)
{
for (int j = 0; j < AllowTypeAry.Length; j++)
{
if (strArray[i].Trim() == AllowTypeAry[j].Trim())
{
chkAllowType.SetItemChecked(j, true);
}
}
}
txtCode.ReadOnly = true;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtCode.Text.Trim() == string.Empty)
{
MessageBox.Show(@"请输入编码");
txtCode.Select();
return;
}
if (txtSqlServer.Text.Trim() == string.Empty)
{
MessageBox.Show(@"请输入mssql表名称");
txtSqlServer.Select();
return;
}
if (txtMySql.Text.Trim() == string.Empty)
{
MessageBox.Show(@"请输入mysql表名称");
txtSqlServer.Select();
return;
}
if (_id != 0)//修改
{
//已经存在
DataSet ds = _dal.GetList("State=1 and id!=" + _id + " and SetOrdKey='" + txtCode.Text.Trim() + "' ");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
MessageBox.Show(@"该编码已经存在");
txtCode.Select();
}
else
{
SetOrdTable model = _dal.GetModel(_id);
model.SetOrdKey = txtCode.Text.Trim();
model.SetOrdText = txtSqlServer.Text.Trim();
model.Remark = txtMySql.Text.Trim();
model.AllowWorkType = chkAllowType.Text;
bool flag = _dal.Update(model);
if (flag != true)
{
return;
}
DialogResult = DialogResult.OK;
Close();
}
}
else
{
//已经存在
DataSet ds = _dal.GetList("State=1 and SetOrdKey='" + txtCode.Text.Trim() + "' ");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
MessageBox.Show(@"该编码已经存在");
txtCode.Select();
}
else
{
SetOrdTable model = new SetOrdTable
{
SetOrdText = txtSqlServer.Text.Trim(),
SetOrdKey = txtCode.Text.Trim(),
State = 1,
Remark = txtMySql.Text.Trim(),
AllowWorkType = chkAllowType.Text
};
int res = _dal.Add(model);
if (res >= 0)
{
DialogResult = DialogResult.OK;
Close();
}
}
}
}
