Пример #1
0
        public ActionResult GetBanerListJson()
        {
            List <object> baners = new List <object>();

            FileApp fileApp = new FileApp();
            var     data    = fileApp.GetList("baner");

            foreach (var item in data)
            {
                baners.Add(new { name = item.FileName, base64 = item.FileContent });
            }
            return(Content(baners.ToJson()));
        }
Пример #2
0
        public ActionResult GetInventory(string f_Id, string longitude, string latitude)
        {
            string        strSql  = @"select a.Id,a.WareId,a.WareName,d.Address,d.Longitude,d.Latitude,Distince=6378137.0*acos(sin(cast('" + latitude + "' as decimal(18,6))/180*pi())*sin(Latitude/180*pi())+cos(cast('" + latitude + "' as decimal(18,6))/180*pi())*cos(Latitude/180*pi())*cos((cast('" + longitude + "' as decimal(18,6))-Longitude)/180*pi())),a.OrderNo,c.ProductName as ProductType,(select F_ItemName from View_ItemType_ItemDetail where F_EnCode='0202' and F_ItemCode=a.Grade) as Grade,a.Strength,(select F_ItemName from View_ItemType_ItemDetail where F_EnCode='0208' and F_ItemCode=a.Length) as Length,(select F_ItemName from View_ItemType_ItemDetail where F_EnCode='0203' and F_ItemCode=a.HorseValue) as HorseValue,(select F_ItemName from View_ItemType_ItemDetail where F_EnCode='0207' and F_ItemCode=a.Status) as Status,(select F_ItemName from View_ItemType_ItemDetail where F_EnCode='0206' and F_ItemCode=a.QuoteType) as QuoteType,(case when a.QuoteType<>'Futures' then a.Price else null end) as Price,(case when a.QuoteType<>'Futures' then null else a.Contract end) as Contract,(case when a.QuoteType<>'Futures' then null else cast(b.Price as decimal(18,2)) end) as ContractPrice,(case when a.QuoteType<>'Futures' then null else cast(a.Basis+b.Price as decimal(18,2)) end) as TotalPrice,(case when a.QuoteType<>'Futures' then null else Basis end) as Basis,a.Year,a.SailingSchedule,(a.Weight-isnull((select sum(Weight) from InventoryOut where InventoryId=a.Id),0)) as Weight,a.Description from Inventory a left join Contract b on a.Contract=b.ContractCode left join Product c on c.ProductCode=a.ProductType inner join WareHouse d on a.WareId=d.Id where a.Id='" + f_Id + "'";
            DataView      dv      = DbHelper.ExecuteToDataView(strSql);
            FileApp       fileApp = new FileApp();
            var           files   = fileApp.GetList(f_Id);
            List <object> img     = new List <object>();

            foreach (FileEntity file in files)
            {
                //img.Add(new { base64 = file.FileContent });
                if (!string.IsNullOrEmpty(file.FilePath))
                {
                    img.Add(new { base64 = file.FilePath.Replace("\\", "/") });
                }
            }

            object obj = new object();

            obj = new
            {
                f_Id            = Convert.ToString(dv[0]["Id"]),
                wareId          = Convert.ToString(dv[0]["WareId"]),
                wareName        = Convert.ToString(dv[0]["WareName"]),
                address         = Convert.ToString(dv[0]["Address"]),
                distance        = (Convert.ToDouble(dv[0]["Distince"]) / 1000).ToString("#0.00"),
                longitude       = Convert.ToDouble(dv[0]["Longitude"]),
                latitude        = Convert.ToDouble(dv[0]["Latitude"]),
                orderNo         = Convert.ToString(dv[0]["OrderNo"]),
                productType     = Convert.ToString(dv[0]["ProductType"]),
                grade           = Convert.ToString(dv[0]["Grade"]),
                strength        = Convert.ToString(dv[0]["Strength"]),
                length          = Convert.ToString(dv[0]["Length"]),
                horseValue      = Convert.ToString(dv[0]["HorseValue"]),
                status          = Convert.ToString(dv[0]["Status"]),
                quoteType       = Convert.ToString(dv[0]["QuoteType"]),
                price           = Convert.ToString(dv[0]["Price"]),
                contract        = Convert.ToString(dv[0]["Contract"]),
                contractPrice   = Convert.ToString(dv[0]["ContractPrice"]),
                totalPrice      = Convert.ToString(dv[0]["TotalPrice"]),
                basis           = Convert.ToString(dv[0]["Basis"]),
                year            = Convert.ToString(dv[0]["Year"]),
                sailingSchedule = Convert.ToString(dv[0]["SailingSchedule"]),
                weight          = Convert.ToString(dv[0]["Weight"]),
                description     = Convert.ToString(dv[0]["Description"]),
                imgList         = img
            };

            return(Content(obj.ToJson()));
        }
