public int UpdateMaker(EntityMaker entity)
{
string SqlStr = "";
SqlStr = "update tc_maker set ";
SqlStr += "Maker_name = '" + entity.Maker_name.Trim() + "' ";
SqlStr += ",Maker_yxm = '" + entity.Maker_yxm.Trim() + "' ";
SqlStr += ",Maker_address = '" + entity.Maker_address.Trim() + "' ";
SqlStr += ",Maker_quality_reg = '" + entity.Maker_quality_reg.Trim() + "' ";
SqlStr += ",Maker_hygiene = '" + entity.Maker_hygiene.Trim() + "' ";
SqlStr += ",Maker_licence = '" + entity.Maker_licence.Trim() + "' ";
SqlStr += ",Maker_tel = '" + entity.Maker_tel.Trim() + "' ";
SqlStr += ",Maker_principal = '" + entity.Maker_principal.Trim() + "' ";
SqlStr += ",Maker_postal_code = '" + entity.Maker_postal_code.Trim() + "' ";
SqlStr += ",Maker_business_scope = '" + entity.Maker_business_scope.Trim() + "' ";
SqlStr += ",Maker_business_goods = '" + entity.Maker_business_goods.Trim() + "' ";
SqlStr += " where Maker_code= '" + entity.Maker_code.Trim() + "' ";
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = SqlStr;
ExcuteSql(sqlCommand);
return(Constants.SystemConfig.SERVER_SUCCESS);
}
public int InsertMaker(EntityMaker entityMaker)
{
string SqlStr = "";
SqlStr = "insert into tc_maker";
SqlStr += " values('"
+ entityMaker.Maker_code.Trim() + "','"
+ entityMaker.Maker_name.Trim() + "','"
+ entityMaker.Maker_yxm.Trim() + "','"
+ entityMaker.Maker_address.Trim() + "','"
+ entityMaker.Maker_quality_reg.Trim() + "','"
+ entityMaker.Maker_hygiene.Trim() + "','"
+ entityMaker.Maker_licence.Trim() + "','"
+ entityMaker.Maker_tel.Trim() + "','"
+ entityMaker.Maker_principal.Trim() + "','"
+ entityMaker.Maker_postal_code.Trim() + "','"
+ entityMaker.Maker_business_scope.Trim() + "','"
+ entityMaker.Maker_business_goods.Trim() + "')";
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = SqlStr;
try
{
ExcuteSql(sqlCommand);
}
catch
{
return(Constants.SystemConfig.SERVER_ERROR);
}
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)
{
if (txtMaker_name.Text.Trim() == string.Empty)
{
MessageBox.Show("生产厂家名称不能为空！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtMaker_name.Focus();
return;
}
//判断非法字符
foreach (Control control in groupBox1.Controls)
{
if (control is TextBox)
{
if (Util.CheckRegex(control.Text.Trim()) && !((TextBox)control).ReadOnly)
{
MessageBox.Show("不可以输入非法字符，请重新输入！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
control.Focus();
return;
}
}
}
EntityMaker entityMaker = new EntityMaker();
try
{
result = -1;
//如果是添加
if (dataType == DataType.Insert)
{
entityMaker.Maker_code = txtMaker_code.Text;
entityMaker.Maker_name = txtMaker_name.Text;
entityMaker.Maker_yxm = txtMaker_yxm.Text;
entityMaker.Maker_address = txtMaker_address.Text;
entityMaker.Maker_quality_reg = txtMaker_quality_reg.Text;
entityMaker.Maker_hygiene = txtMaker_hygiene.Text;
entityMaker.Maker_licence = txtMaker_licence.Text;
entityMaker.Maker_tel = txtMaker_tel.Text;
entityMaker.Maker_principal = txtMaker_principal.Text;
entityMaker.Maker_postal_code = txtMaker_postal_code.Text;
entityMaker.Maker_business_scope = txtMaker_business_scope.Text;
entityMaker.Maker_business_goods = txtMaker_business_goods.Text;
dataAccess = new DataAccess();
dataAccess.Open();
MakePrimaryKey primaryKey = new MakePrimaryKey(dataAccess.Connection, dataAccess.Transaction);
entityMaker.Maker_code = primaryKey.MakeCode("生产厂家");
GetData getData = new GetData(dataAccess.Connection);
result = getData.InsertMaker(entityMaker);
}
//如果是更新
else if (dataType == DataType.Update)
{
//给选中行赋值
countNum = dgv.SelectedRows[0].Index;
entityMaker.Maker_code = txtMaker_code.Text;
entityMaker.Maker_name = txtMaker_name.Text;
entityMaker.Maker_yxm = txtMaker_yxm.Text;
entityMaker.Maker_address = txtMaker_address.Text;
entityMaker.Maker_quality_reg = txtMaker_quality_reg.Text;
entityMaker.Maker_hygiene = txtMaker_hygiene.Text;
entityMaker.Maker_licence = txtMaker_licence.Text;
entityMaker.Maker_tel = txtMaker_tel.Text;
entityMaker.Maker_principal = txtMaker_principal.Text;
entityMaker.Maker_postal_code = txtMaker_postal_code.Text;
entityMaker.Maker_business_scope = txtMaker_business_scope.Text;
entityMaker.Maker_business_goods = txtMaker_business_goods.Text;
dataAccess = new DataAccess();
dataAccess.Open();
dataAccess.BeginTransaction();
GetData getData = new GetData(dataAccess.Connection, dataAccess.Transaction);
//取得结果符
result = getData.UpdateMaker(entityMaker);
//提交事务
dataAccess.Commit();
}
}
catch (Exception ex)
{
if (dataAccess.Transaction != null)
{
//回滚
dataAccess.Rollback();
}
}
finally
{
//关闭数据库连接
dataAccess.Close();
}
if (result == 0)
{
MessageBox.Show("数据已经保存成功！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
BandingDgv();
}
else
{
MessageBox.Show("数据保存时发生错误，请检查数据库！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
//设置按钮状态
dataType = DataType.None;
setButtonState();
//重新加载画面
BandingDgv();
}
