public List <PreDeliveryRemaindful> GetPreDeliverySerialNumber(SheepParameter pm) { string sql = "SELECT s.\"SerialNumber\" FROM \"T_Mating\" M JOIN \"T_Sheep\" s ON s.\"Id\" = M .\"FemaleId\" WHERE \"IsRemindful\" = TRUE AND \"MatingDate\" <:minValue and s.\"Status\"=:status ORDER BY \"MatingDate\" DESC"; DateTime minValue = DateTime.Now.AddDays(0 - (Convert.ToInt32(pm.Value) - pm.Range + 1)); IDbParameters pms = AdoTemplate.CreateDbParameters(); pms.AddWithValue("minValue", minValue); pms.AddWithValue("status", (int)SheepStatusEnum.Nomal); return(GetData <PreDeliveryRemaindful>(sql, pms)); }
public List <PreDeliveryRemaindful> GetPreDeliveryRemaindful(SheepParameter pm) { string sql = "SELECT s.\"SerialNumber\", s.\"Origin\", b.\"Name\" AS \"Breed\", f.\"Name\" AS \"Sheepfold\" FROM \"T_Mating\" M JOIN \"T_Sheep\" s ON s.\"Id\" = M .\"FemaleId\" JOIN \"T_Breed\" b ON b.\"Id\" = s.\"BreedId\" JOIN \"T_Sheepfold\" f ON f.\"Id\" = s.\"SheepfoldId\" WHERE \"IsRemindful\" = TRUE AND \"MatingDate\" <:minValue and s.\"Status\"=:status ORDER BY \"MatingDate\" DESC"; //不生不堕胎就一直提醒,在AddMating时对前边所有的该母羊配种记录进行不提醒操作 // AND \"MatingDate\" <:maxValue //DateTime maxValue = DateTime.Now.AddDays(0 - (Convert.ToInt32(pm.Value) - pm.Range + 1)); DateTime minValue = DateTime.Now.AddDays(0 - (Convert.ToInt32(pm.Value) - pm.Range + 1)); IDbParameters pms = AdoTemplate.CreateDbParameters(); pms.AddWithValue("minValue", minValue); pms.AddWithValue("status", (int)SheepStatusEnum.Nomal); //pms.AddWithValue("maxValue", maxValue); return(GetData <PreDeliveryRemaindful>(sql, pms)); }