Пример #3
0
        public ActionResult GetBanerListJson()
        {
            List <object> baners = new List <object>();

            FileApp fileApp = new FileApp();
            var     data    = fileApp.GetList("baner");

            foreach (var item in data)
            {
                //baners.Add(new { name = item.FileName, base64 = item.FileContent });
                if (!string.IsNullOrEmpty(item.FilePath))
                {
                    baners.Add(new { name = item.FileName, base64 = item.FilePath.Replace("\\", "/") });
                }
            }
            return(Content(baners.ToJson()));
        }
Пример #4
0
 public FilesController(FileApp app)
 {
     _app = app;
 }
Пример #5
0
 public FilesController(IAuth authUtil, FileApp app) : base(authUtil)
 {
     _app = app;
 }
Пример #6
0
        public ActionResult GetInventoryListJson(InventoryReq inventoryReq)
        {
            //sql
            string strSql = @"
                select
                    a.Id,
	                WareName,
	                OrderNo,
	                c.ProductName as ProductType,
	                c.ImgContent as ProductImg,
	                (select F_ItemName from View_ItemType_ItemDetail where F_EnCode='0202' and F_ItemCode=a.Grade) as Grade,
	                Strength,
	                (select F_ItemName from View_ItemType_ItemDetail where F_EnCode='0208' and F_ItemCode=a.Length) as Length,
	                (select F_ItemName from View_ItemType_ItemDetail where F_EnCode='0203' and F_ItemCode=a.HorseValue) as HorseValue,
	                (select F_ItemName from View_ItemType_ItemDetail where F_EnCode='0207' and F_ItemCode=a.Status) as Status,
	                (select F_ItemName from View_ItemType_ItemDetail where F_EnCode='0206' and F_ItemCode=a.QuoteType) as QuoteType,
	                (case when a.QuoteType<>'Futures' then a.Price else null end) as Price,
	                (case when a.QuoteType<>'Futures' then null else a.Contract end) as Contract,
	                (case when a.QuoteType<>'Futures' then null else cast(b.Price as decimal(18,2)) end) as ContractPrice,
	                (case when a.QuoteType<>'Futures' then null else cast(a.Basis+b.Price as decimal(18,2)) end) as TotalPrice,
	                (case when a.QuoteType<>'Futures' then null else Basis end) as Basis,
	                Year,
	                SailingSchedule,
	                (Weight-isnull((select sum(Weight) from InventoryOut where InventoryId=a.Id),0)) as Weight,
	                IsRecommend,
	                b.FS,b.M,b.S,b.C,b.V
                from Inventory a
	                left join Contract b on a.Contract=b.ContractCode
                    left join Product c on c.ProductCode=a.ProductType
                where 1=1 ";

            //where
            string strQry = "";

            if (inventoryReq.inventoryQry != null)
            {
                InventoryQry[] inventoryQrys = inventoryReq.inventoryQry;
                foreach (InventoryQry inventoryQry in inventoryQrys)
                {
                    if (inventoryQry.code.ToLower() == "strength")//强力是范围,其他都是选项
                    {
                        foreach (List selected in inventoryQry.list)
                        {
                            if (selected.name.ToLower() == "min")
                            {
                                strQry += " and cast(Strength as float)>=" + selected.code + " ";
                            }
                            else if (selected.name.ToLower() == "max")
                            {
                                strQry += " and cast(Strength as float)<=" + selected.code + " ";
                            }
                        }
                    }
                    else if (inventoryQry.code.ToLower() == "producttype")//分类中,其他是除美棉/澳棉/巴西棉/印度棉以外的所有
                    {
                        string condition = "";
                        foreach (List selected in inventoryQry.list)
                        {
                            if (selected.code.ToLower() != "qt")
                            {
                                if (selected.selected)
                                {
                                    condition += "'" + selected.code + "',";
                                }
                            }
                            else
                            {
                                if (selected.selected)
                                {
                                    DataView dvQT = DbHelper.ExecuteToDataView("select ProductCode from Product where ProductCode not in ('mm','bxm','ydm','om')");
                                    foreach (DataRowView drv in dvQT)
                                    {
                                        condition += "'" + drv["ProductCode"] + "',";
                                    }
                                }
                            }
                        }
                        if (!string.IsNullOrEmpty(condition))
                        {
                            strQry += " and " + inventoryQry.code + " in (" + condition.Trim(',') + ") ";
                        }
                    }
                    else
                    {
                        string condition = "";
                        foreach (List selected in inventoryQry.list)
                        {
                            if (selected.selected)
                            {
                                condition += "'" + selected.code + "',";
                            }
                        }
                        if (!string.IsNullOrEmpty(condition))
                        {
                            strQry += " and " + inventoryQry.code + " in (" + condition.Trim(',') + ") ";
                        }
                    }
                }
            }

            //order
            string strOrder = " order by IsRecommend desc,a.CreatorTime desc ";

            //paging
            Pagination pagination = inventoryReq.pagination;
            string     strPaging  = " offset " + (pagination.page - 1) * pagination.rows + " rows fetch next " + pagination.rows + " rows only";

            DataView      dvInventory = DbHelper.ExecuteToDataView(strSql + strQry + strOrder + strPaging);
            List <object> inventorys  = new List <object>();

            foreach (DataRowView drv in dvInventory)
            {
                FileApp       fileApp = new FileApp();
                var           files   = fileApp.GetList(Convert.ToString(drv["Id"]));
                List <object> img     = new List <object>();
                foreach (FileEntity file in files)
                {
                    //baer64改成url,参数名不变了
                    //img.Add(new { base64 = file.FileContent });
                    if (!string.IsNullOrEmpty(file.FilePath))
                    {
                        img.Add(new { base64 = file.FilePath.Replace("\\", "/") });
                    }
                }
                inventorys.Add(new
                {
                    f_Id            = Convert.ToString(drv["Id"]),
                    wareName        = Convert.ToString(drv["WareName"]),
                    orderNo         = Convert.ToString(drv["OrderNo"]),
                    productType     = Convert.ToString(drv["ProductType"]),
                    productImg      = Convert.ToString(drv["ProductImg"]),
                    grade           = Convert.ToString(drv["Grade"]),
                    strength        = Convert.ToString(drv["Strength"]),
                    length          = Convert.ToString(drv["Length"]),
                    horseValue      = Convert.ToString(drv["HorseValue"]),
                    status          = Convert.ToString(drv["Status"]),
                    quoteType       = Convert.ToString(drv["QuoteType"]),
                    price           = Convert.ToString(drv["Price"]),
                    contract        = Convert.ToString(drv["Contract"]),
                    contractPrice   = Convert.ToString(drv["ContractPrice"]),
                    basis           = Convert.ToString(drv["Basis"]),
                    totalPrice      = Convert.ToString(drv["TotalPrice"]),
                    year            = Convert.ToString(drv["Year"]),
                    sailingSchedule = Convert.ToString(drv["SailingSchedule"]),
                    weight          = Convert.ToString(drv["Weight"]),
                    isRecommend     = Convert.ToString(drv["IsRecommend"]),
                    fs      = Convert.ToString(drv["FS"]),
                    m       = Convert.ToString(drv["M"]),
                    s       = Convert.ToString(drv["S"]),
                    c       = Convert.ToString(drv["C"]),
                    v       = Convert.ToString(drv["V"]),
                    imgList = img
                });
            }

            return(Content(inventorys.ToJson()));
        }
