public void InitUser()
{
List <YbUsers> users = new YbUsers_BLL().GetList(a => a.YBUserName != "集体").ToList();
foreach (YbUsers user in users)
{
ListItem li = new ListItem()
{
Text = user.YBUserName,
Value = user.YBUserID.ToString()
};
DropDownList_YbUser.Items.Add(li);
}
}
public void InitYBUser()
{
YbUsers_BLL bll = new YbUsers_BLL();
List <YbUsers> ulist = bll.GetList(a => a.Work == "预报").OrderBy(a => a.Order).ToList();
ListItem allli = new ListItem()
{
Text = "全部", Value = "全部", Selected = true
};
DropDownList_YBUser.Items.Add(allli);
foreach (var item in ulist)
{
ListItem li = new ListItem()
{
Text = item.YBUserName, Value = item.YBUserName
};
DropDownList_YBUser.Items.Add(li);
}
}
public void BaoWen_Import()
{
BaoWens_BLL bll = new BaoWens_BLL();
YbUsers_BLL ubll = new YbUsers_BLL();
var shijiandir = FileHelper.GetShareLastDirectory(@"\\172.18.226.48\新城镇报", "20*", "administrator", "ybk");
string path = @"\\172.18.226.48\新城镇报\" + shijiandir.Name + @"\早上6点00前";
// var shijiandir = "201702";
//string path = @"\\172.18.226.48\新城镇报\" + shijiandir + @"\早上6点00前";
List <FileInfo> allFileList = FileHelper.GetShareFileInfos(path, "Z_SEVP_C_BEQD_*16812*", "administrator", "ybk");
//List<FileInfo> nearFileList = allFileList.Where(a => a.CreationTime >= DateTime.Now.AddDays(-7)).ToList();
List <FileInfo> nearFileList = allFileList;
int total = 0;
foreach (FileInfo fileInfo in nearFileList)
{
string fileName = path + @"\" + fileInfo.Name;
if (bll.GetCount(a => a.FileName == fileName) <= 0)
{
if (!fileInfo.Name.Contains("-16812_."))
{
Models.SQL.BaoWens baowen = new Models.SQL.BaoWens();
baowen.BWID = Guid.NewGuid();
baowen.BWType = "早间报文";
baowen.CreateTime = DateTime.Now;
baowen.YBDateTime =
DateTime.ParseExact(fileInfo.Name.Substring(14, 12), "yyyyMMddHHmm",
CultureInfo.InvariantCulture).AddHours(8);
//int leftcount = fileInfo.Name.Length - fileInfo.Name.IndexOf("-16812");
string fileNameUpper = fileInfo.Name.ToUpper();
if (fileNameUpper.Contains("-16812_") && !fileNameUpper.Contains("-16812_."))
{
baowen.YBUserName = fileNameUpper.Substring(fileNameUpper.IndexOf("-16812_") + 7,
fileNameUpper.Length - fileNameUpper.IndexOf("-16812_") - 7 - 4);
}
else
{
baowen.YBUserName = "******";
}
YbUsers user = ubll.Get(a => a.YBUserName == baowen.YBUserName && a.Work == "预报");
if (user == null)
{
int order = (int)ubll.GetList(a => a.Work == "预报").Max(a => a.Order) + 1;
YbUsers newuser = new YbUsers
{
YBUserID = Guid.NewGuid(),
YBUserName = baowen.YBUserName,
Work = "预报",
Position = "预报员",
CreateTime = DateTime.Now,
Order = order
};
baowen.YBUserID = newuser.YBUserID;
ubll.Add(newuser);
}
else
{
baowen.YBUserID = user.YBUserID;
}
baowen.Content =
FileHelper.GetShareTextContent(path + @"\" + fileInfo.Name, "administrator", "ybk", Encoding.Default);
baowen.FileName = path + @"\" + fileInfo.Name;
baowen.IsTranslate = false;
bll.Add(baowen);
total++;
}
}
}
Console.WriteLine(shijiandir.Name);
//Console.WriteLine(shijiandir);
Console.WriteLine("早间报文导入成功，总数：" + total);
}
public void Calculate()
{
Score_Day_BLL dayBll = new Score_Day_BLL();
DateTime startTime = DateTime.Parse(DropDownList_Year.SelectedItem.Value + "-" + DropDownList_Month.SelectedItem.Value + "-01");
DateTime endTime = startTime.AddMonths(1).AddDays(-1);
List <Score_Day> dayList = dayBll.GetList(a => a.YBDate >= startTime && a.YBDate <= endTime && a.YBUserName != "集体").OrderBy(a => a.YBDate).ToList();
List <Score_Day> dayList_Group = dayBll.GetList(a => a.YBDate >= startTime && a.YBDate <= endTime && a.YBUserName == "集体").OrderBy(a => a.YBDate).ToList();
List <Score_Month> list = new List <Score_Month>();
foreach (var day in dayList)
{
var day_group = dayList_Group.Where(a => a.YBDate == day.YBDate && a.YBTime == day.YBTime).FirstOrDefault();
double Ts晴雨 = Math.Round(((double)day.RainShine24 / (double)day.AllTotal * 10 / 24 + (double)day.RainShine48 / (double)day.AllTotal * 8 / 24 + (double)day.RainShine72 / (double)day.AllTotal * 6 / 24) * 100, 2);
double Ts晴雨_集体 = Math.Round(((double)day_group.RainShine24 / (double)day_group.AllTotal * 10 / 24 + (double)day_group.RainShine48 / (double)day_group.AllTotal * 8 / 24 + (double)day_group.RainShine72 / (double)day_group.AllTotal * 6 / 24) * 100, 2);
double Ts高温 = Math.Round(((double)day.MaxTemp24 / (double)day.AllTotal * 10 / 24 + (double)day.MaxTemp48 / (double)day.AllTotal * 8 / 24 + (double)day.MaxTemp72 / (double)day.AllTotal * 6 / 24) * 100, 2);
double Ts高温_集体 = Math.Round(((double)day_group.MaxTemp24 / (double)day_group.AllTotal * 10 / 24 + (double)day_group.MaxTemp48 / (double)day_group.AllTotal * 8 / 24 + (double)day_group.MaxTemp72 / (double)day_group.AllTotal * 6 / 24) * 100, 2);
double Ts低温 = Math.Round(((double)day.MinTemp24 / (double)day.AllTotal * 10 / 24 + (double)day.MinTemp48 / (double)day.AllTotal * 8 / 24 + (double)day.MinTemp72 / (double)day.AllTotal * 6 / 24) * 100, 2);
double Ts低温_集体 = Math.Round(((double)day_group.MinTemp24 / (double)day_group.AllTotal * 10 / 24 + (double)day_group.MinTemp48 / (double)day_group.AllTotal * 8 / 24 + (double)day_group.MinTemp72 / (double)day_group.AllTotal * 6 / 24) * 100, 2);
//个人降水
double rainfall24 = 100;
if (day.Rainfall24 != null && day.Rainfall24Total != null)
{
rainfall24 = (double)day.Rainfall24 / (double)day.Rainfall24Total * 100;
}
double rainfall48 = 100;
if (day.Rainfall48 != null && day.Rainfall48Total != null)
{
rainfall48 = (double)day.Rainfall48 / (double)day.Rainfall48Total * 100;
}
double rainfall72 = 100;
if (day.Rainfall72 != null && day.Rainfall72Total != null)
{
rainfall72 = (double)day.Rainfall72 / (double)day.Rainfall72Total * 100;
}
double Ts降水 = Math.Round(rainfall24 * 10 / 24 + rainfall48 * 8 / 24 + rainfall72 * 6 / 24, 2);
if (day.Rainfall24 == null && day.Rainfall48 == null && day.Rainfall72 == null)
{
Ts降水 = 0.00;
}
//集体降水
double rainfall24_group = 100;
if (day_group.Rainfall24 != null && day_group.Rainfall24Total != null)
{
rainfall24_group = (double)day_group.Rainfall24 / (double)day_group.Rainfall24Total * 100;
}
double rainfall48_group = 100;
if (day_group.Rainfall48 != null && day_group.Rainfall48Total != null)
{
rainfall48_group = (double)day_group.Rainfall48 / (double)day_group.Rainfall48Total * 100;
}
double rainfall72_group = 100;
if (day_group.Rainfall72 != null && day_group.Rainfall72Total != null)
{
rainfall72_group = (double)day_group.Rainfall72 / (double)day_group.Rainfall72Total * 100;
}
double Ts降水_集体 = Math.Round(rainfall24_group * 10 / 24 + rainfall48_group * 8 / 24 + rainfall72_group * 6 / 24, 2);
if (day_group.Rainfall24 == null && day_group.Rainfall48 == null && day_group.Rainfall72 == null)
{
Ts降水_集体 = 0.00;
}
//个人暴雨
double rainstorm24 = 100;
if (day.Rainstorm24 != null && day.Rainstorm24Total != null)
{
rainstorm24 = (double)day.Rainstorm24 / (double)day.Rainstorm24Total * 100;
}
double rainstorm48 = 100;
if (day.Rainstorm48 != null && day.Rainstorm48Total != null)
{
rainstorm48 = (double)day.Rainstorm48 / (double)day.Rainstorm48Total * 100;
}
double Ts暴雨 = Math.Round(rainstorm24 * 10 / 18 + rainstorm48 * 8 / 18, 2);
if (day.Rainstorm24 == null && day.Rainfall48 == null && day.Rainfall72 == null)
{
Ts暴雨 = 0.00;
}
//集体暴雨
double rainstorm24_group = 100;
if (day_group.Rainstorm24 != null && day_group.Rainstorm24Total != null)
{
rainstorm24_group = (double)day_group.Rainstorm24 / (double)day_group.Rainstorm24Total * 100;
}
double rainstorm48_group = 100;
if (day_group.Rainstorm48 != null && day_group.Rainstorm48Total != null)
{
rainstorm48_group = (double)day_group.Rainstorm48 / (double)day_group.Rainstorm48Total * 100;
}
double Ts暴雨_集体 = Math.Round(rainstorm24_group * 10 / 18 + rainstorm48_group * 8 / 18, 2);
if (day_group.Rainstorm24 == null && day_group.Rainfall48 == null && day_group.Rainfall72 == null)
{
Ts暴雨_集体 = 0.00;
}
double Ts总分 = Math.Round(Ts晴雨 * 30 / 100 + Ts降水 * 30 / 100 + Ts高温 * 20 / 100 + Ts低温 * 20 / 100, 2);
double Ts总分_集体 = Math.Round(Ts晴雨_集体 * 30 / 100 + Ts降水_集体 * 30 / 100 + Ts高温_集体 * 20 / 100 + Ts低温_集体 * 20 / 100, 2);
double Ts加权总分 = Ts总分_集体 * 60 / 100 + Ts总分 * 40 / 100;
Score_Month month = new Score_Month();
month.YBUserName = day.YBUserName;
month.YBUserID = day.YBUserID;
month.RainShine = decimal.Parse(Ts晴雨.ToString());
month.RainShine_Group = decimal.Parse(Ts晴雨_集体.ToString());
month.MinTemp = decimal.Parse(Ts低温.ToString());
month.MinTemp_Group = decimal.Parse(Ts低温_集体.ToString());
month.MaxTemp = decimal.Parse(Ts高温.ToString());
month.MaxTemp_Group = decimal.Parse(Ts高温_集体.ToString());
month.Rainfall = decimal.Parse(Ts降水.ToString());
month.Rainfall_Group = decimal.Parse(Ts降水_集体.ToString());
month.Rainstorm = decimal.Parse(Ts暴雨.ToString());
month.Rainstorm_Group = decimal.Parse(Ts暴雨_集体.ToString());
month.Total = decimal.Parse(Ts总分.ToString());
month.Total_Group = decimal.Parse(Ts总分_集体.ToString());
month.WeightedTotal = decimal.Parse(Ts加权总分.ToString());
list.Add(month);
//if (day.YBUserName == "毕玮")
//{
// Response.Write( day.YBDate.ToString()+"："+month.Rainfall + "<br/>");
//}
}
List <Score_Month> vlist = list.GroupBy(a => new { a.YBUserName }).Select(g => new Score_Month
{
YBUserName = g.Key.YBUserName,
RainShine = g.Average(a => a.RainShine),
RainShine_Group = g.Average(a => a.RainShine_Group),
MinTemp = g.Average(a => a.MinTemp),
MinTemp_Group = g.Average(a => a.MinTemp_Group),
MaxTemp = g.Average(a => a.MaxTemp),
MaxTemp_Group = g.Average(a => a.MaxTemp_Group),
Rainfall = g.Average(a => a.Rainfall),
Rainfall_Group = g.Average(a => a.Rainfall_Group),
Rainstorm = g.Average(a => a.Rainstorm),
Rainstorm_Group = g.Average(a => a.Rainstorm_Group),
Total = g.Average(a => a.Total),
Total_Group = g.Average(a => a.Total_Group),
WeightedTotal = g.Average(a => a.WeightedTotal)
}).ToList();
List <YbUsers> ulist = new YbUsers_BLL().GetList(a => a.Work == "预报").ToList();
Score_Month_BLL bll = new Score_Month_BLL();
foreach (var item in vlist)
{
item.ScoreID = Guid.NewGuid();
item.Year = int.Parse(DropDownList_Year.SelectedItem.Value);
item.Month = int.Parse(DropDownList_Month.SelectedItem.Value);
item.YBUserID = ulist.Where(a => a.YBUserName == item.YBUserName).FirstOrDefault().YBUserID;
bll.Add(item, false);
}
if (vlist.Count() > 0)
{
int Year = int.Parse(DropDownList_Year.SelectedItem.Value);
int Month = int.Parse(DropDownList_Month.SelectedItem.Value);
bll.Delete(a => a.Year == Year && a.Month == Month);
bll.SaveChange();
}
BindData();
Response.Write("<script language=javascript defer>alert('计算成功！');</script>");
}
protected void RepeaterScheduling_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
YbUsers_BLL ubll = new YbUsers_BLL();
List <PF.Models.SQL.YbUsers> users = ubll.GetList().ToList();
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
//找到分类Repeater关联的数据项
Day_Scheduling_ViewModel dsv = (Day_Scheduling_ViewModel)e.Item.DataItem;
Label Label_ShouXi = (Label)e.Item.FindControl("Label_ShouXi");
Label Label_LingBan = (Label)e.Item.FindControl("Label_LingBan");
Label Label_ZhiBan = (Label)e.Item.FindControl("Label_ZhiBan");
Label Label_LianXian = (Label)e.Item.FindControl("Label_LianXian");
HiddenField hid = (HiddenField)e.Item.FindControl("HiddenField_DayTime");
DateTime dt = DateTime.Parse(hid.Value);
PF.Models.SQL.Scheduling shouxi = sclist.Where(a => a.Date == dt && a.Work == "首席").FirstOrDefault();
if (shouxi != null)
{
Label_ShouXi.Text = shouxi.YBUserName;
}
else
{
Label_ShouXi.Text = string.Empty;
}
PF.Models.SQL.Scheduling lingban = sclist.Where(a => a.Date == dt && a.Work == "领班").FirstOrDefault();
if (lingban != null)
{
Label_LingBan.Text = lingban.YBUserName;
}
else
{
Label_LingBan.Text = string.Empty;
}
PF.Models.SQL.Scheduling zhiban = sclist.Where(a => a.Date == dt && a.Work == "值班").FirstOrDefault();
if (zhiban != null)
{
Label_ZhiBan.Text = zhiban.YBUserName;
}
else
{
Label_LingBan.Text = string.Empty;
}
PF.Models.SQL.Scheduling lianxian = sclist.Where(a => a.Date == dt && a.Work == "连线").FirstOrDefault();
if (lianxian != null)
{
Label_LianXian.Text = lianxian.YBUserName;
}
else
{
Label_LianXian.Text = string.Empty;
}
}
}
protected void RepeaterScheduling_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
YbUsers_BLL ubll = new YbUsers_BLL();
List <PF.Models.SQL.YbUsers> users = ubll.GetList(a => a.Work == "预报" && a.Position != "挂职" && a.YBUserName != "集体").OrderBy(a => a.Order).ToList();
List <PF.Models.SQL.YbUsers> users_LianXian = ubll.GetList(a => a.Work == "连线").OrderBy(a => a.Order).ToList();
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
//找到分类Repeater关联的数据项
Day_Scheduling_ViewModel dsv = (Day_Scheduling_ViewModel)e.Item.DataItem;
DropDownList DropDownList_ShouXi = (DropDownList)e.Item.FindControl("DropDownList_ShouXi");
DropDownList DropDownList_LingBan = (DropDownList)e.Item.FindControl("DropDownList_LingBan");
DropDownList DropDownList_ZhiBan = (DropDownList)e.Item.FindControl("DropDownList_ZhiBan");
DropDownList DropDownList_LianXian = (DropDownList)e.Item.FindControl("DropDownList_LianXian");
ListItem lino1 = new ListItem()
{
Text = " ", Value = "未选择"
};
ListItem lino2 = new ListItem()
{
Text = " ", Value = "未选择"
};
ListItem lino3 = new ListItem()
{
Text = " ", Value = "未选择"
};
ListItem lino4 = new ListItem()
{
Text = " ", Value = "未选择"
};
DropDownList_ShouXi.Items.Add(lino1);
DropDownList_LingBan.Items.Add(lino2);
DropDownList_ZhiBan.Items.Add(lino3);
DropDownList_LianXian.Items.Add(lino4);
foreach (var ybUser in users)
{
ListItem li1 = new ListItem()
{
Text = ybUser.YBUserName, Value = ybUser.YBUserID.ToString()
};
ListItem li2 = new ListItem()
{
Text = ybUser.YBUserName, Value = ybUser.YBUserID.ToString()
};
ListItem li3 = new ListItem()
{
Text = ybUser.YBUserName, Value = ybUser.YBUserID.ToString()
};
DropDownList_ShouXi.Items.Add(li1);
DropDownList_LingBan.Items.Add(li2);
DropDownList_ZhiBan.Items.Add(li3);
}
foreach (var ybUser in users_LianXian)
{
ListItem li4 = new ListItem()
{
Text = ybUser.YBUserName, Value = ybUser.YBUserID.ToString()
};
DropDownList_LianXian.Items.Add(li4);
}
HiddenField hid = (HiddenField)e.Item.FindControl("HiddenField_DayTime");
DateTime dt = DateTime.Parse(hid.Value);
PF.Models.SQL.Scheduling shouxi = sclist.Where(a => a.Date == dt && a.Work == "首席").FirstOrDefault();
foreach (ListItem lis in DropDownList_ShouXi.Items)
{
if (shouxi != null)
{
if (lis.Text == shouxi.YBUserName)
{
lis.Selected = true;
}
else
{
lis.Selected = false;
}
}
else
{
if (lis.Value == "未选择")
{
lis.Selected = true;
}
else
{
lis.Selected = false;
}
}
}
PF.Models.SQL.Scheduling lingban = sclist.Where(a => a.Date == dt && a.Work == "领班").FirstOrDefault();
foreach (ListItem li in DropDownList_LingBan.Items)
{
if (lingban != null)
{
if (li.Text == lingban.YBUserName)
{
li.Selected = true;
}
else
{
li.Selected = false;
}
}
else
{
if (li.Value == "未选择")
{
li.Selected = true;
}
else
{
li.Selected = false;
}
}
}
PF.Models.SQL.Scheduling zhiban = sclist.Where(a => a.Date == dt && a.Work == "值班").FirstOrDefault();
foreach (ListItem li in DropDownList_ZhiBan.Items)
{
if (zhiban != null)
{
if (li.Text == zhiban.YBUserName)
{
li.Selected = true;
}
else
{
li.Selected = false;
}
}
else
{
if (li.Value == "未选择")
{
li.Selected = true;
}
else
{
li.Selected = false;
}
}
}
PF.Models.SQL.Scheduling lianxian = sclist.Where(a => a.Date == dt && a.Work == "连线").FirstOrDefault();
foreach (ListItem li in DropDownList_LianXian.Items)
{
if (lianxian != null)
{
if (li.Text == lianxian.YBUserName)
{
li.Selected = true;
}
else
{
li.Selected = false;
}
}
else
{
if (li.Value == "未选择")
{
li.Selected = true;
}
else
{
li.Selected = false;
}
}
}
}
}
