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