Example #1
0
        public static JiwangshiDto GetOneJiwangshiDto(string table,string strwhere)
        {
            JiwangshiDto jiwangshiDto=new JiwangshiDto();

            jiwangshiDto = JiwangshiDal.GetOneJiwangshi(table, strwhere);

            return jiwangshiDto;
        }
Example #2
0
        public static void AddJiwangshi(JiwangshiDto jiwangshiDto)
        {
            SqlParameter[] arParames = JiwangshiDal.getParameters(jiwangshiDto);
            SqlConnection myconn = new SqlConnection(CommonDal.ConnectionString);
            try
            {
                SqlHelper.ExecuteNonQuery(myconn, CommandType.StoredProcedure, "CreateJiwangshi", arParames);
            }
            catch (SqlException ex)
            {
                throw ex;
            }
            finally
            {

                myconn.Close();
                myconn.Dispose();
            }
        }
Example #3
0
        public static List<JiwangshiDto> GetJiwangshiList(string table,string strwhere)
        {
            List<JiwangshiDto> jiwangshilist = new List<JiwangshiDto>();

            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)
            {
                JiwangshiDto jiwangshiDto = new JiwangshiDto();

                jiwangshiDto = JiwangshiDal.getDataRowToJiwangshiDto(dr);

                jiwangshilist.Add(jiwangshiDto);

            }

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

                myconn.Close();
                myconn.Dispose();
            }
        }
Example #4
0
        public JsonResult AjaxJibingInsert()
        {
            //  string content = Request.Form["healthXuexing"].ToString();
            //  string content2 = Request.Form["healthFeiyong"].ToString();
            // string content3 = Request.Form["healthJiazuDady"].ToString();

            int JiwangshiUserId = 0;
            string JiwangshiName = "";
            string JiwangshiClass = "既往史";
            DateTime JiwangshiTime = System.DateTime.Now;
            string JiwangshiJibingClass = "";

            JiwangshiUserId = int.Parse(Request.Form["JiwangshiUserId"].ToString());
            JiwangshiClass = Request.Form["JiwangshiClass"].ToString();
            JiwangshiName = Request.Form["JiwangshiName"].ToString();
            JiwangshiJibingClass = Request.Form["JiwangshiJibingClass"].ToString();
            JiwangshiTime = DateTime.Parse(Request.Form["JiwangshiTime"].ToString());

            JiwangshiDto jiwangshiDto = new JiwangshiDto();

            jiwangshiDto.JiwangshiUserId = JiwangshiUserId;
            jiwangshiDto.JiwangshiClass = JiwangshiClass;
            jiwangshiDto.JiwangshiName = JiwangshiName;
            jiwangshiDto.JiwangshiJibingClass = JiwangshiJibingClass;
            jiwangshiDto.JiwangshiTime = JiwangshiTime;

            JiwangshiBll.AddJiwangshi(jiwangshiDto);

            var json = new JsonResult();
            string strwhere = "JiwangshiUserId=" + JiwangshiUserId + " and JiwangshiClass='" + JiwangshiClass + "'";
            List<JiwangshiDto> jiwangshiDtoList = JiwangshiBll.GetJiwangshiDtoList("CrmJiwangshi", strwhere);

            json.Data = jiwangshiDtoList;
            json.JsonRequestBehavior = JsonRequestBehavior.AllowGet;

            return json;
            //return RedirectToAction("HealthIndex");
        }
Example #5
0
        public void AjaxJibingInsert12()
        {
            //  string content = Request.Form["healthXuexing"].ToString();
            //  string content2 = Request.Form["healthFeiyong"].ToString();
            // string content3 = Request.Form["healthJiazuDady"].ToString();

            int JiwangshiUserId = 0;
            string JiwangshiName = "";
            string JiwangshiClass = "既往史";
            DateTime JiwangshiTime = System.DateTime.Now;
            string JiwangshiJibingClass = "";

            JiwangshiUserId = int.Parse(Request.Form["JiwangshiUserId"].ToString());
            JiwangshiClass = Request.Form["JiwangshiClass"].ToString();
            JiwangshiName = Request.Form["JiwangshiName"].ToString();
            JiwangshiJibingClass = Request.Form["JiwangshiJibingClass"].ToString();
            JiwangshiTime = DateTime.Parse(Request.Form["JiwangshiTime"].ToString());

            JiwangshiDto jiwangshiDto = new JiwangshiDto();

            jiwangshiDto.JiwangshiUserId = JiwangshiUserId;
            jiwangshiDto.JiwangshiClass = JiwangshiClass;
            jiwangshiDto.JiwangshiName = JiwangshiName;
            jiwangshiDto.JiwangshiJibingClass = JiwangshiJibingClass;
            jiwangshiDto.JiwangshiTime = JiwangshiTime;

            JiwangshiBll.AddJiwangshi(jiwangshiDto);

            return;
            //return RedirectToAction("HealthIndex");
        }
Example #6
0
        private static SqlParameter[] getParameters(JiwangshiDto jiwangshiDto)
        {
            SqlParameter[] arParames = new SqlParameter[6];

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

            arParames[1] = new SqlParameter("@JiwangshiName", SqlDbType.VarChar, 50);
            arParames[1].Value = jiwangshiDto.JiwangshiName;

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

            arParames[3] = new SqlParameter("@JiwangshiUserId", SqlDbType.Int);
            arParames[3].Value = jiwangshiDto.JiwangshiUserId;

            arParames[4] = new SqlParameter("@JiwangshiTime", SqlDbType.DateTime);
            arParames[4].Value = jiwangshiDto.JiwangshiTime;

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

            return arParames;
        }
Example #7
0
        private static JiwangshiDto getDataRowToJiwangshiDto(DataRow dr)
        {
            JiwangshiDto jiwangshiDto = new JiwangshiDto();

            jiwangshiDto.JiwangshiId = int.Parse(dr["JiwangshiId"].ToString());
            jiwangshiDto.JiwangshiName = dr["JiwangshiName"].ToString();
            jiwangshiDto.JiwangshiJibingClass = dr["JiwangshiJibingClass"].ToString();

            jiwangshiDto.JiwangshiUserId = int.Parse(dr["JiwangshiUserId"].ToString());
            jiwangshiDto.JiwangshiClass = dr["JiwangshiClass"].ToString();

            jiwangshiDto.JiwangshiTime = DateTime.Parse(dr["JiwangshiTime"].ToString());

            return jiwangshiDto;
        }
Example #8
0
 public static void UpdateJiwangshiDto(JiwangshiDto jiwangshiDto)
 {
     JiwangshiDal.UpdateJiwangshi(jiwangshiDto);
 }
Example #9
0
    public static void AddJiwangshi(JiwangshiDto jiwangshiDto)
    {
        JiwangshiDal.AddJiwangshi(jiwangshiDto);
 
    }