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)); }