public int Update(BasicInfoModel model) { string sql = "update BasicInfo set Name=@name,Gender=@gender,Age=@age,Email=@email where PersonID=@id"; SqlParameter[] p = new SqlParameter[] { new SqlParameter("@name", SqlDbType.NVarChar, 100) { Value = model.Name }, new SqlParameter("@gender", SqlDbType.NChar, 1) { Value = model.Gender }, new SqlParameter("@age", SqlDbType.Int) { Value = model.Age }, new SqlParameter("@email", SqlDbType.NVarChar, 50) { Value = model.Email }, new SqlParameter("@id", SqlDbType.Int) { Value = model.PersonID } }; return(SqlHelper.ExecuteNoneQuery(sql, CommandType.Text, p)); }
public BasicInfoModel SelectModelById(int id) { BasicInfoModel model = new BasicInfoModel(); string sql = "select * from BasicInfo where PersonID=@id"; SqlParameter p = new SqlParameter("@id", SqlDbType.Int) { Value = id }; using (SqlDataReader reader = SqlHelper.ExecuteReader(sql, CommandType.Text, p)) { if (reader.HasRows) { while (reader.Read()) { //PersonID, Name, Gender, Age, Email model = new BasicInfoModel(); model.PersonID = reader.GetInt32(0); model.Name = reader.GetString(1); model.Gender = reader.GetString(2); model.Age = reader.GetInt32(3); model.Email = reader.GetString(4); } } } return(model); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; BasicInfoBll bll = new BasicInfoBll(); int id = int.Parse(context.Request["personId"]); BasicInfoModel model = bll.SelectModelById(id); JavaScriptSerializer jss = new JavaScriptSerializer(); if (model != null) { string jsonData = jss.Serialize(model); context.Response.Write(jsonData); } }
public List <BasicInfoModel> SelectByRow(int pagesize, int pageindex, out int pagecount, out int recordcount) { // @pagesize int, //@pageindex int, //@pagecount int output, //@recordcount int output List <BasicInfoModel> ls = new List <BasicInfoModel>(); string sql = "usp_basicInfoByRow"; SqlParameter[] p = new SqlParameter[] { new SqlParameter("@pagesize", SqlDbType.Int) { Value = pagesize }, new SqlParameter("@pageindex", SqlDbType.Int) { Value = pageindex }, new SqlParameter("@pagecount", SqlDbType.Int) { Direction = ParameterDirection.Output }, new SqlParameter("@recordcount", SqlDbType.Int) { Direction = ParameterDirection.Output }, }; using (SqlDataReader reader = SqlHelper.ExecuteReader(sql, CommandType.StoredProcedure, p)) { if (reader.HasRows) { while (reader.Read()) { //PersonID, Name, Gender, Age, Email BasicInfoModel model = new BasicInfoModel(); model.PersonID = reader.GetInt32(0); model.Name = reader.GetString(1); model.Gender = reader.GetString(2); model.Age = reader.GetInt32(3); model.Email = reader.GetString(4); ls.Add(model); } } } pagecount = (int)p[2].Value; recordcount = (int)p[3].Value; return(ls); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; BasicInfoBll bll = new BasicInfoBll(); BasicInfoModel model = new BasicInfoModel(); model.Name = context.Request["name"]; model.Gender = context.Request["gender"]; model.Age = int.Parse(context.Request["age"]); model.Email = context.Request["email"]; if (bll.Insert(model)) { context.Response.Write("ok"); } else { context.Response.Write("notok"); } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; BasicInfoModel model = new BasicInfoModel(); model.Name = context.Request["txtName"]; model.Age = int.Parse(context.Request["txtAge"]); model.Gender = context.Request["gender"]; model.Email = context.Request["txtEmail"]; model.PersonID = int.Parse(context.Request["hidId"]); BasicInfoBll bll = new BasicInfoBll(); if (bll.Update(model)) { context.Response.Redirect("ok"); } else { context.Response.Write("notok"); } }
public int Insert(BasicInfoModel model) { string sql = "insert into BasicInfo values(@name,@gender,@age,@email)"; SqlParameter[] p = new SqlParameter[] { new SqlParameter("@name", SqlDbType.NVarChar, 100) { Value = model.Name }, new SqlParameter("@gender", SqlDbType.NChar, 1) { Value = model.Gender }, new SqlParameter("@age", SqlDbType.Int) { Value = model.Age }, new SqlParameter("@email", SqlDbType.NVarChar, 50) { Value = model.Email } }; return(SqlHelper.ExecuteNoneQuery(sql, CommandType.Text, p)); }
public IActionResult Index(BasicInfoModel model) { return(View("Display", model)); }
public bool Update(BasicInfoModel model) { return(dal.Update(model) > 0); }
public bool Insert(BasicInfoModel model) { return(dal.Insert(model) > 0); }