public int InsertCounterRow(EntityCounter entity) { string SqlStr = ""; SqlStr = "insert into tc_counter"; SqlStr += " values('" + entity.Counter_code.Trim() + "','" + entity.Counter_manager.Trim() + "','" + entity.Counter_type.Trim() + "')"; SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = SqlStr; ExcuteSql(sqlCommand); return(Constants.SystemConfig.SERVER_SUCCESS); }
public int UpdateCounterTable(EntityCounter entity) { string SqlStr = ""; SqlStr = "update tc_counter set "; SqlStr += "Counter_manager = '" + entity.Counter_manager.Trim() + "' "; SqlStr += ",Counter_type = '" + entity.Counter_type.Trim() + "' "; SqlStr += " where counter_code= '" + entity.Counter_code.Trim() + "' "; 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/07/13 完成 /// 更新信息: /// </history> //*********************************************************************** 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() == string.Empty) { MessageBox.Show("货位编号不能为空!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); txtCode.Focus(); return; } if (txtType.Text.Trim() == string.Empty) { MessageBox.Show("存货种类不能为空!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); txtType.Focus(); return; } if (txtManager.Text.Trim() == "" || txtManager.Text.Trim() == "双击选择负责人...") { MessageBox.Show("货位负责人不能为空!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); txtManager.Focus(); return; } try { result = -1; //如果是添加 if (dataType == DataType.Insert) { //取得实体类 counterEntity = new EntityCounter(); //赋值实体类 counterEntity.Counter_code = txtCode.Text; counterEntity.Counter_manager = txtManager.Text; counterEntity.Counter_type = txtType.Text; //打开数据库连接 dataAccess = new DataAccess(); dataAccess.Open(); //取得操作类 GetData getData = new GetData(dataAccess.Connection); if (getData.InsertIsOnly("TC_COUNTER", "Counter_code", txtCode.Text.Trim())) { MessageBox.Show("您输入的货位编号已经存在,请更改货位编号后再保存!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); txtCode.Focus(); return; } //取得结果符 result = getData.InsertCounterRow(counterEntity); 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 (dgvCounter.SelectedRows != null && dgvCounter.SelectedRows.Count != 0) { countNum = dgvCounter.SelectedRows[0].Index; } //取得树体类 counterEntity = new EntityCounter(); //赋值实体类 counterEntity.Counter_code = txtCode.Text; counterEntity.Counter_manager = txtManager.Text; counterEntity.Counter_type = txtType.Text; //打开数据库连接 dataAccess = new DataAccess(); dataAccess.Open(); //打开事务 dataAccess.BeginTransaction(); //取得操作类 GetData getData = new GetData(dataAccess.Connection, dataAccess.Transaction); if (getData.UpdateIsOnly("TC_COUNTER", "Counter_code", counterEntity.Counter_code, "Counter_code", txtCode.Text.Trim())) { MessageBox.Show("您输入的货位编号已经存在,请更改货位编号后再保存!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); txtCode.Focus(); return; } //取得结果符 result = getData.UpdateCounterTable(counterEntity); //提交事务 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 { //关闭数据库连接 dataAccess.Close(); } //设置按钮状态 dataType = DataType.None; setButtonState(); //重新加载画面 BandingDgvCounter(); }