public override void Init()
{
//逻辑对象赋值
bll = Col_Order00Bll.GetInstence();
//表格对象赋值
grid = Grid1;
}
protected void Grid1_RowSelect(object sender, FineUI.GridRowSelectEventArgs e)
{
string str = GridViewHelper.GetSelectedKey(Grid1, true);
string[] col_id_shop_id = str.Split(',');
string shop_id = col_id_shop_id[1];
string col_id = col_id_shop_id[0];
DataTable dt_left = null;
dt_left = Col_Order00Bll.GetInstence().GET_ARCHIVEORDERS_LEFT_LIST(col_id);
Grid2.DataSource = dt_left;
Grid2.DataBind();
Grid2.SelectedRowIndex = 0;
string prod_id = GridViewHelper.GetSelectedKey(Grid2, true);
DataTable dt_right = null;
dt_right = Col_Order00Bll.GetInstence().GET_ARCHIVEORDERS_RIGHT_LIST(prod_id, col_id);
Grid3.DataSource = dt_right;
Grid3.DataBind();
var PurchasePLANColumn0 = Grid3.FindColumn("SUP_QUAN0") as FineUI.RenderField; // HeaderText="生产量/采购量"
var PurchasePLANColumn1 = Grid3.FindColumn("SUP_QUAN1") as FineUI.RenderField; // HeaderText="生产量/采购量"
var model_ARCHIVEORDERS = new Col_Order00(x => x.COL_ID == col_id);
var model_SHOP = new SHOP00(x => x.SHOP_ID == shop_id);
string area_id = model_SHOP.SHOP_Area_ID.ToString();
// var model_SYS_PARAMATERS = new SYS_PARAMATERS(x => x.Area_Id == area_id); //根据参数表 显示信息
//if (model_SYS_PARAMATERS != null)
//{
//if (model_SYS_PARAMATERS.COL_ORDER_TYPE == 0) //产品类型汇整
// {
//if (model_ARCHIVEORDERS.PROD_TYPE == 0) { PurchasePLANColumn1.Hidden = true; PPhidId.Text = "0"; }
//if (model_ARCHIVEORDERS.PROD_TYPE == 1) { PurchasePLANColumn0.Hidden = true; PPhidId.Text = "1"; }
//if (model_ARCHIVEORDERS.PROD_TYPE == 2) { PurchasePLANColumn0.Hidden = true; PPhidId.Text = "1"; }
// }
//if (model_SYS_PARAMATERS.COL_ORDER_TYPE == 1) //产品类型汇整
//{
// if (model_ARCHIVEORDERS.PROD_TYPE == 1) { PurchasePLANColumn0.Hidden = true; PPhidId.Text = "0"; }
// if (model_ARCHIVEORDERS.PROD_TYPE == 2) { PurchasePLANColumn0.Hidden = true; PPhidId.Text = "1"; }
//}
// }
}
protected void Grid2_RowSelect(object sender, FineUI.GridRowSelectEventArgs e)
{
string str = GridViewHelper.GetSelectedKey(Grid1, true);
string[] col_id_shop_id = str.Split(',');
string shop_id = col_id_shop_id[1];
string col_id = col_id_shop_id[0];
string prod_id = GridViewHelper.GetSelectedKey(Grid2, true);
DataTable dt_right = null;
dt_right = Col_Order00Bll.GetInstence().GET_ARCHIVEORDERS_RIGHT_LIST(prod_id, col_id);
Grid3.DataSource = dt_right;
Grid3.DataBind();
}
/// <summary>读取数据</summary>
public override void LoadData()
{
//关闭窗口
ButtonCancel.OnClientClick = ActiveWindow.GetHideReference();
int id = ConvertHelper.Cint0(hidId.Text);
if (id != 0)
{
//获取指定ID的菜单内容，如果不存在，则创建一个菜单实体
var model = Col_Order00Bll.GetInstence().GetModelForCache(x => x.Id == id);
if (model == null)
{
return;
}
txtSHOP_ID.Text = model.SHOP_ID;
txtCOL_ID.Text = model.COL_ID;
txtINPUT_DATE.Text = model.INPUT_DATE.ToString();
txtORD_USER.Text = model.ORD_USER;
txtEXPECT_DATE.Text = model.EXPECT_DATE.ToString();
txtSTATUS.Text = model.STATUS.ToString();
txtPROD_TYPE.Text = model.PROD_TYPE.ToString();
txtORD_DEP_ID.Text = model.ORD_DEP_ID;
txtCOL_BeginDate.Text = model.COL_BeginDate.ToString();
txtCOL_EndDate.Text = model.COL_EndDate.ToString();
txtAPP_USER.Text = model.APP_USER;
txtAPP_DATE.Text = model.APP_DATE.ToString();
txtMemo.Text = model.Memo;
txtLOCKED.Text = model.LOCKED.ToString();
txtCRT_DATETIME.Text = model.CRT_DATETIME.ToString();
txtCRT_USER_ID.Text = model.CRT_USER_ID.ToString();
txtMOD_DATETIME.Text = model.MOD_DATETIME.ToString();
txtMOD_USER_ID.Text = model.MOD_USER_ID.ToString();
txtLAST_UPDATE.Text = model.LAST_UPDATE.ToString();
txtTrans_STATUS.Text = model.Trans_STATUS.ToString();
}
}
/// <summary>
/// 核准
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public override void Approval()
{
string str = GridViewHelper.GetSelectedKey(Grid1, true);
string[] col_id_shop_id = str.Split(',');
string col_id = col_id_shop_id[0];
string shop_id = col_id_shop_id[1];
int ispp = ConvertHelper.Cint0(PPhidId.Text.Trim());
string user_id = OnlineUsersBll.GetInstence().GetManagerId().ToString();
int result = Col_Order00Bll.GetInstence().ADD_PLAN_PURCHASE(col_id, shop_id, user_id, ispp);
if (result == 0)
{
Alert.Show("核准成功！");
}
else
{
Alert.Show("核准失败！请重新汇整");
}
}
/// <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();
}
/// <summary>
/// 数据保存
/// </summary>
/// <returns></returns>
public override string Save()
{
string result = string.Empty;
int id = ConvertHelper.Cint0(hidId.Text);
try
{
#region 数据验证
//if (string.IsNullOrEmpty(txtAREA_NAME.Text.Trim()))
//{
// return txtAREA_NAME.Label + "不能为空！";
//}
//var sName = StringHelper.Left(txtName.Text, 50);
//if (BranchBll.GetInstence().Exist(x => x.Name == sName && x.Id != id))
//{
// return txtName.Label + "已存在！请重新输入！";
//}
//if (string.IsNullOrEmpty(txtId.Text.Trim()))
//{
// return txtId.Label + "不能为空！";
//}
//var sUrl = StringHelper.Left(txtUrl.Text, 400);
//if (BranchBll.GetInstence().Exist(x => x.Url == sUrl && x.Id != id))
//{
// return txtUrl.Label + "已存在！请重新输入！";
//}
#endregion
#region 赋值
//读取资料
var model = new Col_Order00(x => x.Id == id);
model.SHOP_ID = txtSHOP_ID.Text;
model.COL_ID = txtCOL_ID.Text;
model.INPUT_DATE = DateTime.Now; // ConvertHelper.StringToDatetime(txtINPUT_DATE.Text);
model.ORD_USER = txtORD_USER.Text;
model.EXPECT_DATE = DateTime.Now; // ConvertHelper.StringToDatetime(txtEXPECT_DATE.Text);
model.STATUS = ConvertHelper.Cint0(txtSTATUS.Text);
model.PROD_TYPE = ConvertHelper.Cint0(txtPROD_TYPE.Text);
model.ORD_TYPE = ConvertHelper.Cint0(txtORD_TYPE.Text);
model.ORD_DEP_ID = txtORD_DEP_ID.Text;
model.COL_BeginDate = DateTime.Now; //ConvertHelper.StringToDatetime(txtCOL_BeginDate.Text);
model.COL_EndDate = DateTime.Now; //ConvertHelper.StringToDatetime(txtCOL_EndDate.Text);
model.APP_USER = txtAPP_USER.Text;
model.APP_DATE = DateTime.Now;//ConvertHelper.StringToDatetime(txtAPP_DATE.Text);
model.Memo = txtMemo.Text;
model.LOCKED = ConvertHelper.StringToByte(txtLOCKED.Text);
// model.ORD_DEP_ID = txtORD_DEP_ID.Text;
model.CRT_DATETIME = DateTime.Now; //ConvertHelper.StringToDatetime(txtCRT_DATETIME.Text);
model.CRT_USER_ID = txtCRT_USER_ID.Text;
model.MOD_DATETIME = DateTime.Now; //ConvertHelper.StringToDatetime(txtMOD_DATETIME.Text);
model.MOD_USER_ID = txtMOD_USER_ID.Text;
model.LAST_UPDATE = DateTime.Now; //ConvertHelper.StringToDatetime(txtLAST_UPDATE.Text);
model.Trans_STATUS = ConvertHelper.StringToByte(txtTrans_STATUS.Text);
#endregion
//----------------------------------------------------------
//存储到数据库
Col_Order00Bll.GetInstence().Save(this, model);
}
catch (Exception e)
{
result = "保存失败！";
//出现异常，保存出错日志信息
CommonBll.WriteLog(result, e);
}
return(result);
}
