/// <summary> /// 得到一个对象实体 /// </summary> public DigiPower.Onlinecol.Standard.Model.T_ReadyCheckBook_MDL GetModel(int ReadyCheckBookID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ReadyCheckBookID,SingleProjectID,CodeType,ReadyCheckBookCode,BeginDate,EndDate,CreateUserID,CreateTime, "); strSql.Append("TOTAL_SCROLL,CHARACTER_SCROLL,PIC_SCROLL,PIC_PAGE_COUNT,PHOTO_COUNT,RADIO_COUNT,OTHER_MATERIAL,Directory_SCROLL,Directory_PAGE_COUNT, "); strSql.Append("zljddw,ArchiveUserName,ArchiveUser_Tel,jsdwfzr_Name,jsdwfzr_Tel,cscd from T_ReadyCheckBook "); strSql.Append(" where ReadyCheckBookID=@ReadyCheckBookID "); SqlParameter[] parameters = { new SqlParameter("@ReadyCheckBookID", SqlDbType.Int, 8) }; parameters[0].Value = ReadyCheckBookID; DigiPower.Onlinecol.Standard.Model.T_ReadyCheckBook_MDL model = new DigiPower.Onlinecol.Standard.Model.T_ReadyCheckBook_MDL(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ReadyCheckBookID"].ToString() != "") { model.ReadyCheckBookID = int.Parse(ds.Tables[0].Rows[0]["ReadyCheckBookID"].ToString()); } if (ds.Tables[0].Rows[0]["SingleProjectID"].ToString() != "") { model.SingleProjectID = int.Parse(ds.Tables[0].Rows[0]["SingleProjectID"].ToString()); } model.CodeType = ds.Tables[0].Rows[0]["CodeType"].ToString(); model.ReadyCheckBookCode = ds.Tables[0].Rows[0]["ReadyCheckBookCode"].ToString(); if (ds.Tables[0].Rows[0]["BeginDate"].ToString() != "") { model.BeginDate = DateTime.Parse(ds.Tables[0].Rows[0]["BeginDate"].ToString()); } if (ds.Tables[0].Rows[0]["EndDate"].ToString() != "") { model.EndDate = DateTime.Parse(ds.Tables[0].Rows[0]["EndDate"].ToString()); } if (ds.Tables[0].Rows[0]["CreateUserID"].ToString() != "") { model.CreateUserID = int.Parse(ds.Tables[0].Rows[0]["CreateUserID"].ToString()); } if (ds.Tables[0].Rows[0]["CreateTime"].ToString() != "") { model.CreateTime = DateTime.Parse(ds.Tables[0].Rows[0]["CreateTime"].ToString()); } if (ds.Tables[0].Rows[0]["TOTAL_SCROLL"].ToString() != "") { model.TOTAL_SCROLL = int.Parse(ds.Tables[0].Rows[0]["TOTAL_SCROLL"].ToString()); } if (ds.Tables[0].Rows[0]["CHARACTER_SCROLL"].ToString() != "") { model.CHARACTER_SCROLL = int.Parse(ds.Tables[0].Rows[0]["CHARACTER_SCROLL"].ToString()); } if (ds.Tables[0].Rows[0]["PIC_SCROLL"].ToString() != "") { model.PIC_SCROLL = int.Parse(ds.Tables[0].Rows[0]["PIC_SCROLL"].ToString()); } if (ds.Tables[0].Rows[0]["PIC_PAGE_COUNT"].ToString() != "") { model.PIC_PAGE_COUNT = int.Parse(ds.Tables[0].Rows[0]["PIC_PAGE_COUNT"].ToString()); } if (ds.Tables[0].Rows[0]["PHOTO_COUNT"].ToString() != "") { model.PHOTO_COUNT = int.Parse(ds.Tables[0].Rows[0]["PHOTO_COUNT"].ToString()); } if (ds.Tables[0].Rows[0]["RADIO_COUNT"].ToString() != "") { model.RADIO_COUNT = int.Parse(ds.Tables[0].Rows[0]["RADIO_COUNT"].ToString()); } if (ds.Tables[0].Rows[0]["OTHER_MATERIAL"].ToString() != "") { model.OTHER_MATERIAL = ds.Tables[0].Rows[0]["OTHER_MATERIAL"].ToString(); } if (ds.Tables[0].Rows[0]["Directory_SCROLL"].ToString() != "") { model.Directory_SCROLL = int.Parse(ds.Tables[0].Rows[0]["Directory_SCROLL"].ToString()); } if (ds.Tables[0].Rows[0]["Directory_PAGE_COUNT"].ToString() != "") { model.Directory_PAGE_COUNT = int.Parse(ds.Tables[0].Rows[0]["Directory_PAGE_COUNT"].ToString()); } if (ds.Tables[0].Rows[0]["zljddw"].ToString() != "") { model.zljddw = ds.Tables[0].Rows[0]["zljddw"].ToString(); } if (ds.Tables[0].Rows[0]["ArchiveUserName"].ToString() != "") { model.ArchiveUserName = ds.Tables[0].Rows[0]["ArchiveUserName"].ToString(); } if (ds.Tables[0].Rows[0]["ArchiveUser_Tel"].ToString() != "") { model.ArchiveUser_Tel = ds.Tables[0].Rows[0]["ArchiveUser_Tel"].ToString(); } if (ds.Tables[0].Rows[0]["jsdwfzr_Name"].ToString() != "") { model.jsdwfzr_Name = ds.Tables[0].Rows[0]["jsdwfzr_Name"].ToString(); } if (ds.Tables[0].Rows[0]["jsdwfzr_Tel"].ToString() != "") { model.jsdwfzr_Tel = ds.Tables[0].Rows[0]["jsdwfzr_Tel"].ToString(); } if (ds.Tables[0].Rows[0]["cscd"].ToString() != "") { model.cscd = ds.Tables[0].Rows[0]["cscd"].ToString(); } return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(DigiPower.Onlinecol.Standard.Model.T_ReadyCheckBook_MDL model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_ReadyCheckBook("); strSql.Append("SingleProjectID,CodeType,ReadyCheckBookCode,BeginDate,EndDate,CreateUserID,CreateTime,"); strSql.Append("TOTAL_SCROLL,CHARACTER_SCROLL,PIC_SCROLL,PIC_PAGE_COUNT,PHOTO_COUNT,RADIO_COUNT,OTHER_MATERIAL,Directory_SCROLL,Directory_PAGE_COUNT,"); strSql.Append("zljddw,ArchiveUserName,ArchiveUser_Tel,jsdwfzr_Name,jsdwfzr_Tel,cscd) "); strSql.Append(" values ("); strSql.Append("@SingleProjectID,@CodeType,@ReadyCheckBookCode,@BeginDate,@EndDate,@CreateUserID,@CreateTime,"); strSql.Append("@TOTAL_SCROLL,@CHARACTER_SCROLL,@PIC_SCROLL,@PIC_PAGE_COUNT,@PHOTO_COUNT,@RADIO_COUNT,@OTHER_MATERIAL,@Directory_SCROLL,@Directory_PAGE_COUNT,"); strSql.Append("@zljddw,@ArchiveUserName,@ArchiveUser_Tel,@jsdwfzr_Name,@jsdwfzr_Tel,@cscd)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@SingleProjectID", SqlDbType.Int, 8), new SqlParameter("@CodeType", SqlDbType.NVarChar, 20), new SqlParameter("@ReadyCheckBookCode", SqlDbType.NVarChar, 50), new SqlParameter("@BeginDate", SqlDbType.DateTime), new SqlParameter("@EndDate", SqlDbType.DateTime), new SqlParameter("@CreateUserID", SqlDbType.Int, 8), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@TOTAL_SCROLL", SqlDbType.Int, 4), new SqlParameter("@CHARACTER_SCROLL", SqlDbType.Int, 4), new SqlParameter("@PIC_SCROLL", SqlDbType.Int, 4), new SqlParameter("@PIC_PAGE_COUNT", SqlDbType.Int, 4), new SqlParameter("@PHOTO_COUNT", SqlDbType.Int, 4), new SqlParameter("@RADIO_COUNT", SqlDbType.Int, 4), new SqlParameter("@OTHER_MATERIAL", SqlDbType.NVarChar, 200), new SqlParameter("@Directory_SCROLL", SqlDbType.Int, 4), new SqlParameter("@Directory_PAGE_COUNT", SqlDbType.Int, 4), new SqlParameter("@zljddw", SqlDbType.NVarChar, 100), new SqlParameter("@ArchiveUserName", SqlDbType.NVarChar, 50), new SqlParameter("@ArchiveUser_Tel", SqlDbType.NVarChar, 20), new SqlParameter("@jsdwfzr_Name", SqlDbType.NVarChar, 50), new SqlParameter("@jsdwfzr_Tel", SqlDbType.NVarChar, 20), new SqlParameter("@cscd", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.SingleProjectID; parameters[1].Value = model.CodeType; parameters[2].Value = model.ReadyCheckBookCode; parameters[3].Value = model.BeginDate; parameters[4].Value = model.EndDate; parameters[5].Value = model.CreateUserID; parameters[6].Value = model.CreateTime; parameters[7].Value = model.TOTAL_SCROLL; parameters[8].Value = model.CHARACTER_SCROLL; parameters[9].Value = model.PIC_SCROLL; parameters[10].Value = model.PIC_PAGE_COUNT; parameters[11].Value = model.PHOTO_COUNT; parameters[12].Value = model.RADIO_COUNT; parameters[13].Value = model.OTHER_MATERIAL; parameters[14].Value = model.Directory_SCROLL; parameters[15].Value = model.Directory_PAGE_COUNT; parameters[16].Value = model.zljddw; parameters[17].Value = model.ArchiveUserName; parameters[18].Value = model.ArchiveUser_Tel; parameters[19].Value = model.jsdwfzr_Name; parameters[20].Value = model.jsdwfzr_Tel; parameters[21].Value = model.cscd; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(DigiPower.Onlinecol.Standard.Model.T_ReadyCheckBook_MDL model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_ReadyCheckBook set "); strSql.Append("SingleProjectID=@SingleProjectID,"); strSql.Append("CodeType=@CodeType,"); strSql.Append("ReadyCheckBookCode=@ReadyCheckBookCode,"); strSql.Append("BeginDate=@BeginDate,"); strSql.Append("EndDate=@EndDate,"); strSql.Append("CreateUserID=@CreateUserID,"); strSql.Append("CreateTime=@CreateTime,"); strSql.Append("TOTAL_SCROLL=@TOTAL_SCROLL,"); strSql.Append("CHARACTER_SCROLL=@CHARACTER_SCROLL,"); strSql.Append("PIC_SCROLL=@PIC_SCROLL,"); strSql.Append("PIC_PAGE_COUNT=@PIC_PAGE_COUNT,"); strSql.Append("PHOTO_COUNT=@PHOTO_COUNT,"); strSql.Append("RADIO_COUNT=@RADIO_COUNT,"); strSql.Append("OTHER_MATERIAL=@OTHER_MATERIAL,"); strSql.Append("Directory_SCROLL=@Directory_SCROLL,"); strSql.Append("Directory_PAGE_COUNT=@Directory_PAGE_COUNT,"); strSql.Append("zljddw=@zljddw,"); strSql.Append("ArchiveUserName=@ArchiveUserName,"); strSql.Append("ArchiveUser_Tel=@ArchiveUser_Tel,"); strSql.Append("jsdwfzr_Name=@jsdwfzr_Name,"); strSql.Append("jsdwfzr_Tel=@jsdwfzr_Tel,"); strSql.Append("cscd = @cscd"); strSql.Append(" where ReadyCheckBookID=@ReadyCheckBookID "); SqlParameter[] parameters = { new SqlParameter("@ReadyCheckBookID", SqlDbType.Int, 8), new SqlParameter("@SingleProjectID", SqlDbType.Int, 8), new SqlParameter("@CodeType", SqlDbType.NVarChar, 20), new SqlParameter("@ReadyCheckBookCode", SqlDbType.NVarChar, 50), new SqlParameter("@BeginDate", SqlDbType.DateTime), new SqlParameter("@EndDate", SqlDbType.DateTime), new SqlParameter("@CreateUserID", SqlDbType.Int, 8), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@TOTAL_SCROLL", SqlDbType.Int, 4), new SqlParameter("@CHARACTER_SCROLL", SqlDbType.Int, 4), new SqlParameter("@PIC_SCROLL", SqlDbType.Int, 4), new SqlParameter("@PIC_PAGE_COUNT", SqlDbType.Int, 4), new SqlParameter("@PHOTO_COUNT", SqlDbType.Int, 4), new SqlParameter("@RADIO_COUNT", SqlDbType.Int, 4), new SqlParameter("@OTHER_MATERIAL", SqlDbType.NVarChar, 200), new SqlParameter("@Directory_SCROLL", SqlDbType.Int, 4), new SqlParameter("@Directory_PAGE_COUNT", SqlDbType.Int, 4), new SqlParameter("@zljddw", SqlDbType.NVarChar, 100), new SqlParameter("@ArchiveUserName", SqlDbType.NVarChar, 50), new SqlParameter("@ArchiveUser_Tel", SqlDbType.NVarChar, 20), new SqlParameter("@jsdwfzr_Name", SqlDbType.NVarChar, 50), new SqlParameter("@jsdwfzr_Tel", SqlDbType.NVarChar, 20), new SqlParameter("@cscd", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.ReadyCheckBookID; parameters[1].Value = model.SingleProjectID; parameters[2].Value = model.CodeType; parameters[3].Value = model.ReadyCheckBookCode; parameters[4].Value = model.BeginDate; parameters[5].Value = model.EndDate; parameters[6].Value = model.CreateUserID; parameters[7].Value = model.CreateTime; parameters[8].Value = model.TOTAL_SCROLL; parameters[9].Value = model.CHARACTER_SCROLL; parameters[10].Value = model.PIC_SCROLL; parameters[11].Value = model.PIC_PAGE_COUNT; parameters[12].Value = model.PHOTO_COUNT; parameters[13].Value = model.RADIO_COUNT; parameters[14].Value = model.OTHER_MATERIAL; parameters[15].Value = model.Directory_SCROLL; parameters[16].Value = model.Directory_PAGE_COUNT; parameters[17].Value = model.zljddw; parameters[18].Value = model.ArchiveUserName; parameters[19].Value = model.ArchiveUser_Tel; parameters[20].Value = model.jsdwfzr_Name; parameters[21].Value = model.jsdwfzr_Tel; parameters[22].Value = model.cscd; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }