//修改数据
public int Update(ErrowTab model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ErrowTab set ");
strSql.Append("LinkURL=@LinkURL,");
strSql.Append("QuestionDescript=@QuestionDescript,");
strSql.Append("Connetions=@Connetions,");
strSql.Append("BoolChuLi=@BoolChuLi,");
strSql.Append("BoolReturn=@BoolReturn,");
strSql.Append("ReturnContext=@ReturnContext,");
strSql.Append("Descript=@Descript,");
strSql.Append("LoginName=@LoginName,");
strSql.Append("createtime=@createtime,");
strSql.Append("updatetime=@updatetime");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4),
new SqlParameter("@LinkURL", SqlDbType.NVarChar, 300),
new SqlParameter("@QuestionDescript", SqlDbType.Text),
new SqlParameter("@Connetions", SqlDbType.NVarChar, 300),
new SqlParameter("@BoolChuLi", SqlDbType.Int, 4),
new SqlParameter("@BoolReturn", SqlDbType.Int, 4),
new SqlParameter("@ReturnContext", SqlDbType.Text),
new SqlParameter("@Descript", SqlDbType.NVarChar, 500),
new SqlParameter("@LoginName", SqlDbType.NVarChar, 300),
new SqlParameter("@createtime", SqlDbType.DateTime),
new SqlParameter("@updatetime", SqlDbType.DateTime)
};
parameters[0].Value = model.Id;
parameters[1].Value = model.LinkURL;
parameters[2].Value = model.QuestionDescript;
parameters[3].Value = model.Connetions;
parameters[4].Value = model.BoolChuLi;
parameters[5].Value = model.BoolReturn;
parameters[6].Value = model.ReturnContext;
parameters[7].Value = model.Descript;
parameters[8].Value = model.LoginName;
parameters[9].Value = model.createtime;
parameters[10].Value = model.updatetime;
return(DBHelpe.ExecuteCommand(strSql.ToString(), parameters));
}
