コード例 #1
0
ファイル: HealthBll.cs プロジェクト: jorzen2010/HealthCrm
        public static HealthDto GetOneHealthDto(string table,string strwhere)
        {
            HealthDto healthDto=new HealthDto();

            healthDto = HealthDal.GetOneHealth(table, strwhere);

            return healthDto;
        }
コード例 #2
0
ファイル: HealthDal.cs プロジェクト: jorzen2010/HealthCrm
        public static void AddHealth(HealthDto healthDto)
        {
            SqlParameter[] arParames = HealthDal.getParameters(healthDto);
            SqlConnection myconn = new SqlConnection(CommonDal.ConnectionString);
            try
            {
            SqlHelper.ExecuteNonQuery(myconn, CommandType.StoredProcedure, "CreateHealth", arParames);
            }
            catch (SqlException ex)
            {
                throw ex;
            }
            finally
            {

                myconn.Close();
                myconn.Dispose();
            }
        }
コード例 #3
0
ファイル: HealthDal.cs プロジェクト: jorzen2010/HealthCrm
        public static List<HealthDto> GetHealthList(string table,string strwhere)
        {
            List<HealthDto> userlist = new List<HealthDto>();

            SqlParameter[] arParames = new SqlParameter[2];
            arParames[0] = new SqlParameter("@table ", SqlDbType.VarChar, 200);
            arParames[0].Value = table;

            arParames[1] = new SqlParameter("@Where ", SqlDbType.VarChar, 8000);
            arParames[1].Value = strwhere;
            SqlConnection myconn = new SqlConnection(CommonDal.ConnectionString);
            try
            {
            DataTable dt = null;
            DataSet ds = SqlHelper.ExecuteDataset(myconn, CommandType.StoredProcedure, "getModelByWhere", arParames);
            dt = ds.Tables[0];
            foreach (DataRow dr in dt.Rows)
            {
                HealthDto HealthDto = new HealthDto();

                HealthDto = HealthDal.getDataRowToHealthDto(dr);

                userlist.Add(HealthDto);

            }

            return userlist;
            }
            catch (SqlException ex)
            {
                throw ex;
            }
            finally
            {

                myconn.Close();
                myconn.Dispose();
            }
        }
