/// <summary>
/// 保存修改
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button1_Click(object sender, EventArgs e)
{
var idx = Request["Idx"];
if (string.IsNullOrEmpty(idx))
{
return;
}
var et = new Tab_SmartPerson().Get(idx);
var img = SaveFile(this.FileUpload1);
et.BeautyResume = Server.HtmlEncode(txtResume.Text.Trim());//美容履历
et.BeautyShare = Server.HtmlEncode(txtShare.Text);
et.DarenName = Server.HtmlEncode(txtName.Text);
et.SinaShareContent = Server.HtmlEncode(txtshareContent.Text.Trim());
et.Title = Server.HtmlEncode(txtTitle.Text);
et.HeaderImg = string.IsNullOrEmpty(img)?et.HeaderImg:img;
et.showPageBool = Request["chkShowPage"] == "on" ? "yes" : "No"; // chkShowPage.Checked ? "Yes" : "No";
et.Title = Server.HtmlEncode(txtTitle.Text);
et.Update(et);
if (chkShowPage.Checked)
{
string strSql = string.Format("update Tab_SmartPerson set showPageBool='no' where idx <> {0}", idx);
SqlHelper.ExecuteNonQuery(CommandType.Text, strSql);
}
Response.Redirect("SevicerManage.aspx");
}
/// <summary>
/// 获取首页显示的达人
/// </summary>
/// <returns></returns>
public List <Tab_SmartPerson> GetServicer()
{
var ets = new Tab_SmartPerson().ListAll("select top 1 * from Tab_SmartPerson where showPageBool='yes' order by idx desc");
if (null == ets)
{
return(null);
}
return(ets.ToList());
}
/// <summary>
/// 添加达人
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button1_Click(object sender, EventArgs e)
{
var et = new Tab_SmartPerson();
int idx = et.AddNew(new Tab_SmartPerson {
BeautyResume = Server.HtmlEncode(txtResume.Text.Trim()),//美容履历
BeautyShare = Server.HtmlEncode(txtShare.Text),
DarenName = Server.HtmlEncode(txtName.Text),
SinaShareContent = Server.HtmlEncode(txtshareContent.Text.Trim()),
Title = Server.HtmlEncode(txtTitle.Text),
HeaderImg = SaveFile(this.FileUpload1),
CreatedDate = DateTime.Now,
showPageBool = chkShowPage.Checked?"Yes":"no",
});
if (chkShowPage.Checked)
{
string strSql = string.Format("update Tab_SmartPerson set showPageBool='no' where idx <> {0}", idx);
SqlHelper.ExecuteNonQuery(CommandType.Text, strSql);
}
Response.Redirect("SevicerManage.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
// VerfiyAdmin.CheckAdminLogin(this);
var idx = Request["Idx"];
if (string.IsNullOrEmpty(idx))
{
Response.End(); return;
}
var et = new Tab_SmartPerson().Get(idx);
if (null == et)
{
return;
}
txtName.Text = et.DarenName;
txtResume.Text = et.BeautyResume;
txtshareContent.Text = et.SinaShareContent;
txtTitle.Text = et.Title;
txtShare.Text = et.BeautyShare;
chkShowPage.Checked = et.showPageBool.Trim().ToLower() == "yes";
}
}
/// <summary>
/// 按页获取达人信息
/// </summary>
/// <param name="startRowIndex"></param>
/// <param name="maximumRows"></param>
/// <param name="bshowpage"></param>
/// <returns></returns>
public static List <Tab_SmartPerson> GetDaren(int startRowIndex = 1, int maximumRows = 10, bool?bshowpage = null)
{
bool bTotalCount = false;
maximumRows = maximumRows <= 1 ? 10 : maximumRows;
int pgIdx = startRowIndex / maximumRows; pgIdx = (pgIdx < 1 || startRowIndex <= 0) ? 1 : (startRowIndex / maximumRows) + 1;
if (startRowIndex == 0)
{
pgIdx = 1;
}
SqlParameter prmWhr = new SqlParameter("@strWhere", "");
if (null != bshowpage)
{
prmWhr.SqlValue = bshowpage.Value ? "showPageBool='yes'" : "showPageBool='no'";
}
var prmDoCount = new SqlParameter("@doCount", bTotalCount);
SqlParameter[] prms = new SqlParameter[] {
new SqlParameter("@tblName", "Tab_SmartPerson"),
new SqlParameter("@strGetFields", "*"),
new SqlParameter("@fldName", "CreatedDate"),
new SqlParameter("@PageSize", maximumRows),
new SqlParameter("@PageIndex", pgIdx),
prmDoCount,
new SqlParameter("@OrderType", true),//降序
prmWhr
};
var ds = SqlHelper.ExecuteDataset(CommandType.StoredProcedure, "P_Y_Pagination", prms);
if (null == ds || ds.Tables == null || ds.Tables.Count < 1)
{
return(null);
}
return(Tab_SmartPerson.ToModel(ds.Tables[0]));
}
