public int InsertSpecialCompanent(SpecialCompanent obj) { string sql = @"INSERT INTO[BE_SpecialCompanent]([SpecialID] , [ItemName] , [IsDisabled] , [Created] , [CreatedBy] , [Modified] , [ModifiedBy] ) VALUES(@SpecialID , @ItemName , @IsDisabled , @Created , @CreatedBy , @Modified , @ModifiedBy )" ; SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans); SqlParameter pSpecialID = new SqlParameter("SpecialID", Convert2DBnull(obj.SpecialID)); pSpecialID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pSpecialID); SqlParameter pItemName = new SqlParameter("ItemName", Convert2DBnull(obj.ItemName)); pItemName.SqlDbType = SqlDbType.NVarChar; cmd.Parameters.Add(pItemName); SqlParameter pIsDisabled = new SqlParameter("IsDisabled", Convert2DBnull(obj.IsDisabled)); pIsDisabled.SqlDbType = SqlDbType.Bit; cmd.Parameters.Add(pIsDisabled); SqlParameter pCreated = new SqlParameter("Created", Convert2DBnull(obj.Created)); pCreated.SqlDbType = SqlDbType.DateTime; cmd.Parameters.Add(pCreated); SqlParameter pCreatedBy = new SqlParameter("CreatedBy", Convert2DBnull(obj.CreatedBy)); pCreatedBy.SqlDbType = SqlDbType.NVarChar; cmd.Parameters.Add(pCreatedBy); SqlParameter pModified = new SqlParameter("Modified", Convert2DBnull(obj.Modified)); pModified.SqlDbType = SqlDbType.DateTime; cmd.Parameters.Add(pModified); SqlParameter pModifiedBy = new SqlParameter("ModifiedBy", Convert2DBnull(obj.ModifiedBy)); pModifiedBy.SqlDbType = SqlDbType.NVarChar; cmd.Parameters.Add(pModifiedBy); return(cmd.ExecuteNonQuery()); }
public List <SpecialCompanent> LoadSpecialCompanentsByModifiedBy(string modifiedBy) { string sql = @"SELECT [SpecialID] , [ItemName] , [IsDisabled] , [Created] , [CreatedBy] , [Modified] , [ModifiedBy] FROM [BE_SpecialCompanent] WHERE [ModifiedBy]=@ModifiedBy" ; SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans); SqlParameter pModifiedBy = new SqlParameter("ModifiedBy", modifiedBy); pModifiedBy.SqlDbType = SqlDbType.NVarChar; cmd.Parameters.Add(pModifiedBy); List <SpecialCompanent> ret = new List <SpecialCompanent>(); SqlDataReader dr = cmd.ExecuteReader(); try { while (dr.Read()) { SpecialCompanent iret = new SpecialCompanent(); if (!Convert.IsDBNull(dr["SpecialID"])) { iret.SpecialID = (Guid)dr["SpecialID"]; } iret.ItemName = dr["ItemName"].ToString(); if (!Convert.IsDBNull(dr["IsDisabled"])) { iret.IsDisabled = (bool)dr["IsDisabled"]; } if (!Convert.IsDBNull(dr["Created"])) { iret.Created = (DateTime)dr["Created"]; } iret.CreatedBy = dr["CreatedBy"].ToString(); if (!Convert.IsDBNull(dr["Modified"])) { iret.Modified = (DateTime)dr["Modified"]; } iret.ModifiedBy = dr["ModifiedBy"].ToString(); ret.Add(iret); } } finally { dr.Close(); } return(ret); }
public int LoadSpecialCompanentBySpecialID(SpecialCompanent obj) { string sql = @"SELECT [SpecialID] , [ItemName] , [IsDisabled] , [Created] , [CreatedBy] , [Modified] , [ModifiedBy] FROM [BE_SpecialCompanent] WITH(NOLOCK) WHERE [SpecialID]=@SpecialID" ; SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans); SqlParameter pSpecialID = new SqlParameter("SpecialID", Convert2DBnull(obj.SpecialID)); pSpecialID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pSpecialID); int ret = 0; SqlDataReader dr = cmd.ExecuteReader(); try { while (dr.Read()) { if (!Convert.IsDBNull(dr["SpecialID"])) { obj.SpecialID = (Guid)dr["SpecialID"]; } obj.ItemName = dr["ItemName"].ToString(); if (!Convert.IsDBNull(dr["IsDisabled"])) { obj.IsDisabled = (bool)dr["IsDisabled"]; } if (!Convert.IsDBNull(dr["Created"])) { obj.Created = (DateTime)dr["Created"]; } obj.CreatedBy = dr["CreatedBy"].ToString(); if (!Convert.IsDBNull(dr["Modified"])) { obj.Modified = (DateTime)dr["Modified"]; } obj.ModifiedBy = dr["ModifiedBy"].ToString(); ret += 1; } } finally { dr.Close(); } return(ret); }
public int UpdateSpecialCompanentBySpecialID(SpecialCompanent obj) { string sql = @"UPDATE [BE_SpecialCompanent] SET [ItemName]=@ItemName , [IsDisabled]=@IsDisabled , [Created]=@Created , [CreatedBy]=@CreatedBy , [Modified]=@Modified , [ModifiedBy]=@ModifiedBy WHERE [SpecialID]=@SpecialID" ; SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans); SqlParameter pItemName = new SqlParameter("ItemName", Convert2DBnull(obj.ItemName)); pItemName.SqlDbType = SqlDbType.NVarChar; cmd.Parameters.Add(pItemName); SqlParameter pIsDisabled = new SqlParameter("IsDisabled", Convert2DBnull(obj.IsDisabled)); pIsDisabled.SqlDbType = SqlDbType.Bit; cmd.Parameters.Add(pIsDisabled); SqlParameter pCreated = new SqlParameter("Created", Convert2DBnull(obj.Created)); pCreated.SqlDbType = SqlDbType.DateTime; cmd.Parameters.Add(pCreated); SqlParameter pCreatedBy = new SqlParameter("CreatedBy", Convert2DBnull(obj.CreatedBy)); pCreatedBy.SqlDbType = SqlDbType.NVarChar; cmd.Parameters.Add(pCreatedBy); SqlParameter pModified = new SqlParameter("Modified", Convert2DBnull(obj.Modified)); pModified.SqlDbType = SqlDbType.DateTime; cmd.Parameters.Add(pModified); SqlParameter pModifiedBy = new SqlParameter("ModifiedBy", Convert2DBnull(obj.ModifiedBy)); pModifiedBy.SqlDbType = SqlDbType.NVarChar; cmd.Parameters.Add(pModifiedBy); SqlParameter pSpecialID = new SqlParameter("SpecialID", Convert2DBnull(obj.SpecialID)); pSpecialID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pSpecialID); return(cmd.ExecuteNonQuery()); }