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));
}
