protected dzyjwbyjModel GetModel() { dzyjwbyjModel model = this.da.GetModel(this.Session["yhdm"].ToString()); model.v_wbyjmc = this.txtwbyjmc.Text.ToString(); model.v_password = this.txtpassword.Text.ToString(); return(model); }
public int Update(dzyjwbyjModel model) { StringBuilder builder = new StringBuilder(); builder.Append("update pt_dzyj_wbyj set "); builder.Append("v_wbyjmc='" + model.v_wbyjmc + "',"); builder.Append("v_password='******',"); builder.Append("v_xm='" + model.v_xm + "'"); builder.Append(" where v_yhdm='" + model.v_yhdm + "' "); return(publicDbOpClass.ExecSqlString(builder.ToString())); }
public int Add(dzyjwbyjModel model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into pt_dzyj_wbyj("); builder.Append("v_yhdm,v_wbyjmc,v_password,v_xm"); builder.Append(")"); builder.Append(" values ("); builder.Append("'" + model.v_yhdm + "',"); builder.Append("'" + model.v_wbyjmc + "',"); builder.Append("'" + model.v_password + "',"); builder.Append("'" + model.v_xm + "'"); builder.Append(")"); return(publicDbOpClass.ExecSqlString(builder.ToString())); }
protected void PageBind() { DataTable list = this.da.GetList(" v_yhdm = '" + this.Session["yhdm"].ToString() + "'"); if (list.Rows.Count > 0) { this.txtwbyjmc.Text = list.Rows[0]["v_wbyjmc"].ToString(); this.txtpassword.Text = list.Rows[0]["v_password"].ToString(); return; } userManageDb userManageDb = new userManageDb(); dzyjwbyjModel model = this.da.GetModel(this.Session["yhdm"].ToString()); model.v_yhdm = this.Session["yhdm"].ToString(); model.v_xm = userManageDb.GetUserName(this.Session["yhdm"].ToString()); model.v_password = ""; model.v_wbyjmc = ""; this.da.Add(model); }
public dzyjwbyjModel GetModel(string v_yhdm) { StringBuilder builder = new StringBuilder(); builder.Append("select "); builder.Append(" v_yhdm,v_wbyjmc,v_password,v_xm "); builder.Append(" from pt_dzyj_wbyj "); builder.Append(" where v_yhdm='" + v_yhdm + "' "); dzyjwbyjModel model = new dzyjwbyjModel(); DataSet set = publicDbOpClass.DataSetQuary(builder.ToString()); if (set.Tables[0].Rows.Count > 0) { model.v_yhdm = set.Tables[0].Rows[0]["v_yhdm"].ToString(); model.v_wbyjmc = set.Tables[0].Rows[0]["v_wbyjmc"].ToString(); model.v_password = set.Tables[0].Rows[0]["v_password"].ToString(); model.v_xm = set.Tables[0].Rows[0]["v_xm"].ToString(); return(model); } return(null); }