Esempio n. 1
0
        /// <summary>
        /// 删除(返仓单)
        /// </summary>
        /// <returns></returns>
        public ActionResult DeleteWareHert(int sellRetuerID)
        {
            string strMsg = "fail";

            try
            {
                B_WanManifestList conver = (from tbWarHouser in MyModels.B_WanManifestList
                                            where tbWarHouser.WanManifestID == sellRetuerID
                                            select tbWarHouser).Single();
                MyModels.B_WanManifestList.Remove(conver);

                int waDetialid = (int)conver.WanManifestID;

                //查询对应对应明细(总数量)
                var converDetial = (from tbWarHouserDetial in MyModels.B_WanManifestDetailList
                                    where tbWarHouserDetial.WanManifestID == waDetialid
                                    select tbWarHouserDetial).ToList();
                int thyCount = converDetial.Count();

                if (thyCount > 0)
                {
                    for (int i = 0; i < thyCount; i++)
                    {
                        MyModels.B_WanManifestDetailList.Remove(converDetial[i]);
                        MyModels.SaveChanges();
                        strMsg = "success";
                    }
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
            }
            return(Json(strMsg, JsonRequestBehavior.AllowGet));
        }
Esempio n. 2
0
        /// <summary>
        /// 记录编号
        /// </summary>
        /// <returns></returns>
        public ActionResult getEmpCodef()
        {
            string Std   = "";
            var    listy = (from tbem in MyModels.B_WanManifestList
                            orderby tbem.Remember
                            select tbem).ToList();

            if (listy.Count > 0)
            {
                int intcoun = listy.Count;
                B_WanManifestList mymodell = listy[intcoun - 1];
                int inemp = Convert.ToInt32(mymodell.Remember.Substring(1, 8));
                inemp++;
                Std = inemp.ToString();
                for (int i = 0; i < 6; i++)
                {
                    Std = Std.Length < 6 ? "0" + Std : Std;
                }
            }
            else
            {
                Std = "000001";
            }
            return(Json(Std, JsonRequestBehavior.AllowGet));
        }
Esempio n. 3
0
        public ActionResult ShneheanDan(B_WanManifestList OK, bool state)
        {
            ReturnJsonVo returnJson = new ReturnJsonVo();
            string       strMag     = "fali";

            try
            {
                B_WanManifestList MyB_ConverList = new B_WanManifestList();
                MyB_ConverList.WanManifestID     = OK.WanManifestID;
                MyB_ConverList.SellID            = OK.SellID;
                MyB_ConverList.Remember          = OK.Remember;
                MyB_ConverList.PurchaseSectionID = OK.PurchaseSectionID;
                MyB_ConverList.RegisterName      = OK.RegisterName;
                MyB_ConverList.RegisterTime      = OK.RegisterTime;
                MyB_ConverList.ExamineName       = OK.ExamineName;
                MyB_ConverList.ExamineTime       = OK.ExamineTime;


                MyModels.Entry(MyB_ConverList).State = System.Data.Entity.EntityState.Modified;
                if (MyModels.SaveChanges() > 0)
                {
                    strMag = "succsee";
                    B_WanManifestList wafrtbool = (from tbbool in MyModels.B_WanManifestList
                                                   where tbbool.WanManifestID == MyB_ConverList.WanManifestID
                                                   select tbbool).Single(); //查询原状态
                    wafrtbool.ExamineNot            = state;                //改变是否为冲红单状态
                    MyModels.Entry(wafrtbool).State = EntityState.Modified;


                    if (MyModels.SaveChanges() > 0)//保存
                    {
                        returnJson.State = true;
                        returnJson.Text  = "修改成功";
                    }
                    else
                    {
                        returnJson.State = false;
                        returnJson.Text  = "修改失败";
                    }
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
            }
            return(Json(new { strMag, returnJson }, JsonRequestBehavior.AllowGet));
        }
Esempio n. 4
0
        public ActionResult UptoctuFanDan(B_WanManifestList OK, Array JiShangPiID, Array JiRuJianShu, Array JiRuXiShu, Array JieMingXiId)
        {
            string strMag = "fali";

            try
            {
                //一
                string   Z      = ((string[])JiShangPiID)[0];
                string[] intsid = Z.Split(',');
                //二
                string   M          = ((string[])JiRuJianShu)[0];
                string[] intsRuJian = M.Split(',');
                //三
                string   N          = ((string[])JiRuXiShu)[0];
                string[] intsNXiShu = N.Split(',');
                //四
                string   idd          = ((string[])JieMingXiId)[0];
                string[] intsNXiShuid = idd.Split(',');


                B_WanManifestList MyB_ConverList = new B_WanManifestList();
                MyB_ConverList.WanManifestID     = OK.WanManifestID;
                MyB_ConverList.SellID            = OK.SellID;
                MyB_ConverList.Remember          = OK.Remember;
                MyB_ConverList.PurchaseSectionID = OK.PurchaseSectionID;
                MyB_ConverList.RegisterName      = OK.RegisterName;
                MyB_ConverList.RegisterTime      = OK.RegisterTime;


                MyModels.Entry(MyB_ConverList).State = System.Data.Entity.EntityState.Modified;
                if (MyModels.SaveChanges() > 0)
                {
                    B_WanManifestDetailList ConverDeTailList = new B_WanManifestDetailList();

                    for (int H = 0; H < intsNXiShu.Length;)
                    {
                        for (int E = 0; E < intsRuJian.Length;)
                        {
                            for (int d = 0; d < intsid.Length;)
                            {
                                for (int id = 0; id < intsNXiShuid.Length; id++)
                                {
                                    ConverDeTailList.WanManifestID         = MyB_ConverList.WanManifestID;       //要货ID
                                    ConverDeTailList.WanManifestDetailID   = Convert.ToInt32(intsNXiShuid[id]);; //要货明细ID
                                    ConverDeTailList.GoodsID               = Convert.ToInt32(intsid[d]);;        //商品ID
                                    ConverDeTailList.Subdivision           = Convert.ToDecimal(intsNXiShu[H]);   //入库细数
                                    ConverDeTailList.MumberOfPackages      = Convert.ToDecimal(intsRuJian[E]);   //入库件数
                                    MyModels.Entry(ConverDeTailList).State = System.Data.Entity.EntityState.Modified;
                                    MyModels.SaveChanges();                                                      //保存
                                    strMag = "succsee";
                                    d++;
                                    E++;
                                    H++;
                                }
                            }
                        }
                    }
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
            }
            return(Json(strMag, JsonRequestBehavior.AllowGet));
        }
Esempio n. 5
0
        public ActionResult InsectPeiZaiDan(B_WanManifestList OK, Array JiShangPiID, Array JiRuJianShu, Array JiRuXiShu)
        {
            string strMag = "fali";

            try
            {
                //一
                string   Z      = ((string[])JiShangPiID)[0];
                string[] intsid = Z.Split(',');
                //二
                string   M          = ((string[])JiRuJianShu)[0];
                string[] intsRuJian = M.Split(',');
                //三
                string   N          = ((string[])JiRuXiShu)[0];
                string[] intsNXiShu = N.Split(',');


                int oldWareHouseRows = (from tb in MyModels.B_WanManifestList
                                        where tb.Remember == OK.Remember
                                        select tb).Count();

                if (oldWareHouseRows == 0)
                {
                    B_WanManifestList MyB_ConverList = new B_WanManifestList();

                    MyB_ConverList.SellID   = OK.SellID;
                    MyB_ConverList.Remember = OK.Remember;

                    MyB_ConverList.PurchaseSectionID = OK.PurchaseSectionID;


                    MyB_ConverList.RegisterName = OK.RegisterName;
                    MyB_ConverList.RegisterTime = OK.RegisterTime;


                    MyModels.B_WanManifestList.Add(MyB_ConverList);
                    if (MyModels.SaveChanges() > 0)
                    {
                        B_WanManifestDetailList ConverDeTailList = new B_WanManifestDetailList();

                        for (int H = 0; H < intsNXiShu.Length;)
                        {
                            for (int E = 0; E < intsRuJian.Length;)
                            {
                                for (int d = 0; d < intsid.Length; d++)
                                {
                                    ConverDeTailList.WanManifestID    = MyB_ConverList.WanManifestID;     //要货ID
                                    ConverDeTailList.GoodsID          = Convert.ToInt32(intsid[d]);;      //商品ID
                                    ConverDeTailList.Subdivision      = Convert.ToDecimal(intsNXiShu[H]); //入库细数
                                    ConverDeTailList.MumberOfPackages = Convert.ToDecimal(intsRuJian[E]); //入库件数
                                    MyModels.B_WanManifestDetailList.Add(ConverDeTailList);
                                    MyModels.SaveChanges();                                               //保存
                                    strMag = "succsee";
                                    E++;
                                    H++;
                                }
                            }
                        }
                    }
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
            }
            return(Json(strMag, JsonRequestBehavior.AllowGet));
        }