Exemplo n.º 1
0
        public ActionResult AddEdit()
        {
            this.Internationalization();

            #region Add

            if (Request.Form["oper"].Equals("add"))
            {
                try
                {
                    TugDataEntities db = new TugDataEntities();
                    {
                        TugDataModel.TugInfor tug = new TugInfor();

                        tug.Code = Request.Form["Code"];
                        tug.Name1 = Request.Form["Name1"];
                        tug.Name2 = Request.Form["Name2"];
                        tug.SimpleName = Request.Form["SimpleName"];
                        tug.Power = Request.Form["Power"];
                        tug.Class = Request.Form["Class"];
                        tug.Speed = Request.Form["Speed"];
                        tug.Length = Request.Form["Length"];
                        tug.Width = Request.Form["Width"];
                        tug.Remark = Request.Form["Remark"];
                        tug.OwnerID = -1;
                        tug.CreateDate = tug.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");;
                        tug.UserID = Session.GetDataFromSession<int>("userid");
                        tug.UserDefinedCol1 = Request.Form["UserDefinedCol1"];
                        tug.UserDefinedCol2 = Request.Form["UserDefinedCol2"];
                        tug.UserDefinedCol3 = Request.Form["UserDefinedCol3"];
                        tug.UserDefinedCol4 = Request.Form["UserDefinedCol4"];

                        if (Request.Form["UserDefinedCol5"] != "")
                            tug.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"]);

                        if (Request.Form["UserDefinedCol6"] != "")
                            tug.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"]);

                        if (Request.Form["UserDefinedCol7"] != "")
                            tug.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"]);

                        if (Request.Form["UserDefinedCol8"] != "")
                            tug.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"]);

                        tug.UserDefinedCol9 = Request.Form["UserDefinedCol9"];
                        tug.UserDefinedCol10 = Request.Form["UserDefinedCol10"];

                        tug = db.TugInfor.Add(tug);
                        db.SaveChanges();

                        var ret = new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE };
                        //Response.Write(@Resources.Common.SUCCESS_MESSAGE);
                        return Json(ret);
                    }
                }
                catch (Exception)
                {
                    var ret = new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE };
                    //Response.Write(@Resources.Common.EXCEPTION_MESSAGE);
                    return Json(ret);
                }
            }

            #endregion Add

            #region Edit

            if (Request.Form["oper"].Equals("edit"))
            {
                try
                {
                    TugDataEntities db = new TugDataEntities();
                    string name1 = Request.Form["Name1"];
                    int idx = Util.toint(Request.Form["IDX"]);
                    System.Linq.Expressions.Expression<Func<TugInfor, bool>> exp = u => u.Name1 == name1 && u.IDX != idx;
                    TugInfor tmpName = db.TugInfor.Where(exp).FirstOrDefault();
                    if (tmpName != null)
                    {
                        return Json(new { code = Resources.Common.ERROR_CODE, message = "拖轮名称1已存在!" });//Resources.Common.ERROR_MESSAGE
                    }

                    TugInfor tug = db.TugInfor.Where(u => u.IDX == idx).FirstOrDefault();

                    if (tug == null)
                    {
                        return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
                    }
                    else
                    {
                        string oldTugName1 = tug.Name1;
                        string newTugName1 = Request.Form["Name1"].Trim();
                        int tugIdx = idx;

                        tug.Code = Request.Form["Code"];
                        tug.Name1 = Request.Form["Name1"];
                        tug.Name2 = Request.Form["Name2"];
                        tug.SimpleName = Request.Form["SimpleName"];
                        tug.Power = Request.Form["Power"];
                        tug.Class = Request.Form["Class"];
                        tug.Speed = Request.Form["Speed"];
                        tug.Length = Request.Form["Length"];
                        tug.Width = Request.Form["Width"];
                        tug.Remark = Request.Form["Remark"];
                        tug.OwnerID = -1;
                        tug.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");;
                        tug.UserID = Session.GetDataFromSession<int>("userid");
                        tug.UserDefinedCol1 = Request.Form["UserDefinedCol1"];
                        tug.UserDefinedCol2 = Request.Form["UserDefinedCol2"];
                        tug.UserDefinedCol3 = Request.Form["UserDefinedCol3"];
                        tug.UserDefinedCol4 = Request.Form["UserDefinedCol4"];

                        if (Request.Form["UserDefinedCol5"] != "")
                            tug.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"]);

                        if (Request.Form["UserDefinedCol6"] != "")
                            tug.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"]);

                        if (Request.Form["UserDefinedCol7"] != "")
                            tug.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"]);

                        if (Request.Form["UserDefinedCol8"] != "")
                            tug.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"]);

                        tug.UserDefinedCol9 = Request.Form["UserDefinedCol9"];
                        tug.UserDefinedCol10 = Request.Form["UserDefinedCol10"];

                        db.Entry(tug).State = System.Data.Entity.EntityState.Modified;
                        db.SaveChanges();

                        TugBusinessLogic.Utils.UpDateTugName1(tugIdx, oldTugName1, newTugName1);

                        return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE });
                    }
                }
                catch (Exception exp)
                {
                    return Json(new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE });
                }
            }

            #endregion Edit

            return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE });
        }
Exemplo n.º 2
0
        public ActionResult AddTug(string Code, string Name1, string Name2, string SimpleName, string Power, string Class, string Speed, string Length, string Width, string Remark)
        {
            this.Internationalization();
                try
                {
                    TugDataEntities db = new TugDataEntities();
                    System.Linq.Expressions.Expression<Func<TugInfor, bool>> exp = u => u.Name1 == Name1;
                    TugInfor tmpName = db.TugInfor.Where(exp).FirstOrDefault();
                    if (tmpName != null)
                    {
                        throw new Exception("拖轮名称1已存在!");
                    }
                    {
                        TugDataModel.TugInfor tug = new TugInfor();

                        tug.Code = Code;
                        tug.Name1 = Name1;
                        tug.Name2 = Name2;
                        tug.SimpleName = SimpleName;
                        tug.Power = Power;
                        tug.Class = Class;
                        tug.Speed = Speed;
                        tug.Length = Length;
                        tug. Width= Width;
                        tug.Remark =Remark ;
                        tug.OwnerID = -1;
                        tug.CreateDate = tug.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); ;
                        tug.UserID = Session.GetDataFromSession<int>("userid");
                        //tug.UserDefinedCol1 = "";
                        //tug.UserDefinedCol2 = "";
                        //tug.UserDefinedCol3 = "";
                        //tug.UserDefinedCol4 = "";

                        //if (Request.Form["UserDefinedCol5"] != "")
                        //    tug.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"]);

                        //if (Request.Form["UserDefinedCol6"] != "")
                        //    tug.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"]);

                        //if (Request.Form["UserDefinedCol7"] != "")
                        //    tug.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"]);

                        //if (Request.Form["UserDefinedCol8"] != "")
                        //    tug.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"]);

                        //tug.UserDefinedCol9 = "";
                        //tug.UserDefinedCol10 = "";

                        tug = db.TugInfor.Add(tug);
                        db.SaveChanges();

                        var ret = new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE };
                        //Response.Write(@Resources.Common.SUCCESS_MESSAGE);
                        return Json(ret);
                    }
                }
                catch (Exception ex)
                {
                    //var ret = new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE };
                    //return Json(ret);
                    throw ex;
                }
        }