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