private void btnSave_Click(object sender, EventArgs e)
{
if (bll.IsExit(txtName.Text.Trim()))
{
MessageBox.Show("名称重复！", "信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
try
{
T_JB_PLACEAREA mo = new T_JB_PLACEAREA();
mo.C_NAME = txtName.Text.Trim();
mo.C_MEMO = txtMemo.Text.Trim();
if (bll.Save(mo))
{
MessageBox.Show("保存成功！", "信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
Log.saveLog("添加货区成功！Id：" + lblId.Text);
Close();
}
else
{
MessageBox.Show("保存失败！", "信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception)
{
MessageBox.Show("与数据库连接失败，请查看网络连接是否正常。如不能解决请与网络管理员联系！", "严重错误：", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
/// <summary>
/// 根据id获得实体
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public T_JB_PLACEAREA GetById(string id)
{
T_JB_PLACEAREA mo = new T_JB_PLACEAREA();
DataRow dr = GetById(tableName, id);
mo.C_ID = dr["C_ID"].ToString();
mo.C_NAME = dr["C_NAME"].ToString();
mo.C_MEMO = dr["C_MEMO"].ToString();
return(mo);
}
public bool Save(T_JB_PLACEAREA mo)
{
try
{
long dec_id = 0;
string c_id = string.Empty;
int count = 0;
string sql = "SELECT max(c_id) FROM " + tableName;
object obj = dbHelper.GetScalar(sql);
dec_id = Convert.IsDBNull(obj) ? 0 : Convert.ToInt64(obj);
sql =
"INSERT INTO " + "[" + tableName +
"] ([C_ID],[C_NAME],[C_MEMO])" +
"VALUES (@C_ID,@C_NAME,@C_MEMO)";
Hashtable table = new Hashtable();
mo.C_ID = (dec_id + 1).ToString().PadLeft(4, '0');
table.Add("C_ID", mo.C_ID);
table.Add("C_NAME", mo.C_NAME);
table.Add("C_MEMO", mo.C_MEMO);
DbParameter[] parms = dbHelper.getParams(table);
count = dbHelper.ExecuteCommand(sql, parms);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
Log.write(ex.Message + "\r\n" + ex.StackTrace);
throw ex;
}
finally
{
dbHelper.getConnection().Close();
}
}
public bool Update(T_JB_PLACEAREA mo)
{
try
{
string sql =
"UPDATE " + "[" + tableName +
"] SET [C_NAME] = @C_NAME, " +
"[C_MEMO] = @C_MEMO " +
"WHERE [C_ID] = @C_ID ";
Hashtable table = new Hashtable();
table.Add("C_ID", mo.C_ID);
table.Add("C_NAME", mo.C_NAME);
table.Add("C_MEMO", mo.C_MEMO);
DbParameter[] parms = dbHelper.getParams(table);
int count = dbHelper.ExecuteCommand(sql, parms);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
Log.write(ex.Message + "\r\n" + ex.StackTrace);
throw ex;
}
finally
{
dbHelper.getConnection().Close();
}
}
private void Init()
{
try
{
T_JB_PLACEAREA mo = bll.GetById(id);
if (mo == null)
{
MessageBox.Show("获取信息失败！", "信息", MessageBoxButtons.OK, MessageBoxIcon.Warning);
this.Close();
}
else
{
lblId.Text = mo.C_ID;
txtName.Text = mo.C_NAME;
txtMemo.Text = mo.C_MEMO;
}
}
catch (Exception)
{
MessageBox.Show("与数据库连接失败，请查看网络连接是否正常。如不能解决请与网络管理员联系！", "严重错误：", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public bool Update(T_JB_PLACEAREA mo)
{
return(dal.Update(mo));
}
public bool Save(T_JB_PLACEAREA mo)
{
return(dal.Save(mo));
}