public DataTable GetDataTable(ManagersModel model) { string sql = string.Format("select * from GP_Managers_login where managers_name=@managers_name and managers_password=@managers_password"); SqlParameter[] prams = { db.MakeInParam("@managers_name", SqlDbType.NVarChar, 50, model.managers_name), db.MakeInParam("@managers_password", SqlDbType.NVarChar, 50, model.managers_password) }; DataTable dt = db.RunDataTable(sql, prams); return(dt); }
protected void Page_Load(object sender, EventArgs e) { if (Session["managersModel"] == null) { Response.Write("<script>alert('尚无该成员信息!');</script>"); } managersModel = (ManagersModel)Session["managersModel"]; ltRealName.Text = managersModel.managers_real_name.ToString(); ltDate.Text = DateTime.Now.ToString("yyyy年MM月dd日"); }
public DataTable GetDataTable(ManagersModel model) { return(managersDAL.GetDataTable(model)); }