private bool DoEdit(int _id) { try { BLL.user_pm bll = new BLL.user_pm(); Model.user_pm model = bll.GetModel(_id); model.name = txtName.Text; model.sex = Convert.ToInt32(rblSex.SelectedValue); model.origin = txtOrigin.Text; model.phone = txtPhone.Text; model.comname = txtComName.Text; model.job = txtJob.Text; model.year = Convert.ToInt32(txtYear.Text); model.jobimg = jobImg.Text; model.img = txtImg.Text; model.add_time = Convert.ToDateTime(txtAddTime.Text); model.pass_time = Convert.ToDateTime(txtPassTime.Text); if (bll.Update(model)) { AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "修改产品经理信息"); //记录日志 return(true); } } catch { return(false); } return(false); }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="model">Model.user_pm</param> /// <returns>True or False</returns> public bool Update(Model.user_pm model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update [" + databaseprefix + "user_pm] set "); strSql.Append("user_id=@user_id,"); strSql.Append("name=@name,"); strSql.Append("sex=@sex,"); strSql.Append("origin=@origin,"); strSql.Append("phone=@phone,"); strSql.Append("comname=@comname,"); strSql.Append("job=@job,"); strSql.Append("year=@year,"); strSql.Append("jobimg=@jobimg,"); strSql.Append("img=@img,"); strSql.Append("status=@status,"); strSql.Append("add_time=@add_time,"); strSql.Append("pass_time=@pass_time"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@user_id", SqlDbType.Int, 4), new SqlParameter("@name", SqlDbType.VarChar, 100), new SqlParameter("@sex", SqlDbType.Int, 4), new SqlParameter("@origin", SqlDbType.NVarChar, 100), new SqlParameter("@phone", SqlDbType.NVarChar, 100), new SqlParameter("@comname", SqlDbType.NVarChar, 100), new SqlParameter("@job", SqlDbType.NVarChar, 100), new SqlParameter("@year", SqlDbType.Int, 4), new SqlParameter("@jobimg", SqlDbType.NText), new SqlParameter("@img", SqlDbType.NText), new SqlParameter("@status", SqlDbType.Int, 4), new SqlParameter("@add_time", SqlDbType.DateTime), new SqlParameter("@pass_time", SqlDbType.DateTime), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.user_id; parameters[1].Value = model.name; parameters[2].Value = model.sex; parameters[3].Value = model.origin; parameters[4].Value = model.phone; parameters[5].Value = model.comname; parameters[6].Value = model.job; parameters[7].Value = model.year; parameters[8].Value = model.jobimg; parameters[9].Value = model.img; parameters[10].Value = model.status; parameters[11].Value = model.add_time; parameters[12].Value = model.pass_time; parameters[13].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } return(false); }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="model">Model.user_pm</param> /// <returns>ID</returns> public int Add(Model.user_pm model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [" + databaseprefix + "user_pm]("); strSql.Append("user_id,name,sex,origin,phone,comname,job,year,jobimg,img,status,add_time"); strSql.Append(") values("); strSql.Append("@user_id,@name,@sex,@origin,@phone,@comname,@job,@year,@jobimg,@img,@status,@add_time)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@user_id", SqlDbType.Int, 4), new SqlParameter("@name", SqlDbType.VarChar, 100), new SqlParameter("@sex", SqlDbType.Int, 4), new SqlParameter("@origin", SqlDbType.NVarChar, 100), new SqlParameter("@phone", SqlDbType.NVarChar, 100), new SqlParameter("@comname", SqlDbType.NVarChar, 100), new SqlParameter("@job", SqlDbType.NVarChar, 100), new SqlParameter("@year", SqlDbType.Int, 4), new SqlParameter("@jobimg", SqlDbType.NText), new SqlParameter("@img", SqlDbType.NText), new SqlParameter("@status", SqlDbType.Int, 4), new SqlParameter("@add_time", SqlDbType.DateTime) }; parameters[0].Value = model.user_id; parameters[1].Value = model.name; parameters[2].Value = model.sex; parameters[3].Value = model.origin; parameters[4].Value = model.phone; parameters[5].Value = model.comname; parameters[6].Value = model.job; parameters[7].Value = model.year; parameters[8].Value = model.jobimg; parameters[9].Value = model.img; parameters[10].Value = model.status; parameters[11].Value = model.add_time; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (null != obj) { return(Convert.ToInt32(obj)); } else { return(0); } }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="model">Model.user_pm</param> /// <returns>ID</returns> public int Add(Model.user_pm model) { return(dal.Add(model)); }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="model">Model.user_pm</param> /// <returns>True Or False</returns> public bool Update(Model.user_pm model) { return(dal.Update(model)); }
private void register_pm(HttpContext context) { int uid = DTRequest.GetInt("uid", 0); string name = DTRequest.GetString("name"); string birthday = DTRequest.GetString("birthday"); int sex = DTRequest.GetInt("sex", 0); string origin = DTRequest.GetString("origin"); string phone = DTRequest.GetString("phone"); string comName = DTRequest.GetString("comName"); string job = DTRequest.GetString("job"); int year = DTRequest.GetInt("year", 0); string jobImg = DTRequest.GetString("jobImg"); string img = DTRequest.GetString("img"); if (uid == 0) { context.Response.Write("{\"status\":0,\"msg\":\"未登录,请登录后重新提交!\"}"); return; } if (name == "") { context.Response.Write("{\"status\":0,\"msg\":\"请输入姓名!\"}"); return; } if (sex == 0) { context.Response.Write("{\"status\":0,\"msg\":\"请选择性别!\"}"); return; } if (origin == "") { context.Response.Write("{\"status\":0,\"msg\":\"请输入籍贯!\"}"); return; } if (phone == "") { context.Response.Write("{\"status\":0,\"msg\":\"请输入电话号码!\"}"); return; } if (comName == "") { context.Response.Write("{\"status\":0,\"msg\":\"请输入公司名称!\"}"); return; } if (job == "") { context.Response.Write("{\"status\":0,\"msg\":\"请输入所在岗位!\"}"); return; } if (jobImg == "" || jobImg == "undefined" || img == "" || img == "undefined") { context.Response.Write("{\"status\":0,\"msg\":\"请上传工牌照片和生活照!\"}"); return; } Model.user_pm model = new Model.user_pm(); model.user_id = uid; model.name = name; model.sex = sex; model.origin = origin; model.phone = phone; model.comname = comName; model.job = job; model.year = year; model.jobimg = jobImg; model.img = img; model.status = 1; model.add_time = DateTime.Now; if (new BLL.user_pm().Add(model) > 0) { new BLL.user().UpdateField(uid, "level=1"); context.Response.Write("{\"status\":1,\"msg\":\"提交成功!\"}"); } else { context.Response.Write("{\"status\":0,\"msg\":\"提交失败,请重新提交!\"}"); } }
/// <summary> /// 组合成对象实体 /// </summary> /// <param name="row">一行数据</param> /// <returns>Model.user_pm</returns> private Model.user_pm DataRowToModel(DataRow row) { Model.user_pm model = new Model.user_pm(); if (row != null) { if (null != row["id"] && "" != row["id"].ToString()) { model.id = int.Parse(row["id"].ToString()); } if (null != row["user_id"] && "" != row["user_id"].ToString()) { model.user_id = int.Parse(row["user_id"].ToString()); } if (null != row["name"]) { model.name = row["name"].ToString(); } if (null != row["sex"] && "" != row["sex"].ToString()) { model.sex = int.Parse(row["sex"].ToString()); } if (null != row["origin"]) { model.origin = row["origin"].ToString(); } if (null != row["phone"]) { model.phone = row["phone"].ToString(); } if (null != row["comname"]) { model.comname = row["comname"].ToString(); } if (null != row["job"]) { model.job = row["job"].ToString(); } if (null != row["year"] && "" != row["year"].ToString()) { model.year = int.Parse(row["year"].ToString()); } if (null != row["jobimg"]) { model.jobimg = row["jobimg"].ToString(); } if (null != row["img"]) { model.img = row["img"].ToString(); } if (null != row["status"] && "" != row["status"].ToString()) { model.status = int.Parse(row["status"].ToString()); } if (null != row["add_time"] && "" != row["add_time"].ToString()) { model.add_time = DateTime.Parse(row["add_time"].ToString()); } if (null != row["pass_time"] && "" != row["pass_time"].ToString()) { model.pass_time = DateTime.Parse(row["pass_time"].ToString()); } } return(model); }