public void BandGrid2(string shop_name, string shop_idStr, string shop_id, string begTime, string endTime, int chooseSign) { conditionList = new List <ConditionFun.SqlqueryCondition>(); if (chooseSign == 0) { conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, ORDER00Table.SHOP_ID, Comparison.Equals, shop_id, false, false)); conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, ORDER00Table.INPUT_DATE, Comparison.BetweenAnd, begTime, false, false)); conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, ORDER00Table.INPUT_DATE, Comparison.BetweenAnd, endTime, false, false)); } else if (chooseSign == 1) { conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, ORDER00Table.SHOP_ID, Comparison.Equals, shop_id, false, false)); conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, ORDER00Table.EXPECT_DATE, Comparison.BetweenAnd, begTime, false, false)); conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, ORDER00Table.EXPECT_DATE, Comparison.BetweenAnd, endTime, false, false)); } else if (chooseSign == -1) { conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, "1", Comparison.Equals, "1", false, false)); } // ORDER00Bll.GetInstence().BindGrid(Grid2, 0, sortList); // bll.BindGrid(Grid2, 0, sortList); ORDER00Bll.GetInstence().BindGrid(Grid2, 0, 0, conditionList, sortList); //------------------ }
protected void Grid2_RowSelect(object sender, FineUI.GridRowSelectEventArgs e) { string ORDER_ID = GridViewHelper.GetSelectedKey(Grid2, true); if (ORDER_ID != "") { //获取指定ID的菜单内容,如果不存在,则创建一个菜单实体 var model = ORDER00Bll.GetInstence().GetModelForCache(x => x.ORDER_ID == ORDER_ID); if (model == null) { return; } //txtSHOP_ID.Text = model.SHOP_ID; // ddlShop.SelectedValue = model.SHOP_ID + ""; SHOP00Bll.GetInstence().GetShopList(this, model.SHOP_ID, ddlShop); //.BandDropDownListShowShop(this, ddlShop, shop_id); //分店名称 txtORDER_ID.Text = model.ORDER_ID; ddlShop.SelectedValue = model.SHOP_ID; txtINPUT_DATE.SelectedDate = ConvertHelper.StringToDatetime(model.INPUT_DATE.ToString()); txtORD_USER.Text = model.ORD_USER; ddlEXPECT_DATE.SelectedDate = model.EXPECT_DATE; ddlStatus.SelectedValue = model.STATUS + ""; ddlORD_TYPE.SelectedValue = model.ORD_TYPE.ToString(); ddlOUT_SHOP.Text = model.OUT_SHOP; txtEXPORTED_ID.Text = model.EXPORTED_ID.ToString(); txtEXPORTED.Checked = ConvertHelper.IsFloat(model.EXPORTED.ToString()); txtAPP_USER.Text = model.APP_USER; txtAPP_DATE.Text = model.APP_DATE.ToString(); txtMemo.Text = model.Memo; cbLOCKED.Checked = ConvertHelper.IsInt(model.LOCKED); ddlORDER_DEP.SelectedValue = model.ORD_DEP_ID + ""; txtCRT_DATETIME.SelectedDate = ConvertHelper.StringToDatetime(model.CRT_DATETIME.ToString()); txtCRT_USER_ID.Text = model.CRT_USER_ID.ToString(); txtMOD_DATETIME.SelectedDate = ConvertHelper.StringToDatetime(model.MOD_DATETIME.ToString()); txtMOD_USER_ID.Text = model.MOD_USER_ID.ToString(); txtLAST_UPDATE.Text = model.LAST_UPDATE.ToString(); cbTrans_STATUS.Checked = model.Trans_STATUS == 0 ? false : true; //价格区域 //var model_shop =new SHOP00(x => x.SHOP_ID == model.SHOP_ID); //string prcarea_id = model_shop.SHOP_Price_Area; DataTable table = GetSourceData(ORDER_ID, "0"); //获取订单下面所有的商品信息 Grid1.DataSource = table; Grid1.DataBind(); } //按钮权限 ButtonPowers(); }
public override void Init() { //逻辑对象赋值 bll = ORDER00Bll.GetInstence(); //表格对象赋值 grid = Grid1; }
protected void BindGrid2() { DataSet ds = null; ds = ORDER00Bll.GetInstence().Get_ORDER01_PRODUCT00_PRODUCT01_("5", ""); Grid2.DataSource = ds; Grid2.DataBind(); }
// 模拟在服务器端保存数据 // 特别注意:在真实的开发环境中,不要在Session放置大量数据,否则会严重影响服务器性能 private DataTable GetSourceData() { DataSet ds = null; ds = ORDER00Bll.GetInstence().Get_ORDER01_PRODUCT00_PRODUCT01_("4", ""); if (Session[KEY_FOR_DATASOURCE_SESSION] == null) { Session[KEY_FOR_DATASOURCE_SESSION] = ds.Tables[0];// DataSourceUtil.GetEmptyDataTable(); } return((DataTable)Session[KEY_FOR_DATASOURCE_SESSION]); }
public DataTable GetDataTable(string ORDER_ID, string PRCAREA_ID) { DataSet ds = null; if (ORDER_ID != "" && PRCAREA_ID != "") { ds = ORDER00Bll.GetInstence().Get_ORDER01_PRODUCT00_PRODUCT01_(ORDER_ID, PRCAREA_ID); } DataTable table = new DataTable(); // table.Columns.Add(new DataColumn("SNo", typeof(int))); table.Columns.Add(new DataColumn("ID", typeof(int))); table.Columns.Add(new DataColumn("PROD_NAME1", typeof(String))); table.Columns.Add(new DataColumn("PROD_ID", typeof(String))); table.Columns.Add(new DataColumn("PROD_SPEC", typeof(String))); table.Columns.Add(new DataColumn("PROD_UNIT", typeof(String))); table.Columns.Add(new DataColumn("ON_QUAN", typeof(String))); table.Columns.Add(new DataColumn("STD_PRICE", typeof(String))); table.Columns.Add(new DataColumn("QUAN1", typeof(String))); table.Columns.Add(new DataColumn("Order_QUAN", typeof(String))); table.Columns.Add(new DataColumn("PROD_MEMO", typeof(String))); int i = 0; if (ds != null) { DataRow row; foreach (DataRow item in ds.Tables[0].Rows) { i = i + 1; row = table.NewRow(); row[0] = i;//int.Parse(item["SNo"].ToString()); // row[1] = item["PROD_NAME1"].ToString(); row[2] = item["PROD_ID"].ToString(); row[3] = item["PROD_SPEC"].ToString(); row[4] = item["PROD_UNIT"].ToString(); row[5] = item["ON_QUAN"].ToString(); row[6] = item["STD_PRICE"].ToString(); row[7] = item["QUAN1"].ToString(); row[8] = item["Order_QUAN"].ToString(); row[9] = item["PROD_MEMO"].ToString(); table.Rows.Add(row); } } return(table); }
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(); }
/// <summary> /// 数据保存 /// </summary> /// <returns></returns> public override string Save() { string result = string.Empty; int id = ConvertHelper.Cint0(hidId.Text); try { //判断 if (ddlShop.SelectedValue == "0") { return(ddlShop.Label + "不能为空!"); } if (ddlOUT_SHOP.SelectedValue == "0") { return(ddlOUT_SHOP.Label + "不能为空!"); } if (ddlORDER_DEP.SelectedValue == "0") { return(ddlORDER_DEP.Label + "不能为空!"); } //订单编号 if (txtORDER_ID.Text == "") { Random ran = new Random(); txtORDER_ID.Text = ddlShop.SelectedValue + "OR" + DateTime.Now.ToString("yyyy-MM-dd").Replace("-", "") + ran.Next(1000, 9999); } string manager_LoginName = OnlineUsersBll.GetInstence().GetUserOnlineInfo("Manager_LoginName").ToString();//登录名 txtAPP_USER.Text = manager_LoginName; txtAPP_DATE.SelectedDate = DateTime.Now; string ORDER_ID = txtORDER_ID.Text; // GridViewHelper.GetSelectedKey(Grid2, true); //获取价格区域 string shop_id = OnlineUsersBll.GetInstence().GetUserOnlineInfo("SHOP_ID").ToString(); var model_SHOP = new SHOP00(x => x.SHOP_ID == shop_id); string prcarea_id = model_SHOP.SHOP_Price_Area; // 复制原始表格的结构 DataTable newTable = GetSourceData(ORDER_ID, prcarea_id).Clone(); DataRow newRow; JArray mergedData = Grid1.GetMergedData(); int i = 0; foreach (JObject mergedRow in mergedData) { string status = mergedRow.Value <string>("status"); int rowIndex = mergedRow.Value <int>("index"); JObject values = mergedRow.Value <JObject>("values"); i = i + 1; newRow = newTable.NewRow(); newRow[0] = rowIndex;//i;////j;// rowIndex; // 将行标识符设置为行索引号 newRow[1] = values.Value <string>("PROD_NAME1"); newRow[2] = values.Value <string>("PROD_ID"); newRow[3] = values.Value <string>("PROD_SPEC"); newRow[4] = values.Value <string>("PROD_UNIT"); newRow[5] = values.Value <string>("ON_QUAN"); newRow[6] = values.Value <string>("STD_PRICE"); newRow[7] = values.Value <string>("QUAN1"); newTable.Rows.Add(newRow); } // 更新数据源 Session[KEY_FOR_DATASOURCE_SESSION] = newTable; labResult.Text = ""; // String.Format("用户修改的数据:<pre>{0}</pre>", Grid1.GetModifiedData().ToString(Newtonsoft.Json.Formatting.Indented)); // MessageBox.Show(this,String.Format("用户修改的数据:<pre>{0}</pre>", Grid1.GetModifiedData().ToString(Newtonsoft.Json.Formatting.Indented))); // DataTable table = GetSourceData(); Grid1.DataSource = (DataTable)Session[KEY_FOR_DATASOURCE_SESSION];// table; Grid1.DataBind(); #region 数据验证 //判断列表 DataTable dt = (DataTable)Session[KEY_FOR_DATASOURCE_SESSION]; if (dt.Rows.Count <= 0 || Session[KEY_FOR_DATASOURCE_SESSION] == null) { return("要货明细不能为空!"); } #endregion //改变界面 ddlStatus.SelectedValue = "1" + ""; #region 赋值 主表 var model = new ORDER00(x => x.ORDER_ID == ORDER_ID); model.SHOP_ID = ddlShop.SelectedValue; model.ORDER_ID = txtORDER_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 = 1; model.ORD_TYPE = ConvertHelper.Cint0(ddlORD_TYPE.SelectedValue); model.OUT_SHOP = ddlOUT_SHOP.SelectedValue; model.EXPORTED_ID = txtEXPORTED_ID.Text; model.EXPORTED = ConvertHelper.StringToByte(txtEXPORTED.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(cbLOCKED.Checked.ToString()); model.ORD_DEP_ID = ddlORDER_DEP.SelectedValue; 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 = 0; #endregion //---------------------------------------------------------- //存储到数据库 ORDER00Bll.GetInstence().Save(this, model); //清空子表 ORDER00Bll.GetInstence().Delete(model.ORDER_ID); #region 添加子表 JArray mergedData1 = Grid1.GetMergedData(); int f = mergedData.Count; int k = 0; foreach (JObject mergedRow in mergedData1) { string status = mergedRow.Value <string>("status"); int rowIndex = mergedRow.Value <int>("index"); JObject values = mergedRow.Value <JObject>("values"); k = k + 1; var model_1 = new ORDER01(x => x.SNo == k && x.ORDER_ID == txtORDER_ID.Text.Trim()); model_1.SNo = k;// rowIndex + 1; model_1.SHOP_ID = ddlShop.SelectedValue; model_1.ORDER_ID = txtORDER_ID.Text.Trim(); model_1.PROD_ID = values.Value <string>("PROD_ID"); model_1.QUANTITY = 0; model_1.ON_QUAN = ConvertHelper.StringToDecimal(values.Value <string>("ON_QUAN")); model_1.QUAN1 = ConvertHelper.StringToDecimal(values.Value <string>("QUAN1"));//小计 model_1.QUAN2 = 0; model_1.COST_PRICE = ConvertHelper.StringToDecimal(values.Value <string>("STD_PRICE")); model_1.STD_UNIT = values.Value <string>("PROD_UNIT"); model_1.STD_CONVERT = 0; model_1.STD_QUAN = ConvertHelper.StringToDecimal(values.Value <string>("ON_QUAN")); model_1.STD_PRICE = ConvertHelper.StringToDecimal(values.Value <string>("STD_PRICE")); model_1.Memo = ""; model_1.CRT_DATETIME = DateTime.Now; model_1.CRT_USER_ID = txtCRT_USER_ID.Text; model_1.MOD_DATETIME = DateTime.Now; model_1.MOD_USER_ID = txtMOD_USER_ID.Text; //---------------------------------------------------------- //存储到数据库 ORDER01Bll.GetInstence().Save(this, model_1); } ///grid2 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); #endregion } catch (Exception e) { result = "保存失败!"; //出现异常,保存出错日志信息 CommonBll.WriteLog(result, e); } return(result); }
protected void ButtonOrderSearch_Click(Object sender, EventArgs e) { FineUI.Grid grid4 = Window4.FindControl("PanelGrid5").FindControl("Grid4") as FineUI.Grid; ORDER00Bll.GetInstence().BindGrid(grid4, 0, 0, OrderCondition(), null); }
/// <summary>读取数据</summary> public override void LoadData() { int id = ConvertHelper.Cint0(hidId.Text); if (id != 0) { //获取指定ID的菜单内容,如果不存在,则创建一个菜单实体 var model = ORDER00Bll.GetInstence().GetModelForCache(x => x.Id == id); if (model == null) { return; } txtSHOP_ID.Text = model.SHOP_ID; txtORDER_ID.Text = model.ORD_DEP_ID; txtINPUT_DATE.Text = model.INPUT_DATE.ToString(); txtORD_USER.Text = model.ORD_USER; ddlEXPECT_DATE.SelectedDate = model.EXPECT_DATE; ddlStatus.SelectedValue = model.STATUS.ToString(); ddlORD_TYPE.SelectedValue = model.ORD_TYPE.ToString(); ddlOUT_SHOP.Text = model.OUT_SHOP; txtEXPORTED_ID.Text = model.EXPORTED_ID.ToString(); txtEXPORTED.Text = model.EXPORTED.ToString(); txtAPP_USER.Text = model.APP_USER; txtAPP_DATE.Text = model.APP_DATE.ToString(); txtMemo.Text = model.Memo; cbLOCKED.Checked = ConvertHelper.IsInt(model.LOCKED); ddlBranch.SelectedValue = model.ORD_DEP_ID; 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(); } else //添加 //表头 { SHOP00Bll.GetInstence().BandDropDownListShowShop(this, ddlShop, ""); //分店名称 txtINPUT_DATE.SelectedDate = DateTime.Now; //单据时间 ddlStatus.SelectedValue = "1"; //状态 ddlEXPECT_DATE.SelectedDate = DateTime.Now.AddDays(1); int managerId = OnlineUsersBll.GetInstence().GetManagerId();//获取登录名 txtManage.Text = OnlineUsersBll.GetInstence().GetManager_LoginName(this, managerId, true); } // FineUI.DropDownList dddlPROD_NAME2 = Window2.FindControl("ddlPROD_NAME2") as FineUI.DropDownList; // PRODUCT00Bll.GetInstence().BandDropDownListShowProductName1(this, dddlPROD_NAME2); // dddlPROD_NAME2.SelectedIndexChanged += new EventHandler(ddlPROD_NAME2_SelectedIndexChanged); // ddlPROD_NAME2 DataTable table = GetSourceData(); Grid1.DataSource = table; Grid1.DataBind(); }
/// <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 ORDER00(x => x.Id == id); model.SHOP_ID = txtSHOP_ID.Text; model.ORDER_ID = txtORDER_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(ddlStatus.SelectedValue); model.ORD_TYPE = ConvertHelper.Cint0(ddlORD_TYPE.SelectedValue); model.OUT_SHOP = ddlOUT_SHOP.SelectedValue; model.EXPORTED_ID = txtEXPORTED_ID.Text; model.EXPORTED = ConvertHelper.StringToByte(txtEXPORTED.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(cbLOCKED.Checked.ToString()); model.ORD_DEP_ID = ddlBranch.SelectedValue; 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 //---------------------------------------------------------- //存储到数据库 ORDER00Bll.GetInstence().Save(this, model); } catch (Exception e) { result = "保存失败!"; //出现异常,保存出错日志信息 CommonBll.WriteLog(result, e); } return(result); }
/// <summary>读取数据</summary> public override void LoadData() { //绑定事件 //关闭窗口 ButtonCancel.OnClientClick = ActiveWindow.GetHideReference(); string id = hidId.Text.Trim(); if (id != "0") { //获取指定ID的菜单内容,如果不存在,则创建一个菜单实体 var model = ORDER00Bll.GetInstence().GetModelForCache(x => x.ORDER_ID == id); if (model == null) { return; } txtSHOP_ID.Text = model.SHOP_ID; txtORDER_ID.Text = model.ORD_DEP_ID; txtINPUT_DATE.Text = model.INPUT_DATE.ToString(); txtORD_USER.Text = model.ORD_USER; ddlEXPECT_DATE.SelectedDate = model.EXPECT_DATE; ddlStatus.SelectedValue = model.STATUS.ToString(); ddlORD_TYPE.SelectedValue = model.ORD_TYPE.ToString(); ddlOUT_SHOP.Text = model.OUT_SHOP; txtEXPORTED_ID.Text = model.EXPORTED_ID.ToString(); txtEXPORTED.Text = model.EXPORTED.ToString(); txtAPP_USER.Text = model.APP_USER; txtAPP_DATE.Text = model.APP_DATE.ToString(); txtMemo.Text = model.Memo; cbLOCKED.Checked = ConvertHelper.IsInt(model.LOCKED); ddlBranch.SelectedValue = model.ORD_DEP_ID; 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(); } else //添加 //表头 { SHOP00Bll.GetInstence().BandDropDownListShowShop(this, ddlShop, ""); //分店名称 txtINPUT_DATE.SelectedDate = DateTime.Now; //单据时间 ddlStatus.SelectedValue = "1"; //状态 ddlEXPECT_DATE.SelectedDate = DateTime.Now.AddDays(1); int managerId = OnlineUsersBll.GetInstence().GetManagerId();//获取登录名 txtManage.Text = OnlineUsersBll.GetInstence().GetManager_LoginName(this, managerId, true); //windows //Window2.Title = "添加"; } // FineUI.DropDownList dddlPROD_NAME2 = Window2.FindControl("ddlPROD_NAME2") as FineUI.DropDownList; }