public bool Update(MODELNullReadReasonName MODELNullReadReasonName)
{
StringBuilder str = new StringBuilder();
str.Append("UPDATE NullReadReasonMemo SET NullReadReasonName=@NullReadReasonName,MEMO=@MEMO ");
str.Append("WHERE NullReadReasonID=@NullReadReasonID");
SqlParameter[] para =
{
new SqlParameter("@NullReadReasonName", SqlDbType.VarChar, 50),
new SqlParameter("@MEMO", SqlDbType.VarChar, 50),
new SqlParameter("@NullReadReasonID", SqlDbType.VarChar, 50)
};
para[0].Value = MODELNullReadReasonName.NullReadReasonName;
para[1].Value = MODELNullReadReasonName.Memo;
para[2].Value = MODELNullReadReasonName.NullReadReasonID;
if (DBUtility.DbHelperSQL.ExecuteSql(str.ToString(), para) > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool Insert(MODELNullReadReasonName MODELNullReadReasonName)
{
StringBuilder str = new StringBuilder();
str.Append("INSERT INTO NullReadReasonMemo(NullReadReasonID,NullReadReasonName,MEMO) ");
str.Append("VALUES(@NullReadReasonID,@NullReadReasonName,@MEMO)");
SqlParameter[] para =
{
new SqlParameter("@NullReadReasonID", SqlDbType.VarChar, 30),
new SqlParameter("@NullReadReasonName", SqlDbType.VarChar, 50),
new SqlParameter("@MEMO", SqlDbType.VarChar, 50)
};
para[0].Value = MODELNullReadReasonName.NullReadReasonID;
para[1].Value = MODELNullReadReasonName.NullReadReasonName;
para[2].Value = MODELNullReadReasonName.Memo;
if (DBUtility.DbHelperSQL.ExecuteSql(str.ToString(), para) > 0)
{
return(true);
}
else
{
return(false);
}
}
private void toolSubmit_Click(object sender, EventArgs e)
{
try
{
if (txtName.Text.Trim() == "")
{
mes.Show("请输入未抄表情况说明!");
txtName.Focus();
return;
}
if (txtID.Text.Trim() == "")
{
mes.Show("请输入代码!");
txtID.Focus();
return;
}
MODELNullReadReasonName MODELNullReadReasonName = new MODELNullReadReasonName();
MODELNullReadReasonName.NullReadReasonName = txtName.Text;
MODELNullReadReasonName.Memo = txtMemo.Text;
if (isAdd)
{
DataTable dtRows = BLLNullReadReasonMemo.Query(" AND NullReadReasonID='" + txtID.Text + "'");
if (dtRows.Rows.Count > 0)
{
mes.Show("输入的代码已经存在,请重新输入!");
txtID.Focus();
return;
}
MODELNullReadReasonName.NullReadReasonID = txtID.Text;
if (BLLNullReadReasonMemo.Insert(MODELNullReadReasonName))
{
toolSearch_Click(null, null);
dgList.ClearSelection();
dgList.CurrentCell = dgList.Rows[dgList.Rows.Count - 1].Cells[1];
}
else
{
mes.Show("添加失败,请重新点击保存按钮!");
return;
}
}
else
{
//如果修改了代码，检测输入的新代码是否存在
MODELNullReadReasonName.NullReadReasonID = txtIDOld.Text;
if (BLLNullReadReasonMemo.Update(MODELNullReadReasonName))
{
dgList.CurrentRow.Cells["NullReadReasonName"].Value = MODELNullReadReasonName.NullReadReasonName;
dgList.CurrentRow.Cells["Memo"].Value = MODELNullReadReasonName.Memo;
}
else
{
mes.Show("修改失败,请重新点击保存按钮!");
return;
}
}
//DisEnableControl(gbDetail);
dgList.Enabled = true;
toolAdd.Text = "添加";
toolDelete.Enabled = true;
toolSearch.Enabled = true;
isAdd = false;
txtID.ReadOnly = true;
}
catch (Exception ex)
{
log.Write(ex.Message, MsgType.Error);
mes.Show(ex.Message);
}
}
