private void btn_Save_Click(object sender, EventArgs e) { try { Mod_TB_MATERIAL_COST mod = bll.GetModel(c_id); mod.C_MATERIAL_NAME = txt_NYJZ1.Text; mod.C_REMARK = txt_BZ.Text; mod.C_UNIT = txt_DW.Text; mod.N_COST = Convert.ToDecimal(txt_DJ.Text); mod.C_EMP_ID = RV.UI.UserInfo.UserID; mod.D_MOD_DT = RV.UI.ServerTime.timeNow(); if (txt_DJ.Text == "0") { MessageBox.Show("单价不能为0!"); return; } if (txt_DW.Text == "") { MessageBox.Show("请输入单位!"); return; } bll.Update(mod); MessageBox.Show("保存成功!"); Common.UserLog.AddLog(strMenuName, this.Name, this.Text, "修改能源介质成本");//添加操作日志 this.DialogResult = DialogResult.Cancel; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 删除 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_Stop_Click(object sender, EventArgs e) { try { if (DialogResult.No == MessageBox.Show("是否确认删除?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1)) { return; } if (true) { } int[] rows = this.gv_NYCB.GetSelectedRows(); if (rows.Count() == 0) { return; } foreach (var item in rows) { DataRow dr = this.gv_NYCB.GetDataRow(item); Mod_TB_MATERIAL_COST mod = bll.GetModel(dr["C_ID"].ToString()); mod.N_STATUS = 0; mod.D_END_DATE = DateTime.Now; bll.Update(mod); Common.UserLog.AddLog(strMenuName, this.Name, this.Text, "删除能源介质成本信息");//添加操作日志 } NewMethod(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void FrmPB_NYKZCB_EDIT_Load(object sender, EventArgs e) { strMenuName = RV.UI.UserInfo.menuName; Mod_TB_MATERIAL_COST mod = bll.GetModel(c_id); txt_NYJZ1.Enabled = false; txt_NYJZ1.Text = mod.C_MATERIAL_NAME; txt_BZ.Text = mod.C_REMARK; txt_DJ.Text = mod.N_COST.ToString(); txt_DW.Text = mod.C_UNIT; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_TB_MATERIAL_COST model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TPB_MATERIAL_COST set "); strSql.Append("C_MATERIAL_NAME=:C_MATERIAL_NAME,"); strSql.Append("D_START_DATE=:D_START_DATE,"); strSql.Append("D_END_DATE=:D_END_DATE,"); strSql.Append("N_STATUS=:N_STATUS,"); strSql.Append("N_COST=:N_COST,"); strSql.Append("C_EMP_ID=:C_EMP_ID,"); strSql.Append("D_MOD_DT=:D_MOD_DT,"); strSql.Append("C_REMARK=:C_REMARK,"); strSql.Append("C_UNIT=:C_UNIT"); strSql.Append(" where C_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_MATERIAL_NAME", OracleDbType.Varchar2, 100), new OracleParameter(":D_START_DATE", OracleDbType.Date), new OracleParameter(":D_END_DATE", OracleDbType.Date), new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1), new OracleParameter(":N_COST", OracleDbType.Decimal, 15), new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":D_MOD_DT", OracleDbType.Date), new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 200), new OracleParameter(":C_UNIT", OracleDbType.Varchar2, 100), new OracleParameter(":C_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = model.C_MATERIAL_NAME; parameters[1].Value = model.D_START_DATE; parameters[2].Value = model.D_END_DATE; parameters[3].Value = model.N_STATUS; parameters[4].Value = model.N_COST; parameters[5].Value = model.C_EMP_ID; parameters[6].Value = model.D_MOD_DT; parameters[7].Value = model.C_REMARK; parameters[8].Value = model.C_UNIT; parameters[9].Value = model.C_ID; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TB_MATERIAL_COST DataRowToModel(DataRow row) { Mod_TB_MATERIAL_COST model = new Mod_TB_MATERIAL_COST(); if (row != null) { if (row["C_ID"] != null) { model.C_ID = row["C_ID"].ToString(); } if (row["C_MATERIAL_NAME"] != null) { model.C_MATERIAL_NAME = row["C_MATERIAL_NAME"].ToString(); } if (row["D_START_DATE"] != null && row["D_START_DATE"].ToString() != "") { model.D_START_DATE = DateTime.Parse(row["D_START_DATE"].ToString()); } if (row["D_END_DATE"] != null && row["D_END_DATE"].ToString() != "") { model.D_END_DATE = DateTime.Parse(row["D_END_DATE"].ToString()); } if (row["N_STATUS"] != null && row["N_STATUS"].ToString() != "") { model.N_STATUS = decimal.Parse(row["N_STATUS"].ToString()); } if (row["N_COST"] != null && row["N_COST"].ToString() != "") { model.N_COST = decimal.Parse(row["N_COST"].ToString()); } if (row["C_EMP_ID"] != null) { model.C_EMP_ID = row["C_EMP_ID"].ToString(); } if (row["D_MOD_DT"] != null && row["D_MOD_DT"].ToString() != "") { model.D_MOD_DT = DateTime.Parse(row["D_MOD_DT"].ToString()); } if (row["C_REMARK"] != null) { model.C_REMARK = row["C_REMARK"].ToString(); } if (row["C_UNIT"] != null) { model.C_UNIT = row["C_UNIT"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TB_MATERIAL_COST model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TPB_MATERIAL_COST("); strSql.Append("C_MATERIAL_NAME,D_START_DATE,D_END_DATE,N_STATUS,N_COST,C_EMP_ID,D_MOD_DT,C_REMARK,C_UNIT)"); strSql.Append(" values ("); strSql.Append(":C_MATERIAL_NAME,:D_START_DATE,:D_END_DATE,:N_STATUS,:N_COST,:C_EMP_ID,:D_MOD_DT,:C_REMARK,:C_UNIT)"); OracleParameter[] parameters = { new OracleParameter(":C_MATERIAL_NAME", OracleDbType.Varchar2, 100), new OracleParameter(":D_START_DATE", OracleDbType.Date), new OracleParameter(":D_END_DATE", OracleDbType.Date), new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1), new OracleParameter(":N_COST", OracleDbType.Decimal, 15), new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":D_MOD_DT", OracleDbType.Date), new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 200), new OracleParameter(":C_UNIT", OracleDbType.Varchar2, 100) }; parameters[0].Value = model.C_MATERIAL_NAME; parameters[1].Value = model.D_START_DATE; parameters[2].Value = model.D_END_DATE; parameters[3].Value = model.N_STATUS; parameters[4].Value = model.N_COST; parameters[5].Value = model.C_EMP_ID; parameters[6].Value = model.D_MOD_DT; parameters[7].Value = model.C_REMARK; parameters[8].Value = model.C_UNIT; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TB_MATERIAL_COST GetModel(string C_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select C_ID,C_MATERIAL_NAME,D_START_DATE,D_END_DATE,N_STATUS,N_COST,C_EMP_ID,D_MOD_DT,C_REMARK,C_UNIT from TPB_MATERIAL_COST "); strSql.Append(" where C_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = C_ID; Mod_TB_MATERIAL_COST model = new Mod_TB_MATERIAL_COST(); DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_TB_MATERIAL_COST model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TB_MATERIAL_COST model) { return(dal.Add(model)); }