/// <summary> /// 主表保存 /// </summary> /// <returns></returns> public string MAINEdit() { string _IB_ID = tbxIB_ID.Text; try { var model = new IN_BACK00(x => x.IB_ID == _IB_ID); var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString()); string _SHOP_ID = ddlSHOP_NAME.SelectedValue; if (String.IsNullOrEmpty(_IB_ID)) { model.SetIsNew(true); model.CRT_DATETIME = DateTime.Now; model.CRT_USER_ID = OlUser.Manager_LoginName; DataTable dt = new DataTable(); dt = (DataTable)SPs.Get_ORDER_SEED(_SHOP_ID, "IN_BACK00").ExecuteDataTable(); _IB_ID = dt.Rows[0]["PLANE_ID"].ToString(); //var model = Purchase00.SingleOrDefault(x => x.Purchase_ID == _Pur00_id); } model.SHOP_ID = _SHOP_ID; model.IB_ID = _IB_ID.ToString(); model.STATUS = ConvertHelper.Cint(ddlStatus.SelectedValue); model.INPUT_DATE = ConvertHelper.StringToDatetime(dpINPUT_DATE.SelectedDate.ToString()); model.OUT_SHOP = ddlOUT_SHOP.SelectedValue; model.STOCK_ID = ddlSTOCK_ID.SelectedValue; model.USER_ID = OlUser.Manager_LoginName; model.APP_USER = OlUser.Manager_LoginName; model.APP_DATETIME = DateTime.Now; string _RELATE_ID = tbxRELATE_ID.Text; model.RELATE_ID = _RELATE_ID; if (!String.IsNullOrEmpty(_RELATE_ID)) { var modelOrder = new OUT_BACK00(x => x.BK_ID == _RELATE_ID); modelOrder.Exported = 1; modelOrder.Exported_ID = _IB_ID; modelOrder.Save(); } model.Memo = tbxMemo.Text; model.LOCKED = ConvertHelper.StringToByte(ckLOCKED.Checked ? "1" : "0"); model.MOD_DATETIME = DateTime.Now; model.MOD_USER_ID = OlUser.Manager_LoginName; model.LAST_UPDATE = DateTime.Now; model.Trans_STATUS = 0; IN_BACK00Bll.GetInstence().Save(this, model); } catch (Exception err) { return(err.Message); } return(""); }
/// <summary>读取数据</summary> public override void LoadData() { //设置排序 if (sortList == null) { Sort(null); } //绑定Grid表格 OnlineUsersBll.GetInstence().BindGrid(Grid1, Grid1.PageIndex + 1, Grid1.PageSize, null, sortList); }
/// <summary> /// 子表保存 /// </summary> /// <returns></returns> public string DetailEdit() { JArray jarr = Grid2.GetMergedData(); var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString()); string result = ""; int n = 0; for (int i = 0; i < jarr.Count; i++) { try { int id = ConvertHelper.Cint(jarr[i]["values"]["Id01"].ToString()); var model2 = new Inventory01(x => x.Id == id); //string str = jarr[i]["status"].ToString(); if (jarr[i]["status"].ToString().Equals("modified")) { model2.SetIsNew(false); } //else if (jarr[i]["status"].ToString().Equals("unchanged")) //{ // continue; //} else { model2.SetIsNew(true); } model2.SHOP_ID = jarr[i]["values"]["SHOP_ID01"].ToString(); if (!String.IsNullOrEmpty(tbxINV_ID.Text)) { model2.INV_ID = tbxINV_ID.Text; } else { return("保存失败"); } model2.SNo = ConvertHelper.Cint(jarr[i]["values"]["SNo01"].ToString()); model2.PROD_ID = jarr[i]["values"]["PROD_ID01"].ToString(); model2.QUANTITY = ConvertHelper.Cdbl(jarr[i]["values"]["QUANTITY01"].ToString()); model2.QUAN = ConvertHelper.Cdbl(jarr[i]["values"]["QUAN01"].ToString()); model2.QUAN1 = ConvertHelper.Cint(jarr[i]["values"]["QUAN101"].ToString()); model2.QUAN2 = ConvertHelper.Cdbl(jarr[i]["values"]["QUAN201"].ToString()); model2.QUAN_B = ConvertHelper.Cdbl(jarr[i]["values"]["QUAN_B01"].ToString()); model2.MEMO = jarr[i]["values"]["MEMO01"].ToString(); Inventory01Bll.GetInstence().Save(this, model2); } catch (Exception err) { n++; result = "明细保存失败" + n + "条"; } } LoadDETAIL(); return(result); }
/// <summary>读取数据</summary> public override void LoadData() { string shop_id = SHOP_hidId.Text.Trim(); int managerId = OnlineUsersBll.GetInstence().GetManagerId();//获取登录名 //表头 SHOP00Bll.GetInstence().BandDropDownListShowShop(this, ddlShop, shop_id); //分店名称 SHOP00Bll.GetInstence().BandDropDownListShowShop1(this, ddlOUT_SHOP); //供货分店 // ORDER_DEP00Bll.GetInstence().BandDropDownList(this, ddlORDER_DEP, shop_id);//订货部门 BranchBll.GetInstence().BandDropDownList(this, ddlORDER_DEP); HiddenDep_Id.Text = ddlORDER_DEP.SelectedValue; string manager_LoginName = OnlineUsersBll.GetInstence().GetUserOnlineInfo("Manager_LoginName").ToString();//登录名 txtCRT_USER_ID.Text = manager_LoginName; txtORD_USER.Text = manager_LoginName; txtAPP_USER.Text = manager_LoginName; txtMOD_USER_ID.Text = manager_LoginName; txtINPUT_DATE.SelectedDate = DateTime.Now; //单据时间 txtManage.Text = manager_LoginName; ddlStatus.SelectedValue = "0";//状态 ddlEXPECT_DATE.SelectedDate = DateTime.Now.AddDays(1); txtCRT_DATETIME.SelectedDate = DateTime.Now; txtMOD_DATETIME.SelectedDate = DateTime.Now; txtEXPORTED_ID.Text = ""; txtMemo.Text = ""; cbTrans_STATUS.Checked = false; DataTable table = GetSourceData("", ""); Grid1.DataSource = table; Grid1.DataBind(); ///grid2 // string shop_id = OnlineUsersBll.GetInstence().GetUserOnlineInfo("SHOP_ID").ToString(); // conditionList = new List<ConditionFun.SqlqueryCondition>(); // conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, ORDER00Table.SHOP_ID, Comparison.Equals, shop_id, false, false)); // ORDER00Bll.GetInstence().BindGrid(Grid2, 0, sortList); // bll.BindGrid(Grid2, 0, sortList); // ORDER00Bll.GetInstence().BindGrid(Grid2, 0, 0, conditionList, sortList); //------------------ }
protected override void OnInit(EventArgs e) { base.OnInit(e); //检测用户是否超时退出 OnlineUsersBll.GetInstence().IsTimeOut(); //检测用户登录的有效性(是否被系统踢下线或管理员踢下线) if (OnlineUsersBll.GetInstence().IsOffline(this)) { return; } if (!IsPostBack) { //检测当前页面是否有访问权限 MenuInfoBll.GetInstence().CheckPagePower(this); #region 设置页面按键权限 try { //定义按键控件 Control btnControl = null; //找到页面放置按键控件的位置 ControlCollection controls = MenuInfoBll.GetInstence().GetControls(this.Controls, "toolBar"); //逐个读取出来 for (int i = 0; i < controls.Count; i++) { //取出控件 btnControl = controls[i]; //判断是否除了刷新、查询和关闭以外的按键 if (btnControl.ID != "ButtonRefresh" && btnControl.ID != "ButtonSearch" && btnControl.ID != "ButtonClose" && btnControl.ID != "ButtonReset") { //是的话检查该按键当前用户是否有控件权限,没有的话则禁用该按键 ((FineUI.Button)btnControl).Enabled = MenuInfoBll.GetInstence().CheckControlPower(this, btnControl.ID); } } } catch (Exception) { } #endregion //记录用户当前所在的页面位置 CommonBll.UserRecord(this); } //运行UI页面初始化函数,子类继承后需要重写本函数,以提供给本初始化函数调用 Init(); //如果列表项不为空时,绑定空数据显示内容 if (grid != null) { grid.EmptyText = String.Format("<img src=\"{0}\" alt=\"No Data Found!\"/>", ResolveUrl("/WebManage/Images/no_data_found.jpg")); } }
/// <summary> /// 点击 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Preview_Ok_Click(object sender, EventArgs e) { //获取登录用户 var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString()); //登录名 string userId = OlUser.Manager_LoginName; Grid previewGrid = previewWindow.FindControl("previewDataPanel").FindControl("previewDataGrid") as Grid; int[] seelctedRows = previewGrid.SelectedRowIndexArray; if (seelctedRows == null || seelctedRows.Length == 0) { Alert.Show("请选择需要确认的账单!"); return; } StringBuilder sb = new StringBuilder(); int outTotal = 0; int backTotal = 0; foreach (int rowIndex in seelctedRows) { long id = (long)previewGrid.DataKeys[rowIndex][0]; BillType billType = (BillType)previewGrid.DataKeys[rowIndex][1]; switch (billType) { case BillType.OutBill: //出货单 if (ProcessOutBill(id, userId)) { outTotal++; } break; case BillType.BackBill: //退货单 if (ProcessBackBill(id, userId)) { backTotal++; } break; } } if (backTotal > 0) { Alert.Show(string.Format("汇整完成, 出货单:{0}条,退货单:{1}条。", outTotal, backTotal)); } else { Alert.Show(string.Format("汇整完成, 出货单:{0}条。", outTotal)); } previewWindow.Hidden = true; }
/// <summary> /// 子表保存 /// </summary> /// <returns></returns> public string DetailEdit() { JArray jarr = Grid2.GetMergedData(); var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString()); string result = ""; int n = 0; for (int i = 0; i < jarr.Count; i++) { try { var model2 = new Adjust01(); //string str = jarr[i]["status"].ToString(); if (jarr[i]["status"].ToString().Equals("modified")) { model2.SetIsNew(false); } else if (jarr[i]["status"].ToString().Equals("unchanged")) { continue; } else { model2.SetIsNew(true); } model2.SHOP_ID = jarr[i]["values"]["SHOP_ID01"].ToString(); if (!String.IsNullOrEmpty(jarr[i]["values"]["AD_ID01"].ToString())) { model2.AD_ID = jarr[i]["values"]["AD_ID01"].ToString(); } else { return("保存失败"); } model2.SNo = ConvertHelper.Cint(jarr[i]["values"]["SNo01"].ToString()); model2.PROD_ID = jarr[i]["values"]["PROD_ID01"].ToString(); model2.QUANTITY = ConvertHelper.StringToDecimal(jarr[i]["values"]["QUANTITY01"].ToString()); model2.STD_UNIT = jarr[i]["values"]["STD_UNIT01"].ToString(); model2.STD_CONVERT = ConvertHelper.Cint(jarr[i]["values"]["STD_CONVERT01"].ToString()); model2.STD_QUAN = ConvertHelper.StringToDecimal(jarr[i]["values"]["STD_QUAN01"].ToString()); model2.STD_PRICE = ConvertHelper.StringToDecimal(jarr[i]["values"]["STD_PRICE01"].ToString()); model2.COST = ConvertHelper.StringToDecimal(jarr[i]["values"]["COST01"].ToString()); model2.MEMO = jarr[i]["values"]["MEMO01"].ToString(); Adjust01Bll.GetInstence().Save(this, model2); } catch (Exception err) { n++; result = "明细保存失败" + n + "条"; } } return(result); }
/// <summary> /// 数据保存 /// </summary> /// <returns></returns> public override string Save() { string result = string.Empty; // int id = ConvertHelper.Cint0(hidId.Text); try { #region 数据验证 if (string.IsNullOrEmpty(txtPwd.Text.Trim())) { return(txtPwd.Label + "不能为空!"); } if (string.IsNullOrEmpty(txtPwd1.Text.Trim())) { return(txtPwd1.Label + "不能为空!"); } if (txtPwd.Text.Trim() != txtPwd1.Text.Trim()) { return(txtPwd.Label + "两次输入密码不一致!"); } #endregion #region 赋值 int managerId = OnlineUsersBll.GetInstence().GetManagerId(); var model = Manager.SingleOrDefault(x => x.Id == managerId); model.LoginPass = Encrypt.Md5(Encrypt.Md5(txtPwd.Text.Trim())); #endregion //---------------------------------------------------------- //存储到数据库 ManagerBll.GetInstence().Save(this, model); Alert.Show("修改成功!"); } catch (Exception e) { result = "保存失败!"; //出现异常,保存出错日志信息 CommonBll.WriteLog(result, e); } return(result); }
/// <summary> /// 主表保存 /// </summary> /// <returns></returns> public string TAKEN10Edit() { string _takein_id = tbxTAKEIN_ID.Text; try { var model = new TAKEIN10(x => x.TAKEIN_ID == _takein_id); var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString()); string _SHOP_ID = ddlSHOP_NAME.SelectedValue; if (String.IsNullOrEmpty(_takein_id)) { model.SetIsNew(true); model.CRT_DATETIME = DateTime.Now; model.CRT_USER_ID = OlUser.Manager_LoginName; DataTable dt = new DataTable(); dt = (DataTable)SPs.Get_ORDER_SEED(_SHOP_ID, "TAKEN10").ExecuteDataTable(); _takein_id = dt.Rows[0]["PLANE_ID"].ToString(); //var model = Purchase00.SingleOrDefault(x => x.Purchase_ID == _Pur00_id); } model.SHOP_ID = _SHOP_ID; model.TAKEIN_ID = _takein_id.ToString(); model.STATUS = ConvertHelper.Cint(ddlStatus.SelectedValue); model.STOCK_ID = ddlSTOCK_ID.SelectedValue; //model.INPUT_DATE = ConvertHelper.StringToDatetime(dpINPUT_DATE.SelectedDate.ToString()); model.INPUT_DATE = ConvertHelper.StringToDatetime(dpINPUT_DATE.SelectedDate.ToString()); model.SUP_ID = ddlSUP_NAME.SelectedValue; model.USER_ID = OlUser.Manager_LoginName; model.APP_USER = OlUser.Manager_LoginName; model.APP_DATETIME = DateTime.Now; model.TOT_AMOUNT = ConvertHelper.StringToDecimal(numTOT_AMOUNT.Text); model.TOT_TAX = ConvertHelper.StringToDecimal(numTOT_QTY.Text); model.TOT_QTY = ConvertHelper.StringToDecimal(numPRE_PAY.Text); model.PRE_PAY = ConvertHelper.StringToDecimal(numPRE_PAY.Text); model.PRE_PAY_ID = tbxPRE_PAY_ID.Text; model.RELATE_ID = tbxRELATE_ID.Text; model.INVOICE_ID = tbxINVOICE_ID.Text; model.TAKEIN_TYPE = ConvertHelper.Cint(ddlTAKEIN_TYPE.SelectedValue); model.Memo = tbxMemo.Text; model.LOCKED = ConvertHelper.StringToByte(ckLOCKED.Checked ? "1" : "0"); model.MOD_DATETIME = DateTime.Now; model.MOD_USER_ID = OlUser.Manager_LoginName; model.LAST_UPDATE = DateTime.Now; model.Trans_STATUS = 0; TAKEIN10Bll.GetInstence().Save(this, model); } catch (Exception err) { return(err.Message); } return(""); }
/// <summary> /// OrderDep00保存 /// </summary> /// <returns></returns> public string OrderDep00Save(JArray upJson) { string result = ""; for (int i = 0; i < upJson.Count; i++) { try { int _Id = ConvertHelper.Cint(upJson[i]["values"]["Id"].ToString()); var model = new ORDER_DEP00(x => x.Id == _Id); if (upJson[i]["status"].ToString() == "newadded") { model.ORDDEP_ID = TABLE_SEEDBll.GetInstence().GetTableSeed("ORDER_DEP00", "", 0); } else { model.ORDDEP_ID = upJson[i]["values"]["ORDDEP_ID"].ToString(); } model.ORDDEP_NAME = upJson[i]["values"]["ORDDEP_NAME"].ToString(); model.ORDER_WEEK = upJson[i]["values"]["ORDER_WEEK"].ToString(); //string a = upJson[i]["values"]["USABLE"].ToString(); if (upJson[i]["values"]["USABLE"].ToString() == "True") { model.USABLE = 1; } else { model.USABLE = 0; } model.CRT_USER_ID = upJson[i]["values"]["CRT_USER_ID"].ToString(); model.CRT_DATETIME = DateTime.Now; var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString()); model.MOD_DATETIME = DateTime.Now; model.MOD_USER_ID = OlUser.Manager_LoginName; ORDER_DEP00Bll.GetInstence().Save(this, model); } catch (Exception err) { result = result + upJson[i]["values"]["ORDDEP_NAME"].ToString() + "相关数据保存失败" + Environment.NewLine; } } if (String.IsNullOrEmpty(result)) { result = ""; } //int i = aa.Count; return(result); }
/// <summary> /// 作废按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public void BtnPur00_Cancel(Object sender, EventArgs e) { string Pur00_ID = tbxPurchase_ID.Text.ToString(); var model = Purchase00.SingleOrDefault(x => x.Purchase_ID == Pur00_ID); if (model == null) { FineUI.Alert.ShowInParent("订单单号不存在", FineUI.MessageBoxIcon.Information); } //1 = 存档 2 = 核准 3 = 作废 4 = 已引入(供应商进货) switch (model.STATUS) { case 1: model.STATUS = 3; break; case 2: FineUI.Alert.ShowInParent("订单已核准,无法进行作废", FineUI.MessageBoxIcon.Information); return; case 3: model.STATUS = 1; break; case 4: FineUI.Alert.ShowInParent("订单已引入,无法进行作废", FineUI.MessageBoxIcon.Information); return; default: FineUI.Alert.ShowInParent("订单状态有误,无法进行作废", FineUI.MessageBoxIcon.Information); return; } ddlStatus.SelectedValue = model.STATUS.ToString(); var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString()); model.MOD_DATETIME = DateTime.Now; model.LAST_UPDATE = DateTime.Now; model.MOD_USER_ID = OlUser.Manager_LoginName; string result = ""; try { Purchase00Bll.GetInstence().Save(this, model); } catch (Exception err) { result = err.Message; } //BtnPur01_Edit(sender, e); //string result = Pur01_Edit(); if (String.IsNullOrEmpty(result)) { result = Pur_Edit(); } LoadPur(); LoadDataPur01(); FineUI.Alert.ShowInParent(result, FineUI.MessageBoxIcon.Error); //FineUI.Alert.ShowInParent("核准成功", FineUI.MessageBoxIcon.Information); }
/// <summary> /// 核准 /// </summary> public override void Approval() { GridRow row = resultGrid.SelectedRow; if (row == null) { Alert.Show("请选择需要核准的应付账单"); return; } try { int Id = Convert.ToInt32(row.DataKeys[0].ToString()); DUE00 due00 = selectHelper.SelectSingle <DUE00>(false, null, new List <ConditionFun.SqlqueryCondition>() { new ConditionFun.SqlqueryCondition(ConstraintType.Where, "Id", Comparison.Equals, Id, false, false) }); if (due00 != null) { if (due00.STATUS != SubsonicConstants.STATUS_NEW) { Alert.Show(string.Format("应付账单[{0}]不是存档状态无法核准")); return; } var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString()); int ret = updaterHelper.Update(string.Format("update DUE00 set status = 2 where status = 1 and id = {0}", Id)); if (ret == 1) { Alert.Show(string.Format("核准[{0}]成功", row.DataKeys[2].ToString())); } else { Alert.Show(string.Format("核准[{0}]失败", row.DataKeys[2].ToString())); } //加载页面 LoadData(); } else { Alert.Show(string.Format("核准失败,未查询到应付账单[{0}]", row.DataKeys[1].ToString())); } }catch (Exception e) { CommonBll.WriteLog("核准应付账单发生错误", e); Alert.Show("核准失败,核准发生异常,详情请见日志"); } }
/// <summary> /// 核准 /// </summary> public override void Approval() { GridRow row = resultGrid.SelectedRow; if (row == null) { Alert.Show("请选择需要核准的应付账单"); return; } try { int id = Convert.ToInt32(row.DataKeys[0].ToString()); RECEIVABLES00 pay = selectHelper.SelectSingle <RECEIVABLES00>(false, null, new List <ConditionFun.SqlqueryCondition>() { new ConditionFun.SqlqueryCondition(ConstraintType.Where, "Id", Comparison.Equals, id, false, false) }); if (SubsonicConstants.STATUS_NEW == pay.STATUS) { Alert.Show("应付账单状态不是存档状态,不能核准"); return; } else { var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString()); int ret = updaterHelper.Update(string.Format("update RECEIVABLES00 set status = 2 where status = 1 and id = {0}", id)); //核准时间 pay.MOD_DATETIME = DateTime.Now; //核准人 pay.MOD_USER_ID = OlUser.Manager_LoginName; pay.Save(); if (ret == 1) { Alert.Show(string.Format("出货单号[{0}]核准成功", pay.OUT_ID)); } else { Alert.Show(string.Format("出货单号[{0}]核准失败", pay.OUT_ID)); } LoadData(); } }catch (Exception e) { CommonBll.WriteLog(string.Format("id:{0}核准失败", row.DataKeys[0]), e); } }
/// <summary> /// Grid点击事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Grid1_RowCommand(object sender, FineUI.GridCommandEventArgs e) { GridRow gr = Grid1.Rows[e.RowIndex]; //获取当前点击列的主键ID object id = gr.DataKeys[0]; //因为要记录修改人,修改时间跟最后更新时间,所以将单字段更新换成多字段更新 switch (e.CommandName) { case "ENABLE": try { var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == OnlineUsersBll.GetInstence().GetUserHashKey()); Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("ENABLE", ConvertHelper.StringToByte(e.CommandArgument)); dic.Add("MOD_DATETIME", ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"))); dic.Add("MOD_USER_ID", OlUser.Manager_LoginName); dic.Add("LAST_UPDATE", ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"))); if (ConvertHelper.Cint0(id) > 0) { PROD_DEPBll.GetInstence().UpdateValue(this, ConvertHelper.Cint0(id), dic); } LoadData(); //PROD_KINDBll.GetInstence().Save(this, model); } catch (Exception err) { //出现异常,保存出错日志信息 CommonBll.WriteLog("保存失败", err); } //更新状态 //PROD_KINDBll.GetInstence().UpdateENABLE(this, ConvertHelper.Cint0(id), ConvertHelper.Cint0(e.CommandArgument)); //重新加载 //LoadData(); break; case "ButtonEdit": //打开编辑窗口 Window1.IFrameUrl = "ProdDepEdit.aspx?Id=" + id + "&" + MenuInfoBll.GetInstence().PageUrlEncryptStringNoKey(id + ""); Window1.Hidden = false; break; } }
/// <summary> /// 入库核准 /// </summary> public override void Approval() { string ma_id = GridViewHelper.GetSelectedKey(Grid1, true); string SHOP_ID = OnlineUsersBll.GetInstence().GetUserOnlineInfo("SHOP_ID").ToString(); string manager_LoginName = OnlineUsersBll.GetInstence().GetUserOnlineInfo("Manager_LoginName").ToString();//登录名 int result = Material00Bll.GetInstence().ApprovalReduceStock(SHOP_ID, ma_id, manager_LoginName); if (result == 0) { Alert.Show("核准成功!"); } else { Alert.Show("核准失败!请重新汇整"); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //获取ID值 hidId.Text = RequestHelper.GetQueryString("ORDER_Id") + ""; //部门 int Branch_Id = ConvertHelper.Cint0(OnlineUsersBll.GetInstence().GetUserOnlineInfo("Branch_Id").ToString()); //绑定下拉列表 PRODUCT00Bll.GetInstence().BandDropDownListShowProductName1(this, ddlPROD_NAME1); //加载数据 LoadData(); } }
/// <summary> /// 加载数据 /// </summary> public override void LoadData() { //获取登录用户 var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString()); //获取用户所属shop shopId = OlUser.SHOP_ID; //出货单号 string outNo = outId.Text; //状态 int status = 0; if (billStatus.SelectedIndex > 0) { status = Convert.ToInt32(billStatus.SelectedValue); } List <ConditionFun.SqlqueryCondition> conditionList = new List <ConditionFun.SqlqueryCondition>(); conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, "Id", Comparison.GreaterThan, 0, false, false)); string selectedValue = shopIdDropdown.SelectedValue; //添加门店过滤 if (selectedValue != null && !selectedValue.Equals(shopId)) { conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.And, "IN_SHOP", Comparison.Equals, selectedValue, false, false)); } //出货单号过滤 if (outNo != null && outNo.Trim().Length > 0) { conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.And, "OUT_ID", Comparison.Like, outNo + "%", false, false)); } //添加状态过滤 if (status > 0) { conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.And, "STATUS", Comparison.Equals, status, false, false)); } RECEIVABLES00Bll.GetInstence().BindGrid(resultGrid, 0, 30, conditionList); }
protected override void OnInit(EventArgs e) { base.OnInit(e); //检测用户是否超时退出 OnlineUsersBll.GetInstence().IsTimeOut(); if (!IsPostBack) { //检测当前页面是否有访问权限 //MenuInfoBll.GetInstence().CheckPagePower(this); #region 设置页面按键权限 try { //定义按键控件 Control btnControl = null; //找到页面放置按键控件的位置 ControlCollection controls = MenuInfoBll.GetInstence().GetControls(this.Controls, "toolBar"); //逐个读取出来 if (controls != null) { for (int i = 0; i < controls.Count; i++) { //取出控件 btnControl = controls[i]; //判断是否除了刷新、查询和关闭以外的按键 btnControl.ID != "ButtonAdd" && btnControl.ID != "ButtonEdit" && btnControl.ID != "ButtonDelete" && && btnControl.ID != "ButtonReset" if (btnControl.ID != "ButtonRefresh" && btnControl.ID != "ButtonSearch" && btnControl.ID != "ButtonClose" && btnControl.ID != "ButtonCancel") { //是的话检查该按键当前用户是否有控件权限,没有的话则禁用该按键 ((FineUI.Button)btnControl).Enabled = MenuInfoBll.GetInstence().CheckControlPower(this, btnControl.ID); } } } } catch (Exception) { } #endregion //记录用户当前所在的页面位置 CommonBll.UserRecord(this); } //运行UI页面初始化函数,子类继承后需要重写本函数,以提供给本初始化函数调用 Init(); }
/// <summary> /// 订货部门新增一行 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void ButtonOrderDepNewRow_Clikc(object sender, EventArgs e) { JObject deObject = new JObject(); deObject.Add("Id", "0"); deObject.Add("ORDDEP_ID", ""); deObject.Add("ORDDEP_NAME", ""); deObject.Add("ORDER_WEEK", ""); deObject.Add("USABLE", true); var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString()); string lgname = OlUser.Manager_LoginName; deObject.Add("CRT_USER_ID", lgname); deObject.Add("CRT_DATETIME", DateTime.Now.ToString()); deObject.Add("MOD_USER_ID", OlUser.Manager_LoginName); deObject.Add("MOD_DATETIME", DateTime.Now.ToString()); Grid1.AddNewRecord(deObject, true); }
protected void ddlORDER_DEP_SelectedIndexChanged(object sender, EventArgs e) { JArray mergedData = Grid1.GetMergedData(); int gridrowsCount = mergedData.Count; if (gridrowsCount > 0) { Window1.Hidden = false; } string SHOP_ID = OnlineUsersBll.GetInstence().GetUserOnlineInfo("SHOP_ID").ToString(); string ORDER_DEP_VALUE = ddlORDER_DEP.SelectedValue; if (SHOP_ID != "0") { PRODUCT00Bll.GetInstence().BandDropDownListShowProductName_1(this, DropDownList1, SHOP_ID); // (System.Web.UI.WebControls.DropDownList) } }
/// <summary>读取数据</summary> public override void LoadData() { #region 展示用户信息 //在线人数 txtOnlineUserCount.Text = OnlineUsersBll.GetInstence().GetUserOnlineCount() + ""; //当前用户信息 var userHashKey = OnlineUsersBll.GetInstence().GetUserHashKey(); var model = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == userHashKey); if (model == null) { return; } //用户名称 txtUser.Text = model.Manager_CName;// +" [" + IpHelper.GetUserIp() + "]"; //部门 txtSHOPName.Text = model.SHOP_NAME1; //职位 txtPositionInfoName.Text = model.Position_Name; #endregion #region 菜单栏数据绑定 //获取用户页面操作权限 _pagePower = OnlineUsersBll.GetInstence().GetPagePower(); //创建查询条件 var wheres = new List <ConditionFun.SqlqueryCondition>(); //条件:只查询出需要显示的菜单 wheres.Add(new ConditionFun.SqlqueryCondition(ConstraintType.And, MenuInfoTable.IsDisplay, Comparison.Equals, 1)); //进行查询,获取DataTable var dt = MenuInfoBll.GetInstence().GetDataTable(false, 0, null, 0, 0, wheres); //绑定树列表 BandingTree(dt); #endregion #region 开启时钟检测 Timer1.Enabled = true; #endregion }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { //获取ID值 hidId.Text = RequestHelper.GetInt0("Id") + ""; // SHOP_hidId.Text = OnlineUsersBll.GetInstence().GetUserOnlineInfo("SHOP_ID").ToString(); HiddenLastShop_Id.Text = OnlineUsersBll.GetInstence().GetUserOnlineInfo("SHOP_ID").ToString(); user = OnlineUsersBll.GetInstence().GetPosition_Name(this, OnlineUsersBll.GetInstence().GetManagerId(), false); if (user.Contains("区域管理员")) { ddlShop.Enabled = true; } else { ddlShop.Enabled = false; } //加载数据 LoadData(); // 删除选中单元格的客户端脚本 string deleteScript = GetDeleteScript(Grid1); // 删除选中行按钮 btnDelete.OnClientClick = Grid1.GetNoSelectionAlertReference("请至少选择一项!") + deleteScript; //deleteScript; //按钮 //ButtonApproval.Enabled = false; //ButtonSave.Enabled = false; } catch (Exception e1) { MessageBox.Show(this, e1.Message); } // LoadData(); } }
///// <summary> ///// 更换分店事件 ///// </summary> ///// <param name="sender"></param> ///// <param name="e"></param> //protected void shopIdDropdown_SelectedIndexChanged(object sender, EventArgs e) //{ // LoadData(); //} /// <summary> /// 汇整出货单 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Archive_Click(object sender, EventArgs e) { archiveWindow.Hidden = true; //获取登录用户 var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString()); //登录名 string userId = OlUser.Manager_LoginName; //获取用户所属shop shopId = OlUser.SHOP_ID; DatePicker dpStart = archiveWindow.FindControl("archiveDatePanel").FindControl("outStartDate") as DatePicker; DatePicker dpEnd = archiveWindow.FindControl("archiveDatePanel").FindControl("outEndDate") as DatePicker; List <ReceiveBillMain> previewList = new List <ReceiveBillMain>(); //出货单 List <ReceiveBillMain> tmpList = QueryOutBill(dpStart.Text, dpEnd.Text, userId); if (tmpList.Count > 0) { previewList.AddRange(tmpList); } //退货单 tmpList = QueryBackBill(dpStart.Text, dpEnd.Text, userId); if (tmpList.Count > 0) { previewList.AddRange(tmpList); } //Alert.Show(string.Format("汇整完成,共汇整{0}条出货单.", total)); previewWindow.Hidden = false; previewWindow.Top = 100; Grid previewGrid = previewWindow.FindControl("previewDataPanel").FindControl("previewDataGrid") as Grid; previewGrid.DataSource = previewList; previewGrid.DataBind(); }
protected void Grid2AddNewRow_Click(object sender, EventArgs e) { FineUI.Grid Grid3 = Window2.FindControl("PanelA").FindControl("Grid3") as FineUI.Grid; int[] selections = Grid3.SelectedRowIndexArray; string _ORDDEP_ID = hidORDDEP_ID.Text.ToString(); string result = ""; if (!String.IsNullOrEmpty(_ORDDEP_ID)) { foreach (int i in selections) { int _Id = ConvertHelper.Cint(Grid3.DataKeys[i][0].ToString()); var model = new PROD_DEP(x => x.Id == _Id); string checkResult = CheckDataAddDep(model.DEP_ID); if (!String.IsNullOrEmpty(checkResult)) { result = result + checkResult + Environment.NewLine; continue; } JObject deObject = new JObject(); deObject.Add("Id1", "0"); deObject.Add("ORDDEP_ID1", _ORDDEP_ID); deObject.Add("DEP_ID1", model.DEP_ID); deObject.Add("DEP_NAME1", model.DEP_NAME); deObject.Add("Meno", " "); deObject.Add("USABLE1", true); var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString()); string lgname = OlUser.Manager_LoginName; deObject.Add("CRT_USER_ID1", lgname); deObject.Add("CRT_DATETIME1", DateTime.Now.ToString()); deObject.Add("MOD_USER_ID1", OlUser.Manager_LoginName); deObject.Add("MOD_DATETIME1", DateTime.Now.ToString()); Grid2.AddNewRecord(deObject, true); } } if (!String.IsNullOrEmpty(result.Trim())) { FineUI.Alert.ShowInParent(result, FineUI.MessageBoxIcon.Information); } }
public override void Init() { //获取登录用户 var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString()); //获取用户所属shop shopId = OlUser.SHOP_ID; //绑定门店下拉列表 //SHOP00Bll.GetInstence().BandDropDownListShowShop1(this, shopIdDropdown); //查询查询所有分店 var shop = SHOP00Bll.GetInstence().GetModelForCache(s => s.SHOP_ID.Equals(shopId)); List <ConditionFun.SqlqueryCondition> shopCondition = new List <ConditionFun.SqlqueryCondition>(); shopCondition.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, "SHOP_Area_ID", Comparison.Equals, shop.SHOP_Area_ID, false, false)); List <SHOP00> shopList = selectHelper.Select <SHOP00>(false, 0, null, shopCondition, null).ExecuteTypedList <SHOP00>(); shopIdDropdown.DataSource = shopList; shopIdDropdown.DataTextField = "SHOP_NAME1"; shopIdDropdown.DataValueField = "SHOP_ID"; shopIdDropdown.DataBind(); foreach (SHOP00 shop00 in shopList) { shopDic[shop00.SHOP_ID] = shop00.SHOP_NAME1; } //初始化时间 DatePicker outStartDate = archiveWindow.FindControl("archiveDatePanel").FindControl("outStartDate") as DatePicker; outStartDate.SelectedDate = ConvertHelper.StringToDatetime(DateTime.Now.AddMonths(-1).ToString("yyyy-MM-dd 00:00:00")); DatePicker outEndDate = archiveWindow.FindControl("archiveDatePanel").FindControl("outEndDate") as DatePicker; outEndDate.SelectedDate = ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd 00:00:00")); }
public override void Approval() { string manager_LoginName = OnlineUsersBll.GetInstence().GetUserOnlineInfo("Manager_LoginName").ToString();//登录名 txtAPP_USER.Text = manager_LoginName; txtAPP_DATE.SelectedDate = DateTime.Now; ddlStatus.SelectedValue = "2"; string ORDER_ID = txtORDER_ID.Text.Trim(); var model = new ORDER00(x => x.ORDER_ID == ORDER_ID); model.APP_USER = txtAPP_USER.Text; model.APP_DATE = ConvertHelper.StringToDatetime(txtAPP_DATE.SelectedDate.ToString()); model.STATUS = 2; ORDER00Bll.GetInstence().Save(this, model); ButtonPowers(); }
protected void Grid1_PreDataBound(object sender, EventArgs e) { // 设置LinkButtonField的点击客户端事件 // LinkButtonField deleteField = Grid1.FindColumn("Delete") as LinkButtonField; // deleteField.OnClientClick = GetDeleteScript(Grid1); string SHOP_ID = OnlineUsersBll.GetInstence().GetUserOnlineInfo("SHOP_ID").ToString(); // string ORDER_DEP_VALUE = ddlORDER_DEP.SelectedValue; if (SHOP_ID != "0") { PRODUCT00Bll.GetInstence().BandDropDownListShowProductName_1(this, DropDownList1, SHOP_ID); // (System.Web.UI.WebControls.DropDownList) } //DropDownList1.DataTextField = PRODUCT00Table.PROD_NAME1; //DropDownList1.DataValueField = PRODUCT00Table.PROD_ID; // DropDownList1.SelectedValue = ((System.Data.DataRowView)(row)).Row.Table.Rows[e.RowIndex][PRODUCT00Table.PROD_ID].ToString(); }
protected void ButtonApproval_Click(object sender, EventArgs 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 user_id = OnlineUsersBll.GetInstence().GetManagerId().ToString(); int ex_int = OUT00Bll.GetInstence().SplitOrders(col_id, user_id); if (ex_int == 1) { Alert.Show("核准失败,请重新核准!"); } else { Alert.Show("核准成功!"); } }
public void btnSaveCONTRACT01() { JArray conJons = Grid2.GetMergedData(); for (int i = 0; i < conJons.Count; i++) { CONTRACT01 model = null; var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString()); if (conJons[i]["values"]["Id01"].ToString() == "0" || conJons[i]["status"].ToString() == "newadded") { model = new CONTRACT01(); model.CRT_DATETIME = ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")); model.CRT_USER_ID = OlUser.Manager_LoginName; } else { int _id = ConvertHelper.Cint(conJons[i]["values"]["Id01"].ToString()); model = new CONTRACT01(x => x.Id == _id); } model.MOD_DATETIME = ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")); model.LAST_UPDATE = ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")); model.MOD_USER_ID = OlUser.Manager_LoginName; model.CONTRACT_ID = conJons[i]["values"]["CONTRACT_ID01"].ToString(); model.PROD_ID = conJons[i]["values"]["PROD_ID01"].ToString(); model.CONTRACT_PRICE = ConvertHelper.StringToDecimal(conJons[i]["values"]["CONTRACT_PRICE01"].ToString()); model.CONTRACT_PRICE1 = ConvertHelper.StringToDecimal(conJons[i]["values"]["CONTRACT_PRICE101"].ToString()); model.CONTRACT_PRICE2 = ConvertHelper.StringToDecimal(conJons[i]["values"]["CONTRACT_PRICE201"].ToString()); string a = conJons[i]["values"]["USABLE01"].ToString(); if (conJons[i]["values"]["USABLE01"].ToString() == "True") { model.USABLE = 1; } else { model.USABLE = 0; } model.Meno = conJons[i]["values"]["Meno01"].ToString(); CONTRACT01Bll.GetInstence().Save(this, model); } }
/// <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("核准失败!请重新汇整"); } }