public int Add(AnnexListModel model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into XPM_Basic_AnnexList("); builder.Append("AnnexCode,ModuleID,RecordCode,AnnexType,FileCode,AnnexName,OriginalName,FilePath,FileSize,AddDate,State,HumanCode,Remark,ProjectUniqueCode)"); builder.Append(" values ("); builder.Append("@AnnexCode,@ModuleID,@RecordCode,@AnnexType,@FileCode,@AnnexName,@OriginalName,@FilePath,@FileSize,@AddDate,@State,@HumanCode,@Remark,@ProjectUniqueCode)"); SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@AnnexCode", SqlDbType.UniqueIdentifier, 0x10), new SqlParameter("@ModuleID", SqlDbType.Int, 4), new SqlParameter("@RecordCode", SqlDbType.NVarChar, 0x24), new SqlParameter("@AnnexType", SqlDbType.Int, 4), new SqlParameter("@FileCode", SqlDbType.NVarChar, 50), new SqlParameter("@AnnexName", SqlDbType.NVarChar, 80), new SqlParameter("@OriginalName", SqlDbType.NVarChar, 100), new SqlParameter("@FilePath", SqlDbType.NVarChar, 100), new SqlParameter("@FileSize", SqlDbType.Int, 4), new SqlParameter("@AddDate", SqlDbType.DateTime), new SqlParameter("@State", SqlDbType.Int, 4), new SqlParameter("@HumanCode", SqlDbType.VarChar, 10), new SqlParameter("@Remark", SqlDbType.VarChar, 200), new SqlParameter("@ProjectUniqueCode", SqlDbType.VarChar, 50) }; commandParameters[0].Value = model.AnnexCode; commandParameters[1].Value = model.ModuleID; commandParameters[2].Value = model.RecordCode; commandParameters[3].Value = model.AnnexType; commandParameters[4].Value = model.FileCode; commandParameters[5].Value = model.AnnexName; commandParameters[6].Value = model.OriginalName; commandParameters[7].Value = model.FilePath; commandParameters[8].Value = model.FileSize; commandParameters[9].Value = model.AddDate; commandParameters[10].Value = model.State; commandParameters[11].Value = model.HumanCode; commandParameters[12].Value = model.Remark; commandParameters[13].Value = model.ProjectUniqueCode; return(publicDbOpClass.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters)); }
public AnnexListModel GetModel(Guid AnnexCode) { StringBuilder builder = new StringBuilder(); builder.Append("select AnnexCode,ModuleID,RecordCode,AnnexType,FileCode,AnnexName,OriginalName,FilePath,FileSize,AddDate,State,HumanCode,Remark,ProjectUniqueCode from XPM_Basic_AnnexList "); builder.Append(" where AnnexCode=@AnnexCode "); AnnexListModel model = null; using (IDataReader reader = publicDbOpClass.ExecuteReader(CommandType.Text, builder.ToString(), new SqlParameter[] { new SqlParameter("@AnnexCode", AnnexCode) })) { if (reader.Read()) { model = this.ReaderBind(reader); } } return(model); }
public AnnexListModel ReaderBind(IDataReader dataReader) { AnnexListModel model = new AnnexListModel(); object obj2 = dataReader["AnnexCode"]; if ((obj2 != null) && (obj2 != DBNull.Value)) { model.AnnexCode = new Guid(obj2.ToString()); } obj2 = dataReader["ModuleID"]; if ((obj2 != null) && (obj2 != DBNull.Value)) { model.ModuleID = (int)obj2; } model.RecordCode = dataReader["RecordCode"].ToString(); obj2 = dataReader["AnnexType"]; if ((obj2 != null) && (obj2 != DBNull.Value)) { model.AnnexType = (int)obj2; } model.FileCode = dataReader["FileCode"].ToString(); model.AnnexName = dataReader["AnnexName"].ToString(); model.OriginalName = dataReader["OriginalName"].ToString(); model.FilePath = dataReader["FilePath"].ToString(); obj2 = dataReader["FileSize"]; if ((obj2 != null) && (obj2 != DBNull.Value)) { model.FileSize = (int)obj2; } obj2 = dataReader["AddDate"]; if ((obj2 != null) && (obj2 != DBNull.Value)) { model.AddDate = (DateTime)obj2; } obj2 = dataReader["State"]; if ((obj2 != null) && (obj2 != DBNull.Value)) { model.State = (int)obj2; } model.HumanCode = dataReader["HumanCode"].ToString(); model.Remark = dataReader["Remark"].ToString(); model.ProjectUniqueCode = dataReader["ProjectUniqueCode"].ToString(); return(model); }
public int Update(AnnexListModel model) { StringBuilder builder = new StringBuilder(); builder.Append("update XPM_Basic_AnnexList set "); builder.Append("ModuleID=@ModuleID,"); builder.Append("RecordCode=@RecordCode,"); builder.Append("AnnexType=@AnnexType,"); builder.Append("FileCode=@FileCode,"); builder.Append("AnnexName=@AnnexName,"); builder.Append("OriginalName=@OriginalName,"); builder.Append("FilePath=@FilePath,"); builder.Append("FileSize=@FileSize,"); builder.Append("AddDate=@AddDate,"); builder.Append("State=@State,"); builder.Append("HumanCode=@HumanCode,"); builder.Append("Remark=@Remark,"); builder.Append("ProjectUniqueCode=@ProjectUniqueCode"); builder.Append(" where AnnexCode=@AnnexCode "); SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@AnnexCode", SqlDbType.UniqueIdentifier, 0x10), new SqlParameter("@ModuleID", SqlDbType.Int, 4), new SqlParameter("@RecordCode", SqlDbType.NVarChar, 0x24), new SqlParameter("@AnnexType", SqlDbType.Int, 4), new SqlParameter("@FileCode", SqlDbType.NVarChar, 50), new SqlParameter("@AnnexName", SqlDbType.NVarChar, 80), new SqlParameter("@OriginalName", SqlDbType.NVarChar, 100), new SqlParameter("@FilePath", SqlDbType.NVarChar, 100), new SqlParameter("@FileSize", SqlDbType.Int, 4), new SqlParameter("@AddDate", SqlDbType.DateTime), new SqlParameter("@State", SqlDbType.Int, 4), new SqlParameter("@HumanCode", SqlDbType.VarChar, 10), new SqlParameter("@Remark", SqlDbType.VarChar, 200), new SqlParameter("@ProjectUniqueCode", SqlDbType.VarChar, 50) }; commandParameters[0].Value = model.AnnexCode; commandParameters[1].Value = model.ModuleID; commandParameters[2].Value = model.RecordCode; commandParameters[3].Value = model.AnnexType; commandParameters[4].Value = model.FileCode; commandParameters[5].Value = model.AnnexName; commandParameters[6].Value = model.OriginalName; commandParameters[7].Value = model.FilePath; commandParameters[8].Value = model.FileSize; commandParameters[9].Value = model.AddDate; commandParameters[10].Value = model.State; commandParameters[11].Value = model.HumanCode; commandParameters[12].Value = model.Remark; commandParameters[13].Value = model.ProjectUniqueCode; return(publicDbOpClass.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters)); }
public int Add(AnnexListModel model) { return(this.annexList.Add(model)); }
public int Update(AnnexListModel model) { return(this.annexList.Update(model)); }