private void InsertGroup(DataTable dtGroup)
        {
            foreach (DataRow row in dtGroup.Rows)
            {
                string strId         = row["Index"].ToString();
                string strName       = row["Name"].ToString();
                string strManager    = row["ManagerName"].ToString();
                string strManagerTel = row["ManagerTel"].ToString();
                string strAddress    = row["Address"].ToString();
                string strRefOrg     = row["RefOrgName"].ToString();

                if (GroupBll.IsNameExist(strName))
                {
                    continue;
                }

                GlareSysEfDbAndModels.GroupInfo group = new GlareSysEfDbAndModels.GroupInfo()
                {
                    CreateDt     = DateTime.Now,
                    Id           = 0,
                    IsDel        = 0,
                    ManageName   = strManager,
                    ManageTel    = strManagerTel,
                    UpdateDt     = DateTime.Now,
                    GroupAddress = strAddress,
                    GroupName    = strName,
                    OrgId        = userInfo.UserInfo.MgrOrgId
                };
                string strError;
                GroupBll.AddAGroup(ref group, out strError);
            }
        }
Exemple #2
0
        public ActionResult Modify(GlareSysEfDbAndModels.GroupInfo subject)
        {
            ResultHelper objResult = null;

            try
            {
                using (LedDb db = new LedDb())
                {
                    if (ModelState.IsValid)
                    {
                        GroupInfo aSubject = db.GroupInfo.Where(p => p.Id == subject.Id).FirstOrDefault();
                        aSubject.GroupName    = subject.GroupName;
                        aSubject.GroupAddress = subject.GroupAddress;
                        aSubject.ManageName   = subject.ManageName;
                        aSubject.ManageTel    = subject.ManageTel;
                        aSubject.OrgId        = subject.OrgId;
                        aSubject.UpdateDt     = DateTime.Now;

                        string strMsg = string.Empty;
                        bool   b      = GroupBll.UpdateProejct(ref subject, out strMsg);
                        if (b)
                        {
                            objResult = new ResultHelper()
                            {
                                Status = true,
                                Ret    = 0,
                                Obj    = subject,
                                Msg    = strMsg,
                                Desc   = strMsg
                            };
                        }
                        else
                        {
                            objResult = new ResultHelper()
                            {
                                Desc   = strMsg,
                                Msg    = strMsg,
                                Obj    = null,
                                Ret    = -1,
                                Status = false
                            };
                        }
                        //if (db.SaveChanges() > 0)
                        //{

                        //    objResult = new ResultHelper()
                        //    {
                        //        Status = true,
                        //        Ret = 0,
                        //        Obj = subject,
                        //        Msg = "Edit Success!",
                        //        Desc = "Edit Success!"
                        //    };
                        //}
                        //else
                        //{
                        //    objResult = new ResultHelper()
                        //    {
                        //        Desc = "Edit Faile,please try again.",
                        //        Msg = "Edit Faile,please try again.",
                        //        Obj = null,
                        //        Ret = -1,
                        //        Status = false
                        //    };
                        //}
                    }
                    else
                    {
                        objResult = new ResultHelper()
                        {
                            Desc   = " Faile,please try again",
                            Msg    = " Faile,please try again",
                            Obj    = null,
                            Ret    = -1,
                            Status = false
                        };
                    }
                }
            }
            catch (Exception ex)
            {
                objResult = new ResultHelper()
                {
                    Desc   = ex.Message,
                    Msg    = ex.Message,
                    Obj    = null,
                    Ret    = -1,
                    Status = false
                };
            }
            return(Json(objResult));
        }
Exemple #3
0
        public ActionResult Add(GlareSysEfDbAndModels.GroupInfo subject)
        {
            ResultHelper objResult = null;

            try
            {
                using (LedDb db = new LedDb())
                {
                    if (ModelState.IsValid)
                    {
                        subject.UpdateDt = DateTime.Now;
                        subject.CreateDt = DateTime.Now;
                        subject.IsDel    = 0;
                        string strMsg = string.Empty;
                        bool   b      = GroupBll.AddAGroup(ref subject, out strMsg);
                        if (b)
                        {
                            objResult = new ResultHelper()
                            {
                                Status = true,
                                Ret    = 0,
                                Obj    = subject,
                                Msg    = strMsg,
                                Desc   = strMsg
                            };
                        }
                        else
                        {
                            objResult = new ResultHelper()
                            {
                                Desc   = strMsg,
                                Msg    = strMsg,
                                Obj    = null,
                                Ret    = -1,
                                Status = false
                            };
                        }
                        //db.GroupInfo.Add(subject);
                        //if (db.SaveChanges() > 0)
                        //{

                        //    objResult = new ResultHelper()
                        //    {
                        //        Status = true,
                        //        Ret = 0,
                        //        Obj = subject,
                        //        Msg = "Add  Success!",
                        //        Desc = "Add  Success!"
                        //    };
                        //}
                        //else
                        //{
                        //    objResult = new ResultHelper()
                        //    {
                        //        Desc = "Add  Faile,please try again.",
                        //        Msg = "Add  Faile,please try again.",
                        //        Obj = null,
                        //        Ret = -1,
                        //        Status = false
                        //    };
                        //}
                    }
                    else
                    {
                        objResult = new ResultHelper()
                        {
                            Desc   = " Faile,please try again",
                            Msg    = " Faile,please try again",
                            Obj    = null,
                            Ret    = -1,
                            Status = false
                        };
                    }
                }
            }
            catch (Exception ex)
            {
                objResult = new ResultHelper()
                {
                    Desc   = ex.Message,
                    Msg    = ex.Message,
                    Obj    = null,
                    Ret    = -1,
                    Status = false
                };
            }
            return(Json(objResult));
        }