private void Init()
{
try
{
T_JB_WAREHOUSE 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;
txtCom.Text = mo.C_COM;
txtBaudrate.Text = mo.C_BAUDRATE;
txtPort.Text = mo.C_PORT;
txtWritePort.Text = mo.C_WRITE_PORT;
txtReadPort.Text = mo.C_READ_PORT;
txtIpAddress.Text = mo.C_IP_ADDRESS;
cmbType.SelectedValue = mo.C_TYPE;
cbAuto.Checked = mo.I_AUTO == 0 ? false : true;
cbIn.Checked = mo.I_IN_MOBILE == 0 ? false : true;
cbOut.Checked = mo.I_OUT_MOBILE == 0 ? false : true;
}
}
catch (Exception)
{
MessageBox.Show("与数据库连接失败，请查看网络连接是否正常。如不能解决请与网络管理员联系！", "严重错误：", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public bool Update(T_JB_WAREHOUSE mo)
{
try
{
string sql =
"UPDATE " + "[" + tableName +
"] SET [C_NAME] = @C_NAME, " +
"[C_TYPE] = @C_TYPE, " +
"[C_COM] = @C_COM, " +
"[C_BAUDRATE] = @C_BAUDRATE, " +
"[C_IP_ADDRESS] = @C_IP_ADDRESS, " +
"[C_PORT] = @C_PORT, " +
"[C_WRITE_PORT] = @C_WRITE_PORT, " +
"[C_READ_PORT] = @C_READ_PORT, " +
"[I_AUTO] = @I_AUTO, " +
"[I_IN_MOBILE] = @I_IN_MOBILE, " +
"[I_OUT_MOBILE] = @I_OUT_MOBILE " +
"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_TYPE", mo.C_TYPE);
table.Add("C_COM", mo.C_COM);
table.Add("C_BAUDRATE", mo.C_BAUDRATE);
table.Add("C_IP_ADDRESS", mo.C_IP_ADDRESS);
table.Add("C_PORT", mo.C_PORT);
table.Add("C_WRITE_PORT", mo.C_WRITE_PORT);
table.Add("C_READ_PORT", mo.C_READ_PORT);
table.Add("I_AUTO", mo.I_AUTO);
table.Add("I_IN_MOBILE", mo.I_IN_MOBILE);
table.Add("I_OUT_MOBILE", mo.I_OUT_MOBILE);
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();
}
}
public bool Save(T_JB_WAREHOUSE 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_TYPE] ,[C_COM],[C_BAUDRATE],[C_IP_ADDRESS],[C_PORT],[C_WRITE_PORT],[C_READ_PORT],[I_AUTO],[I_IN_MOBILE],[I_OUT_MOBILE])" +
"VALUES (@C_ID,@C_NAME,@C_TYPE,@C_COM,@C_BAUDRATE,@C_IP_ADDRESS,@C_PORT,@C_WRITE_PORT,@C_READ_PORT,@I_AUTO,@I_IN_MOBILE,@I_OUT_MOBILE)";
Hashtable table = new Hashtable();
mo.C_ID = (dec_id + 1).ToString().PadLeft(2, '0');
table.Add("C_ID", mo.C_ID);
table.Add("C_NAME", mo.C_NAME);
table.Add("C_TYPE", mo.C_TYPE);
table.Add("C_COM", mo.C_COM);
table.Add("C_BAUDRATE", mo.C_BAUDRATE);
table.Add("C_IP_ADDRESS", mo.C_IP_ADDRESS);
table.Add("C_PORT", mo.C_PORT);
table.Add("C_WRITE_PORT", mo.C_WRITE_PORT);
table.Add("C_READ_PORT", mo.C_READ_PORT);
table.Add("I_AUTO", mo.I_AUTO);
table.Add("I_IN_MOBILE", mo.I_IN_MOBILE);
table.Add("I_OUT_MOBILE", mo.I_OUT_MOBILE);
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();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (bll.IsExitNotSelf(id, txtName.Text.Trim()))
{
MessageBox.Show("名称重复！", "信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
try
{
T_JB_WAREHOUSE mo = new T_JB_WAREHOUSE();
mo.C_ID = id;
mo.C_COM = txtCom.Text.Trim();
mo.C_NAME = txtName.Text.Trim();
mo.C_BAUDRATE = txtBaudrate.Text.Trim();
mo.C_PORT = txtPort.Text.Trim();
mo.C_WRITE_PORT = txtWritePort.Text.Trim();
mo.C_READ_PORT = txtReadPort.Text.Trim();
mo.C_IP_ADDRESS = txtIpAddress.Text.Trim();
mo.C_TYPE = cmbType.SelectedValue.ToString();
mo.I_AUTO = cbAuto.Checked ? 1 : 0;
mo.I_IN_MOBILE = cbIn.Checked ? 1 : 0;
mo.I_OUT_MOBILE = cbOut.Checked ? 1 : 0;
if (bll.Update(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_WAREHOUSE GetById(string id)
{
T_JB_WAREHOUSE mo = new T_JB_WAREHOUSE();
DataRow dr = GetById(tableName, id);
mo.C_ID = dr["C_ID"].ToString();
mo.C_NAME = dr["C_NAME"].ToString();
mo.C_COM = dr["C_COM"].ToString();
mo.C_BAUDRATE = dr["C_BAUDRATE"].Equals(DBNull.Value) ? string.Empty : dr["C_BAUDRATE"].ToString();
mo.C_PORT = dr["C_PORT"].Equals(DBNull.Value) ? string.Empty : dr["C_PORT"].ToString();
mo.C_WRITE_PORT = dr["C_WRITE_PORT"].Equals(DBNull.Value) ? string.Empty : dr["C_WRITE_PORT"].ToString();
mo.C_READ_PORT = dr["C_READ_PORT"].Equals(DBNull.Value) ? string.Empty : dr["C_READ_PORT"].ToString();
mo.C_IP_ADDRESS = dr["C_IP_ADDRESS"].Equals(DBNull.Value) ? string.Empty : dr["C_IP_ADDRESS"].ToString();
mo.C_TYPE = dr["C_TYPE"].Equals(DBNull.Value) ? string.Empty : dr["C_TYPE"].ToString();
mo.I_AUTO = int.Parse(dr["I_AUTO"].ToString());
mo.I_IN_MOBILE = int.Parse(dr["I_IN_MOBILE"].ToString());
mo.I_OUT_MOBILE = int.Parse(dr["I_OUT_MOBILE"].ToString());
return(mo);
}
public bool Update(T_JB_WAREHOUSE mo)
{
return(dal.Update(mo));
}
public bool Save(T_JB_WAREHOUSE mo)
{
return(dal.Save(mo));
}
