Example #1
0
        public void Register(string code)
        {
            if (code != ActiveCode.ToString())
            {
                return;
            }

            RegisterDate = DateTime.Now;
            Active       = true;
        }
Example #2
0
        public TaiKhoanViewModel Register(TaiKhoanViewModel TaiKhoanVm, string s)
        {
            var taiKhoan = Mapper.Map <TaiKhoanViewModel, TaiKhoan>(TaiKhoanVm);
            var today    = DateTime.Today.ToShortDateString();

            taiKhoan.thoigiandk = today;

            int checkEmail = _repository.FindAllNoTracking().Where(x => x.email == TaiKhoanVm.email).Count();

            if (checkEmail > 0)
            {
                TaiKhoanVm.email = "";
            }
            int checkSdt = _repository.FindAllNoTracking().Where(x => x.sdt == TaiKhoanVm.sdt).Count();

            if (checkSdt > 0)
            {
                TaiKhoanVm.sdt = "";
            }
            if (checkEmail < 1 && checkSdt < 1)
            {
                if (TaiKhoanVm.UserType == Data.Enum.UserType.Customer)
                {
                    taiKhoan.KhachhangNavigation = new Khachhang();
                }
                if (TaiKhoanVm.UserType == Data.Enum.UserType.Merchant)
                {
                    taiKhoan.NccNavigation = new Ncc();
                }

                _repository.AddReturn(taiKhoan);
                taiKhoan.matk    = taiKhoan.KeyId;
                TaiKhoanVm.KeyId = taiKhoan.KeyId;



                ActiveCode newCode = new ActiveCode();
                newCode.KeyId      = 0;
                newCode.code       = s;
                newCode.CodeType   = Data.Enum.CodeType.Active;
                newCode.DateCreate = DateTime.Now;
                newCode.User_FK    = taiKhoan.KeyId;
                newCode.CodeStatus = Data.Enum.CodeStatus.UnActivated;
                _repositoryCode.Add(newCode);
            }


            //sanphamVm.Id = _convertFunction.Instance.Create_Code(true, sp.KeyId,
            //CommonConstants.defaultLengthNumberCode, const_AddressbookType.Employee);
            //sp.Id = HP_EmployeeVm.Id;
            //employee.UserBy.IsEmployee = true;

            return(TaiKhoanVm);
        }
Example #3
0
        public TaiKhoanViewModel ConfirmEmail(int id, string s)
        {
            ActiveCode Code = _repositoryCode.FindAll().Where(x => x.User_FK == id).SingleOrDefault();

            if (s == Code.code)
            {
                Code.CodeStatus = Data.Enum.CodeStatus.Activated;
                var item = _repository.FindById(id);
                return(Mapper.Map <TaiKhoan, TaiKhoanViewModel>(item));
            }
            else
            {
                return(new TaiKhoanViewModel());
            }
        }
