Esempio n. 1
0
        public static CustomerDto getDTO(DataRow dr)
        {
            CustomerDto CustomerDto = new CustomerDto();

            CustomerDto.CustomerId = int.Parse(dr["CustomerId"].ToString());
            CustomerDto.CustomerName = dr["CustomerName"].ToString();
            CustomerDto.CustomerNumber = dr["CustomerNumber"].ToString();
            CustomerDto.CustomerSex = dr["CustomerSex"].ToString();
            CustomerDto.CustomerBirthday = DateTime.Parse(dr["CustomerBirthday"].ToString());
            CustomerDto.CustomerTelephone = dr["CustomerTelephone"].ToString();
            CustomerDto.CustomerEmail = dr["CustomerEmail"].ToString();
            CustomerDto.CustomerMinzu = dr["CustomerMinzu"].ToString();
            CustomerDto.CustomerHunyin = dr["CustomerHunyin"].ToString();
            CustomerDto.CustomerChangzhu = dr["CustomerChangzhu"].ToString();
            CustomerDto.CustomerWenhua = dr["CustomerWenhua"].ToString();
            CustomerDto.CustomerZhiye = dr["CustomerZhiye"].ToString();
            CustomerDto.CustomerAddress = dr["CustomerAddress"].ToString();
            CustomerDto.CustomerHujiAddress = dr["CustomerHujiAddress"].ToString();
            CustomerDto.CustomerLianxiren = dr["CustomerLianxiren"].ToString();
            CustomerDto.CustomerLianxirenTel = dr["CustomerLianxirenTel"].ToString();
            CustomerDto.CustomerJuweihui = dr["CustomerJuweihui"].ToString();
            CustomerDto.CustomerXiangzhen = dr["CustomerXiangzhen"].ToString();
            CustomerDto.CustomerDanwei = dr["CustomerDanwei"].ToString();
            CustomerDto.CustomerYongyao = dr["CustomerYongyao"].ToString();
            CustomerDto.CustomerBeizhu = dr["CustomerBeizhu"].ToString();
            CustomerDto.CustomerGuidang = dr["CustomerGuidang"].ToString();
            CustomerDto.CustomerDoctor = dr["CustomerDoctor"].ToString();
            CustomerDto.CustomerShequ = dr["CustomerShequ"].ToString();

            return CustomerDto;
        }
Esempio n. 2
0
        public ActionResult Create(CustomerAddViewModel model)
        {
            try
            {
                CustomerDto dto = new CustomerDto();

                dto.CustomerName = model.CustomerName;
                dto.CustomerNumber = model.CustomerNumber;
                dto.CustomerSex = CommonTools.GetSexByVerify(model.CustomerNumber);
                dto.CustomerBirthday = DateTime.Parse(CommonTools.GetBirthdyByVerify(model.CustomerNumber));

                string JsonString = JsonHelper.JsonSerializerBySingleData(dto);
                Message msg = CMSService.Insert("Customer", JsonString);
                return RedirectTo("/Customer/Index?category=全部&guidang=0", msg.MessageInfo);
            }
            catch
            {
                Message msg = new Message();
                msg.MessageStatus = "Error";
                msg.MessageInfo = "操作出错了";
                ViewBag.Status = msg.MessageStatus;
                ViewBag.msg = msg.MessageInfo;
                return View();
            }
        }
Esempio n. 3
0
        public static string CustomerIdToName(string strWhere)
        {
            CustomerDto dto =new CustomerDto();
            DataTable dt=CMSService.SelectOne("Customer","CMSCustomer",strWhere);
            foreach (DataRow dr in dt.Rows)
            {
                dto = CustomerMapping.getDTO(dr);

            }
            return dto.CustomerName;
        }
Esempio n. 4
0
        public ActionResult Guidang(int id)
        {
            CustomerGuidangViewModel model = new CustomerGuidangViewModel();
            DataTable dt = CMSService.SelectOne("Customer", "CMSCustomer", "CustomerId=" + id);
            foreach (DataRow dr in dt.Rows)
            {
                CustomerDto dto = new CustomerDto();
                dto = CustomerMapping.getDTO(dr);
                model.CustomerId = dto.CustomerId;
                model.CustomerName = dto.CustomerName;
                model.CustomerGuidang = dto.CustomerGuidang;

            }
            ViewData["ListGuidang"] = MyService.GetCategoryList("CategoryParentId=30");
            return View(model);
        }
