protected void btnSubmit1_Click(object sender, EventArgs e) { Grid2.Rows.Clear(); //判断 FineUI.RadioButton RaddpUp_Date = Window2.FindControl("A").FindControl("RaddpUp_Date") as FineUI.RadioButton; FineUI.RadioButton RadEXPECT_DATE = Window2.FindControl("B").FindControl("RadEXPECT_DATE") as FineUI.RadioButton; if (RaddpUp_Date.Checked == false && RadEXPECT_DATE.Checked == false) { Alert.Show("请选择时间"); return; } string Start_Time = ""; string End_Time = ""; //获取时间 DatePicker dpUp_DateBeg = Window2.FindControl("A").FindControl("dpUp_DateBeg") as DatePicker; DateTime dt_up_date_bg = ConvertHelper.StringToDatetime(DateTime.Parse(dpUp_DateBeg.SelectedDate.ToString()).ToString("yyyy-MM-dd 00:00:00")); DatePicker dpUp_DateEnd = Window2.FindControl("A").FindControl("dpUp_DateEnd") as DatePicker; DateTime dt_up_date_end = ConvertHelper.StringToDatetime(DateTime.Parse(dpUp_DateEnd.SelectedDate.ToString()).ToString("yyyy-MM-dd 23:59:59")); DatePicker dpEXPECT_DATEBeg = Window2.FindControl("B").FindControl("dpEXPECT_DATEBeg") as DatePicker; DateTime dt_expect_date_bg = ConvertHelper.StringToDatetime(DateTime.Parse(dpEXPECT_DATEBeg.SelectedDate.ToString()).ToString("yyyy-MM-dd 00:00:00")); DatePicker dpEXPECT_DATEEnd = Window2.FindControl("B").FindControl("dpEXPECT_DATEEnd") as DatePicker; DateTime dt_expect_date_end = ConvertHelper.StringToDatetime(DateTime.Parse(dpEXPECT_DATEEnd.SelectedDate.ToString()).ToString("yyyy-MM-dd 23:59:59")); int IsTime = 1; if (RaddpUp_Date.Checked) { IsTime = 0; Start_Time = dt_up_date_bg.ToString(); End_Time = dt_up_date_end.ToString(); } if (RadEXPECT_DATE.Checked) { IsTime = 1; Start_Time = dt_expect_date_bg.ToString(); End_Time = dt_expect_date_end.ToString(); } string shop_id = SHOP_hidId.Text.Trim(); string shop_name = OnlineUsersBll.GetInstence().GetUserOnlineInfo("SHOP_NAME1").ToString(); string shop_idStr = ORDER00Table.SHOP_ID; if (shop_name.Contains("区域中心")) { IsTime = -1; } Session["SerchPars_session_Orders"] = Session["SerchPars_session"] = IsTime + "," + Start_Time + "," + End_Time; BandGrid2(shop_name, shop_idStr, shop_id, Start_Time, End_Time, IsTime); Window2.Hidden = true; }
/// <summary> /// 汇整 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnArchive_Click(object sender, EventArgs e) { //判断 FineUI.RadioButton RaddpUp_Date = Window2.FindControl("A").FindControl("RaddpUp_Date") as FineUI.RadioButton; FineUI.RadioButton RadEXPECT_DATE = Window2.FindControl("B").FindControl("RadEXPECT_DATE") as FineUI.RadioButton; if (RaddpUp_Date.Checked == false && RadEXPECT_DATE.Checked == false) { Alert.Show("请选择时间"); return; } string Start_Time = ""; string End_Time = ""; //获取时间 DatePicker dpUp_DateBeg = Window2.FindControl("A").FindControl("dpUp_DateBeg") as DatePicker; DateTime dt_up_date_bg = ConvertHelper.StringToDatetime(dpUp_DateBeg.SelectedDate.ToString()); DatePicker dpUp_DateEnd = Window2.FindControl("A").FindControl("dpUp_DateEnd") as DatePicker; DateTime dt_up_date_end = ConvertHelper.StringToDatetime(dpUp_DateEnd.SelectedDate.ToString()); DatePicker dpEXPECT_DATEBeg = Window2.FindControl("B").FindControl("dpEXPECT_DATEBeg") as DatePicker; DateTime dt_expect_date_bg = ConvertHelper.StringToDatetime(dpEXPECT_DATEBeg.SelectedDate.ToString()); DatePicker dpEXPECT_DATEEnd = Window2.FindControl("B").FindControl("dpEXPECT_DATEEnd") as DatePicker; DateTime dt_expect_date_end = ConvertHelper.StringToDatetime(dpEXPECT_DATEEnd.SelectedDate.ToString()); //参数 Random ran = new Random(); string SHOP_ID = OnlineUsersBll.GetInstence().GetUserOnlineInfo("SHOP_ID").ToString(); string COL_ID = SHOP_ID + "CL" + DateTime.Now.ToString("yyyy-MM-dd") + +ran.Next(1000, 9999); string manager_LoginName = OnlineUsersBll.GetInstence().GetUserOnlineInfo("Manager_LoginName").ToString();//登录名 int IsTime = 1; if (RaddpUp_Date.Checked) { IsTime = 0; Start_Time = dt_up_date_bg.ToString(); End_Time = dt_up_date_end.ToString(); } if (RadEXPECT_DATE.Checked) { IsTime = 1; Start_Time = dt_expect_date_bg.ToString(); End_Time = dt_expect_date_end.ToString(); } string ORD_DEP_ID_C = "";//汇整者的 部门 int ex_int = Col_Order00Bll.GetInstence().ADD_ARCHIVEORDERS(manager_LoginName, ORD_DEP_ID_C, SHOP_ID, Start_Time, End_Time, IsTime); if (ex_int == 0) { Alert.Show("汇整成功!"); } else { Alert.Show("汇整失败!请重新汇整!"); } LoadData(); }
protected void btnImport_Click(object sender, EventArgs e) { //判断 FineUI.RadioButton RaddpUp_Date = Window2.FindControl("A").FindControl("RaddpUp_Date") as FineUI.RadioButton; FineUI.RadioButton RadEXPECT_DATE = Window2.FindControl("B").FindControl("RadEXPECT_DATE") as FineUI.RadioButton; if (RaddpUp_Date.Checked == false && RadEXPECT_DATE.Checked == false) { Alert.Show("请选择时间"); return; } string Start_Time = ""; string End_Time = ""; //参数 Random ran = new Random(); string SHOP_ID = OnlineUsersBll.GetInstence().GetUserOnlineInfo("SHOP_ID").ToString(); string COL_ID = SHOP_ID + "CL" + DateTime.Now.ToString("yyyy-MM-dd") + +ran.Next(1000, 9999); string manager_LoginName = OnlineUsersBll.GetInstence().GetUserOnlineInfo("Manager_LoginName").ToString();//登录名 int IsTime = 1; if (RaddpUp_Date.Checked) { //获取时间 DatePicker dpUp_DateBeg = Window2.FindControl("A").FindControl("dpUp_DateBeg") as DatePicker; DateTime dt_up_date_bg = ConvertHelper.StringToDatetime(dpUp_DateBeg.SelectedDate.ToString()); DatePicker dpUp_DateEnd = Window2.FindControl("A").FindControl("dpUp_DateEnd") as DatePicker; DateTime dt_up_date_end = ConvertHelper.StringToDatetime(dpUp_DateEnd.SelectedDate.ToString()); IsTime = 0; Start_Time = dt_up_date_bg.ToString(); End_Time = dt_up_date_end.ToString(); } if (RadEXPECT_DATE.Checked) { DatePicker dpEXPECT_DATEBeg = Window2.FindControl("B").FindControl("dpEXPECT_DATEBeg") as DatePicker; DateTime dt_expect_date_bg = ConvertHelper.StringToDatetime(dpEXPECT_DATEBeg.SelectedDate.ToString()); DatePicker dpEXPECT_DATEEnd = Window2.FindControl("B").FindControl("dpEXPECT_DATEEnd") as DatePicker; DateTime dt_expect_date_end = ConvertHelper.StringToDatetime(dpEXPECT_DATEEnd.SelectedDate.ToString()); IsTime = 1; Start_Time = dt_expect_date_bg.ToString(); End_Time = dt_expect_date_end.ToString(); } int ex_int = TAKEIN00Bll.GetInstence().LeadIntoProductPlanList(Start_Time, End_Time, IsTime.ToString(), SHOP_ID, manager_LoginName); if (ex_int == 0) { Alert.Show("引入成功!"); } else { Alert.Show("引入失败!请重新引入!"); } LoadData(); }
/// <summary> /// 汇整 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSearch_Click(object sender, EventArgs e) { //判断 FineUI.RadioButton RaddpUp_Date = Window2.FindControl("A").FindControl("RaddpUp_Date") as FineUI.RadioButton; FineUI.RadioButton RadEXPECT_DATE = Window2.FindControl("B").FindControl("RadEXPECT_DATE") as FineUI.RadioButton; if (RaddpUp_Date.Checked == false && RadEXPECT_DATE.Checked == false) { Alert.Show("请选择时间"); return; } string Start_Time = ""; string End_Time = ""; //获取时间 DatePicker dpUp_DateBeg = Window2.FindControl("A").FindControl("dpUp_DateBeg") as DatePicker; DateTime dt_up_date_bg = ConvertHelper.StringToDatetime(dpUp_DateBeg.SelectedDate.ToString()); DatePicker dpUp_DateEnd = Window2.FindControl("A").FindControl("dpUp_DateEnd") as DatePicker; DateTime dt_up_date_end = ConvertHelper.StringToDatetime(dpUp_DateEnd.SelectedDate.ToString()); DatePicker dpEXPECT_DATEBeg = Window2.FindControl("B").FindControl("dpEXPECT_DATEBeg") as DatePicker; DateTime dt_expect_date_bg = ConvertHelper.StringToDatetime(dpEXPECT_DATEBeg.SelectedDate.ToString()); DatePicker dpEXPECT_DATEEnd = Window2.FindControl("B").FindControl("dpEXPECT_DATEEnd") as DatePicker; DateTime dt_expect_date_end = ConvertHelper.StringToDatetime(dpEXPECT_DATEEnd.SelectedDate.ToString()); //参数 Random ran = new Random(); string SHOP_ID = OnlineUsersBll.GetInstence().GetUserOnlineInfo("SHOP_ID").ToString();; string COL_ID = SHOP_ID + "CL" + DateTime.Now.ToString("yyyy-MM-dd") + +ran.Next(1000, 9999); string manager_LoginName = OnlineUsersBll.GetInstence().GetUserOnlineInfo("Manager_LoginName").ToString();//登录名 conditionList = new List <ConditionFun.SqlqueryCondition>(); int IsTime = 1; if (RaddpUp_Date.Checked) { IsTime = 0; Start_Time = dt_up_date_bg.ToString(); End_Time = dt_up_date_end.ToString(); conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, PLAN00Table.INPUT_DATE, Comparison.BetweenAnd, Start_Time, false, false)); conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, PLAN00Table.INPUT_DATE, Comparison.BetweenAnd, End_Time, false, false)); } if (RadEXPECT_DATE.Checked) { IsTime = 1; Start_Time = dt_expect_date_bg.ToString(); End_Time = dt_expect_date_end.ToString(); conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, PLAN00Table.EXPECT_DATE, Comparison.BetweenAnd, Start_Time, false, false)); conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, PLAN00Table.EXPECT_DATE, Comparison.BetweenAnd, End_Time, false, false)); } Window2.Hidden = true; bll.BindGrid(Grid1, 0, 0, conditionList, sortList); }