Example #4
0
        public CMCResponse UploadExcelFile()
        {
            try {
                //保存文件
                var    file     = System.Web.HttpContext.Current.Request.Files[0];
                string fullPath = HttpContext.Current.Server.MapPath("~/ExcelUpload/") + file.FileName;
                file.SaveAs(fullPath);

                //获取文件数据
                using (FileStream fs = new FileStream(fullPath, FileMode.Open))
                {
                    IWorkbook workbook     = new XSSFWorkbook(fs);
                    ISheet    sheet        = workbook.GetSheetAt(0);
                    int       lastRowIndex = sheet.LastRowNum;

                    //第一行获取活动名称
                    IRow   row          = sheet.GetRow(0);
                    int    rowLastIndex = row.LastCellNum - 1;
                    string activeName   = row.GetCell(rowLastIndex).StringCellValue;
                    int    lastColumn   = 0;
                    switch (activeName)
                    {
                    case "激活":
                        lastColumn = 9;

                        break;

                    case "营销":
                        lastColumn = 12;

                        break;

                    case "消费者":
                        lastColumn = 16;

                        break;

                    case "资产":
                        lastColumn = 18;

                        break;

                    case "资产领用":
                        lastColumn = 21;

                        break;

                    default:
                        Response.status  = 1;
                        Response.message = "上传活动名称有误";
                        return(Response);
                    }
                    //第3/4行获取名称基本信息
                    //List<string> nameList = new List<string>();
                    //List<string> basicInfo = new List<string>();
                    //for (int nameIndex = 0; nameIndex < lastColumn; nameIndex++)
                    //{
                    //    row = sheet.GetRow(2);
                    //    nameList.Add(row.GetCell(nameIndex).StringCellValue);
                    //}

                    //生成上传活动信息存入数据库
                    byte[] byteArray = new byte[file.ContentLength];
                    file.InputStream.Read(byteArray, 0, file.ContentLength);
                    //fs.Read(byteArray, 0, Convert.ToInt32(fs.Length));

                    IRow       row3       = sheet.GetRow(3);
                    CodeActive codeActive = new CodeActive();
                    codeActive.AppId           = "Excel文件上传";
                    codeActive.CorpCode        = row3.GetCell(5).StringCellValue;
                    codeActive.CorpName        = row3.GetCell(4).StringCellValue;
                    codeActive.SubCorpCode     = row3.GetCell(6).StringCellValue;
                    codeActive.ProductCode     = row3.GetCell(8).StringCellValue;
                    codeActive.ProductName     = row3.GetCell(7).StringCellValue;
                    codeActive.ProduceWorkline = row3.GetCell(6).StringCellValue;
                    codeActive.ActivityName    = activeName;
                    codeActive.Amount          = Convert.ToString(lastRowIndex - 2);
                    codeActive.ActualQuantity  = Convert.ToString(lastRowIndex - 2);
                    codeActive.UploadDate      = DateTime.Now;
                    codeActive.Uploader        = "CMC后台";
                    codeActive.ProcessType     = 3;
                    codeActive.Memo            = row3.GetCell(9).StringCellValue;
                    codeActive.ApplyId         = 0;

                    int activeID = CodeActiveUploadFactory.Instance.InsertNewActive(codeActive, byteArray);
                    if (activeName == "激活")
                    {
                        List <ActiveCode> alist = new List <ActiveCode>();
                        //第4行开始获取数据
                        for (int index = 3; index <= lastRowIndex; index++)
                        {
                            //获取当前行
                            row = sheet.GetRow(index);
                            //生成Mongo对象存码信息

                            ActiveCode c = new ActiveCode();
                            c.ActiveName     = activeName;
                            c.CreateDate     = row.GetCell(2).DateCellValue;;
                            c.ApplyId        = codeActive.ApplyId;
                            c.CodeActivityId = activeID;
                            c.CorpCode       = codeActive.CorpCode;
                            c.SubCorpCode    = codeActive.SubCorpCode;
                            c.CorpName       = codeActive.CorpName;
                            try
                            {
                                c.Code = row.GetCell(0).StringCellValue;
                            }
                            catch
                            {
                                c.Code = row.GetCell(0).NumericCellValue.ToString();
                            }
                            //c.MaskCode = row.GetCell(1).NumericCellValue.ToString();
                            c.ProductCode = row.GetCell(8).StringCellValue;
                            c.ProductName = row.GetCell(7).StringCellValue;
                            c.Memo        = row.GetCell(9).StringCellValue;
                            alist.Add(c);
                        }
                        string res = ReportFactory.Instance.SplitMongoInster <ActiveCode>(alist);
                        if (res == "数据插入MongoDB失败")
                        {
                            Response.status       = 0;
                            this.Response.message = res + ",检查MongoDB是否正常";
                            return(Response);
                        }
                    }
                    if (activeName == "营销")
                    {
                        List <SalesCode> alist = new List <SalesCode>();
                        //第4行开始获取数据
                        for (int index = 3; index <= lastRowIndex; index++)
                        {
                            //获取当前行
                            row = sheet.GetRow(index);
                            //生成Mongo对象存码信息

                            SalesCode c = new SalesCode();
                            c.ActiveName     = activeName;
                            c.CreateDate     = row.GetCell(2).DateCellValue;;
                            c.ApplyId        = codeActive.ApplyId;
                            c.CodeActivityId = activeID;
                            c.CorpCode       = codeActive.CorpCode;
                            c.SubCorpCode    = codeActive.SubCorpCode;
                            c.CorpName       = codeActive.CorpName;
                            try
                            {
                                c.Code = row.GetCell(0).StringCellValue;
                            }
                            catch
                            {
                                c.Code = row.GetCell(0).NumericCellValue.ToString();
                            }
                            //c.MaskCode = row.GetCell(1).NumericCellValue.ToString();
                            c.ProductCode       = row.GetCell(8).StringCellValue;
                            c.ProductName       = row.GetCell(7).StringCellValue;
                            c.Memo              = row.GetCell(9).StringCellValue;
                            c.ActiveDescription = row.GetCell(10).StringCellValue;
                            c.ActiveStartDate   = row.GetCell(11).DateCellValue;
                            c.ActiveEndDate     = row.GetCell(12).DateCellValue;
                            alist.Add(c);
                        }
                        string res = ReportFactory.Instance.SplitMongoInster <SalesCode>(alist);
                        if (res == "数据插入MongoDB失败")
                        {
                            Response.status       = 0;
                            this.Response.message = res + ",检查MongoDB是否正常";
                            return(Response);
                        }
                    }
                    if (activeName == "消费者")
                    {
                        List <CustomerCode> alist = new List <CustomerCode>();
                        //第4行开始获取数据
                        for (int index = 3; index <= lastRowIndex; index++)
                        {
                            //获取当前行
                            row = sheet.GetRow(index);
                            //生成Mongo对象存码信息

                            CustomerCode c = new CustomerCode();
                            c.ActiveName     = activeName;
                            c.CreateDate     = row.GetCell(2).DateCellValue;;
                            c.ApplyId        = codeActive.ApplyId;
                            c.CodeActivityId = activeID;
                            c.CorpCode       = codeActive.CorpCode;
                            c.SubCorpCode    = codeActive.SubCorpCode;
                            c.CorpName       = codeActive.CorpName;
                            try
                            {
                                c.Code = row.GetCell(0).StringCellValue;
                            }
                            catch
                            {
                                c.Code = row.GetCell(0).NumericCellValue.ToString();
                            }
                            //c.MaskCode = row.GetCell(1).NumericCellValue.ToString();
                            c.ProductCode       = row.GetCell(8).StringCellValue;
                            c.ProductName       = row.GetCell(7).StringCellValue;
                            c.Memo              = row.GetCell(9).StringCellValue;
                            c.ActiveDescription = row.GetCell(10).StringCellValue;
                            c.ActiveStartDate   = row.GetCell(11).DateCellValue;
                            c.ActiveEndDate     = row.GetCell(12).DateCellValue;
                            c.CustomerOpenID    = row.GetCell(13).StringCellValue;
                            c.CustomerTime      = row.GetCell(14).DateCellValue;
                            c.CustomerLocatio   = row.GetCell(15).StringCellValue;
                            c.WhatActive        = row.GetCell(16).StringCellValue;
                            alist.Add(c);
                        }
                        string res = ReportFactory.Instance.SplitMongoInster <CustomerCode>(alist);
                        if (res == "数据插入MongoDB失败")
                        {
                            Response.status       = 0;
                            this.Response.message = res + ",检查MongoDB是否正常";
                            return(Response);
                        }
                    }
                    if (activeName == "消费者")
                    {
                        List <CustomerCode> alist = new List <CustomerCode>();
                        //第4行开始获取数据
                        for (int index = 3; index <= lastRowIndex; index++)
                        {
                            //获取当前行
                            row = sheet.GetRow(index);
                            //生成Mongo对象存码信息

                            CustomerCode c = new CustomerCode();
                            c.ActiveName     = activeName;
                            c.CreateDate     = row.GetCell(2).DateCellValue;;
                            c.ApplyId        = codeActive.ApplyId;
                            c.CodeActivityId = activeID;
                            c.CorpCode       = codeActive.CorpCode;
                            c.SubCorpCode    = codeActive.SubCorpCode;
                            c.CorpName       = codeActive.CorpName;
                            c.Code           = row.GetCell(0).NumericCellValue.ToString();
                            //c.MaskCode = row.GetCell(1).NumericCellValue.ToString();
                            c.ProductCode       = row.GetCell(8).StringCellValue;
                            c.ProductName       = row.GetCell(7).StringCellValue;
                            c.Memo              = row.GetCell(9).StringCellValue;
                            c.ActiveDescription = row.GetCell(10).StringCellValue;
                            c.ActiveStartDate   = row.GetCell(11).DateCellValue;
                            c.ActiveEndDate     = row.GetCell(12).DateCellValue;
                            c.CustomerOpenID    = row.GetCell(13).StringCellValue;
                            c.CustomerTime      = row.GetCell(14).DateCellValue;
                            c.CustomerLocatio   = row.GetCell(15).StringCellValue;
                            c.WhatActive        = row.GetCell(16).StringCellValue;
                            alist.Add(c);
                        }
                        string res = ReportFactory.Instance.SplitMongoInster <CustomerCode>(alist);
                        if (res == "数据插入MongoDB失败")
                        {
                            Response.status       = 0;
                            this.Response.message = res + ",检查MongoDB是否正常";
                            return(Response);
                        }
                    }
                    if (activeName == "资产")
                    {
                        List <PropertyCode> alist = new List <PropertyCode>();
                        //第4行开始获取数据
                        for (int index = 3; index <= lastRowIndex; index++)
                        {
                            //获取当前行
                            row = sheet.GetRow(index);
                            //生成Mongo对象存码信息

                            PropertyCode c = new PropertyCode();
                            c.ActiveName     = activeName;
                            c.CreateDate     = row.GetCell(2).DateCellValue;
                            c.ApplyId        = codeActive.ApplyId;
                            c.CodeActivityId = activeID;
                            c.CorpCode       = codeActive.CorpCode;
                            c.SubCorpCode    = codeActive.SubCorpCode;
                            c.CorpName       = codeActive.CorpName;
                            try
                            {
                                c.Code = row.GetCell(0).StringCellValue;
                            }
                            catch
                            {
                                c.Code = row.GetCell(0).NumericCellValue.ToString();
                            }
                            //c.MaskCode = row.GetCell(1).NumericCellValue.ToString();
                            c.ProductCode         = row.GetCell(8).StringCellValue;
                            c.ProductName         = row.GetCell(7).StringCellValue;
                            c.Memo                = row.GetCell(9).StringCellValue;
                            c.ProductProvider     = row.GetCell(17).StringCellValue;
                            c.ProductPurcheseDate = row.GetCell(18).DateCellValue;
                            alist.Add(c);
                        }
                        string res = ReportFactory.Instance.SplitMongoInster <PropertyCode>(alist);
                        if (res == "数据插入MongoDB失败")
                        {
                            Response.status       = 0;
                            this.Response.message = res + ",检查MongoDB是否正常";
                            return(Response);
                        }
                    }
                    if (activeName == "资产领用")
                    {
                        List <PropertyUseCode> alist = new List <PropertyUseCode>();
                        //第4行开始获取数据
                        for (int index = 3; index <= lastRowIndex; index++)
                        {
                            //获取当前行
                            row = sheet.GetRow(index);
                            //生成Mongo对象存码信息

                            PropertyUseCode c = new PropertyUseCode();
                            c.ActiveName     = activeName;
                            c.CreateDate     = row.GetCell(2).DateCellValue;
                            c.ApplyId        = codeActive.ApplyId;
                            c.CodeActivityId = activeID;
                            c.CorpCode       = codeActive.CorpCode;
                            c.SubCorpCode    = codeActive.SubCorpCode;
                            c.CorpName       = codeActive.CorpName;
                            try
                            {
                                c.Code = row.GetCell(0).StringCellValue;
                            }
                            catch
                            {
                                c.Code = row.GetCell(0).NumericCellValue.ToString();
                            }
                            //c.MaskCode = row.GetCell(1).NumericCellValue.ToString();
                            c.ProductCode     = row.GetCell(8).StringCellValue;
                            c.ProductName     = row.GetCell(7).StringCellValue;
                            c.Memo            = row.GetCell(9).StringCellValue;
                            c.ClaimDepartment = row.GetCell(19).StringCellValue;
                            c.ClaimPerson     = row.GetCell(20).StringCellValue;
                            c.ClaimDate       = row.GetCell(21).DateCellValue;
                            alist.Add(c);
                        }
                        string res = ReportFactory.Instance.SplitMongoInster <PropertyUseCode>(alist);
                        if (res == "数据插入MongoDB失败")
                        {
                            Response.status       = 0;
                            this.Response.message = res + ",检查MongoDB是否正常";
                            return(Response);
                        }
                    }
                }

                //删除文件
                System.IO.File.Delete(fullPath);

                Response.status  = 1;
                Response.message = "上传成功";
            }
            catch (Exception e)
            {
                Response.status  = 0;
                Response.message = e.Message;
            }

            return(Response);
        }