public QPS.NEW.Model.Leaveword GetModel(int Id) { QPS.NEW.Model.Leaveword leaveeord = null; string strSql = "select * from Leaveword where Id=@id"; DataTable dt = sqlHelper_.GetDataTable( strSql, CommandType.Text, new SqlParameter[] { new SqlParameter("@id", Id) } ); if (dt != null && dt.Rows.Count > 0) { leaveeord = new Model.Leaveword(); leaveeord.Id = Id; leaveeord.UserID = Convert.ToInt32(dt.Rows[0]["UserID"]); leaveeord.title = dt.Rows[0]["title"].ToString(); leaveeord.Content = dt.Rows[0]["Content"].ToString(); } return(leaveeord); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string ID = Convert.ToString(Request["id"]); NEW.Model.Leaveword m_leaveword = new QPS.NEW.Model.Leaveword(); QPS.NEW.BLL.Leaveword lw = new QPS.NEW.BLL.Leaveword(); m_leaveword = lw.GetModel(Convert.ToInt32(ID)); this.txtTitle.Text = m_leaveword.title; this.Content.Text = m_leaveword.Content; } }
protected void Page_Load(object sender, EventArgs e) { if(!IsPostBack) { string ID =Convert.ToString(Request["id"]); NEW.Model.Leaveword m_leaveword = new QPS.NEW.Model.Leaveword(); QPS.NEW.BLL.Leaveword lw = new QPS.NEW.BLL.Leaveword(); m_leaveword = lw.GetModel(Convert.ToInt32(ID)); this.txtTitle.Text = m_leaveword.title; this.Content.Text = m_leaveword.Content; } }
public int Add(QPS.NEW.Model.Leaveword model) { string[] filedName = new string[50]; string[] paramName = new string[50]; SqlParameter[] sqlParams = new SqlParameter[50]; int Count = 0; if (model.UserID != -999) { filedName[Count] = "UserID"; paramName[Count] = "@" + filedName[Count]; sqlParams[Count] = new SqlParameter(paramName[Count], model.UserID); Count++; } if (model.title != null) { filedName[Count] = "title"; paramName[Count] = "@" + filedName[Count]; sqlParams[Count] = new SqlParameter(paramName[Count], model.title); Count++; } if (model.Content != null) { filedName[Count] = "Content"; paramName[Count] = "@" + filedName[Count]; sqlParams[Count] = new SqlParameter(paramName[Count], model.Content); Count++; } StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Leaveword("); for (int i = 0; i < Count; i++) { strSql.Append(filedName[i]); if (i != Count - 1) { strSql.Append(","); } } strSql.Append(")values("); for (int i = 0; i < Count; i++) { strSql.Append(paramName[i]); if (i != Count - 1) { strSql.Append(","); } } strSql.Append(")"); int res = -1; res = sqlHelper_.ExecuteCommand( strSql.ToString(), CommandType.Text, sqlParams ); if (res != 1) { return(0); } return(1); }