private void dgv_show() { dgv.Rows.Clear(); var companyCode = companies[ComboShopName.SelectedIndex].Split(Constants.SplitChar)[0]; if (companyCode == "") { MessageBox.Show("未定义连锁店铺,请先到连锁店铺定义!"); return; } string errorDesc = ""; var comments = ShopManagement.queryCommentByCompany(MainForm.ip, companyCode, out errorDesc); if (comments == null) { MessageBox.Show(errorDesc); return; } int i = 1; foreach (var comment in comments) { dgv.Rows.Add(i, comment.content, PCUtil.converJavaTimeToNetTime(comment.createTime).ToString("MM-dd HH:mm")); i++; } }
private void BTRegister_Click(object sender, EventArgs e) { string code = TextCode.Text.Trim(); if (code == "") { BathClass.printErrorMsg("公司代码为空!"); return; } string name = TextName.Text.Trim(); if (name == "") { BathClass.printErrorMsg("公司名称为空!"); return; } string errorDesc = ""; var success = ShopManagement.registerCompany(LogIn.connectionIP, code, name, TextTel.Text.Trim(), TextTel.Text.Trim(), out errorDesc); if (success) { var db = new BathDBDataContext(LogIn.connectionString); db.Options.FirstOrDefault().company_Code = code; db.SubmitChanges(); this.DialogResult = DialogResult.OK; this.Close(); } else { BathClass.printErrorMsg(errorDesc); } }
/// <summary> /// 购物车结算跳转到确认订单页面 /// </summary> /// <param name="id"></param> /// <param name="num"></param> /// <returns></returns> public JsonResult ShoPay(string id, string num) { //将传送过来的只转换为数组 string[] shopid = id.Split(','); string[] shopnum = num.Split(','); SportsDBEntities sde = new SportsDBEntities(); //保存对象的内容 List <ShopManagement> slist = new List <ShopManagement>(); //进行每一个的修改 for (int i = 0; i < shopid.Length - 1; i++) { int cartId = Convert.ToInt32(shopid[i]); ShopManagement s = sde.ShopManagement.Where(a => a.cart_id == cartId).FirstOrDefault(); //添加数据到订单 add_deil(s, cartId); s.cart_quantity = Convert.ToInt32(shopnum[i]); //修改 sde.SaveChanges(); //执行数据库修改 slist.Add(s); } //用户编号 int uid = Convert.ToInt32(Session["uid"]); //查询用户的默认地址 List <tbl_AddressInfo> tbladdrss = sde.tbl_AddressInfo.Where(a => a.userid == uid).ToList(); Session["Address"] = tbladdrss; //收货地址 Session["slist"] = slist; //物品信息 return(Json(1)); }
public static ShopManagementVM SetSubData(ShopManagement model, bool isSetItem) { var data = ShopManagementVM.MToVM(model); data.ProfileImage = ImageLinkStorageVM.MToVM(ImageLinkStorageService.GetByID(model.ProfileImage, model.ID, model.API)); data.Items = isSetItem ? IS_ItemService.SetSubDatas(IS_ItemService.GetByOID(model.ID, model.API), model.API) : new List <IS_ItemVM>(); return(data); }
//--------------------------------------------------------------- public void DisplaySearchPanel() { /*HideInputPanel (); * HideMapSelectPanel (); * searchPanel.SetActive(true);*/ string nameOfThisScene = SceneManager.GetActiveScene().name; ShopManagement.SetPreviousSceneName(nameOfThisScene); LevelManager.SLoadLevel("02 Shop"); }
/// <summary> /// 将物品添加到购物车中 /// </summary> /// <param name="GoodsMsg"></param> /// <returns></returns> public ActionResult GoodsShop(string GoodsMsg) { //将传过来的字符串转换为数组 string[] msg = GoodsMsg.Split(','); if (Session["name"] == null) { Response.Write(99); Response.End(); return(View()); } SportsDBEntities sde = new SportsDBEntities(); //使用EF int uid = Convert.ToInt32(Session["uid"]); //用户编号 int gid = Convert.ToInt32(msg[0]); //商品编号 string CodeNumber = msg[4]; //尺寸 string color = msg[3]; //颜色 int sid = Convert.ToInt32(msg[7]); //商店id ShopManagement smm = sde.ShopManagement.Where(a => a.userid == uid && a.GoodsInfo_ID == gid && a.StoreInfo_ID == sid && a.cart_color == color && a.cart_CodeNumber == CodeNumber).FirstOrDefault(); if (smm != null) { int num = Convert.ToInt32(msg[6]); //数量 smm.cart_quantity = num + smm.cart_quantity; //修改数量 int count = sde.SaveChanges(); //执行数据库的修改 Response.Write(count); Response.End(); return(View()); } else { //实例化一个新的购物车类 ShopManagement sm = new ShopManagement(); sm.cart_addtime = DateTime.Now; sm.GoodsInfo_ID = Convert.ToInt32(msg[0]); sm.cart_remark = msg[1]; sm.cart_photo = msg[2]; sm.cart_color = msg[3]; sm.cart_CodeNumber = msg[4]; sm.userid = Convert.ToInt32(Session["uid"]); sm.StoreInfo_ID = Convert.ToInt32(msg[7]); sm.cart_price = Convert.ToDecimal(msg[5]); sm.cart_quantity = Convert.ToInt32(msg[6]); //添加 sde.Entry(sm).State = System.Data.EntityState.Added; int count = sde.SaveChanges(); Response.Write(count); Response.End(); return(View()); } }
/// <summary> /// 购物车结算加入待付款 /// </summary> /// <param name="s"></param> /// <param name="num"></param> public void add_deil(ShopManagement s, int num) { SportsDBEntities sde = new SportsDBEntities(); //生成不重复的订单编号 string str = Guid.NewGuid().ToString().Replace("-", ""); //总价 decimal?money = num * s.cart_price; //用户编号 int uid = Convert.ToInt32(Session["uid"]); //添加订单表 OrderBySeller obs = new OrderBySeller(); obs.order_createTime = DateTime.Now; obs.order_status = 1; obs.orderdetails_status = -1; obs.order_cost = money; obs.userid = uid; obs.GoodsInfo_ID = s.GoodsInfo_ID; obs.order_no = str; obs.order_paytime = DateTime.Now; sde.Entry(obs).State = System.Data.EntityState.Added;//执行添加操作 sde.SaveChanges(); //查询当前的订单编号 OrderBySeller os = sde.OrderBySeller.Where(a => a.order_no == str).FirstOrDefault(); //当前订单编号 int orderId = Convert.ToInt32(os.order_id); //添加订单详情表 tbl_orderdetailsInfo tod = new tbl_orderdetailsInfo(); tod.orderdetails_totalprice = money; tod.orderdetails_quantity = num; tod.cart_color = s.cart_color; tod.cart_CodeNumber = s.cart_CodeNumber; tod.cart_photo = s.cart_photo; tod.cart_remark = s.cart_remark; tod.orderdetails_unitprice = s.cart_price; tod.GoodsInfo_id = s.GoodsInfo_ID; tod.order_id = orderId; tod.orderdetails_price = money; tod.StoreInfo_ID = s.StoreInfo_ID; tod.UserInfo_id = uid; //添加操作 sde.Entry(tod).State = System.Data.EntityState.Added; //数据库执行操作返回状态 sde.SaveChanges(); }
/// <summary> /// 删除多个商品 /// </summary> /// <returns></returns> public JsonResult DeleteCartAll(string id) { string[] aid = id.Split(','); SportsDBEntities sde = new SportsDBEntities(); for (int i = 0; i < aid.Length - 1; i++) { int cartid = Convert.ToInt32(aid[i]); ShopManagement sm = new ShopManagement(); sm.cart_id = cartid; sde.Entry(sm).State = System.Data.EntityState.Deleted; } int count = sde.SaveChanges(); return(Json(count)); }
//按日期查询 private void BTDateFind_Click(object sender, EventArgs e) { string errorDesc = ""; var shopYeJis = ShopManagement.queryYeJi(LogIn.connectionIP, companyCodes, DPDate.Value.ToString("yyyy-MM-dd"), "D", out errorDesc); if (shopYeJis == null) { BathClass.printErrorMsg(errorDesc); return; } DgvDateStores.Rows.Clear(); DgvDateTotal.Rows.Clear(); DgvDateTotal.Rows.Add( MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.accountCash), 0), MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.accountbankUnion), 0), MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.cardSaleCash), 0), MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.cardSaleBankUnion), 0), MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.totalRevenue), 0), MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.creditCard), 0), MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.coupon), 0), MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.groupBuy), 0), MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.server), 0), MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.zero), 0), MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.wipeZero), 0)); foreach (var shopYeJi in shopYeJis) { DgvDateStores.Rows.Add( shopYeJi.companyName, shopYeJi.accountCash, shopYeJi.accountbankUnion, shopYeJi.cardSaleCash, shopYeJi.cardSaleBankUnion, shopYeJi.totalRevenue, shopYeJi.creditCard, shopYeJi.coupon, shopYeJi.groupBuy, shopYeJi.server, shopYeJi.zero, shopYeJi.wipeZero); } }
//按照月查询 private void BTMonthFind_Click(object sender, EventArgs e) { string errorDesc = ""; var shopYeJis = ShopManagement.queryYeJi(MainForm.ip, companyCodes, CBYear.Text + "-" + CBMonth.Text, "M", out errorDesc); if (shopYeJis == null) { MessageBox.Show(errorDesc); return; } DgvMonthStores.Rows.Clear(); DgvMonthTotal.Rows.Clear(); DgvMonthTotal.Rows.Add( MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.accountCash), 0), MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.accountbankUnion), 0), MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.cardSaleCash), 0), MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.cardSaleBankUnion), 0), MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.totalRevenue), 0), MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.creditCard), 0), MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.coupon), 0), MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.groupBuy), 0), MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.server), 0), MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.zero), 0), MConvert <double> .ToTypeOrDefault(shopYeJis.Sum(x => x.wipeZero), 0)); foreach (var shopYeJi in shopYeJis) { DgvMonthStores.Rows.Add( shopYeJi.companyName, shopYeJi.accountCash, shopYeJi.accountbankUnion, shopYeJi.cardSaleCash, shopYeJi.cardSaleBankUnion, shopYeJi.totalRevenue, shopYeJi.creditCard, shopYeJi.coupon, shopYeJi.groupBuy, shopYeJi.server, shopYeJi.zero, shopYeJi.wipeZero); } }
private void dgv_show() { string errorDesc = ""; var comments = ShopManagement.queryCommentByCompany(LogIn.connectionIP, LogIn.options.company_Code, out errorDesc); if (comments == null) { BathClass.printErrorMsg(errorDesc); return; } int i = 1; foreach (var comment in comments) { dgv.Rows.Add(i, comment.content, PCUtil.converJavaTimeToNetTime(comment.createTime).ToString("MM-dd HH:mm")); i++; } }
//添加 private void BTAdd_Click(object sender, EventArgs e) { var code = TextCode.Text.Trim(); if (code == "") { MessageBox.Show("需要输入内容!"); return; } if (!StringUtil.isEmpty(companies.FirstOrDefault(x => x.Split(Constants.SplitChar)[0] == code))) { MessageBox.Show("已经包含该店铺,不能重复添加!"); return; } //需要连接服务器检验code是否存在! string errorDesc = ""; var customer = ShopManagement.queryCustomer(MainForm.ip, code, out errorDesc); if (customer == null) { if (!StringUtil.isEmpty(errorDesc)) { MessageBox.Show(errorDesc); } else { MessageBox.Show("该店铺代码不存在,请确认!"); TextCode.SelectAll(); TextCode.Focus(); } return; } //companyCodes.Add(code); companies.Add(joinCustomer(customer)); IOUtil.set_config_by_key(ConfigKeys.KEY_COMPANY_CODE, string.Join(Constants.BIG_SPLITCHAR.ToString(), companies.ToArray())); dgv_show(); TextCode.Text = ""; TextCode.Focus(); }