public List<PD_BASE_KAOPINGTYPE_Model> DataTableToList(DataTable dt) { List<PD_BASE_KAOPINGTYPE_Model> list = new List<PD_BASE_KAOPINGTYPE_Model>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { PD_BASE_KAOPINGTYPE_Model item = new PD_BASE_KAOPINGTYPE_Model(); if (dt.Rows[i]["AUTO_ID"].ToString() != "") { item.AUTO_ID = new int?(int.Parse(dt.Rows[i]["AUTO_ID"].ToString())); } item.KHTYPENAME = dt.Rows[i]["KHTYPENAME"].ToString(); if (dt.Rows[i]["KHTYPEPER"].ToString() != "") { item.KHTYPEPER = new int?(int.Parse(dt.Rows[i]["KHTYPEPER"].ToString())); } if (dt.Rows[i]["ORDERID"].ToString() != "") { item.ORDERID = new int?(int.Parse(dt.Rows[i]["ORDERID"].ToString())); } item.REMARK = dt.Rows[i]["REMARK"].ToString(); item.ISCOMFIRM = dt.Rows[i]["ISCOMFIRM"].ToString(); item.KHYEAR = dt.Rows[i]["KHYEAR"].ToString(); list.Add(item); } } return list; }
public PD_BASE_KAOPINGTYPE_Model GetModel(int AUTO_ID) { StringBuilder builder = new StringBuilder(); builder.Append("select AUTO_ID,KHTYPENAME,KHTYPEPER,ORDERID,REMARK,ISCOMFIRM,KHYEAR from PD_BASE_KAOPINGTYPE "); builder.Append(" where AUTO_ID=:AUTO_ID "); OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":AUTO_ID", OracleType.Number, 4) }; cmdParms[0].Value = AUTO_ID; PD_BASE_KAOPINGTYPE_Model model = new PD_BASE_KAOPINGTYPE_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.KHTYPENAME = set.Tables[0].Rows[0]["KHTYPENAME"].ToString(); if (set.Tables[0].Rows[0]["KHTYPEPER"].ToString() != "") { model.KHTYPEPER = new int?(int.Parse(set.Tables[0].Rows[0]["KHTYPEPER"].ToString())); } if (set.Tables[0].Rows[0]["ORDERID"].ToString() != "") { model.ORDERID = new int?(int.Parse(set.Tables[0].Rows[0]["ORDERID"].ToString())); } model.REMARK = set.Tables[0].Rows[0]["REMARK"].ToString(); model.ISCOMFIRM = set.Tables[0].Rows[0]["ISCOMFIRM"].ToString(); model.KHYEAR = set.Tables[0].Rows[0]["KHYEAR"].ToString(); return model; }
public void Add(PD_BASE_KAOPINGTYPE_Model model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into PD_BASE_KAOPINGTYPE("); builder.Append("AUTO_ID,KHTYPENAME,KHTYPEPER,ORDERID,REMARK,ISCOMFIRM,KHYEAR)"); builder.Append(" values ("); builder.Append("SQ_KAOHETYPE.NEXTVAL,:KHTYPENAME,:KHTYPEPER,:ORDERID,:REMARK,:ISCOMFIRM,:KHYEAR)"); OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":KHTYPENAME", OracleType.NVarChar), new OracleParameter(":KHTYPEPER", OracleType.Number, 4), new OracleParameter(":ORDERID", OracleType.Number, 4), new OracleParameter(":REMARK", OracleType.NVarChar), new OracleParameter(":ISCOMFIRM", OracleType.Char, 1), new OracleParameter(":KHYEAR", OracleType.NVarChar) }; cmdParms[0].Value = model.KHTYPENAME; cmdParms[1].Value = model.KHTYPEPER; cmdParms[2].Value = model.ORDERID; cmdParms[3].Value = model.REMARK; cmdParms[4].Value = model.ISCOMFIRM; cmdParms[5].Value = model.KHYEAR; DbHelperOra.ExecuteSql(builder.ToString(), cmdParms); }
public bool Update(PD_BASE_KAOPINGTYPE_Model model) { StringBuilder builder = new StringBuilder(); builder.Append("update PD_BASE_KAOPINGTYPE set "); builder.Append("AUTO_ID=:AUTO_ID,"); builder.Append("KHTYPENAME=:KHTYPENAME,"); builder.Append("KHTYPEPER=:KHTYPEPER,"); builder.Append("ORDERID=:ORDERID,"); builder.Append("REMARK=:REMARK,"); builder.Append("ISCOMFIRM=:ISCOMFIRM,"); builder.Append("KHYEAR=:KHYEAR"); builder.Append(" where AUTO_ID=:AUTO_ID "); OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":AUTO_ID", OracleType.Number, 4), new OracleParameter(":KHTYPENAME", OracleType.NVarChar), new OracleParameter(":KHTYPEPER", OracleType.Number, 4), new OracleParameter(":ORDERID", OracleType.Number, 4), new OracleParameter(":REMARK", OracleType.NVarChar), new OracleParameter(":ISCOMFIRM", OracleType.Char, 1), new OracleParameter(":KHYEAR", OracleType.NVarChar) }; cmdParms[0].Value = model.AUTO_ID; cmdParms[1].Value = model.KHTYPENAME; cmdParms[2].Value = model.KHTYPEPER; cmdParms[3].Value = model.ORDERID; cmdParms[4].Value = model.REMARK; cmdParms[5].Value = model.ISCOMFIRM; cmdParms[6].Value = model.KHYEAR; return (DbHelperOra.ExecuteSql(builder.ToString(), cmdParms) > 0); }
private void UpdateKHType() { PD_BASE_KAOPINGTYPE_Model model = new PD_BASE_KAOPINGTYPE_Model(); PD_BASE_KAOPINGTYPE_Bll bll = new PD_BASE_KAOPINGTYPE_Bll(); if (base.Request["PK"] != null) { model.AUTO_ID = new int?(Convert.ToInt32(base.Request["PK"].ToString())); } model.KHTYPENAME = this.txtKHTypeName.Text.Trim(); model.KHTYPEPER = new int?(Convert.ToInt32(this.txtKHTypePer.Text.Trim())); model.KHYEAR = this.ddlKH_Year.SelectedValue.ToString(); if (string.IsNullOrEmpty(this.txtOrderID.Text.Trim())) { model.ORDERID = 0; } else { model.ORDERID = new int?(Convert.ToInt32(this.txtOrderID.Text.Trim())); } model.REMARK = this.txtRemark.Text.Trim(); model.ISCOMFIRM = this.ddlIsComfirm.SelectedValue; if (bll.Update(model)) { Const.DoSuccessClose("修改成功", this.Page); } }
private void ShowInfo(string pk) { PD_BASE_KAOPINGTYPE_Model model = new PD_BASE_KAOPINGTYPE_Model(); model = new PD_BASE_KAOPINGTYPE_Bll().GetModel(Convert.ToInt32(pk)); this.txtKHTypeName.Text = model.KHTYPENAME; this.txtKHTypePer.Text = model.KHTYPEPER.ToString(); this.txtOrderID.Text = model.ORDERID.ToString(); this.txtRemark.Text = model.REMARK; this.ddlIsComfirm.SelectedValue = model.ISCOMFIRM; this.ddlKH_Year.SelectedValue = model.KHYEAR; }
private void AddKHType() { try { if (this.txtKHTypeName.Text.Trim() == "") { Const.ShowMessage("请输入考核内容!", this.Page); } if (this.txtKHTypePer.Text.Trim() == "") { Const.ShowMessage("请输入考核项目分值!", this.Page); } else { PD_BASE_KAOPINGTYPE_Model model = new PD_BASE_KAOPINGTYPE_Model(); PD_BASE_KAOPINGTYPE_Bll bll = new PD_BASE_KAOPINGTYPE_Bll(); model.KHTYPENAME = this.txtKHTypeName.Text.Trim(); model.KHTYPEPER = new int?(Convert.ToInt32(this.txtKHTypePer.Text.Trim())); model.KHYEAR = this.ddlKH_Year.SelectedValue.ToString(); if (string.IsNullOrEmpty(this.txtOrderID.Text.Trim())) { model.ORDERID = 0; } else { model.ORDERID = new int?(Convert.ToInt32(this.txtOrderID.Text.Trim())); } model.REMARK = this.txtRemark.Text.Trim(); model.ISCOMFIRM = this.ddlIsComfirm.SelectedValue; bll.Add(model); Const.DoSuccessClose("添加成功", 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_KAOPINGTYPE_Model model) { return this.dal.Update(model); }
public void Add(PD_BASE_KAOPINGTYPE_Model model) { this.dal.Add(model); }