public int InsertDeviceRow(EntityDevice entityDevice)
{
string SqlStr = "";
SqlStr = "insert into tc_device(device_code,device_name, device_type,device_made,device_date,device_usedate,device_address,device_application,staff_name,device_remarks)";
SqlStr += " values('" + entityDevice.Device_code.Trim()
+ "','" + entityDevice.Device_name.Trim()
+ "','" + entityDevice.Device_type.Trim()
+ "','" + entityDevice.Device_made.Trim()
+ "','" + entityDevice.Device_date
+ "','" + entityDevice.Device_usedate
+ "','" + entityDevice.Device_address.Trim()
+ "','" + entityDevice.Device_application.Trim()
+ "','" + entityDevice.Staff_name.Trim()
+ "','" + entityDevice.Device_remarks.Trim()
+ "')";
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = SqlStr;
try
{
ExcuteSql(sqlCommand);
}
catch
{
return(Constants.SystemConfig.SERVER_ERROR);
}
return(Constants.SystemConfig.SERVER_SUCCESS);
}
public int UpdateDeviceTable(EntityDevice entity)
{
string SqlStr = "";
SqlStr = "update tc_device set ";
if (entity.Device_code.Trim() != string.Empty)
{
SqlStr += "device_code = '" + entity.Device_code.Trim() + "' ";
}
if (entity.Device_name.Trim() != string.Empty)
{
SqlStr += ",device_name = '" + entity.Device_name.Trim() + "' ";
}
if (entity.Device_type.Trim() != string.Empty)
{
SqlStr += ",device_type = '" + entity.Device_type.Trim() + "' ";
}
if (entity.Device_made.Trim() != string.Empty)
{
SqlStr += ",device_made = '" + entity.Device_made.Trim() + "' ";
}
SqlStr += ",device_date = '" + entity.Device_date.Date + "' ";
SqlStr += ",device_usedate = '" + entity.Device_usedate.Date + "' ";
if (entity.Device_address.Trim() != string.Empty)
{
SqlStr += ",device_address = '" + entity.Device_address.Trim() + "' ";
}
if (entity.Device_application.Trim() != string.Empty)
{
SqlStr += ",device_application = '" + entity.Device_application.Trim() + "' ";
}
if (entity.Staff_name.Trim() != string.Empty)
{
SqlStr += ",staff_name = '" + entity.Staff_name.Trim() + "' ";
}
if (entity.Device_remarks.Trim() != string.Empty)
{
SqlStr += ",device_remarks = '" + entity.Device_remarks.Trim() + "' ";
}
SqlStr += " where device_id= " + entity.Device_id.ToString() + " ";
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = SqlStr;
ExcuteSql(sqlCommand);
return(Constants.SystemConfig.SERVER_SUCCESS);
}
private void btnCommit_Click(object sender, EventArgs e)
{
foreach (Control control in groupBox2.Controls)
{
if (control is TextBox)
{
if (Util.CheckRegex(control.Text.Trim()) && !((TextBox)control).ReadOnly)
{
MessageBox.Show("不可以输入非法字符，请重新输入！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
control.Focus();
return;
}
}
}
if (txtCode.Text.Trim().Equals(string.Empty))
{
MessageBox.Show("设备编号不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtCode.Focus();
return;
}
if (txtName.Text.Trim().Equals(string.Empty))
{
MessageBox.Show("设备名称不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtName.Focus();
return;
}
if (txtType.Text.Trim().Equals(string.Empty))
{
MessageBox.Show("规格型号不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtType.Focus();
return;
}
if (dtpUseDate.Value.Date < dtpBuyDate.Value.Date)
{
MessageBox.Show("启用时间不得早于购置时间！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
dtpBuyDate.Focus();
return;
}
try
{
//如果是添加
if (dataType == DataType.Insert)
{
if (txtUser.Text.Trim().Equals("双击选择维护或使用人..."))
{
MessageBox.Show("请双击选择使用或维护人员！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtUser.Focus();
return;
}
entityDevice = new EntityDevice();
entityDevice.Device_code = txtCode.Text.Trim();
entityDevice.Device_name = txtName.Text.Trim();
entityDevice.Device_type = txtType.Text.Trim();
entityDevice.Device_made = txtMake.Text.Trim();
entityDevice.Device_date = dtpBuyDate.Value.Date;
entityDevice.Device_usedate = dtpUseDate.Value.Date;
entityDevice.Device_address = txtSetPlace.Text.Trim();
entityDevice.Device_application = txtUseMethod.Text.Trim();
entityDevice.Staff_name = txtUser.Text.Trim();
entityDevice.Device_remarks = txtRemarks.Text.Trim();
//打开数据库连接
dataAccess = new DataAccess();
dataAccess.Open();
//取得操作类
GetData getData = new GetData(dataAccess.Connection);
if (getData.InsertIsOnly("tc_device", "device_code", Util.ChangeForSqlString(txtCode.Text.Trim())))
{
MessageBox.Show("您输入的设备编号已经存在！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtCode.Focus();
return;
}
//取得结果符
int result = getData.InsertDeviceRow(entityDevice);
if (result == 0)
{
MessageBox.Show("数据已经保存成功！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("操作添加时发生错误，请检查数据库！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else if (dataType == DataType.Update)
{
if (dgvDevice.SelectedRows != null && dgvDevice.SelectedRows.Count != 0)
{
countNum = dgvDevice.SelectedRows[0].Index;
}
//赋值实体类
entityDevice = new EntityDevice();
entityDevice.Device_id = int.Parse(dgvDevice.SelectedRows[0].Cells["device_id"].Value.ToString());
entityDevice.Device_code = txtCode.Text.Trim();
entityDevice.Device_name = txtName.Text.Trim();
entityDevice.Device_type = txtType.Text.Trim();
entityDevice.Device_made = txtMake.Text.Trim();
entityDevice.Device_date = dtpBuyDate.Value.Date;
entityDevice.Device_usedate = dtpUseDate.Value.Date;
entityDevice.Device_address = txtSetPlace.Text.Trim();
entityDevice.Device_application = txtUseMethod.Text.Trim();
entityDevice.Staff_name = txtUser.Text.Trim();
entityDevice.Device_remarks = txtRemarks.Text.Trim();
//打开数据库连接
dataAccess = new DataAccess();
dataAccess.Open();
//打开事务
dataAccess.BeginTransaction();
//取得操作类
GetData getData = new GetData(dataAccess.Connection, dataAccess.Transaction);
if (getData.UpdateIsOnly("tc_device", "device_id", entityDevice.Device_id.ToString(), "device_code", Util.ChangeForSqlString(txtCode.Text.Trim())))
{
MessageBox.Show("您输入的设备编号已经存在！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtCode.Focus();
return;
}
//取得结果符
int result = getData.UpdateDeviceTable(entityDevice);
//提交事务
dataAccess.Commit();
if (result == 0)
{
MessageBox.Show("数据已经保存成功！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("操作修改时发生错误，请检查数据库！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
catch (Exception ex)
{
if (dataAccess.Transaction != null)
{
//回滚
dataAccess.Rollback();
}
MessageBox.Show("操作数据时发生错误，请检查数据库是否正常开启！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
finally
{
if (dataAccess.Connection != null)
{
dataAccess.Close();
}
}
//设置按钮状态
dataType = DataType.None;
SetButtonState();
BandingDgv();
}
