public List<PD_BASE_KAOPINGTYPEDETAIL_Model> DataTableToList(DataTable dt) { List<PD_BASE_KAOPINGTYPEDETAIL_Model> list = new List<PD_BASE_KAOPINGTYPEDETAIL_Model>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { PD_BASE_KAOPINGTYPEDETAIL_Model item = new PD_BASE_KAOPINGTYPEDETAIL_Model(); if (dt.Rows[i]["AUTO_ID"].ToString() != "") { item.AUTO_ID = new int?(int.Parse(dt.Rows[i]["AUTO_ID"].ToString())); } item.KP_YEAR = dt.Rows[i]["KP_YEAR"].ToString(); item.KP_CONTENT = dt.Rows[i]["KP_CONTENT"].ToString(); if (dt.Rows[i]["KP_TYPEID"].ToString() != "") { item.KP_TYPEID = new int?(int.Parse(dt.Rows[i]["KP_TYPEID"].ToString())); } item.KP_BIAOZHUN = dt.Rows[i]["KP_BIAOZHUN"].ToString(); if (dt.Rows[i]["KP_BASECODE"].ToString() != "") { item.KP_BASECODE = new int?(int.Parse(dt.Rows[i]["KP_BASECODE"].ToString())); } item.ISCOMFIRM = dt.Rows[i]["ISCOMFIRM"].ToString(); list.Add(item); } } return list; }
public PD_BASE_KAOPINGTYPEDETAIL_Model GetModel(int AUTO_ID) { StringBuilder builder = new StringBuilder(); builder.Append("select a.*,b.khtypename from PD_BASE_KAOPINGTYPEDETAIL a ,PD_BASE_KAOPINGTYPE b where a.kp_typeid=b.auto_id "); builder.Append(" and a.AUTO_ID=:AUTO_ID"); OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":AUTO_ID", OracleType.Number, 4) }; cmdParms[0].Value = AUTO_ID; PD_BASE_KAOPINGTYPEDETAIL_Model model = new PD_BASE_KAOPINGTYPEDETAIL_Model(); DataSet set = DbHelperOra.Query(builder.ToString(), cmdParms); if (set.Tables[0].Rows.Count <= 0) { return null; } if (set.Tables[0].Rows[0]["AUTO_ID"].ToString() != "") { model.AUTO_ID = new int?(int.Parse(set.Tables[0].Rows[0]["AUTO_ID"].ToString())); } model.KP_YEAR = set.Tables[0].Rows[0]["KP_YEAR"].ToString(); model.KP_CONTENT = set.Tables[0].Rows[0]["KP_CONTENT"].ToString(); if (set.Tables[0].Rows[0]["KP_TYPEID"].ToString() != "") { model.KP_TYPEID = new int?(int.Parse(set.Tables[0].Rows[0]["KP_TYPEID"].ToString())); } model.KP_BIAOZHUN = set.Tables[0].Rows[0]["KP_BIAOZHUN"].ToString(); if (set.Tables[0].Rows[0]["KP_BASECODE"].ToString() != "") { model.KP_BASECODE = new int?(int.Parse(set.Tables[0].Rows[0]["KP_BASECODE"].ToString())); } model.ISCOMFIRM = set.Tables[0].Rows[0]["ISCOMFIRM"].ToString(); model.typename = set.Tables[0].Rows[0]["khtypename"].ToString(); return model; }
public void Add(PD_BASE_KAOPINGTYPEDETAIL_Model model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into PD_BASE_KAOPINGTYPEDETAIL("); builder.Append("AUTO_ID,KP_YEAR,KP_CONTENT,KP_TYPEID,KP_BIAOZHUN,KP_BASECODE,ISCOMFIRM)"); builder.Append(" values ("); builder.Append("SQ_KAOPINGTYPEDETAIL.NEXTVAL,:KP_YEAR,:KP_CONTENT,:KP_TYPEID,:KP_BIAOZHUN,:KP_BASECODE,:ISCOMFIRM)"); OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":KP_YEAR", OracleType.NVarChar), new OracleParameter(":KP_CONTENT", OracleType.NVarChar), new OracleParameter(":KP_TYPEID", OracleType.Number, 4), new OracleParameter(":KP_BIAOZHUN", OracleType.NVarChar), new OracleParameter(":KP_BASECODE", OracleType.Number, 4), new OracleParameter(":ISCOMFIRM", OracleType.Char, 1) }; cmdParms[0].Value = model.KP_YEAR; cmdParms[1].Value = model.KP_CONTENT; cmdParms[2].Value = model.KP_TYPEID; cmdParms[3].Value = model.KP_BIAOZHUN; cmdParms[4].Value = model.KP_BASECODE; cmdParms[5].Value = model.ISCOMFIRM; DbHelperOra.ExecuteSql(builder.ToString(), cmdParms); }
private void UpdateKHType() { PD_BASE_KAOPINGTYPEDETAIL_Model model = new PD_BASE_KAOPINGTYPEDETAIL_Model(); PD_BASE_KAOPINGTYPEDETAIL_Bll bll = new PD_BASE_KAOPINGTYPEDETAIL_Bll(); if (base.Request["PK"] != null) { model.AUTO_ID = new int?(Convert.ToInt32(base.Request["PK"].ToString())); } model.KP_CONTENT = this.txtKPContent.Text; model.KP_BIAOZHUN = this.txtKP_BiaoZhun.Text; model.KP_YEAR = this.ddlKP_Year.SelectedValue; model.KP_TYPEID = new int?(int.Parse(this.txtKHTypeID.Value)); model.ISCOMFIRM = this.ddlIsComfirm.SelectedValue.ToString(); if (bll.Update(model)) { Const.DoSuccessClose("修改成功", this.Page); } }
private void ShowInfo(string pk) { PD_BASE_KAOPINGTYPEDETAIL_Model model = new PD_BASE_KAOPINGTYPEDETAIL_Model(); model = new PD_BASE_KAOPINGTYPEDETAIL_Bll().GetModel(Convert.ToInt32(pk)); this.txtKPContent.Text = model.KP_CONTENT; this.txtKP_BiaoZhun.Text = model.KP_BIAOZHUN; this.ddlKP_Year.SelectedValue = model.KP_YEAR; this.ddlIsComfirm.SelectedValue = model.ISCOMFIRM.ToString(); this.txtKHTypeID.Value = model.KP_TYPEID.ToString(); this.txtKHType.Value = model.typename.ToString(); }
private void AddKHTypeDetail() { try { if (this.txtKPContent.Text.Trim() == "") { Const.ShowMessage("请输入考评内容!", this.Page); } if (this.txtKP_BiaoZhun.Text.Trim() == "") { Const.ShowMessage("请输入扣分标准!", this.Page); } else { PD_BASE_KAOPINGTYPEDETAIL_Model model = new PD_BASE_KAOPINGTYPEDETAIL_Model(); PD_BASE_KAOPINGTYPEDETAIL_Bll bll = new PD_BASE_KAOPINGTYPEDETAIL_Bll(); model.KP_CONTENT = this.txtKPContent.Text; model.KP_BIAOZHUN = this.txtKP_BiaoZhun.Text; model.KP_YEAR = this.ddlKP_Year.SelectedValue; model.KP_TYPEID = new int?(int.Parse(this.txtKHTypeID.Value)); DataSet set = DbHelperOra.Query("select khtypeper from PD_BASE_KAOPINGTYPE where auto_id=" + model.KP_TYPEID); if (set != null) { model.KP_BASECODE = new int?(Convert.ToInt32(set.Tables[0].Rows[0][0].ToString())); } else { model.KP_BASECODE = 0; } model.ISCOMFIRM = this.ddlIsComfirm.SelectedValue.ToString(); bll.Add(model); Const.DoSuccessOpen("", this.Page); } } catch (Exception exception) { this.el = new ExceptionLog.ExceptionLog(); this.el.ErrClassName = base.GetType().ToString(); this.el.ErrMessage = exception.Message.ToString(); this.el.ErrMethod = "AddMenu()"; this.el.WriteExceptionLog(true); Const.OpenErrorPage("操作失败,请联系管理员!", this.Page); } }
public bool Update(PD_BASE_KAOPINGTYPEDETAIL_Model model) { return this.dal.Update(model); }
public void Add(PD_BASE_KAOPINGTYPEDETAIL_Model model) { this.dal.Add(model); }
private void AddKHTypeDetail() { try { if (this.txtKPContent.Text.Trim() == "") { Const.ShowMessage("请输入考评内容!", this.Page); } if (this.txtKP_BiaoZhun.Text.Trim() == "") { Const.ShowMessage("请输入扣分标准!", this.Page); } else { PD_BASE_KAOPINGTYPEDETAIL_Model model = new PD_BASE_KAOPINGTYPEDETAIL_Model(); PD_BASE_KAOPINGTYPEDETAIL_Bll bll = new PD_BASE_KAOPINGTYPEDETAIL_Bll(); model.KP_CONTENT = this.txtKPContent.Text; model.KP_BIAOZHUN = this.txtKP_BiaoZhun.Text; model.KP_YEAR = this.ddlKP_Year.SelectedValue; model.KP_TYPEID = new int?(this.KPTypeID); model.ISCOMFIRM = this.ddlIsComfirm.SelectedValue.ToString(); bll.Add(model); Const.DoSuccessOpen("", this.Page); } } catch (Exception exception) { this.el = new ExceptionLog.ExceptionLog(); this.el.ErrClassName = base.GetType().ToString(); this.el.ErrMessage = exception.Message.ToString(); this.el.ErrMethod = "AddMenu()"; this.el.WriteExceptionLog(true); Const.OpenErrorPage("操作失败,请联系管理员!", this.Page); } }
public bool Update(PD_BASE_KAOPINGTYPEDETAIL_Model model) { StringBuilder builder = new StringBuilder(); builder.Append("update PD_BASE_KAOPINGTYPEDETAIL set "); builder.Append("AUTO_ID=:AUTO_ID,"); builder.Append("KP_YEAR=:KP_YEAR,"); builder.Append("KP_CONTENT=:KP_CONTENT,"); builder.Append("KP_TYPEID=:KP_TYPEID,"); builder.Append("KP_BIAOZHUN=:KP_BIAOZHUN,"); builder.Append("KP_BASECODE=:KP_BASECODE,"); builder.Append("ISCOMFIRM=:ISCOMFIRM"); builder.Append(" where AUTO_ID=:AUTO_ID "); OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":AUTO_ID", OracleType.Number, 4), new OracleParameter(":KP_YEAR", OracleType.NVarChar), new OracleParameter(":KP_CONTENT", OracleType.NVarChar), new OracleParameter(":KP_TYPEID", OracleType.Number, 4), new OracleParameter(":KP_BIAOZHUN", OracleType.NVarChar), new OracleParameter(":KP_BASECODE", OracleType.Number, 4), new OracleParameter(":ISCOMFIRM", OracleType.Char, 1) }; cmdParms[0].Value = model.AUTO_ID; cmdParms[1].Value = model.KP_YEAR; cmdParms[2].Value = model.KP_CONTENT; cmdParms[3].Value = model.KP_TYPEID; cmdParms[4].Value = model.KP_BIAOZHUN; cmdParms[5].Value = model.KP_BASECODE; cmdParms[6].Value = model.ISCOMFIRM; return (DbHelperOra.ExecuteSql(builder.ToString(), cmdParms) > 0); }