コード例 #4
0
ファイル: HealthDal.cs プロジェクト: jorzen2010/HealthCrm
        private static SqlParameter[] getParameters(HealthDto healthDto)
        {
            SqlParameter[] arParames = new SqlParameter[22];

            arParames[0] = new SqlParameter("@HealthId", SqlDbType.Int);
            arParames[0].Value = healthDto.HealthId;

            arParames[1] = new SqlParameter("@HealthUserId  ", SqlDbType.Int);
            arParames[1].Value = healthDto.HealthUserId;

            arParames[2] = new SqlParameter("@HealthXuexing  ", SqlDbType.VarChar, 50);
            arParames[2].Value = healthDto.HealthXuexing;

            arParames[3] = new SqlParameter("@HealthRH  ", SqlDbType.VarChar, 50);
            arParames[3].Value = healthDto.HealthRH;

            arParames[4] = new SqlParameter("@HealthFeiyong  ", SqlDbType.VarChar, 500);
            arParames[4].Value = healthDto.HealthFeiyong;

            arParames[5] = new SqlParameter("@HealthGuomin  ", SqlDbType.VarChar, 50);
            arParames[5].Value = healthDto.HealthGuomin;

            arParames[6] = new SqlParameter("@HealthBaolou  ", SqlDbType.VarChar, 50);
            arParames[6].Value = healthDto.HealthBaolou;

            arParames[7] = new SqlParameter("@HealthJibing  ", SqlDbType.VarChar, 50);
            arParames[7].Value = healthDto.HealthJibing;

            arParames[8] = new SqlParameter("@HealthShoushu  ", SqlDbType.VarChar, 50);
            arParames[8].Value = healthDto.HealthShoushu;

            arParames[9] = new SqlParameter("@HealthWaishang  ", SqlDbType.VarChar, 50);
            arParames[9].Value = healthDto.HealthWaishang;

            arParames[10] = new SqlParameter("@HealthShuxue ", SqlDbType.VarChar, 50);
            arParames[10].Value = healthDto.HealthShuxue;

            arParames[11] = new SqlParameter("@HealthJiazuDady ", SqlDbType.VarChar, 50);
            arParames[11].Value = healthDto.HealthJiazuDady;

            arParames[12] = new SqlParameter("@HealthJiazuMama ", SqlDbType.VarChar, 50);
            arParames[12].Value = healthDto.HealthJiazuMama;

            arParames[13] = new SqlParameter("@HealthJiazuXiongdi ", SqlDbType.VarChar, 50);
            arParames[13].Value = healthDto.HealthJiazuXiongdi;

            arParames[14] = new SqlParameter("@HealthJiazuZinv ", SqlDbType.VarChar, 50);
            arParames[14].Value = healthDto.HealthJiazuZinv;

            arParames[15] = new SqlParameter("@HealthYichuan ", SqlDbType.VarChar, 50);
            arParames[15].Value = healthDto.HealthYichuan;

            arParames[16] = new SqlParameter("@HealthCanji ", SqlDbType.VarChar, 50);
            arParames[16].Value = healthDto.HealthCanji;

            arParames[17] = new SqlParameter("@HealthChufang ", SqlDbType.VarChar, 50);
            arParames[17].Value = healthDto.HealthChufang;

            arParames[18] = new SqlParameter("@HealthRanliao ", SqlDbType.VarChar, 50);
            arParames[18].Value = healthDto.HealthRanliao;

            arParames[19] = new SqlParameter("@HealthYinshui ", SqlDbType.VarChar, 50);
            arParames[19].Value = healthDto.HealthYinshui;

            arParames[20] = new SqlParameter("@HealthCesuo ", SqlDbType.VarChar, 50);
            arParames[20].Value = healthDto.HealthCesuo;

            arParames[21] = new SqlParameter("@HealthQichulan ", SqlDbType.VarChar, 500);
            arParames[21].Value = healthDto.HealthQichulan;

            return arParames;
        }
コード例 #5
0
ファイル: HealthDal.cs プロジェクト: jorzen2010/HealthCrm
        private static HealthDto getDataRowToHealthDto(DataRow dr)
        {
            HealthDto healthDto = new HealthDto();

            healthDto.HealthId = int.Parse(dr["HealthId"].ToString());
            healthDto.HealthUserId = int.Parse(dr["HealthUserId"].ToString());
            healthDto.HealthXuexing = dr["HealthXuexing"].ToString();
            healthDto.HealthRH = dr["HealthRH"].ToString();
            healthDto.HealthFeiyong = dr["HealthFeiyong"].ToString();
            healthDto.HealthGuomin = dr["HealthGuomin"].ToString();
            healthDto.HealthBaolou = dr["HealthBaolou"].ToString();
            healthDto.HealthJibing = dr["HealthJibing"].ToString();
            healthDto.HealthShoushu = dr["HealthShoushu"].ToString();
            healthDto.HealthWaishang = dr["HealthWaishang"].ToString();
            healthDto.HealthShuxue = dr["HealthShuxue"].ToString();
            healthDto.HealthJiazuDady = dr["HealthJiazuDady"].ToString();
            healthDto.HealthJiazuMama = dr["HealthJiazuMama"].ToString();
            healthDto.HealthJiazuXiongdi = dr["HealthJiazuXiongdi"].ToString();
            healthDto.HealthJiazuZinv = dr["HealthJiazuZinv"].ToString();
            healthDto.HealthYichuan = dr["HealthYichuan"].ToString();
            healthDto.HealthCanji = dr["HealthCanji"].ToString();
            healthDto.HealthChufang = dr["HealthChufang"].ToString();
            healthDto.HealthRanliao = dr["HealthRanliao"].ToString();
            healthDto.HealthYinshui = dr["HealthYinshui"].ToString();
            healthDto.HealthCesuo = dr["HealthCesuo"].ToString();
            healthDto.HealthQichulan = dr["HealthQichulan"].ToString();

            return healthDto;
        }
