public List <OrderStep> LoadOrderSteps() { string sql = @"Select [StepID] ,[PrivilegeID] ,[StepNo] ,[StepName] ,[StepCode] ,[Created] ,[CreatedBy] From [BE_OrderStep] With(NoLock)"; SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans); List <OrderStep> ret = new List <OrderStep>(); SqlDataReader dr = cmd.ExecuteReader(); try { while (dr.Read()) { OrderStep iret = new OrderStep(); if (!Convert.IsDBNull(dr["StepID"])) { iret.StepID = (Guid)dr["StepID"]; } if (!Convert.IsDBNull(dr["PrivilegeID"])) { iret.PrivilegeID = (Guid)dr["PrivilegeID"]; } if (!Convert.IsDBNull(dr["StepNo"])) { iret.StepNo = (int)dr["StepNo"]; } if (!Convert.IsDBNull(dr["StepName"])) { iret.StepName = (string)dr["StepName"]; } if (!Convert.IsDBNull(dr["StepCode"])) { iret.StepCode = (string)dr["StepCode"]; } if (!Convert.IsDBNull(dr["Created"])) { iret.Created = (DateTime)dr["Created"]; } if (!Convert.IsDBNull(dr["CreatedBy"])) { iret.CreatedBy = (string)dr["CreatedBy"]; } ret.Add(iret); } } finally { dr.Close(); } return(ret); }
public int InsertOrderStep(OrderStep obj) { string sql = @"Insert Into [BE_OrderStep]( [StepID] ,[PrivilegeID] ,[StepNo] ,[StepName] ,[StepCode] ,[Created] ,[CreatedBy] )Values ( @StepID ,@PrivilegeID ,@StepNo ,@StepName ,@StepCode ,@Created ,@CreatedBy )"; SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans); SqlParameter pStepID = new SqlParameter("StepID", Convert2DBnull(obj.StepID)); pStepID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pStepID); SqlParameter pPrivilegeID = new SqlParameter("PrivilegeID", Convert2DBnull(obj.PrivilegeID)); pPrivilegeID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pPrivilegeID); SqlParameter pStepNo = new SqlParameter("StepNo", Convert2DBnull(obj.StepNo)); pStepNo.SqlDbType = SqlDbType.Int; cmd.Parameters.Add(pStepNo); SqlParameter pStepName = new SqlParameter("StepName", Convert2DBnull(obj.StepName)); pStepName.SqlDbType = SqlDbType.NVarChar; cmd.Parameters.Add(pStepName); SqlParameter pStepCode = new SqlParameter("StepCode", Convert2DBnull(obj.StepCode)); pStepCode.SqlDbType = SqlDbType.NVarChar; cmd.Parameters.Add(pStepCode); SqlParameter pCreated = new SqlParameter("Created", Convert2DBnull(obj.Created)); pCreated.SqlDbType = SqlDbType.SmallDateTime; cmd.Parameters.Add(pCreated); SqlParameter pCreatedBy = new SqlParameter("CreatedBy", Convert2DBnull(obj.CreatedBy)); pCreatedBy.SqlDbType = SqlDbType.NVarChar; cmd.Parameters.Add(pCreatedBy); return(cmd.ExecuteNonQuery()); }
public int UpdateOrderStepByStepID(OrderStep obj) { string sql = @"Update [BE_OrderStep] Set [PrivilegeID]=@PrivilegeID ,[StepNo]=@StepNo ,[StepName]=@StepName ,[StepCode]=@StepCode ,[Created]=@Created ,[CreatedBy]=@CreatedBy Where StepID=@StepID"; SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans); SqlParameter pStepID = new SqlParameter("StepID", Convert2DBnull(obj.StepID)); pStepID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pStepID); SqlParameter pPrivilegeID = new SqlParameter("PrivilegeID", Convert2DBnull(obj.PrivilegeID)); pPrivilegeID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pPrivilegeID); SqlParameter pStepNo = new SqlParameter("StepNo", Convert2DBnull(obj.StepNo)); pStepNo.SqlDbType = SqlDbType.Int; cmd.Parameters.Add(pStepNo); SqlParameter pStepName = new SqlParameter("StepName", Convert2DBnull(obj.StepName)); pStepName.SqlDbType = SqlDbType.NVarChar; cmd.Parameters.Add(pStepName); SqlParameter pStepCode = new SqlParameter("StepCode", Convert2DBnull(obj.StepCode)); pStepCode.SqlDbType = SqlDbType.NVarChar; cmd.Parameters.Add(pStepCode); SqlParameter pCreated = new SqlParameter("Created", Convert2DBnull(obj.Created)); pCreated.SqlDbType = SqlDbType.SmallDateTime; cmd.Parameters.Add(pCreated); SqlParameter pCreatedBy = new SqlParameter("CreatedBy", Convert2DBnull(obj.CreatedBy)); pCreatedBy.SqlDbType = SqlDbType.NVarChar; cmd.Parameters.Add(pCreatedBy); return(cmd.ExecuteNonQuery()); }
public int LoadOrderStepByPrivilegeID(OrderStep obj) { string sql = @"Select [StepID] ,[PrivilegeID] ,[StepNo] ,[StepName] ,[StepCode] ,[Created] ,[CreatedBy] From [BE_OrderStep] With(NoLock) Where PrivilegeID=@PrivilegeID"; SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans); SqlParameter pPrivilegeID = new SqlParameter("PrivilegeID", Convert2DBnull(obj.PrivilegeID)); pPrivilegeID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pPrivilegeID); int ret = 0; SqlDataReader dr = cmd.ExecuteReader(); try { while (dr.Read()) { if (!Convert.IsDBNull(dr["StepID"])) { obj.StepID = (Guid)dr["StepID"]; } if (!Convert.IsDBNull(dr["PrivilegeID"])) { obj.PrivilegeID = (Guid)dr["PrivilegeID"]; } if (!Convert.IsDBNull(dr["StepNo"])) { obj.StepNo = (int)dr["StepNo"]; } if (!Convert.IsDBNull(dr["StepName"])) { obj.StepName = (string)dr["StepName"]; } if (!Convert.IsDBNull(dr["StepCode"])) { obj.StepCode = (string)dr["StepCode"]; } if (!Convert.IsDBNull(dr["Created"])) { obj.Created = (DateTime)dr["Created"]; } if (!Convert.IsDBNull(dr["CreatedBy"])) { obj.CreatedBy = (string)dr["CreatedBy"]; } ret += 1; } } finally { dr.Close(); } return(ret); }