コード例 #1
0
 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;
 }
コード例 #2
0
 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;
 }
コード例 #3
0
 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);
 }
コード例 #4
0
 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);
     }
 }
コード例 #5
0
 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();
 }
コード例 #6
0
 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);
     }
 }
コード例 #7
0
 public bool Update(PD_BASE_KAOPINGTYPEDETAIL_Model model)
 {
     return this.dal.Update(model);
 }
コード例 #8
0
 public void Add(PD_BASE_KAOPINGTYPEDETAIL_Model model)
 {
     this.dal.Add(model);
 }
コード例 #9
0
 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);
     }
 }
コード例 #10
0
 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);
 }