コード例 #6
0
        public ActionResult HealthInsert(HealthAddViewModel model)
        {
            HealthDto healthDto = new HealthDto();

            healthDto.HealthUserId = int.Parse(Request.Form["HealthUserId"].ToString());
            healthDto.HealthXuexing = Request.Form["HealthXuexing"].ToString();
            healthDto.HealthRH = Request.Form["HealthRH"].ToString();
            healthDto.HealthFeiyong = Request.Form["HealthFeiyong"].ToString();
            if (String.IsNullOrEmpty(Request.Form["HealthGuomin"]))
            {
                healthDto.HealthGuomin = "无";

            }
            else
            {
                healthDto.HealthGuomin = Request.Form["HealthGuomin"].ToString();
            }
            if (String.IsNullOrEmpty(Request.Form["HealthBaolou"]))
            {
                healthDto.HealthBaolou = "无";

            }

            else
            {
                healthDto.HealthBaolou = Request.Form["HealthBaolou"].ToString();
            }
            if (String.IsNullOrEmpty(Request.Form["HealthJibing"]))
            {
                healthDto.HealthJibing = "无";

            }
            else
            {
                healthDto.HealthJibing = Request.Form["HealthJibing"].ToString();

            }
            healthDto.HealthShoushu = Request.Form["HealthShoushu"].ToString();
            healthDto.HealthWaishang = Request.Form["HealthWaishang"].ToString();
            healthDto.HealthShuxue = Request.Form["HealthShuxue"].ToString();
            if (String.IsNullOrEmpty(Request.Form["HealthJiazuDady"]))
            {

                healthDto.HealthJiazuDady = "无";
            }
            else
            {
                healthDto.HealthJiazuDady = Request.Form["HealthJiazuDady"].ToString();
            }

            if (String.IsNullOrEmpty(Request.Form["HealthJiazuMama"]))
            {
                healthDto.HealthJiazuMama = "无";

            }
            else
            {
                healthDto.HealthJiazuMama = Request.Form["HealthJiazuMama"].ToString();
            }

            if (String.IsNullOrEmpty(Request.Form["HealthJiazuXiongdi"]))
            {

                healthDto.HealthJiazuXiongdi = "无";
            }
            else
            {
                healthDto.HealthJiazuXiongdi = Request.Form["HealthJiazuXiongdi"].ToString();

            }
            if (String.IsNullOrEmpty(Request.Form["HealthJiazuZinv"]))
            {
                healthDto.HealthJiazuZinv = "无";

            }
            else
            {
                healthDto.HealthJiazuZinv = Request.Form["HealthJiazuZinv"].ToString();
            }

            healthDto.HealthYichuan = Request.Form["HealthYichuan"].ToString();
            if (String.IsNullOrEmpty(Request.Form["HealthCanji"]))
            {

                healthDto.HealthCanji = "无";

            }
            else
            {
                healthDto.HealthCanji = Request.Form["HealthCanji"].ToString();
            }

            healthDto.HealthChufang = Request.Form["HealthChufang"].ToString();
            healthDto.HealthRanliao = Request.Form["HealthRanliao"].ToString();
            healthDto.HealthYinshui = Request.Form["HealthYinshui"].ToString();
            healthDto.HealthCesuo = Request.Form["HealthCesuo"].ToString();
            healthDto.HealthQichulan = Request.Form["HealthQichulan"].ToString();

            HealthBll.AddHealth(healthDto);

             //   return RedirectTo("/Health/HealthIndex", "客户身体信息添加成功了");
            //return RedirectToAction("HealthIndex");
            return RedirectToAction("UserIndex", "User", new { groupId = 0, userClass = 0, doctorId = System.Web.HttpContext.Current.Request.Cookies["DoctorId"].Value });
        }
コード例 #7
0
ファイル: HealthBll.cs プロジェクト: jorzen2010/HealthCrm
 public static void UpdateHealthDto(HealthDto healthDto)
 {
     HealthDal.UpdateHealth(healthDto);
 }
コード例 #8
0
ファイル: HealthBll.cs プロジェクト: jorzen2010/HealthCrm
    public static void AddHealth(HealthDto healthDto)
    {
        HealthDal.AddHealth(healthDto);
 
    }