public int InsertWorkShift2WorkShop(WorkShift2WorkShop obj) { string sql = @"INSERT INTO[BE_WorkShift2WorkShop]([WorkShiftID] , [WorkShopID] ) VALUES(@WorkShiftID , @WorkShopID )" ; SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans); SqlParameter pWorkShiftID = new SqlParameter("WorkShiftID", Convert2DBnull(obj.WorkShiftID)); pWorkShiftID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pWorkShiftID); SqlParameter pWorkShopID = new SqlParameter("WorkShopID", Convert2DBnull(obj.WorkShopID)); pWorkShopID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pWorkShopID); return(cmd.ExecuteNonQuery()); }
public List <WorkShift2WorkShop> LoadWorkShift2WorkShopsByWorkShopID(Guid workShopID) { string sql = @"SELECT [WorkShiftID] , [WorkShopID] FROM [BE_WorkShift2WorkShop] WHERE [WorkShopID]=@WorkShopID" ; SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans); SqlParameter pWorkShopID = new SqlParameter("WorkShopID", workShopID); pWorkShopID.SqlDbType = SqlDbType.UniqueIdentifier; cmd.Parameters.Add(pWorkShopID); List <WorkShift2WorkShop> ret = new List <WorkShift2WorkShop>(); SqlDataReader dr = cmd.ExecuteReader(); try { while (dr.Read()) { WorkShift2WorkShop iret = new WorkShift2WorkShop(); if (!Convert.IsDBNull(dr["WorkShiftID"])) { iret.WorkShiftID = (Guid)dr["WorkShiftID"]; } if (!Convert.IsDBNull(dr["WorkShopID"])) { iret.WorkShopID = (Guid)dr["WorkShopID"]; } ret.Add(iret); } } finally { dr.Close(); } return(ret); }