public List<PD_PROJECT_KAOPING_Model> DataTableToList(DataTable dt) { List<PD_PROJECT_KAOPING_Model> list = new List<PD_PROJECT_KAOPING_Model>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { PD_PROJECT_KAOPING_Model item = new PD_PROJECT_KAOPING_Model(); if (dt.Rows[i]["AUTO_ID"].ToString() != "") { item.AUTO_ID = new int?(int.Parse(dt.Rows[i]["AUTO_ID"].ToString())); } if (dt.Rows[i]["KP_TYPEID"].ToString() != "") { item.KP_TYPEID = new int?(int.Parse(dt.Rows[i]["KP_TYPEID"].ToString())); } if (dt.Rows[i]["KP_DETAILID"].ToString() != "") { item.KP_DETAILID = new int?(int.Parse(dt.Rows[i]["KP_DETAILID"].ToString())); } item.KP_YEAR = dt.Rows[i]["KP_YEAR"].ToString(); item.KP_COMPANYPK = dt.Rows[i]["KP_COMPANYPK"].ToString(); item.KH_TYPE = dt.Rows[i]["KH_TYPE"].ToString(); if (dt.Rows[i]["KP_SCORE"].ToString() != "") { item.KP_SCORE = new int?(int.Parse(dt.Rows[i]["KP_SCORE"].ToString())); } list.Add(item); } } return list; }
public PD_PROJECT_KAOPING_Model GetModel(int AUTO_ID) { StringBuilder builder = new StringBuilder(); builder.Append("select AUTO_ID,KP_TYPEID,KP_DETAILID,KP_YEAR,KP_COMPANYPK,KH_TYPE,KP_SCORE from PD_PROJECT_KAOPING "); builder.Append(" where AUTO_ID=:AUTO_ID "); OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":AUTO_ID", OracleType.Number, 4) }; cmdParms[0].Value = AUTO_ID; PD_PROJECT_KAOPING_Model model = new PD_PROJECT_KAOPING_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())); } if (set.Tables[0].Rows[0]["KP_TYPEID"].ToString() != "") { model.KP_TYPEID = new int?(int.Parse(set.Tables[0].Rows[0]["KP_TYPEID"].ToString())); } if (set.Tables[0].Rows[0]["KP_DETAILID"].ToString() != "") { model.KP_DETAILID = new int?(int.Parse(set.Tables[0].Rows[0]["KP_DETAILID"].ToString())); } model.KP_YEAR = set.Tables[0].Rows[0]["KP_YEAR"].ToString(); model.KP_COMPANYPK = set.Tables[0].Rows[0]["KP_COMPANYPK"].ToString(); model.KH_TYPE = set.Tables[0].Rows[0]["KH_TYPE"].ToString(); if (set.Tables[0].Rows[0]["KP_SCORE"].ToString() != "") { model.KP_SCORE = new int?(int.Parse(set.Tables[0].Rows[0]["KP_SCORE"].ToString())); } return model; }
public void Add(PD_PROJECT_KAOPING_Model model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into PD_PROJECT_KAOPING("); builder.Append("AUTO_ID,KP_TYPEID,KP_DETAILID,KP_YEAR,KP_COMPANYPK,KH_TYPE,KP_SCORE)"); builder.Append(" values ("); builder.Append(":AUTO_ID,:KP_TYPEID,:KP_DETAILID,:KP_YEAR,:KP_COMPANYPK,:KH_TYPE,:KP_SCORE)"); OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":AUTO_ID", OracleType.Number, 4), new OracleParameter(":KP_TYPEID", OracleType.Number, 4), new OracleParameter(":KP_DETAILID", OracleType.Number, 4), new OracleParameter(":KP_YEAR", OracleType.NVarChar), new OracleParameter(":KP_COMPANYPK", OracleType.NVarChar), new OracleParameter(":KH_TYPE", OracleType.NVarChar), new OracleParameter(":KP_SCORE", OracleType.Number, 4) }; cmdParms[0].Value = model.AUTO_ID; cmdParms[1].Value = model.KP_TYPEID; cmdParms[2].Value = model.KP_DETAILID; cmdParms[3].Value = model.KP_YEAR; cmdParms[4].Value = model.KP_COMPANYPK; cmdParms[5].Value = model.KH_TYPE; cmdParms[6].Value = model.KP_SCORE; DbHelperOra.ExecuteSql(builder.ToString(), cmdParms); }
public bool Update(PD_PROJECT_KAOPING_Model model) { return this.dal.Update(model); }
public void Add(PD_PROJECT_KAOPING_Model model) { this.dal.Add(model); }
public bool Update(PD_PROJECT_KAOPING_Model model) { StringBuilder builder = new StringBuilder(); builder.Append("update PD_PROJECT_KAOPING set "); builder.Append("AUTO_ID=:AUTO_ID,"); builder.Append("KP_TYPEID=:KP_TYPEID,"); builder.Append("KP_DETAILID=:KP_DETAILID,"); builder.Append("KP_YEAR=:KP_YEAR,"); builder.Append("KP_COMPANYPK=:KP_COMPANYPK,"); builder.Append("KH_TYPE=:KH_TYPE,"); builder.Append("KP_SCORE=:KP_SCORE"); builder.Append(" where AUTO_ID=:AUTO_ID "); OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":AUTO_ID", OracleType.Number, 4), new OracleParameter(":KP_TYPEID", OracleType.Number, 4), new OracleParameter(":KP_DETAILID", OracleType.Number, 4), new OracleParameter(":KP_YEAR", OracleType.NVarChar), new OracleParameter(":KP_COMPANYPK", OracleType.NVarChar), new OracleParameter(":KH_TYPE", OracleType.NVarChar), new OracleParameter(":KP_SCORE", OracleType.Number, 4) }; cmdParms[0].Value = model.AUTO_ID; cmdParms[1].Value = model.KP_TYPEID; cmdParms[2].Value = model.KP_DETAILID; cmdParms[3].Value = model.KP_YEAR; cmdParms[4].Value = model.KP_COMPANYPK; cmdParms[5].Value = model.KH_TYPE; cmdParms[6].Value = model.KP_SCORE; return (DbHelperOra.ExecuteSql(builder.ToString(), cmdParms) > 0); }