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);
}