Esempio n. 5
0
        public ActionResult Index(string id,string cid)
        {
            string CustomerName = "";
            string CustomerSex = "";
            string CustomerBirthday = "";
            DataTable dt = CMSService.SelectOne("Customer", "CMSCustomer", "CustomerId=" + cid);
            foreach (DataRow dr in dt.Rows)
            {
                CustomerDto dto = new CustomerDto();
                dto = CustomerMapping.getDTO(dr);
                CustomerName = dto.CustomerName;
                CustomerSex = dto.CustomerSex;
                CustomerBirthday = dto.CustomerBirthday.ToShortDateString();

            }
            string result = id;
            string[] tizhi = result.Split(',');
             int i=0;
             int yangxuzhi = 0;
             for (i = 0; i < 7; i++)
             {
                 yangxuzhi =yangxuzhi+ int.Parse(tizhi[i]);

             }
             int yangxuzhiresult = ((yangxuzhi-7)*100)/(7*4);

             int yinxuzhi = 0;
             for (i = 7; i < 15; i++)
             {
                 yinxuzhi = yinxuzhi + int.Parse(tizhi[i]);

             }
             int yinxuzhiresult = ((yinxuzhi - 8) * 100) / (8 * 4);

             int qixuzhi = 0;
             for (i = 15; i < 23; i++)
             {
                 qixuzhi = qixuzhi + int.Parse(tizhi[i]);

             }
             int qixuzhiresult = ((yinxuzhi - 8) * 100) / (8 * 4);

             int tanshizhi = 0;
             for (i = 23; i < 31; i++)
             {
                 tanshizhi = tanshizhi + int.Parse(tizhi[i]);

             }
             int tanshizhiresult = ((tanshizhi - 8) * 100) / (8 * 4);

             int shirezhi = 0;
             for (i = 31; i < 38; i++)
             {
                 shirezhi = shirezhi + int.Parse(tizhi[i]);

             }
             if (CustomerSex == "男")
             { shirezhi = shirezhi - int.Parse(tizhi[36]); }
             if (CustomerSex == "女")
             { shirezhi = shirezhi - int.Parse(tizhi[37]); }

             //如果是男的减去36项,如果是女的减去37项

             int shirezhiresult = ((shirezhi - 6) * 100) / (6 * 4);

             int xueyuzhi = 0;
             for (i = 38; i < 45; i++)
             {
                 xueyuzhi = xueyuzhi + int.Parse(tizhi[i]);

             }
             int xueyuzhiresult = ((xueyuzhi - 7) * 100) / (7 * 4);

             int qiyuzhi = 0;
             for (i = 45; i < 52; i++)
             {
                 qiyuzhi = qiyuzhi + int.Parse(tizhi[i]);

             }
             int qiyuzhiresult = ((qiyuzhi - 7) * 100) / (7 * 4);

             int tebingzhi = 0;
             for (i = 52; i < 59; i++)
             {
                 tebingzhi = tebingzhi + int.Parse(tizhi[i]);

             }
             int tebingzhiresult = ((tebingzhi - 7) * 100) / (7 * 4);

             int pinghezhi = 0;
             for (i = 59; i < 67; i++)
             {
                 pinghezhi = pinghezhi + int.Parse(tizhi[i]);

             }
             int pinghezhiresult = ((pinghezhi - 7) * 100) / (7 * 4);

             string Customertizhi = "";
             if (yangxuzhiresult < 30 && yinxuzhiresult < 30 && qixuzhiresult < 30 && tanshizhiresult < 30 && shirezhiresult < 30 && xueyuzhiresult < 30 && qiyuzhiresult < 30 && tebingzhiresult < 30 && pinghezhiresult > 60)
             {
                 Customertizhi = "平和质";
             }
             else
             {
             if (yangxuzhiresult >= 40)
             {  Customertizhi += "阳虚质,";}
             if (yinxuzhiresult >= 40)
             { Customertizhi += "阴虚质,"; }
             if (qixuzhiresult >= 40)
             { Customertizhi += "气虚质,"; }
             if (tanshizhiresult >= 40)
             { Customertizhi += "痰湿质,"; }
             if (shirezhiresult >= 40)
             { Customertizhi += "湿热质,"; }
             if (xueyuzhiresult >= 40)
             { Customertizhi += "血瘀质,"; }
             if (qiyuzhiresult >= 40)
             { Customertizhi += "气淤质,"; }
             if (tebingzhiresult >= 40)
             { Customertizhi += "特禀质,"; }
             }
             if (!String.IsNullOrEmpty(Customertizhi))
             { Customertizhi = Customertizhi.Substring(0, Customertizhi.Length - 1); }

             string Customerqinxiangtizhi = "";
             if (yangxuzhiresult > 30 && yangxuzhiresult<40)
             { Customerqinxiangtizhi += "阳虚质,"; }
             if (yinxuzhiresult > 30&&yinxuzhiresult<40)
             { Customerqinxiangtizhi += "阴虚质,"; }
             if (qixuzhiresult > 30 && qixuzhiresult < 40)
             { Customerqinxiangtizhi += "气虚质,"; }
             if (tanshizhiresult > 30 && tanshizhiresult < 40)
             { Customerqinxiangtizhi += "痰湿质,"; }
             if (shirezhiresult > 30 && shirezhiresult < 40)
             { Customerqinxiangtizhi += "湿热质,"; }
             if (xueyuzhiresult > 30 && xueyuzhiresult < 40)
             { Customerqinxiangtizhi += "血瘀质,"; }
             if (qiyuzhiresult > 30 && qiyuzhiresult < 40)
             { Customerqinxiangtizhi += "气淤质,"; }
             if (tebingzhiresult > 30 && tebingzhiresult < 40)
             { Customerqinxiangtizhi += "特禀质,"; }
             if (!String.IsNullOrEmpty(Customerqinxiangtizhi))
             { Customerqinxiangtizhi = Customerqinxiangtizhi.Substring(0, Customerqinxiangtizhi.Length - 1); }

             string Danganhao = System.DateTime.Now.ToString("yyyyMMddhhmmss");
             TizhiDto tizhiDto = new TizhiDto();
             tizhiDto.TizhiYangxu = yangxuzhiresult.ToString();
             tizhiDto.TizhiYinxu = yinxuzhiresult.ToString();
             tizhiDto.TizhiQixu = qixuzhiresult.ToString();
             tizhiDto.TizhiTanshi = tanshizhiresult.ToString();
             tizhiDto.TizhiShire = shirezhiresult.ToString();
             tizhiDto.TizhiQiyu = qiyuzhiresult.ToString();
             tizhiDto.TizhiXueyu = xueyuzhiresult.ToString();
             tizhiDto.TizhiTebing = tebingzhiresult.ToString();
             tizhiDto.TizhiPinghe = pinghezhiresult.ToString();
             tizhiDto.TizhiResult = Customertizhi;
             tizhiDto.TizhiCustomerId = int.Parse(cid);
             tizhiDto.TizhiTime = System.DateTime.Now;
             tizhiDto.TizhiNumber = Danganhao;
             tizhiDto.TizhiImg = "/tizhiresult/" + Danganhao + ".png";

             //ViewBag.yangxuzhiresult = yangxuzhiresult;
             //ViewBag.yinxuzhiresult = yinxuzhiresult;
             //ViewBag.qixuzhiresult = qixuzhiresult;
             //ViewBag.tanshizhiresult = tanshizhiresult;
             //ViewBag.shirezhiresult = shirezhiresult;
             //ViewBag.xueyuzhiresult = xueyuzhiresult;
             //ViewBag.qiyuzhiresult = qiyuzhiresult;
             //ViewBag.tebingzhiresult = tebingzhiresult;
             //ViewBag.pinghezhiresult = pinghezhiresult;
             string JsonString = JsonHelper.JsonSerializerBySingleData(tizhiDto);
             Message msg = CMSService.Insert("Tizhi", JsonString);
             msg=CMSService.UpdateFieldOneByOne("Customer", "CMSCustomer", "CustomerId=" + cid, "CustomerTizhi", Customertizhi);
             ViewBag.CustomerBirthday = CustomerBirthday;
             ViewBag.CustomerName=CustomerName;
             ViewBag.CustomerSex = CustomerSex;
             ViewBag.Customerqinxiangtizhi = Customerqinxiangtizhi;
             ViewBag.Customertizhi = Customertizhi;
             ViewBag.Danganhao = Danganhao;
             //ViewBag.userId = cid;
             return View(tizhiDto);
        }
Esempio n. 6
0
        public ActionResult Details(int id)
        {
            TizhiDto dto = new TizhiDto();
            DataTable dt = CMSService.SelectOne("Tizhi", "CMSTizhi", "TizhiId=" + id);
            foreach (DataRow dr in dt.Rows)
            {
                dto = TizhiMapping.getDTO(dr);

            }
             CustomerDto cDto = new CustomerDto();
            DataTable CustomerDt = CMSService.SelectOne("Customer", "CMSCustomer", "CustomerId=" + dto.TizhiCustomerId);
            foreach (DataRow cdr in CustomerDt.Rows)
            {

                cDto = CustomerMapping.getDTO(cdr);

            }
            ViewBag.CustomerName = cDto.CustomerName;
            ViewBag.CustomerSex = cDto.CustomerSex;
            ViewBag.CustomerBirthday = cDto.CustomerBirthday.ToShortDateString();

            return View(dto);
        }