Пример #1
0
 public bool Save(string name, string phone, string idcardno,
     string specialidcard, string belong,
     DJ_GroupWorkerType workertype,DJ_DijiesheInfo currentDjs, out string errMsg)
 {
     DJ_Workers worker = new DJ_Workers();
     return Save(name, phone, idcardno, specialidcard, belong, workertype, currentDjs, out worker, out errMsg);
 }
Пример #2
0
        public bool Save(string name, string phone, string idcardno,
            string specialidcard, string belong,
            DJ_GroupWorkerType workertype, DJ_DijiesheInfo currentDjs,out DJ_Workers worker, out string errMsg)
        {
            worker = new DJ_Workers();
            bool result = true;
            errMsg = string.Empty;
            var workers = GetWorkers8Multi(string.Empty, name, phone, idcardno, string.Empty, workertype, currentDjs.Id.ToString());
            if (workers.Count > 0)
            {
                result = false;
                worker = workers[0];
                errMsg = "此工作人员已录入,不能重复添加";
            }
            else
            {

                worker.CompanyBelong = belong;
                worker.DJ_Dijiesheinfo = currentDjs;
                worker.IDCard = idcardno;
                worker.Name = name;
                worker.Phone = phone;
                worker.SpecificIdCard = specialidcard;
                worker.WorkerType = workertype;
                Save(worker);
            }
            return result;
        }
