/// <summary> /// 得到一个对象实体 /// </summary> public KPS.Model.CunChuInfo DataRowToModel(DataRow row) { KPS.Model.CunChuInfo model = new KPS.Model.CunChuInfo(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["s_csmc"] != null) { model.s_csmc = row["s_csmc"].ToString(); } if (row["s_date"] != null && row["s_date"].ToString() != "") { model.s_date = DateTime.Parse(row["s_date"].ToString()); } if (row["s_sywdfw"] != null) { model.s_sywdfw = row["s_sywdfw"].ToString(); } if (row["s_syxdsdfw"] != null) { model.s_syxdsdfw = row["s_syxdsdfw"].ToString(); } if (row["s_sworxw"] != null && row["s_sworxw"].ToString() != "") { model.s_sworxw = int.Parse(row["s_sworxw"].ToString()); } if (row["s_wd"] != null) { model.s_wd = row["s_wd"].ToString(); } if (row["s_sd"] != null) { model.s_sd = row["s_sd"].ToString(); } if (row["s_cqcs"] != null) { model.s_cqcs = row["s_cqcs"].ToString(); } if (row["s_wded"] != null) { model.s_wded = row["s_wded"].ToString(); } if (row["s_sded"] != null) { model.s_sded = row["s_sded"].ToString(); } if (row["s_jlr"] != null) { model.s_jlr = row["s_jlr"].ToString(); } if (row["DataType"] != null) { model.DataType = Convert.ToInt32(row["DataType"]); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public KPS.Model.CunChuInfo DataRowToModel(DataRow row) { KPS.Model.CunChuInfo model = new KPS.Model.CunChuInfo(); if (row != null) { if(row["ID"]!=null && row["ID"].ToString()!="") { model.ID=int.Parse(row["ID"].ToString()); } if(row["s_csmc"]!=null) { model.s_csmc=row["s_csmc"].ToString(); } if(row["s_date"]!=null && row["s_date"].ToString()!="") { model.s_date=DateTime.Parse(row["s_date"].ToString()); } if(row["s_sywdfw"]!=null) { model.s_sywdfw=row["s_sywdfw"].ToString(); } if(row["s_syxdsdfw"]!=null) { model.s_syxdsdfw=row["s_syxdsdfw"].ToString(); } if(row["s_sworxw"]!=null && row["s_sworxw"].ToString()!="") { model.s_sworxw=int.Parse(row["s_sworxw"].ToString()); } if(row["s_wd"]!=null) { model.s_wd=row["s_wd"].ToString(); } if(row["s_sd"]!=null) { model.s_sd=row["s_sd"].ToString(); } if(row["s_cqcs"]!=null) { model.s_cqcs=row["s_cqcs"].ToString(); } if(row["s_wded"]!=null) { model.s_wded=row["s_wded"].ToString(); } if(row["s_sded"]!=null) { model.s_sded=row["s_sded"].ToString(); } if(row["s_jlr"]!=null) { model.s_jlr=row["s_jlr"].ToString(); } if (row["DataType"] != null) { model.DataType =Convert.ToInt32(row["DataType"]); } } return model; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(KPS.Model.CunChuInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update PSI_CunChu set "); strSql.Append("s_csmc=@s_csmc,"); strSql.Append("s_date=@s_date,"); strSql.Append("s_sywdfw=@s_sywdfw,"); strSql.Append("s_syxdsdfw=@s_syxdsdfw,"); strSql.Append("s_sworxw=@s_sworxw,"); strSql.Append("s_wd=@s_wd,"); strSql.Append("s_sd=@s_sd,"); strSql.Append("s_cqcs=@s_cqcs,"); strSql.Append("s_wded=@s_wded,"); strSql.Append("s_sded=@s_sded,"); strSql.Append("s_jlr=@s_jlr,"); strSql.Append("DataType=@DataType"); strSql.Append(" where ID=@ID"); OleDbParameter[] parameters = { new OleDbParameter("@s_csmc", OleDbType.VarChar, 255), new OleDbParameter("@s_date", OleDbType.Date), new OleDbParameter("@s_sywdfw", OleDbType.VarChar, 255), new OleDbParameter("@s_syxdsdfw", OleDbType.VarChar, 255), new OleDbParameter("@s_sworxw", OleDbType.Integer, 4), new OleDbParameter("@s_wd", OleDbType.VarChar, 255), new OleDbParameter("@s_sd", OleDbType.VarChar, 255), new OleDbParameter("@s_cqcs", OleDbType.VarChar, 255), new OleDbParameter("@s_wded", OleDbType.VarChar, 255), new OleDbParameter("@s_sded", OleDbType.VarChar, 255), new OleDbParameter("@s_jlr", OleDbType.VarChar, 255), new OleDbParameter("@DataType", OleDbType.Integer, 4), new OleDbParameter("@ID", OleDbType.Integer, 4) }; parameters[0].Value = model.s_csmc; parameters[1].Value = model.s_date; parameters[2].Value = model.s_sywdfw; parameters[3].Value = model.s_syxdsdfw; parameters[4].Value = model.s_sworxw; parameters[5].Value = model.s_wd; parameters[6].Value = model.s_sd; parameters[7].Value = model.s_cqcs; parameters[8].Value = model.s_wded; parameters[9].Value = model.s_sded; parameters[10].Value = model.s_jlr; parameters[11].Value = model.DataType; parameters[12].Value = model.ID; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(KPS.Model.CunChuInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into PSI_CunChu("); strSql.Append("s_csmc,s_date,s_sywdfw,s_syxdsdfw,s_sworxw,s_wd,s_sd,s_cqcs,s_wded,s_sded,s_jlr,DataType)"); strSql.Append(" values ("); strSql.Append("@s_csmc,@s_date,@s_sywdfw,@s_syxdsdfw,@s_sworxw,@s_wd,@s_sd,@s_cqcs,@s_wded,@s_sded,@s_jlr,@DataType)"); OleDbParameter[] parameters = { new OleDbParameter("@s_csmc", OleDbType.VarChar, 255), new OleDbParameter("@s_date", OleDbType.Date), new OleDbParameter("@s_sywdfw", OleDbType.VarChar, 255), new OleDbParameter("@s_syxdsdfw", OleDbType.VarChar, 255), new OleDbParameter("@s_sworxw", OleDbType.Integer, 4), new OleDbParameter("@s_wd", OleDbType.VarChar, 255), new OleDbParameter("@s_sd", OleDbType.VarChar, 255), new OleDbParameter("@s_cqcs", OleDbType.VarChar, 255), new OleDbParameter("@s_wded", OleDbType.VarChar, 255), new OleDbParameter("@s_sded", OleDbType.VarChar, 255), new OleDbParameter("@s_jlr", OleDbType.VarChar, 255), new OleDbParameter("@DataType", OleDbType.Integer, 4) }; parameters[0].Value = model.s_csmc; parameters[1].Value = model.s_date; parameters[2].Value = model.s_sywdfw; parameters[3].Value = model.s_syxdsdfw; parameters[4].Value = model.s_sworxw; parameters[5].Value = model.s_wd; parameters[6].Value = model.s_sd; parameters[7].Value = model.s_cqcs; parameters[8].Value = model.s_wded; parameters[9].Value = model.s_sded; parameters[10].Value = model.s_jlr; parameters[11].Value = model.DataType; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }