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