Пример #3
0
    protected void btnUpload_Click(object sender, EventArgs e)
    {
        string fullname = FileUpload1.FileName.ToString();//直接取得文件名
        string url = FileUpload1.PostedFile.FileName.ToString();//取得上传文件路径
        string typ = FileUpload1.PostedFile.ContentType.ToString();//获取文件MIME内容类型
        string typ2 = fullname.Substring(fullname.LastIndexOf(".") + 1);//后缀名, 不带".".
        int size = FileUpload1.PostedFile.ContentLength;
        string message = string.Empty;

        #region 保存
        if (typ2 == "xlsx" || typ2 == "xls" || typ2 == "xlsm")
        {
            if (size <= 4134904)
            {
                FileUpload1.SaveAs(excelPath + "temp-"+CurrentDJS.SeoName+"." + typ2);
                ExcelOplib.Entity.GroupAll group_excel = excel.getGroup(excelPath + "temp-" + CurrentDJS.SeoName + "." + typ2, out message);
                group_excel.GroupMemberList = group_excel.GroupMemberList.Where(x => !string.IsNullOrEmpty(x.Memtype)).ToList();

                #region group modify
                //group修改
                if (!string.IsNullOrEmpty(Request.QueryString["groupid"]))
                {
                    lblTitle.Text = "从excel文件更新团队";
                    var group_db = bllgroup.GetOne(new Guid(Request.QueryString[0]));
                    /*
                     todo 显示要更新的团队信息
                     */
                    group_db.Name = group_excel.GroupBasic.Name;
                    group_db.BeginDate = DateTime.Parse(group_excel.GroupBasic.Begindate);
                    group_db.DaysAmount = int.Parse(group_excel.GroupBasic.Days);
                    group_db.EndDate = DateTime.Parse(group_excel.GroupBasic.Begindate).AddDays(int.Parse(group_excel.GroupBasic.Days));
                    //group_db.Workers.Clear();

                    group_db.Members.Clear();
                    group_db.Routes.Clear();
                    group_model.DijiesheEditor = (Model.DJ_User_TourEnterprise)CurrentMember;
                    foreach (var item in group_excel.GroupMemberList.Where(x => x.Memtype == "导游" || x.Memtype == "司机"))
                    {
                        group_db.Workers.Add(new Model.DJ_Group_Worker()
                        {
                            DJ_TourGroup = group_db,
                            DJ_Workers = new Model.DJ_Workers()
                            {
                                IDCard = item.Memid,
                                SpecificIdCard = item.Cardno,
                                WorkerType = (Model.DJ_GroupWorkerType)Enum.Parse(typeof(Model.DJ_GroupWorkerType), item.Memtype),
                                Phone = item.Memphone,
                                Name = item.Memname
                            }
                        });
                    }
                    foreach (var item in group_excel.GroupMemberList.Where(x => x.Memtype != "导游" && x.Memtype != "司机"))
                    {
                        group_db.Members.Add(new Model.DJ_TourGroupMember()
                        {
                            DJ_TourGroup = group_db,
                            IdCardNo = item.Memid,
                            SpecialCardNo = item.Cardno,
                            MemberType = (Model.MemberType)Enum.Parse(typeof(Model.MemberType), item.Memtype),
                            PhoneNum = item.Memphone,
                            RealName = item.Memname
                        });
                    }
                    foreach (var item in group_excel.GroupRouteList)
                    {
                        var temp_scenic = item.Scenic.Split(new char[] { ',', '-' }, StringSplitOptions.RemoveEmptyEntries);
                        var temp_hotel = item.Hotel.Split(new char[] { ',', '-' }, StringSplitOptions.RemoveEmptyEntries);
                        foreach (var item2 in temp_scenic)
                        {
                            var sceniclist = bllenterp.GetDJS8name(item2);
                            if (sceniclist.Count == 0)
                            {
                                bllenterp.Save(new Model.DJ_TourEnterprise()
                                {
                                    Name = item2,
                                    Type = Model.EnterpriseType.景点
                                });
                            }
                            group_model.Routes.Add(new Model.DJ_Route()
                            {
                                DJ_TourGroup = group_model,
                                DayNo = int.Parse(item.RouteDate),
                                Enterprise = sceniclist.Count == 0 ? bllenterp.GetDJS8name(item2).First() : sceniclist[0]
                            });
                        }
                        foreach (var item2 in temp_hotel)
                        {
                            var hotellist = bllenterp.GetDJS8name(item2);
                            if (hotellist.Count == 0)
                            {
                                bllenterp.Save(new Model.DJ_TourEnterprise()
                                {
                                    Name = item2,
                                    Type = Model.EnterpriseType.宾馆
                                });
                            }
                            group_model.Routes.Add(new Model.DJ_Route()
                            {
                                DJ_TourGroup = group_model,
                                DayNo = int.Parse(item.RouteDate),
                                Enterprise = hotellist.Count == 0 ? bllenterp.GetDJS8name(item2).First() : hotellist[0]
                            });
                        }
                    }
                    group_model = group_db;
                    bllgroup.Save(group_db);
                }
                #endregion
                #region group new
                else
                {
                    lblTitle.Text = "从excel文件新建团队";
                    group_model.Name = group_excel.GroupBasic.Name;
                    group_model.BeginDate = DateTime.Parse(group_excel.GroupBasic.Begindate);
                    group_model.DaysAmount = int.Parse(group_excel.GroupBasic.Days);
                    group_model.EndDate = DateTime.Parse(group_excel.GroupBasic.Begindate).AddDays(int.Parse(group_excel.GroupBasic.Days));
                    group_model.Workers = new List<Model.DJ_Group_Worker>();
                    group_model.Members = new List<Model.DJ_TourGroupMember>();
                    group_model.Routes = new List<Model.DJ_Route>();
                    group_model.DJ_DijiesheInfo = CurrentDJS;
                    group_model.DijiesheEditor = (Model.DJ_User_TourEnterprise)CurrentMember;
                    foreach (var item in group_excel.GroupMemberList.Where(x => x.Memtype == "导游" || x.Memtype == "司机"))
                    {
                        //是否已经存在该worker
                        var worker = bllworker.GetWorkers8Multi(null, item.Memname, null, null, null,
                            Enum.Parse(typeof(Model.DJ_GroupWorkerType), item.Memtype), CurrentDJS.Id.ToString());
                        //不存在,添加
                        if (worker.Count == 0)
                        {
                            var new_worker = new Model.DJ_Workers()
                                {
                                    IDCard = item.Memid,
                                    SpecificIdCard = item.Cardno,
                                    WorkerType = (Model.DJ_GroupWorkerType)Enum.Parse(typeof(Model.DJ_GroupWorkerType), item.Memtype),
                                    Phone = item.Memphone,
                                    Name = item.Memname,
                                    DJ_Dijiesheinfo=CurrentDJS
                                };
                            bllworker.Save(new_worker);
                            group_model.Workers.Add(new Model.DJ_Group_Worker()
                            {
                                DJ_TourGroup = group_model,
                                DJ_Workers = new_worker
                            });
                        }
                        //存在
                        else
                        {
                            group_model.Workers.Add(new Model.DJ_Group_Worker()
                            {
                                DJ_TourGroup = group_model,
                                DJ_Workers = worker.First()
                            });
                        }
                    }
                    foreach (var item in group_excel.GroupMemberList.Where(x => x.Memtype != "导游" && x.Memtype != "司机"))
                    {
                        group_model.Members.Add(new Model.DJ_TourGroupMember()
                        {
                            DJ_TourGroup = group_model,
                            IdCardNo = item.Memid,
                            SpecialCardNo = item.Cardno,
                            MemberType = (Model.MemberType)Enum.Parse(typeof(Model.MemberType), item.Memtype),
                            PhoneNum = item.Memphone,
                            RealName = item.Memname
                        });
                    }
                    foreach (var item in group_excel.GroupRouteList)
                    {
                        var temp_scenic = item.Scenic.Split(new char[] { ',', '-' }, StringSplitOptions.RemoveEmptyEntries);
                        var temp_hotel = item.Hotel.Split(new char[] { ',', '-' }, StringSplitOptions.RemoveEmptyEntries);
                        foreach (var item2 in temp_scenic)
                        {
                            var sceniclist=bllenterp.GetDJS8name(item2);
                            if(sceniclist.Count==0)
                            {
                                bllenterp.Save(new Model.DJ_TourEnterprise(){
                                    Name=item2,
                                    Type=Model.EnterpriseType.景点
                                });
                            }
                            group_model.Routes.Add(new Model.DJ_Route()
                            {
                                DJ_TourGroup = group_model,
                                DayNo = int.Parse(item.RouteDate),
                                Enterprise = sceniclist.Count == 0 ? bllenterp.GetDJS8name(item2).First() : sceniclist[0]
                            });
                        }
                        foreach (var item2 in temp_hotel)
                        {
                            var hotellist = bllenterp.GetDJS8name(item2);
                            if (hotellist.Count == 0)
                            {
                                bllenterp.Save(new Model.DJ_TourEnterprise()
                                {
                                    Name = item2,
                                    Type = Model.EnterpriseType.宾馆
                                });
                            }
                            group_model.Routes.Add(new Model.DJ_Route()
                            {
                                DJ_TourGroup = group_model,
                                DayNo = int.Parse(item.RouteDate),
                                Enterprise = hotellist.Count == 0 ? bllenterp.GetDJS8name(item2).First() : hotellist[0]
                            });
                        }
                    }
                    bllgroup.Save(group_model);
                }
                #endregion
                Response.Redirect("/LocalTravelAgent/Groups/GroupDetail.aspx?guid=" + group_model.Id);
            }
            else
            {
                Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('你的文件超过限制大小!')", true);
                return;
            }
        }
        else
        {
            //Label1.Text = "上传文件格式不正确.";
            return;
        }
        #endregion
    }