Пример #7
0
        public ActionResult Export(string id)
        {
            var data = new ResumeApp().GetResume(id);

            var tpFilePath = Server.MapPath("~/Content/ResumeTemp.html");

            var resumeTp = "";

            using (var sr = new StreamReader(tpFilePath))
            {
                resumeTp = sr.ReadToEnd();
            }

            if (data.Cv != null)
            {
                var    entity = new FileApp().GetForm(data.Cv.Logo);
                string path   = Server.MapPath("~/Image/") + entity.FileName;

                resumeTp = resumeTp.Replace("[#cvUsername#]", data.Cv.Username)
                           .Replace("[#cvUserSex#]", data.Cv.UserSex)
                           .Replace("[#cvUserAge#]", data.Cv.UserAge.HasValue?data.Cv.UserAge.ToString():"")
                           .Replace("[#cvUserAddress#]", data.Cv.UserAddress)
                           .Replace("[#cvUserTel#]", data.Cv.UserTel)
                           .Replace("[#cvUserEmail#]", data.Cv.UserEmail)
                           .Replace("[#cvSkill#]", data.Cv.SkillContent)
                           .Replace("[#cvSelf#]", data.Cv.SelfContent)
                           .Replace("[#cvUserLogo#]", path);
            }

            if (data.Edu != null)
            {
                resumeTp = resumeTp.Replace("[#eduSchool#]", data.Edu.School)
                           .Replace("[#eduMajor#]", data.Edu.Major)
                           .Replace("[#eduSDT#]", data.Edu.SDTStr);
            }

            var jobExpTp = "<table>"
                           + "	<tr><td class=\"font18 width400\">[#CpyName#]</td><td>[#SDT#] ~ [#EDT#]</td></tr>"
                           + "	<tr><td colspan=\"2\"><span>职务:[#Post#]</span></td></tr>"
                           + "	<tr><td colspan=\"2\"><span>工作内容:[#JobDesc#]</span></td></tr>"
                           + "</table>";

            if (data.JobExps != null)
            {
                List <string> jobExps = new List <string>();
                data.JobExps.ForEach(x => {
                    var temp = jobExpTp.Replace("[#CpyName#]", x.CpyName)
                               .Replace("[#SDT#]", x.SDTStr)
                               .Replace("[#EDT#]", x.EDTStr)
                               .Replace("[#Post#]", x.Post)
                               .Replace("[#JobDesc#]", x.JobDesc);
                    jobExps.Add(temp);
                });
                resumeTp = resumeTp.Replace("[#cvJobExp#]", string.Join("", jobExps.ToArray()));
            }

            var trainExpTp = "<table>"
                             + "	<tr><td class=\"font18 width400\">[#CpyName#]</td><td>[#SDT#] ~ [#EDT#]</td></tr>"
                             + "	<tr><td colspan=\"2\"><span>培训岗位:[#Post#]</span></td></tr>"
                             + "	<tr><td colspan=\"2\"><span>培训内容:[#TrainDesc#]</span></td></tr>"
                             + "</table>";

            if (data.TrainExps != null)
            {
                List <string> trainExps = new List <string>();
                data.TrainExps.ForEach(x =>
                {
                    var temp = trainExpTp.Replace("[#CpyName#]", x.CpyName)
                               .Replace("[#SDT#]", x.SDTStr)
                               .Replace("[#EDT#]", x.EDTStr)
                               .Replace("[#Post#]", x.Post)
                               .Replace("[#TrainDesc#]", x.TrainDesc);
                    trainExps.Add(temp);
                });
                resumeTp = resumeTp.Replace("[#cvTrainExp#]", string.Join("", trainExps.ToArray()));
            }

            var cerTp = "<table>"
                        + "    <tr><td class=\"width400\">[#Name#]</td><td>[#Level#]</td></tr>"
                        + "</table>";

            if (data.Cers != null)
            {
                List <string> cers = new List <string>();
                data.Cers.ForEach(x =>
                {
                    var temp = cerTp.Replace("[#Name#]", x.Name)
                               .Replace("[#Level#]", x.Level);
                    cers.Add(temp);
                });
                resumeTp = resumeTp.Replace("[#cvCer#]", string.Join("", cers.ToArray()));
            }

            Document        doc     = new Document();
            DocumentBuilder builder = new DocumentBuilder(doc);

            builder.InsertHtml(resumeTp);

            byte[] buffer = null;
            using (var ms = new MemoryStream())
            {
                doc.Save(ms, SaveFormat.Doc);
                buffer      = new byte[ms.Length];
                ms.Position = 0;
                ms.Read(buffer, 0, buffer.Length);
            }
            return(File(buffer, "application/x-zip-compressed", HttpUtility.UrlEncode("我的简历.doc", Encoding.UTF8)));
        }