private EapValueListDetail GetEditEntity() { EapValueListDetail ret_entity = new EapValueListDetail(); ret_entity.VLIST_ID = txtVListId.Text.Trim(); try { ret_entity.VLIST_DETAIL_VALUE = decimal.Parse(txtVListDetailValue.Text.Trim()); } catch { Func.ShowMessage(MessageType.Warning, "值列表明细值无效,只能由数字组成,并且不能为空!"); return(null); } ret_entity.VLIST_DETAIL_NAME = txtVListDetailName.Text.Trim(); if (Func.StringLength(ret_entity.VLIST_DETAIL_NAME) == 0 || Func.StringLength(ret_entity.VLIST_DETAIL_NAME) > 50) { Func.ShowMessage(MessageType.Warning, "值列表明细名称不能为空或长度超长!"); return(null); } return(ret_entity); }
/// <summary> /// 添加值列表明细数据 /// </summary> /// <param name="add_entity">新增实体</param> /// <returns>错误消息,为空表示成功</returns> internal string AddValueListDetail(EapValueListDetail add_entity) { if (Config.GetConfig().DB_TYPE == "1") { return(DalOracle.GetDalOracle().AddValueListDetail(add_entity)); } return(string.Empty); }
/// <summary> /// 删除值列表明细数据 /// </summary> /// <param name="vlist_id">删除条件,值列表ID</param> /// <returns>错误消息,为空表示成功</returns> internal string DelValueListDetail(EapValueListDetail del_entity) { if (Config.GetConfig().DB_TYPE == "1") { return(DalOracle.GetDalOracle().DelValueListDetail(del_entity)); } return(string.Empty); }
/// <summary> /// 删除值列表明细数据 /// </summary> /// <param name="vlist_id">删除条件,值列表ID</param> /// <returns>错误消息,为空表示成功</returns> internal string DelValueListDetail(EapValueListDetail del_entity) { StringBuilder sql = new StringBuilder(100); sql.Append("delete T_EAP_VALUE_LIST_DETAIL T WHERE T.VLIST_DETAIL_ID=:VLIST_DETAIL_ID"); OracleParameter[] para = { new OracleParameter(":VLIST_DETAIL_ID", OracleType.Number) }; para[0].Value = del_entity.VLIST_DETAIL_ID; return Oracle.GetOracle().ExecSql(sql, para); }
/// <summary> /// 添加值列表明细数据 /// </summary> /// <param name="add_entity">新增实体</param> /// <returns>错误消息,为空表示成功</returns> internal string AddValueListDetail(EapValueListDetail add_entity) { StringBuilder sql = new StringBuilder(150); sql.Append("insert into T_EAP_VALUE_LIST_DETAIL T(T.VLIST_DETAIL_ID,T.VLIST_ID,T.VLIST_DETAIL_VALUE,T.VLIST_DETAIL_NAME)"); sql.Append(" values(SEQ_EAP_VALUE_LIST_DETAIL.Nextval,:VLIST_ID,:VLIST_DETAIL_VALUE,:VLIST_DETAIL_NAME)"); OracleParameter[] para = { new OracleParameter(":VLIST_ID", OracleType.VarChar), new OracleParameter(":VLIST_DETAIL_VALUE", OracleType.Number), new OracleParameter(":VLIST_DETAIL_NAME", OracleType.VarChar) }; para[0].Value = add_entity.VLIST_ID; para[1].Value = add_entity.VLIST_DETAIL_VALUE; para[2].Value = add_entity.VLIST_DETAIL_NAME; return Oracle.GetOracle().ExecSql(sql, para); }
private void btnSave_Click(object sender, EventArgs e) { EapValueListDetail edit_entity = GetEditEntity(); if (edit_entity == null) { return; } string ret_add = Bll.GetBll().AddValueListDetail(edit_entity); if (ret_add != string.Empty) { Func.ShowMessage(MessageType.Error, "数据添加失败,原因[" + ret_add + "]"); return; } //写日志 Log.Write(MessageType.Information, "添加值列表明细数据成功,值列表ID[" + edit_entity.VLIST_ID + "],值列表明细值[" + edit_entity.VLIST_DETAIL_VALUE + "]", Config.GetConfig().user.USER_ID); Func.ShowMessage(MessageType.Information, "数据添加成功!"); this.Close(); }
private void btnDelVListDetail_Click(object sender, EventArgs e) { if (dgvVListDetail.SelectedCells.Count == 0) { Func.ShowMessage(MessageType.Warning, "没有选中删除数据!"); return; } if (!Func.ShowQuestion("确认要删除该记录数据?")) { return; } EapValueListDetail del_entity = new EapValueListDetail(); del_entity.VLIST_ID = dgvVList.Rows[dgvVList.CurrentCell.RowIndex].Cells["VLIST_ID"].Value.ToString(); int iRowIndex = dgvVListDetail.CurrentCell.RowIndex; del_entity.VLIST_DETAIL_ID = decimal.Parse(dgvVListDetail.Rows[iRowIndex].Cells["VLIST_DETAIL_ID"].Value.ToString()); del_entity.VLIST_DETAIL_VALUE = decimal.Parse(dgvVListDetail.Rows[iRowIndex].Cells["VLIST_DETAIL_VALUE"].Value.ToString()); del_entity.VLIST_DETAIL_NAME = dgvVListDetail.Rows[iRowIndex].Cells["VLIST_DETAIL_NAME"].Value.ToString(); string str = Bll.GetBll().DelValueListDetail(del_entity); if (str != string.Empty) { Func.ShowMessage(MessageType.Error, "删除值列表明细数据失败!原因[" + str + "]"); } else { //写日志 string msg = "删除值列表明细数据成功,值列表ID[" + del_entity.VLIST_ID + "],值列表明细ID[" + del_entity.VLIST_DETAIL_ID + "],值列表明细值[" + del_entity.VLIST_DETAIL_VALUE + "],值列表明细名称[" + del_entity.VLIST_DETAIL_NAME + "]"; Log.Write(MessageType.Information, msg, Config.GetConfig().user.USER_ID); Func.ShowMessage(MessageType.Information, "值列表明细数据删除成功"); BindValueListDetail(del_entity.VLIST_ID); } }