public override void Init() { //逻辑对象赋值 bll = PLAN00Bll.GetInstence(); //表格对象赋值 grid = Grid1; }
protected void Grid1_RowSelect(object sender, FineUI.GridRowSelectEventArgs e) { string str = GridViewHelper.GetSelectedKey(Grid1, true); string[] plan_id_shop_id = str.Split(','); string plan_id = plan_id_shop_id[1]; string shop_id = plan_id_shop_id[0]; DataTable dt_left = null; dt_left = PLAN00Bll.GetInstence().GET_PLAN_LEFT_LIST(plan_id);// Get_PLAN_Left_List(plan_id); Grid2.DataSource = dt_left; Grid2.DataBind(); Grid2.SelectedRowIndex = 0; string prod_id = GridViewHelper.GetSelectedKey(Grid2, true); DataTable dt_right = null; dt_right = PLAN00Bll.GetInstence().GET_PLAN_RIGHT_LIST(plan_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 = PLAN00Bll.GetInstence().GetModelForCache(x => x.Id == id); if (model == null) { return; } txtSHOP_ID.Text = model.SHOP_ID; //分店编号 txtPLAN_ID.Text = model.PLAN_ID; //计划单号 txtSTATUS.Text = model.STATUS.ToString(); //单据状态 txtINPUT_DATE.Text = model.INPUT_DATE.ToString(); //单据日期 txtUSER_ID.Text = model.USER_ID; //制单人 txtAPP_USER.Text = model.APP_USER; //审核人 txtAPP_DATETIME.Text = model.APP_DATETIME.ToString(); //审核时间 txtEXPECT_DATE.Text = model.EXPECT_DATE.ToString(); //期望日期 txtPREPARE_ID.Text = model.PREPARE_ID; //备料单号 txtEXPORTED.Text = model.EXPORTED.ToString(); //引入标记 txtEXPORTED_ID.Text = model.EXPORTED_ID; //引入单号 txtDIV_ID.Text = model.DIV_ID; //生产部门 txtSTOCK_ID.Text = model.STOCK_ID; //仓库编号 txtMemo.Text = model.Memo; //备注 txtLOCKED.Text = model.LOCKED.ToString(); //月结锁定 txtCRT_DATETIME.Text = model.CRT_DATETIME.ToString(); //建档日期 txtCRT_USER_ID.Text = model.CRT_USER_ID; //建档人员 txtMOD_DATETIME.Text = model.MOD_USER_ID; //修改日期 txtMOD_USER_ID.Text = model.MOD_DATETIME.ToString(); //修改人员 txtLAST_UPDATE.Text = model.LAST_UPDATE.ToString(); //最后异动时间 txtTrans_STATUS.Text = model.Trans_STATUS.ToString(); //传输状态 } }
/// <summary> /// 数据保存 /// </summary> /// <returns></returns> public override string Save() { string result = string.Empty; int id = ConvertHelper.Cint0(hidId.Text); try { #region 数据验证 if (string.IsNullOrEmpty(txtSHOP_ID.Text.Trim())) { return(txtSHOP_ID.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 PLAN00(x => x.Id == id); model.SHOP_ID = txtSHOP_ID.Text; //分店编号 model.PLAN_ID = txtPLAN_ID.Text; //计划单号 model.STATUS = ConvertHelper.Cint0(txtSTATUS.Text); //单据状态 model.INPUT_DATE = DateTime.Now; // ConvertHelper.StringToDatetime(txtINPUT_DATE.Text.ToString()); //单据日期 model.USER_ID = txtUSER_ID.Text; //制单人 model.APP_USER = txtAPP_USER.Text; //审核人 model.APP_DATETIME = DateTime.Now; //ConvertHelper.StringToDatetime(txtAPP_DATETIME.Text);//审核时间 model.EXPECT_DATE = DateTime.Now; //ConvertHelper.StringToDatetime(txtEXPECT_DATE.Text.ToString());//期望日期 model.PREPARE_ID = txtPREPARE_ID.Text; //备料单号 model.EXPORTED = ConvertHelper.StringToByte(txtEXPORTED.Text.ToString()); //引入标记 model.EXPORTED_ID = txtEXPORTED_ID.Text; //引入单号 model.DIV_ID = txtDIV_ID.Text; //生产部门 model.STOCK_ID = txtSTOCK_ID.Text; //仓库编号 model.Memo = txtMemo.Text; //备注 model.LOCKED = ConvertHelper.StringToByte(txtLOCKED.Text.ToString()); //月结锁定 model.CRT_DATETIME = DateTime.Now; //ConvertHelper.StringToDatetime(txtCRT_DATETIME.Text.ToString());//建档日期 model.CRT_USER_ID = txtCRT_USER_ID.Text; //建档人员 model.MOD_USER_ID = txtMOD_USER_ID.Text; //修改日期 model.MOD_DATETIME = DateTime.Now; //ConvertHelper.StringToDatetime(txtMOD_DATETIME.Text.ToString());//修改人员 model.LAST_UPDATE = DateTime.Now; //ConvertHelper.StringToDatetime(txtLAST_UPDATE.Text.ToString());//最后异动时间 model.Trans_STATUS = ConvertHelper.StringToByte(txtTrans_STATUS.Text.ToString()); //传输状态 #endregion //---------------------------------------------------------- //存储到数据库 PLAN00Bll.GetInstence().Save(this, model); } catch (Exception e) { result = "保存失败!"; //出现异常,保存出错日志信息 CommonBll.WriteLog(result, e); } return(result); }