public int InsertMaintain_detailTable(EntityMaintain_detail entity)
{
string SqlStr = "";
SqlStr = "insert into tc_maintain_detail";
SqlStr += " values('"
+ entity.Maintain_detail_datetime + "','"
+ entity.Maintain_detail_quality.Trim() + "','"
+ entity.Maintain_detail_settle.Trim() + "','"
+ entity.Maintain_detail_oper.Trim() + "','"
+ entity.Maintain_detail_remark.Trim() + "','"
+ entity.Maintain_code.Trim() + "')";
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = SqlStr;
try
{
ExcuteSql(sqlCommand);
}
catch (Exception ex)
{
return(Constants.SystemConfig.SERVER_ERROR);
throw ex;
}
return(Constants.SystemConfig.SERVER_SUCCESS);
}
public int UpdateMaintain_detailTable(EntityMaintain_detail entity)
{
string SqlStr = "";
SqlStr = "update tc_maintain_detail set ";
SqlStr += "Maintain_detail_datetime = '" + entity.Maintain_detail_datetime + "' ";
SqlStr += ",Maintain_detail_quality = '" + entity.Maintain_detail_quality.Trim() + "' ";
SqlStr += ",Maintain_detail_settle = '" + entity.Maintain_detail_settle.Trim() + "' ";
SqlStr += ",Maintain_detail_oper = '" + entity.Maintain_detail_oper.Trim() + "' ";
SqlStr += ",Maintain_detail_remark = '" + entity.Maintain_detail_remark.Trim() + "' ";
SqlStr += ",Maintain_code = '" + entity.Maintain_code.Trim() + "' ";
SqlStr += " where Maintain_detail_code= '" + entity.Maintain_detail_code + "' ";
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = SqlStr;
ExcuteSql(sqlCommand);
return(Constants.SystemConfig.SERVER_SUCCESS);
}
//***********************************************************************
/// <summary>
/// 保存按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// <history>
/// 完成信息：李梓楠 2010/7/22 完成
/// 更新信息：
/// </history>
//***********************************************************************
private void btnCommit_Click(object sender, EventArgs e)
{
//判断时间有效性
if (DateTime.Now.Date < dateMaintain_datetime.Value.Date)
{
MessageBox.Show("养护日期不可大于今天！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
//判断时间有效性
if (maintainCreateDate > dateMaintain_datetime.Value.Date)
{
MessageBox.Show("养护日期不可小于建档日期！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (txtMaintain_detail_oper.Text.Trim() == string.Empty || txtMaintain_detail_oper.Text == "双击选择养护员...")
{
MessageBox.Show("养护员不能为空！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
//判断非法字符
foreach (Control control in groupbox.Controls)
{
if (control is TextBox)
{
if (Util.CheckRegex(control.Text.Trim()) && !((TextBox)control).ReadOnly)
{
MessageBox.Show("不可以输入非法字符，请重新输入！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
control.Focus();
return;
}
}
}
EntityMaintain_detail entity = new EntityMaintain_detail();
try
{
result = -1;
//如果是添加
if (dataType == DataType.Insert)
{
entity.Maintain_detail_datetime = dateMaintain_datetime.Value.Date;
entity.Maintain_detail_oper = txtMaintain_detail_oper.Text;
entity.Maintain_detail_quality = txtMaintain_detail_quality.Text;
entity.Maintain_detail_remark = txtMaintain_detail_remark.Text;
entity.Maintain_detail_settle = txtMaintain_detail_settle.Text;
entity.Maintain_code = p_maintain_code;
dataAccess = new DataAccess();
dataAccess.Open();
GetData getData = new GetData(dataAccess.Connection);
result = getData.InsertMaintain_detailTable(entity);
}
//如果是更新
else if (dataType == DataType.Update)
{
//给选中行赋值
countNum = dgv.SelectedRows[0].Index;
entity.Maintain_detail_datetime = dateMaintain_datetime.Value.Date;
entity.Maintain_detail_oper = txtMaintain_detail_oper.Text;
entity.Maintain_detail_quality = txtMaintain_detail_quality.Text;
entity.Maintain_detail_remark = txtMaintain_detail_remark.Text;
entity.Maintain_detail_settle = txtMaintain_detail_settle.Text;
entity.Maintain_code = p_maintain_code;
entity.Maintain_detail_code = int.Parse(dgv.SelectedRows[0].Cells["Maintain_detail_code"].Value.ToString());
dataAccess = new DataAccess();
dataAccess.Open();
dataAccess.BeginTransaction();
GetData getData = new GetData(dataAccess.Connection, dataAccess.Transaction);
//取得结果符
result = getData.UpdateMaintain_detailTable(entity);
//提交事务
dataAccess.Commit();
}
}
catch (Exception ex)
{
if (dataAccess.Transaction != null)
{
//回滚
dataAccess.Rollback();
}
//提示错误
MessageBox.Show("操作数据时发生错误，请检查数据库是否正常开启！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
throw ex;
}
finally
{
//关闭数据库连接
dataAccess.Close();
}
//设置按钮状态
dataType = DataType.None;
setButtonState();
//重新加载画面
BandingDgv();
}
