/// <summary> /// 得到一个对象实体 /// </summary> public KPS.Model.BuLiangShiJianInfo DataRowToModel(DataRow row) { KPS.Model.BuLiangShiJianInfo model = new KPS.Model.BuLiangShiJianInfo(); if (row != null) { if(row["ID"]!=null && row["ID"].ToString()!="") { model.ID=int.Parse(row["ID"].ToString()); } if(row["b_ylqxmc"]!=null) { model.b_ylqxmc=row["b_ylqxmc"].ToString(); } if(row["b_ggxh"]!=null) { model.b_ggxh=row["b_ggxh"].ToString(); } if(row["b_sccj"]!=null) { model.b_sccj=row["b_sccj"].ToString(); } if(row["b_cpdm"]!=null) { model.b_cpdm=row["b_cpdm"].ToString(); } if(row["b_sl"]!=null && row["b_sl"].ToString()!="") { model.b_sl=int.Parse(row["b_sl"].ToString()); } if(row["b_sydw"]!=null) { model.b_sydw=row["b_sydw"].ToString(); } if(row["b_scrq"]!=null) { model.b_scrq=row["b_scrq"].ToString(); } if(row["b_zlsgqk"]!=null) { model.b_zlsgqk=row["b_zlsgqk"].ToString(); } if(row["b_bgr"]!=null) { model.b_bgr=row["b_bgr"].ToString(); } if(row["b_bgsj"]!=null && row["b_bgsj"].ToString()!="") { model.b_bgsj=DateTime.Parse(row["b_bgsj"].ToString()); } if(row["b_sydwyj"]!=null) { model.b_sydwyj=row["b_sydwyj"].ToString(); } if(row["b_fzr"]!=null) { model.b_fzr=row["b_fzr"].ToString(); } if(row["b_resj"]!=null && row["b_resj"].ToString()!="") { model.b_resj=DateTime.Parse(row["b_resj"].ToString()); } if(row["b_qyzgfzryj"]!=null) { model.b_qyzgfzryj=row["b_qyzgfzryj"].ToString(); } if(row["b_fzrqz"]!=null) { model.b_fzrqz=row["b_fzrqz"].ToString(); } if(row["b_fzrqzsj"]!=null && row["b_fzrqzsj"].ToString()!="") { model.b_fzrqzsj=DateTime.Parse(row["b_fzrqzsj"].ToString()); } if(row["b_zgclqk"]!=null) { model.b_zgclqk=row["b_zgclqk"].ToString(); } if(row["b_zgjbr"]!=null) { model.b_zgjbr=row["b_zgjbr"].ToString(); } if(row["b_zgjbsj"]!=null && row["b_zgjbsj"].ToString()!="") { model.b_zgjbsj=DateTime.Parse(row["b_zgjbsj"].ToString()); } if (row["DataType"] != null && row["DataType"].ToString() != "") { model.DataType = Convert.ToInt32(row["DataType"]); } } return model; }
/// <summary> /// 得到一个对象实体 /// </summary> public KPS.Model.BuLiangShiJianInfo DataRowToModel(DataRow row) { KPS.Model.BuLiangShiJianInfo model = new KPS.Model.BuLiangShiJianInfo(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["b_ylqxmc"] != null) { model.b_ylqxmc = row["b_ylqxmc"].ToString(); } if (row["b_ggxh"] != null) { model.b_ggxh = row["b_ggxh"].ToString(); } if (row["b_sccj"] != null) { model.b_sccj = row["b_sccj"].ToString(); } if (row["b_cpdm"] != null) { model.b_cpdm = row["b_cpdm"].ToString(); } if (row["b_sl"] != null && row["b_sl"].ToString() != "") { model.b_sl = int.Parse(row["b_sl"].ToString()); } if (row["b_sydw"] != null) { model.b_sydw = row["b_sydw"].ToString(); } if (row["b_scrq"] != null) { model.b_scrq = row["b_scrq"].ToString(); } if (row["b_zlsgqk"] != null) { model.b_zlsgqk = row["b_zlsgqk"].ToString(); } if (row["b_bgr"] != null) { model.b_bgr = row["b_bgr"].ToString(); } if (row["b_bgsj"] != null && row["b_bgsj"].ToString() != "") { model.b_bgsj = DateTime.Parse(row["b_bgsj"].ToString()); } if (row["b_sydwyj"] != null) { model.b_sydwyj = row["b_sydwyj"].ToString(); } if (row["b_fzr"] != null) { model.b_fzr = row["b_fzr"].ToString(); } if (row["b_resj"] != null && row["b_resj"].ToString() != "") { model.b_resj = DateTime.Parse(row["b_resj"].ToString()); } if (row["b_qyzgfzryj"] != null) { model.b_qyzgfzryj = row["b_qyzgfzryj"].ToString(); } if (row["b_fzrqz"] != null) { model.b_fzrqz = row["b_fzrqz"].ToString(); } if (row["b_fzrqzsj"] != null && row["b_fzrqzsj"].ToString() != "") { model.b_fzrqzsj = DateTime.Parse(row["b_fzrqzsj"].ToString()); } if (row["b_zgclqk"] != null) { model.b_zgclqk = row["b_zgclqk"].ToString(); } if (row["b_zgjbr"] != null) { model.b_zgjbr = row["b_zgjbr"].ToString(); } if (row["b_zgjbsj"] != null && row["b_zgjbsj"].ToString() != "") { model.b_zgjbsj = DateTime.Parse(row["b_zgjbsj"].ToString()); } if (row["DataType"] != null && row["DataType"].ToString() != "") { model.DataType = Convert.ToInt32(row["DataType"]); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(KPS.Model.BuLiangShiJianInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into PSI_BuLiangShiJian("); strSql.Append("b_ylqxmc,b_ggxh,b_sccj,b_cpdm,b_sl,b_sydw,b_scrq,b_zlsgqk,b_bgr,b_bgsj,b_sydwyj,b_fzr,b_resj,b_qyzgfzryj,b_fzrqz,b_fzrqzsj,b_zgclqk,b_zgjbr,b_zgjbsj,DataType)"); strSql.Append(" values ("); strSql.Append("@b_ylqxmc,@b_ggxh,@b_sccj,@b_cpdm,@b_sl,@b_sydw,@b_scrq,@b_zlsgqk,@b_bgr,@b_bgsj,@b_sydwyj,@b_fzr,@b_resj,@b_qyzgfzryj,@b_fzrqz,@b_fzrqzsj,@b_zgclqk,@b_zgjbr,@b_zgjbsj,@DataType)"); OleDbParameter[] parameters = { new OleDbParameter("@b_ylqxmc", OleDbType.VarChar, 255), new OleDbParameter("@b_ggxh", OleDbType.VarChar, 255), new OleDbParameter("@b_sccj", OleDbType.VarChar, 255), new OleDbParameter("@b_cpdm", OleDbType.VarChar, 255), new OleDbParameter("@b_sl", OleDbType.Integer, 4), new OleDbParameter("@b_sydw", OleDbType.VarChar, 255), new OleDbParameter("@b_scrq", OleDbType.VarChar, 255), new OleDbParameter("@b_zlsgqk", OleDbType.VarChar, 255), new OleDbParameter("@b_bgr", OleDbType.VarChar, 255), new OleDbParameter("@b_bgsj", OleDbType.Date), new OleDbParameter("@b_sydwyj", OleDbType.VarChar, 255), new OleDbParameter("@b_fzr", OleDbType.VarChar, 255), new OleDbParameter("@b_resj", OleDbType.Date), new OleDbParameter("@b_qyzgfzryj", OleDbType.VarChar, 255), new OleDbParameter("@b_fzrqz", OleDbType.VarChar, 255), new OleDbParameter("@b_fzrqzsj", OleDbType.Date), new OleDbParameter("@b_zgclqk", OleDbType.VarChar, 255), new OleDbParameter("@b_zgjbr", OleDbType.VarChar, 255), new OleDbParameter("@b_zgjbsj", OleDbType.Date), new OleDbParameter("@DataType", OleDbType.Integer, 4), }; parameters[0].Value = model.b_ylqxmc; parameters[1].Value = model.b_ggxh; parameters[2].Value = model.b_sccj; parameters[3].Value = model.b_cpdm; parameters[4].Value = model.b_sl; parameters[5].Value = model.b_sydw; parameters[6].Value = model.b_scrq; parameters[7].Value = model.b_zlsgqk; parameters[8].Value = model.b_bgr; parameters[9].Value = model.b_bgsj; parameters[10].Value = model.b_sydwyj; parameters[11].Value = model.b_fzr; parameters[12].Value = model.b_resj; parameters[13].Value = model.b_qyzgfzryj; parameters[14].Value = model.b_fzrqz; parameters[15].Value = model.b_fzrqzsj; parameters[16].Value = model.b_zgclqk; parameters[17].Value = model.b_zgjbr; parameters[18].Value = model.b_zgjbsj; parameters[19].Value = model.DataType; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(KPS.Model.BuLiangShiJianInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update PSI_BuLiangShiJian set "); strSql.Append("b_ylqxmc=@b_ylqxmc,"); strSql.Append("b_ggxh=@b_ggxh,"); strSql.Append("b_sccj=@b_sccj,"); strSql.Append("b_cpdm=@b_cpdm,"); strSql.Append("b_sl=@b_sl,"); strSql.Append("b_sydw=@b_sydw,"); strSql.Append("b_scrq=@b_scrq,"); strSql.Append("b_zlsgqk=@b_zlsgqk,"); strSql.Append("b_bgr=@b_bgr,"); strSql.Append("b_bgsj=@b_bgsj,"); strSql.Append("b_sydwyj=@b_sydwyj,"); strSql.Append("b_fzr=@b_fzr,"); strSql.Append("b_resj=@b_resj,"); strSql.Append("b_qyzgfzryj=@b_qyzgfzryj,"); strSql.Append("b_fzrqz=@b_fzrqz,"); strSql.Append("b_fzrqzsj=@b_fzrqzsj,"); strSql.Append("b_zgclqk=@b_zgclqk,"); strSql.Append("b_zgjbr=@b_zgjbr,"); strSql.Append("b_zgjbsj=@b_zgjbsj,"); strSql.Append("DataType=@DataType"); strSql.Append(" where ID=@ID"); OleDbParameter[] parameters = { new OleDbParameter("@b_ylqxmc", OleDbType.VarChar, 255), new OleDbParameter("@b_ggxh", OleDbType.VarChar, 255), new OleDbParameter("@b_sccj", OleDbType.VarChar, 255), new OleDbParameter("@b_cpdm", OleDbType.VarChar, 255), new OleDbParameter("@b_sl", OleDbType.Integer, 4), new OleDbParameter("@b_sydw", OleDbType.VarChar, 255), new OleDbParameter("@b_scrq", OleDbType.VarChar, 255), new OleDbParameter("@b_zlsgqk", OleDbType.VarChar, 255), new OleDbParameter("@b_bgr", OleDbType.VarChar, 255), new OleDbParameter("@b_bgsj", OleDbType.Date), new OleDbParameter("@b_sydwyj", OleDbType.VarChar, 255), new OleDbParameter("@b_fzr", OleDbType.VarChar, 255), new OleDbParameter("@b_resj", OleDbType.Date), new OleDbParameter("@b_qyzgfzryj", OleDbType.VarChar, 255), new OleDbParameter("@b_fzrqz", OleDbType.VarChar, 255), new OleDbParameter("@b_fzrqzsj", OleDbType.Date), new OleDbParameter("@b_zgclqk", OleDbType.VarChar, 255), new OleDbParameter("@b_zgjbr", OleDbType.VarChar, 255), new OleDbParameter("@b_zgjbsj", OleDbType.Date), new OleDbParameter("@DataType", OleDbType.Integer, 4), new OleDbParameter("@ID", OleDbType.Integer, 4) }; parameters[0].Value = model.b_ylqxmc; parameters[1].Value = model.b_ggxh; parameters[2].Value = model.b_sccj; parameters[3].Value = model.b_cpdm; parameters[4].Value = model.b_sl; parameters[5].Value = model.b_sydw; parameters[6].Value = model.b_scrq; parameters[7].Value = model.b_zlsgqk; parameters[8].Value = model.b_bgr; parameters[9].Value = model.b_bgsj; parameters[10].Value = model.b_sydwyj; parameters[11].Value = model.b_fzr; parameters[12].Value = model.b_resj; parameters[13].Value = model.b_qyzgfzryj; parameters[14].Value = model.b_fzrqz; parameters[15].Value = model.b_fzrqzsj; parameters[16].Value = model.b_zgclqk; parameters[17].Value = model.b_zgjbr; parameters[18].Value = model.b_zgjbsj; parameters[19].Value = model.DataType; parameters[20].Value = model.ID; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }