/////////////////////////////材料详细信息////////////////////////////////
        public string AddMaterialDetail(decimal pcid, string name, string brand, int count, decimal price,
            decimal total, string size, string seller, string contact, string tel, DateTime? date, string remark)
        {
            var user = GetCookieUser();
            if (user == null)
            {
                return JsonConvert.SerializeObject(new
                {
                    Message = "notlogin"
                });
            }
            try
            {
                var model = new Mo.MaterialDetail()
                {
                    Md_PcID = pcid,
                    Md_Name = name,
                    Md_Brand = brand,
                    Md_Count = count,
                    Md_Price = price,
                    Md_Total = total,
                    Md_Size = size,
                    Md_Seller = seller,
                    Md_Contact = contact,
                    Md_ContactTel = tel,
                    Md_Date = date,
                    Md_Remark = remark,
                    Md_State = 0,
                    Md_Inputer = user.Id,
                    Md_InputDate = DateTime.Now,
                };
                var id = materialBll.Add(model);
                if (id != 0)
                {
                    var purchase = purchaseBll.GetModel(Convert.ToDecimal(model.Md_PcID));
                    purchase.Pc_Total += model.Md_Total;
                    purchase.Pc_Editer = user.Id;
                    purchase.Pc_EditDate = DateTime.Now;
                    purchaseBll.Update(purchase);

                    Dal.Log.Add("添加材料详细信息,编号为:" + id, "ADD", user.Id);
                    return JsonConvert.SerializeObject(new
                    {
                        Message = "success"
                    });
                }
                else
                {
                    return JsonConvert.SerializeObject(new
                    {
                        Message = "false",
                        Content = "保存失败"
                    });
                }
            }
            catch (Exception ex)
            {
                Dal.LogError.Add(ex, user.Id);

                return JsonConvert.SerializeObject(new
                {
                    Message = "error"
                });
            }
        }
        //将文件数据放入DataSet对象中
        public string ImportXlsToData(string fileName)
        {
            var user = GetCookieUser();
            var result = string.Empty;
            try
            {
                var ds = CommonMethod.ImportXlsToDataSet(fileName);

                var list = ds.Tables[0].AsEnumerable().Where(li => !(li["工程编号"].ToString().Trim() == ""
                    && li["材料名称"].ToString().Trim() == "" && li["数量"].ToString().Trim() == ""
                    && li["单价"].ToString().Trim() == "" && li["规格型号"].ToString().Trim() == ""
                    && li["生产厂家"].ToString().Trim() == "" && li["联系人"].ToString().Trim() == ""
                    && li["联系电话"].ToString().Trim() == "" && li["供货日期"].ToString().Trim() == ""
                    && li["备注"].ToString().Trim() == "" && li["品牌"].ToString().Trim() == "")).ToList();

                if (!list.Any())
                {
                    result = "数据为空,导入失败";
                    return result;
                }

                var projNo = list.FirstOrDefault()["工程编号"].ToString();
                if (string.IsNullOrEmpty(projNo))
                {
                    result = "首行数据中工程编号不能为空,导入失败";
                    return result;
                }

                var proj = projBll.GetModelByNo(projNo);
                if (proj == null)
                {
                    result = "工程编号填写有误,导入失败";
                    return result;
                }

                var construction = constructionBll.GetModelList("Ct_State = 0 AND Ct_PID = " + proj.P_ID).FirstOrDefault();
                if (construction == null)
                {
                    result = "该工程无施工信息,导入失败";
                    return result;
                }

                var total = list.Sum(li => CommonMethod.ConvertToDecimal(li["单价"]) * CommonMethod.ConvertToInt(li["数量"]));

                var materialList = new List<Mo.MaterialDetail>();
                list.ForEach(li =>
                {
                    var msg = string.Empty;

                    //筛选错误类型

                    if (li["材料名称"].ToString().Trim() == "")
                    {
                        msg += ",材料名称不得为空";
                    }
                    if (li["数量"].ToString().Trim() == "")
                    {
                        msg += ",数量不得为空";
                    }
                    if (li["单价"].ToString().Trim() == "")
                    {
                        msg += ",单价不得为空";
                    }

                    //本条数据含有错误信息,则放弃导入,记录错误信息
                    if (msg != "")
                    {
                        result += "第" + (list.IndexOf(li) + 2) + "行数据有误" + msg + "<br/>";
                        return;
                    }

                    //总体错误信息不为空则放弃导入,只记录错误信息
                    if (result != "") return;

                    var model = new Mo.MaterialDetail
                    {
                        Md_Name = li["材料名称"].ToString(),
                        Md_Brand = li["品牌"].ToString(),
                        Md_Price = CommonMethod.ConvertToDecimal(li["单价"]),
                        Md_Count = CommonMethod.ConvertToInt(li["数量"]),
                        Md_Total = CommonMethod.ConvertToDecimal(li["单价"]) * CommonMethod.ConvertToInt(li["数量"]),
                        Md_Size = li["规格型号"].ToString(),
                        Md_Seller = li["生产厂家"].ToString(),
                        Md_Contact = li["联系人"].ToString(),
                        Md_ContactTel = li["联系电话"].ToString(),
                        Md_Date = CommonMethod.ConvertToDateTimeOrNull(li["供货日期"]),
                        Md_Remark = li["备注"].ToString(),
                        Md_State = 0,
                        Md_Inputer = user.Id,
                        Md_InputDate = DateTime.Now
                    };
                    materialList.Add(model);
                });
                //错误信息为空 则导入数据
                if (result == string.Empty)
                {
                    var pcid = purchaseBll.Add(new Mo.Purchase
                    {
                        Pc_CtID = construction.Ct_ID,
                        Pc_Total = total,
                        Pc_Date = DateTime.Now,
                        Pc_State = 0,
                        Pc_Inputer = user.Id,
                        Pc_InputDate = DateTime.Now,
                    });
                    if (pcid != 0)
                    {
                        Dal.Log.Add("添加材料采购信息,编号为:" + pcid, "ADD", user.Id);
                    }
                    materialList.ForEach(li =>
                    {
                        li.Md_PcID = pcid;
                        var mdId = materialBll.Add(li);
                        Dal.Log.Add("添加材料详细信息,编号为:" + mdId, "ADD", user.Id);
                    });
                }
            }
            catch (Exception ex)
            {
                result = "数据格式有误,导入失败";
            }
            return result;
        }