public ActionResult CompleteOrder1(List <Model.ViewModel.CartsView> list) { //string result = Newtonsoft.Json.JsonConvert.SerializeObject(list); //List<Model.ViewModel.CartsView> list1 = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ViewModel.CartsView>>(result); int _userId = Convert.ToInt32(Session["userId"]); Model.Orders orders = ordersBll.LoadEntity(m => m.userId == _userId).FirstOrDefault(); foreach (var item in list) { Model.OrderDetail orderDetail = new Model.OrderDetail() { OrderDetail_Id = Convert.ToInt32(CreateId.CreateNum()), order_no = orders.orderId, Pid = item.ProductId, pname = item.Pname, pnum = item.Pcount, p_price = item.Price, subtotal = item.Pcount * item.Price }; if (orderDetailBll.addEntity(orderDetail)) { flag = true; } else { flag = false; } } cartsBll.EmptyCarts(_userId); return(Json(new { flag1 = flag }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 实体转换 /// <summary> private static Model.OrderDetail TranEntity(DataRow dr) { if (dr != null) { Model.OrderDetail model = new Model.OrderDetail(); if (!string.IsNullOrEmpty(dr["Id"].ToString())) { model.Id = int.Parse(dr["Id"].ToString()); } if (!string.IsNullOrEmpty(dr["IsDeleted"].ToString())) { model.IsDeleted = bool.Parse(dr["IsDeleted"].ToString()); } if (!string.IsNullOrEmpty(dr["Status"].ToString())) { model.Status = int.Parse(dr["Status"].ToString()); } model.Code = dr["Code"].ToString(); model.OrderCode = dr["OrderCode"].ToString(); if (!string.IsNullOrEmpty(dr["GId"].ToString())) { model.GId = int.Parse(dr["GId"].ToString()); } if (!string.IsNullOrEmpty(dr["GCount"].ToString())) { model.GCount = decimal.Parse(dr["GCount"].ToString()); } if (!string.IsNullOrEmpty(dr["BuyPrice"].ToString())) { model.BuyPrice = decimal.Parse(dr["BuyPrice"].ToString()); } if (!string.IsNullOrEmpty(dr["TotalMoney"].ToString())) { model.TotalMoney = decimal.Parse(dr["TotalMoney"].ToString()); } if (!string.IsNullOrEmpty(dr["CreatedTime"].ToString())) { model.CreatedTime = DateTime.Parse(dr["CreatedTime"].ToString()); } model.CreatedBy = dr["CreatedBy"].ToString(); if (!string.IsNullOrEmpty(dr["ReCount"].ToString())) { model.ReCount = decimal.Parse(dr["ReCount"].ToString()); } return(model); } else { return(null); } }
protected override void SetPowerZone() { Spare2.DataSource = BLL.C_Car.GetList(" IsDelete = 0 and CType='牵引车' order by ID"); Spare2.DataTextField = "PZCode"; Spare2.DataValueField = "PZCode"; Spare2.DataBind(); CSpare2.DataSource = BLL.C_Car.GetList(" IsDelete = 0 and CType='挂车' order by ID"); CSpare2.DataTextField = "PZCode"; CSpare2.DataValueField = "PZCode"; CSpare2.DataBind(); //ListItem lt = new ListItem(); //lt.Value = ""; //lt.Text = "空项"; //CSpare2.Items.Insert(0, lt); CarSJ1.DataSource = BLL.Member.ManageMember.GetMemberEntityList(" RoleCode='SiJi' AND FMID='1' AND IsClock=0 AND IsClose=0 order by ID"); CarSJ1.DataTextField = "MName"; CarSJ1.DataValueField = "MID"; //CarSJ1.Items.Insert(0, "--请选择--"); CarSJ1.DataBind(); CarSJ2.DataSource = BLL.Member.ManageMember.GetMemberEntityList(" RoleCode='SiJi' AND FMID IN('2','3') AND IsClock=0 AND IsClose=0 order by ID"); CarSJ2.DataTextField = "MName"; CarSJ2.DataValueField = "MID"; CarSJ2.DataBind(); //CarSJ2.Items.Insert(0, "--请选择--"); if (!string.IsNullOrEmpty(Request.QueryString["oid"])) { ocode.Value = Request.QueryString["oid"]; oid.Value = Request.QueryString["oid"]; } if (!string.IsNullOrEmpty(Request.QueryString["id"])) { string id = Request.QueryString["id"]; Model.C_CarTast car = BLL.C_CarTast.GetModel(Convert.ToInt32(id)); Spare2.Value = car.Spare2.ToString(); CSpare2.Value = car.CSpare2.ToString(); CarSJ1.Value = car.CarSJ1.ToString(); CarSJ2.Value = car.CarSJ2.ToString(); if (!string.IsNullOrEmpty(car.OCode)) { Model.OrderDetail od = BLL.OrderDetail.GetModelCode(car.OCode); goodcount = od.GCount.ToString(); Model.Goods good = BLL.Goods.GetModel(od.GId.ToString()); goodname = good.GName; } } }
/// <summary> /// 更新一条数据 /// </summary> public static Hashtable Update(Model.OrderDetail model, Hashtable MyHs) { string guid = Guid.NewGuid().ToString(); StringBuilder strSql = new StringBuilder(); strSql.Append("update OrderDetail set "); strSql.Append(" IsDeleted = @IsDeleted , "); strSql.Append(" Status = @Status , "); strSql.Append(" Code = @Code , "); strSql.Append(" OrderCode = @OrderCode , "); strSql.Append(" GId = @GId , "); strSql.Append(" GCount = @GCount , "); strSql.Append(" BuyPrice = @BuyPrice , "); strSql.Append(" TotalMoney = @TotalMoney , "); strSql.Append(" CreatedTime = @CreatedTime , "); strSql.Append(" CreatedBy = @CreatedBy, "); strSql.Append(" ReCount = @ReCount "); strSql.Append(" where Id=@Id "); strSql.AppendFormat(" ;select '{0}'", guid); SqlParameter[] parameters = { new SqlParameter("@IsDeleted", SqlDbType.Bit, 1), new SqlParameter("@Status", SqlDbType.Int, 4), new SqlParameter("@Code", SqlDbType.VarChar, 50), new SqlParameter("@OrderCode", SqlDbType.VarChar, 50), new SqlParameter("@GId", SqlDbType.Int, 4), new SqlParameter("@GCount", SqlDbType.Decimal, 9), new SqlParameter("@BuyPrice", SqlDbType.Decimal, 9), new SqlParameter("@TotalMoney", SqlDbType.Decimal, 9), new SqlParameter("@CreatedTime", SqlDbType.DateTime), new SqlParameter("@CreatedBy", SqlDbType.VarChar, 50), new SqlParameter("@ReCount", SqlDbType.Decimal, 9), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.IsDeleted; parameters[1].Value = model.Status; parameters[2].Value = model.Code; parameters[3].Value = model.OrderCode; parameters[4].Value = model.GId; parameters[5].Value = model.GCount; parameters[6].Value = model.BuyPrice; parameters[7].Value = model.TotalMoney; parameters[8].Value = model.CreatedTime; parameters[9].Value = model.CreatedBy; parameters[10].Value = model.ReCount; parameters[11].Value = model.Id; MyHs.Add(strSql.ToString(), parameters); return(MyHs); }
protected decimal GetOrderDetailCount(object gid) { Model.Order objOrder = (Model.Order)ViewState["OrderInfo"]; if (objOrder != null) { int goodId = Convert.ToInt32(gid); Model.OrderDetail od = objOrder.OrderDetail.Where(c => c.GId == goodId).FirstOrDefault(); if (od != null) { return(od.GCount); } } return(0); }
public Model.OrderDetail GetBlankOrderDetail() { var orderDetailData = new Model.OrderDetail(); try { orderDetailData.Products = GetProducts(); } catch (Exception ex) { logger.LogError(ex, ex.Message); } return(orderDetailData); }
protected override void SetValue(string id) { Model.Account c = BLL.Account.GetModel(int.Parse(id)); CName.Value = c.CName; SuppName.Value = c.SupplierName; type.Value = c.AType.ToString(); Model.C_CarTast tast = BLL.C_CarTast.GetModel(c.CID); if (!string.IsNullOrEmpty(tast.OCode)) { Model.OrderDetail od = BLL.OrderDetail.GetModelCode(tast.OCode); Model.Goods goods = BLL.Goods.GetModel(od.GId); GoodName.Value = goods.GName; txtGoodCount.Value = c.OrderCount.ToString(); txtGoodPrice.Value = c.OrderPrice.ToString(); } Remark.Value = c.Spare2.ToString(); fid.Value = c.ID.ToString(); }
/// <summary> /// 增加一条数据 /// </summary> public static Hashtable Insert(Model.OrderDetail model, Hashtable MyHs) { string guid = Guid.NewGuid().ToString(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into OrderDetail("); strSql.Append("IsDeleted,Status,Code,OrderCode,GId,GCount,BuyPrice,TotalMoney,CreatedTime,CreatedBy,ReCount"); strSql.Append(") values ("); strSql.Append("@IsDeleted,@Status,@Code,@OrderCode,@GId,@GCount,@BuyPrice,@TotalMoney,@CreatedTime,@CreatedBy,@ReCount"); strSql.Append(") "); strSql.AppendFormat(";select '{0}'", guid); SqlParameter[] parameters = { new SqlParameter("@IsDeleted", SqlDbType.Bit, 1), new SqlParameter("@Status", SqlDbType.Int, 4), new SqlParameter("@Code", SqlDbType.VarChar, 50), new SqlParameter("@OrderCode", SqlDbType.VarChar, 50), new SqlParameter("@GId", SqlDbType.Int, 4), new SqlParameter("@GCount", SqlDbType.Decimal, 9), new SqlParameter("@BuyPrice", SqlDbType.Decimal, 9), new SqlParameter("@TotalMoney", SqlDbType.Decimal, 9), new SqlParameter("@CreatedTime", SqlDbType.DateTime), new SqlParameter("@CreatedBy", SqlDbType.VarChar, 50), new SqlParameter("@ReCount", SqlDbType.Decimal, 9) }; parameters[0].Value = model.IsDeleted; parameters[1].Value = model.Status; parameters[2].Value = model.Code; parameters[3].Value = model.OrderCode; parameters[4].Value = model.GId; parameters[5].Value = model.GCount; parameters[6].Value = model.BuyPrice; parameters[7].Value = model.TotalMoney; parameters[8].Value = model.CreatedTime; parameters[9].Value = model.CreatedBy; parameters[10].Value = model.ReCount; MyHs.Add(strSql.ToString(), parameters); return(MyHs); }
protected void binddata(string id) { Model.C_CarTast c = BLL.C_CarTast.GetModel(int.Parse(id)); Name.Value = c.Name; TType.Value = c.TType.ToString(); SupplierName.Value = c.SupplierName; SupplierName2.Value = c.SupplierName; SupplierName3.Value = c.SupplierName; SupplierAddress.Value = c.SupplierAddress; SupplierTelName.Value = c.SupplierTelName; SupplierTel.Value = c.SupplierTel; Spare2.Value = c.Spare2.ToString(); CSpare2.Value = c.CSpare2.ToString(); CarSJ1.Value = c.CarSJ1.ToString(); CarSJ2.Value = c.CarSJ2.ToString(); //CostType.Value = c.CostType.ToString(); uploadurl.Value = c.BDImg.ToString(); Spare1.Value = c.Spare1.ToString(); ocode.Value = c.OCode; fid.Value = c.ID.ToString(); oid.Value = c.OCode.ToString(); ComDate.Value = c.ComDate.ToString(); if (!string.IsNullOrEmpty(c.OCode))//如果不是空车,就显示商品 { Model.OrderDetail od = BLL.OrderDetail.GetModelCode(c.OCode); txtGood.Value = od.GId.ToString(); txtGoodCount.Value = od.GCount.ToString(); txtGoodPrice.Value = od.BuyPrice.ToString(); } if (!string.IsNullOrEmpty(Request.QueryString["oid"])) { ocode.Value = Request.QueryString["oid"]; } }
protected override string btnAdd_Click() { try { Model.C_CarTast cartast = BLL.C_CarTast.GetModel(int.Parse(Request.Form["cid"])); if (cartast.TState == 1) { return("非法操作,此任务已结束"); } decimal money = Convert.ToDecimal(Request.Form["txtGCount"]); Model.OrderDetail ord = BLL.OrderDetail.GetList(" ordercode='" + cartast.OCode + "' and code='" + Request.Form["txtGoodList"] + "' ").FirstOrDefault(); if (ord != null) { if (money <= 0) { return("输入数量有误或此商品已不可调度"); } ord.ReCount = money; if (BLL.OrderDetail.Update(ord)) { return("调度成功"); } else { return("调度失败"); } } else { return("数据有误,请重试"); } } catch (Exception e) { return(e.Message); } }
/// <summary> /// 更新一条数据 /// </summary> public static bool Update(Model.OrderDetail model) { return(DAL.CommonBase.RunHashtable(Update(model, new Hashtable()))); }
protected override string btnModify_Click() { Hashtable MyHs = new Hashtable(); Model.C_CarTast c = BLL.C_CarTast.GetModelname(Request.Form["Name"]); //Model.C_CarTast c = new Model.C_CarTast(); //c.Name = Request.Form["Name"]; c.TType = int.Parse(Request.Form["TType"]); if (c.TType == 1) { c.SupplierName = Request.Form["SupplierName"]; } else if (c.TType == 2) { c.SupplierName = Request.Form["SupplierName2"]; } else { c.SupplierName = Request.Form["SupplierName3"]; } c.SupplierAddress = Request.Form["SupplierAddress"]; c.SupplierTelName = Request.Form["SupplierTelName"]; c.SupplierTel = Request.Form["SupplierTel"]; c.Spare2 = Request.Form["Spare2"]; c.CSpare2 = Request.Form["CSpare2"]; c.CarSJ1 = Request.Form["CarSJ1"]; c.CarSJ2 = Request.Form["CarSJ2"]; //c.CostType = int.Parse(Request.Form["CostType"]); c.BDImg = Request.Form["uploadurl"]; c.OCode = Request.Form["ocode"]; c.Spare1 = Request.Form["Spare1"]; c.ComDate = DateTime.Parse(Request.Form["ComDate"]); #region 司机车辆验证 Model.C_Car car = BLL.C_Car.GetModelByCode(c.Spare2); if (car == null) { return("此牵引车不存在,请正确输入车辆牌照"); } //if (!string.IsNullOrEmpty(car.Spare1)&&car.ID!=c.ID) // return "此牵引车任务未完成,请选择别的车辆"; if (!string.IsNullOrEmpty(c.CSpare2)) { Model.C_Car car2 = BLL.C_Car.GetModelByCode(c.CSpare2); if (car2 == null) { return("此挂车不存在,请正确输入车辆牌照"); } //if (!string.IsNullOrEmpty(car2.Spare1) && car.ID != c.ID) // return "此挂车任务未完成,请选择别的车辆"; } //存在商品订单 if (!string.IsNullOrEmpty(c.OCode)) { Model.OrderDetail od = BLL.OrderDetail.GetModelCode(c.OCode); od.GId = Convert.ToInt32(Request.Form["txtGood"]); od.BuyPrice = Convert.ToDecimal(Request.Form["txtGoodPrice"]); od.GCount = Convert.ToDecimal(Request.Form["txtGoodCount"]); od.ReCount = Convert.ToDecimal(Request.Form["txtGoodCount"]); BLL.OrderDetail.Update(od, MyHs); } Model.Member siji1 = BLL.Member.GetModelByMID(c.CarSJ1); if (siji1 != null) { if (siji1.FMID != "1") { return("此司机不是主司机"); } } else { return("主司机不存在"); } if (!string.IsNullOrEmpty(c.CarSJ2)) { Model.Member siji2 = BLL.Member.GetModelByMID(c.CarSJ2); if (siji2 != null) { if (siji2.FMID != "2" && siji2.FMID != "3") { return("此司机不是押运员"); } } else { return("押运员不存在"); } } #endregion c.ID = int.Parse(Request.Form["fid"]); BLL.C_CarTast.Update(c, MyHs); if (BLL.CommonBase.RunHashtable(MyHs)) { return("修改成功"); } else { return("修改失败"); } }
public static bool Update(Model.OrderDetail model) { return(yny_005.DAL.OrderDetail.Update(model)); }
protected override string btnAdd_Click() { lock (obj) { Model.C_CarTast cartast = BLL.C_CarTast.GetModel(int.Parse(Request.Form["cid"])); decimal retotalMoney = 0;//实际总额 if (cartast.TState == 1) { return("状态已改变,请勿重复提交"); } cartast.TState = 1; decimal recount = 0; decimal reprice = 0; if (cartast.TType == 1 || cartast.TType == 2) { if (string.IsNullOrEmpty(cartast.BDImg)) { return("请上传磅单图片"); } List <Model.OrderDetail> listord2 = null; if (!string.IsNullOrEmpty(cartast.OCode)) { order = BLL.Order.GetModel(cartast.OCode); listord2 = order.OrderDetail; Model.OrderDetail od = BLL.OrderDetail.GetModelCode(cartast.OCode); if (od != null) { retotalMoney = od.ReCount * od.BuyPrice; recount = od.ReCount; reprice = od.BuyPrice; } } //if (listord2.Sum(m => m.ReCount) <= 0) // return "未查询到实际装车/卸车数量,不能完成"; } Hashtable MyHs = new Hashtable(); Model.C_Car c1 = BLL.C_Car.GetModelByCode(cartast.Spare2); c1.Spare1 = ""; BLL.C_Car.Update(c1, MyHs); Model.C_Car c2 = BLL.C_Car.GetModelByCode(cartast.CSpare2); if (c2 != null) { c2.Spare1 = ""; BLL.C_Car.Update(c2, MyHs); } BLL.C_CarTast.Update(cartast, MyHs); if (cartast.TType == 1 || cartast.TType == 2) { Model.Account acc = new Model.Account(); acc.CID = cartast.ID; acc.CName = cartast.Name; acc.AType = cartast.TType == 1 ? 0 : 1; acc.SupplierID = Convert.ToInt32(cartast.SupplierName); supplier = BLL.C_Supplier.GetModel(int.Parse(cartast.SupplierName)); acc.SupplierName = supplier.Name; acc.TotalMoney = retotalMoney; acc.ReMoney = 0; acc.CreateDate = DateTime.Now; acc.AStutas = 0; acc.comDate = DateTime.MaxValue; acc.OrderCount = recount; acc.OrderPrice = reprice; BLL.Account.Add(acc, MyHs); } if (BLL.CommonBase.RunHashtable(MyHs)) { return("结束任务成功"); } else { return("数据有误,结束任务失败"); } } }
public static bool Insert(Model.OrderDetail model) { return(yny_005.DAL.OrderDetail.Insert(model)); }
public static Hashtable Update(Model.OrderDetail model, Hashtable MyHs) { return(yny_005.DAL.OrderDetail.Update(model, MyHs)); }
public static Hashtable Insert(Model.OrderDetail model, Hashtable MyHs) { return(yny_005.DAL.OrderDetail.Insert(model, MyHs)); }
/// <summary> /// 更新基本资料 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected override string btnModify_Click() { Hashtable MyHs = new Hashtable(); if (Request.Form["chkCloseAll"] == "on" || Request.Form["chkClockAll"] == "on") { string where = ""; if (Request.Form["chkCloseAll"] == "on") { where += string.Format(" IsClose = {0} ", (MemberModel.IsClose ? 1 : 0)); } if (Request.Form["chkClockAll"] == "on") { where += string.Format(" IsClock = {0} ", (MemberModel.IsClock ? 1 : 0)); } if (!string.IsNullOrEmpty(where)) { MyHs.Add(string.Format("update Member set {0} where MID in (select mid from [dbo].[getSubBDMember]('{1}'))", where, MemberModel.MID), null); } //List<Model.Member> list = BllModel.GetMemberEntityList("MID in (select mid from getTreeBuyMID('" + MemberModel.MID + "'))"); //foreach (Model.Member item in list) //{ // if (Request.Form["chkCloseAll"] == "on") // item.IsClose = MemberModel.IsClose; // if (Request.Form["chkClockAll"] == "on") // item.IsClock = MemberModel.IsClock; // BllModel.Update(item, MyHs); //} } BllModel.Update(MemberModel, MyHs); //string error = BLL.Member.CanSetAgency(MemberModel); //if (!string.IsNullOrEmpty(error)) //{ // return error; //} //MyHs.Add(" update member set MSH = '" + MemberModel.MID + "' where " + BLL.Member.GetLeaderCondition(MemberModel) + " and MID <> '" + MemberModel.MID + "'", null); if (MemberModel.Role.IsAdmin) { UpdateQuestion(MemberModel.ID, MyHs); } if (BLL.CommonBase.RunHashtable(MyHs)) { Hashtable MyHs2 = new Hashtable(); List <Model.Account> listaccount = BLL.Account.GetModelList(""); foreach (var item in listaccount) { Model.C_CarTast tast = BLL.C_CarTast.GetModelname(item.CName); Model.Goods g = null; if (tast != null) { if (!string.IsNullOrWhiteSpace(tast.OCode)) { Model.Member mc1 = BLL.Member.GetModelByMID(tast.CarSJ1); Model.Member mc2 = BLL.Member.GetModelByMID(tast.CarSJ2); if (mc1 != null) { item.SJ1 = mc1.MName; } if (mc2 != null) { item.SJ2 = mc2.MName; } Model.OrderDetail od = BLL.OrderDetail.GetModelCode(tast.OCode); g = BLL.Goods.GetModel(od.GId); if (g != null) { item.GName = g.GName; item.Unit = g.Unit; } } } BLL.Account.Update(item, MyHs2); } BLL.CommonBase.RunHashtable(MyHs2); BLL.OperationRecordBLL.Add(TModel.MID, ChangeType.O_XGHYZL, string.Format("修改{0}的资料", MemberModel.MID)); return("操作成功"); } return("操作失败"); }
/// <summary> /// 增加一条数据 /// </summary> public static bool Insert(Model.OrderDetail model) { return(DAL.CommonBase.RunHashtable(Insert(model, new Hashtable()))); }
protected override void SetPowerZone() { //CostType.DataSource = BLL.C_CostType.GetList(" 1 = 1 order by ID"); //CostType.DataTextField = "Name"; //CostType.DataValueField = "ID"; //CostType.DataBind(); txtGood.DataSource = BLL.Goods.GetList(" IsDeleted = 0 order by GID"); txtGood.DataTextField = "GName"; txtGood.DataValueField = "GID"; txtGood.DataBind(); txtGood.Items.Insert(0, "--请选择--"); // Spare2.DataSource = BLL.C_Car.GetList(" IsDelete = 0 and CType='牵引车' order by ID"); //Spare2.DataTextField = "PZCode"; //Spare2.DataValueField = "PZCode"; //Spare2.DataBind(); //CSpare2.DataSource = BLL.C_Car.GetList(" IsDelete = 0 and CType='挂车' order by ID"); //CSpare2.DataTextField = "PZCode"; //CSpare2.DataValueField = "PZCode"; //CSpare2.DataBind(); SupplierName.DataSource = BLL.C_Supplier.GetList(" IsDelete = 0 and (Spare3 is null or Spare3='') and Type=1 order by ID"); SupplierName.DataTextField = "Name"; SupplierName.DataValueField = "ID"; SupplierName.DataBind(); SupplierName.Items.Insert(0, "--请选择--"); SupplierName2.DataSource = BLL.C_Supplier.GetList(" IsDelete = 0 and (Spare3 is null or Spare3='') and Type=2 order by ID"); SupplierName2.DataTextField = "Name"; SupplierName2.DataValueField = "ID"; SupplierName2.DataBind(); SupplierName2.Items.Insert(0, "--请选择--"); SupplierName3.DataSource = BLL.C_Supplier.GetList(" IsDelete = 0 and (Spare3 is null or Spare3='') order by ID"); SupplierName3.DataTextField = "Name"; SupplierName3.DataValueField = "ID"; SupplierName3.DataBind(); SupplierName3.Items.Insert(0, "--请选择--"); Name.Value = DateTime.Now.ToString("yyyyMMddHHmmssfff"); if (!string.IsNullOrEmpty(Request.QueryString["oid"])) { ocode.Value = Request.QueryString["oid"]; oid.Value = Request.QueryString["oid"]; } else { } if (!string.IsNullOrEmpty(Request.QueryString["id"])) { Model.C_CarTast ct = BLL.C_CarTast.GetModel(Convert.ToInt32(Request.QueryString["id"])); Name.Value = ct.Name; sid.Value = ct.SupplierName; if (ct.TType == 1) { SupplierName.Value = ct.SupplierName; } else if (ct.TType == 2) { SupplierName2.Value = ct.SupplierName; } else { SupplierName3.Value = ct.SupplierName; } SupplierAddress.Value = ct.SupplierAddress; Model.OrderDetail od = BLL.OrderDetail.GetModelCode(ct.OCode); if (od != null) { txtGood.Value = od.GId.ToString(); txtGoodCount.Value = od.GCount.ToString(); txtGoodPrice.Value = od.BuyPrice.ToString(); } } //ocode.Disabled = true; }
protected override string btnModify_Click() { Hashtable MyHs = new Hashtable(); Model.C_CarTast cartast = BLL.C_CarTast.GetModel(Convert.ToInt32(Request.Form["tid"])); if (cartast.SHInt != 0) { return("此任务审核状态为已审核状态"); } cartast.SHInt = 1; BLL.C_CarTast.Update(cartast, MyHs); int acount = Convert.ToInt32(BLL.CommonBase.GetSingle("select count(*) from Account where CName='" + cartast.Name + "';")); if (acount == 0) { if (cartast.TType == 1 || cartast.TType == 2) { Model.Member mc1 = BLL.Member.GetModelByMID(cartast.CarSJ1); Model.Member mc2 = BLL.Member.GetModelByMID(cartast.CarSJ2); string SJ1 = ""; string SJ2 = ""; if (mc1 != null) { SJ1 = mc1.MName; } if (mc2 != null) { SJ2 = mc2.MName; } decimal retotalMoney = 0;//实际总额 decimal recount = 0; decimal reprice = 0; string gname = ""; string unit = ""; if (!string.IsNullOrEmpty(cartast.OCode)) { Model.OrderDetail od = BLL.OrderDetail.GetModelCode(cartast.OCode); if (od != null) { retotalMoney = od.ReCount * od.BuyPrice; recount = od.ReCount; reprice = od.BuyPrice; Model.Goods mg = BLL.Goods.GetModel(od.GId); if (mg != null) { gname = mg.GName; unit = mg.Unit; } } } Model.Account acc = new Model.Account(); acc.CID = cartast.ID; acc.CName = cartast.Name; acc.AType = cartast.TType == 1 ? 0 : 1; acc.SupplierID = Convert.ToInt32(cartast.SupplierName); var supplier = BLL.C_Supplier.GetModel(int.Parse(cartast.SupplierName)); acc.SupplierName = supplier.Name; acc.TotalMoney = retotalMoney; acc.ReMoney = 0; acc.CreateDate = DateTime.Now; acc.AStutas = 0; acc.comDate = DateTime.MaxValue; acc.OrderCount = recount; acc.OrderPrice = reprice; acc.SJ1 = SJ1; acc.SJ2 = SJ2; acc.GName = gname; acc.Unit = unit; BLL.Account.Add(acc, MyHs); } } if (BLL.CommonBase.RunHashtable(MyHs)) { return("审核成功"); } else { return("审核失败"); } }
protected override void SetPowerZone() { txtGood.DataSource = BLL.Goods.GetList(" IsDeleted = 0 order by GID"); txtGood.DataTextField = "GName"; txtGood.DataValueField = "GID"; txtGood.DataBind(); txtGood.Items.Insert(0, "--请选择--"); SupplierName.DataSource = BLL.C_Supplier.GetList(" IsDelete = 0 and (Spare3 is null or Spare3='') and Type=1 order by ID"); SupplierName.DataTextField = "Name"; SupplierName.DataValueField = "ID"; SupplierName.DataBind(); SupplierName.Items.Insert(0, "--请选择--"); SupplierName2.DataSource = BLL.C_Supplier.GetList(" IsDelete = 0 and (Spare3 is null or Spare3='') and Type=2 order by ID"); SupplierName2.DataTextField = "Name"; SupplierName2.DataValueField = "ID"; SupplierName2.DataBind(); SupplierName2.Items.Insert(0, "--请选择--"); SupplierName3.DataSource = BLL.C_Supplier.GetList(" IsDelete = 0 and (Spare3 is null or Spare3='') order by ID"); SupplierName3.DataTextField = "Name"; SupplierName3.DataValueField = "ID"; SupplierName3.DataBind(); SupplierName3.Items.Insert(0, "--请选择--"); Name.Value = DateTime.Now.ToString("yyyyMMddHHmmssfff"); if (!string.IsNullOrEmpty(Request.QueryString["oid"])) { ocode.Value = Request.QueryString["oid"]; oid.Value = Request.QueryString["oid"]; } else { } if (!string.IsNullOrEmpty(Request.QueryString["id"])) { Model.C_CarTast ct = BLL.C_CarTast.GetModel(Convert.ToInt32(Request.QueryString["id"])); Name.Value = ct.Name; sid.Value = ct.SupplierName; if (ct.TType == 1) { SupplierName.Value = ct.SupplierName; } else if (ct.TType == 2) { SupplierName2.Value = ct.SupplierName; } else { SupplierName3.Value = ct.SupplierName; } SupplierAddress.Value = ct.SupplierAddress; Model.OrderDetail od = BLL.OrderDetail.GetModelCode(ct.OCode); if (od != null) { txtGood.Value = od.GId.ToString(); txtGoodCount.Value = od.GCount.ToString(); txtGoodPrice.Value = od.BuyPrice.ToString(); } //装车信息 if (ct.TType != 1) { xcView.Visible = false; tcode = ct.TCode; CTModel = BLL.C_CarTast.GetModelname(tcode); if (CTModel != null) { SuppModel = BLL.C_Supplier.GetModel(Convert.ToInt32(CTModel.SupplierName)); if (!string.IsNullOrEmpty(CTModel.OCode)) { OdModel = BLL.OrderDetail.GetList(" ordercode='" + CTModel.OCode + "'; ").FirstOrDefault(); Good = BLL.Goods.GetModel(OdModel.GId); } } } else { zcView.Visible = false; List <Model.C_CarTast> carList = BLL.C_CarTast.GetModelList(" TCode='" + ct.Name + "' "); foreach (var item in carList) { CarTast cModel = new CarTast(); cModel.Code = item.Name; cModel.Supp = BLL.C_Supplier.GetModel(Convert.ToInt32(item.SupplierName)).Name; Model.OrderDetail XCod = BLL.OrderDetail.GetModelCode(item.OCode); if (XCod != null) { cModel.Count = XCod.GCount; cModel.ReCount = XCod.ReCount; cModel.GoodName = BLL.Goods.GetModel(Convert.ToInt32(XCod.GId)).GName; } cModel.CreateTime = item.CreateDate; XCList.Add(cModel); } } } //ocode.Disabled = true; }
protected override string btnModify_Click() { lock (obj) { try { Model.C_CarTast c = null; if (string.IsNullOrEmpty(Request.Form["fid"])) { c = new Model.C_CarTast(); } else { c = BLL.C_CarTast.GetModel(Convert.ToInt32(Request.Form["fid"])); } c.Name = Request.Form["Name"]; c.TType = int.Parse(Request.Form["TType"]); if (c.TType == 1) { c.SupplierName = Request.Form["SupplierName"]; } else if (c.TType == 2) { c.SupplierName = Request.Form["SupplierName2"]; } else { c.SupplierName = Request.Form["SupplierName3"]; } c.SupplierAddress = Request.Form["SupplierAddress"]; c.SupplierTelName = Request.Form["SupplierTelName"]; c.SupplierTel = Request.Form["SupplierTel"]; c.BDImg = Request.Form["uploadurl"]; //c.OCode = Request.Form["ocode"]; c.Spare1 = Request.Form["Spare1"]; c.Prot = Convert.ToInt32(Request.Form["txtProt"]); c.ComDate = DateTime.Parse(Request.Form["ComDate"]); string zcCode = Request.Form["zcCode"]; Model.C_CarTast carTast = BLL.C_CarTast.GetModelname(zcCode); if (carTast == null) { return("未查询到装车单"); } if (carTast.XSMID != TModel.MID) { return("此装车单无权限"); } Hashtable MyHs = new Hashtable(); if (c.TType != 3)//不是空车才能生成商品订单 { #region 生成商品订单 string code = ""; string goodid = Request.Form["txtGood"]; Model.Goods go = BLL.Goods.GetModel(goodid); if (go == null) { return("此商品找不到"); } if (!string.IsNullOrEmpty(goodid)) { decimal goodcount = 0; decimal goodprice = 0; try { goodcount = Convert.ToDecimal(Request.Form["txtGoodCount"]); goodprice = Convert.ToDecimal(Request.Form["txtGoodPrice"]); } catch (Exception e) { return(e.Message); } //先生成订单主表 Model.Order order = new Model.Order(); DateTime dt = DateTime.Now; code = dt.ToString("yyyyMMddHHmmssfff");// dt.Year.ToString() + dt.Month.ToString() + dt.Day.ToString() + dt.Hour.ToString() + dt.Minute.ToString() + dt.Second.ToString() + dt.Millisecond.ToString(); order.Code = code; order.ReceiveId = 0; order.CreatedBy = TModel.MID; order.CreatedTime = DateTime.Now; //order.GoodCount decimal count = goodcount; decimal totalMoney = goodcount * goodprice; string error = string.Empty; //生成订单明细表 Model.OrderDetail od = new Model.OrderDetail(); od.BuyPrice = goodprice; od.Code = GetGuid(); od.CreatedBy = TModel.MID; od.CreatedTime = DateTime.Now; od.GCount = count; od.GId = Convert.ToInt32(goodid); //查看库存数量是否足够,不够的话暂时不能提交订单 od.IsDeleted = false; od.OrderCode = order.Code; od.Status = 1; od.TotalMoney = od.GCount * od.BuyPrice; totalMoney += od.TotalMoney; BLL.OrderDetail.Insert(od, MyHs); order.GoodCount = count; order.IsDeleted = false; order.MID = c.SupplierName; order.OrderTime = DateTime.Now; order.TotalPrice = totalMoney; order.DisCountTotalPrice = order.TotalPrice;// * BLL.Configuration.Model.E_GWDiscount; order.ExpressCompany = c.Name; order.Status = 2; c.OCode = order.Code; BLL.Order.Insert(order, MyHs); if (!string.IsNullOrEmpty(error)) { return(error); } } #endregion } c.TState = -1; c.XSMID = TModel.MID; c.TCode = zcCode; int ncount = Convert.ToInt32(BLL.CommonBase.GetSingle("select COUNT(*) from C_CarTast where Name='" + c.Name + "';")); if (ncount > 0) { return("订单号重复,请刷新重试"); } //int tid = BLL.C_CarTast.Add(c); BLL.C_CarTast.Add(c, MyHs); //if (tid > 0) //{ //car.Spare1 = tid.ToString(); //BLL.C_Car.Update(car, MyHs); //if (car2 != null) //{ // car.Spare1 = tid.ToString(); // BLL.C_Car.Update(car2, MyHs); //} //} //else { // return "任务添加失败"; //} if (BLL.CommonBase.RunHashtable(MyHs)) { return("添加成功"); } else { return("添加失败"); } } catch (Exception e) { return(e.Message); } } }
protected override void SetPowerZone() { tcode = Request.QueryString["tcode"]; CTModel = BLL.C_CarTast.GetModelname(tcode); SuppModel = BLL.C_Supplier.GetModel(Convert.ToInt32(CTModel.SupplierName)); if (!string.IsNullOrEmpty(CTModel.OCode)) { OdModel = BLL.OrderDetail.GetList(" ordercode='" + CTModel.OCode + "'; ").FirstOrDefault(); Good = BLL.Goods.GetModel(OdModel.GId); } txtGood.DataSource = BLL.Goods.GetList(" IsDeleted = 0 order by GID"); txtGood.DataTextField = "GName"; txtGood.DataValueField = "GID"; txtGood.DataBind(); txtGood.Items.Insert(0, "--请选择--"); SupplierName.DataSource = BLL.C_Supplier.GetList(" IsDelete = 0 and (Spare3 is null or Spare3='') and Type=1 order by ID"); SupplierName.DataTextField = "Name"; SupplierName.DataValueField = "ID"; SupplierName.DataBind(); SupplierName.Items.Insert(0, "--请选择--"); SupplierName2.DataSource = BLL.C_Supplier.GetList(" IsDelete = 0 and (Spare3 is null or Spare3='') and Type=2 order by ID"); SupplierName2.DataTextField = "Name"; SupplierName2.DataValueField = "ID"; SupplierName2.DataBind(); SupplierName2.Items.Insert(0, "--请选择--"); SupplierName3.DataSource = BLL.C_Supplier.GetList(" IsDelete = 0 and (Spare3 is null or Spare3='') order by ID"); SupplierName3.DataTextField = "Name"; SupplierName3.DataValueField = "ID"; SupplierName3.DataBind(); SupplierName3.Items.Insert(0, "--请选择--"); Name.Value = DateTime.Now.ToString("yyyyMMddHHmmssfff"); if (!string.IsNullOrEmpty(Request.QueryString["oid"])) { ocode.Value = Request.QueryString["oid"]; oid.Value = Request.QueryString["oid"]; } else { } if (!string.IsNullOrEmpty(Request.QueryString["id"])) { Model.C_CarTast ct = BLL.C_CarTast.GetModel(Convert.ToInt32(Request.QueryString["id"])); Name.Value = ct.Name; sid.Value = ct.SupplierName; if (ct.TType == 1) { SupplierName.Value = ct.SupplierName; } else if (ct.TType == 2) { SupplierName2.Value = ct.SupplierName; } else { SupplierName3.Value = ct.SupplierName; } SupplierAddress.Value = ct.SupplierAddress; Model.OrderDetail od = BLL.OrderDetail.GetModelCode(ct.OCode); if (od != null) { txtGood.Value = od.GId.ToString(); txtGoodCount.Value = od.GCount.ToString(); txtGoodPrice.Value = od.BuyPrice.ToString(); } } }
protected override void SetValue(string id) { cartast = BLL.C_CarTast.GetModel(int.Parse(id)); supplier = BLL.C_Supplier.GetModel(int.Parse(cartast.SupplierName)); cid.Value = id; if (!string.IsNullOrEmpty(cartast.OCode)) { order = BLL.Order.GetModel(cartast.OCode); listord = order.OrderDetail; } if (order != null) { listcost = BLL.C_CostDetalis.GetModelList(" CID=" + order.Id); } if (cartast.TState == 1 || !TModel.Role.SiJi) { anbtn.Visible = false; } Model.Member zm = BLL.Member.GetModelByMID(cartast.CarSJ1); if (zm != null) { zhusiji = zm.MName; } Model.Member fm = BLL.Member.GetModelByMID(cartast.CarSJ2); if (fm != null) { fusiji = fm.MName; } //装车信息 if (cartast.TType != 1) { xcView.Visible = false; tcode = cartast.TCode; CTModel = BLL.C_CarTast.GetModelname(tcode); if (CTModel != null) { SuppModel = BLL.C_Supplier.GetModel(Convert.ToInt32(CTModel.SupplierName)); if (!string.IsNullOrEmpty(CTModel.OCode)) { OdModel = BLL.OrderDetail.GetList(" ordercode='" + CTModel.OCode + "'; ").FirstOrDefault(); Good = BLL.Goods.GetModel(OdModel.GId); } } } else { zcView.Visible = false; List <Model.C_CarTast> carList = BLL.C_CarTast.GetModelList(" TCode='" + cartast.Name + "' "); foreach (var item in carList) { CarTast cModel = new CarTast(); cModel.Code = item.Name; cModel.Supp = BLL.C_Supplier.GetModel(Convert.ToInt32(item.SupplierName)).Name; Model.OrderDetail XCod = BLL.OrderDetail.GetModelCode(item.OCode); if (XCod != null) { cModel.Count = XCod.GCount; cModel.ReCount = XCod.ReCount; cModel.GoodName = BLL.Goods.GetModel(Convert.ToInt32(XCod.GId)).GName; } cModel.CreateTime = item.CreateDate; XCList.Add(cModel); } } }