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