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();
}
