protected void Page_Load(object sender, EventArgs e)
{
MessageList.DataSource = null;
MessageList.DataBind();
if (!IsPostBack)
{
ProductDataBind();
}
}
private void ST_Link_Bind()
{
string ST_sql = "select * from ST_message order by ST_mdate desc";
//调用公共类中的ExceDS方法，执行查询语句
MessageList.DataSource = sd.ExceDS(ST_sql);
MessageList.DataKeyNames = new[] { "ST_id" };
MessageList.DataBind();
}
private void BindMessageArea()
{
if (!string.IsNullOrEmpty(this.Message))
{
PageMessageArea.Visible = true;
}
PageMessage.Text = this.Message;
if (this.BrokenRules != null && this.BrokenRules.Count() > 0)
{
MessageList.DataSource = this.BrokenRules;
MessageList.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
var images = new List <string>();
List <Item2> items = null;
List <Message> messages = null;
//string notAvail = "data:image/jpg;base64,/9j/4AAQSkZJRgABAQAAAQABAAD/2wCEAAkGBxAQEhUQERMQExMQEBETFBIQFhAQEBAPFR0WFxQVExQYHCgkGholGxMUITEhKCkrLi4uFx8zODMsNygtLisBCgoKDg0OGRAQFywcHBwvLCwsLCwsLCwsLCwsLCwsLCwsLCwsNywsLCwsLCw3LDc3LCs3LCsrKzcrKyssKysrK//AABEIAOEA4QMBIgACEQEDEQH/xAAbAAEAAwEBAQEAAAAAAAAAAAAAAgMEBQEGB//EADoQAAIBAgMFBAcIAQUBAAAAAAABAgMRBCExBRJBUXETYbHBIjIzgZGh8RVCcoKy0eHwNCNDUmKSFP/EABcBAQEBAQAAAAAAAAAAAAAAAAABAgP/xAAcEQEBAQADAAMAAAAAAAAAAAAAARExQWECElH/2gAMAwEAAhEDEQA/AP3Bs5eL2pwp/wDp+SG18T/trrLyRzDUiWpzrSlrJvq2QANoAAAAAAAAAAAAAAAAAAAAAAAAAAAShUktG10bREAdDC7Tksp5rnxX7nWhNNXTunxPmTdsvE7stx6S+UjNiyu0ADCvmq896TfNtkADqyAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABMADr/AGl3A5AM/WGgANAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABu2fgo1IttyVpWytyXd3kGEFuJouEnF8NO9cC9YSPZdpd35ZW1tyGjGACgAToxTkk3ZN5vkgIA046jGErRd1budmZgAAAAAAAAAAAAAAAAAAAAAAAAAAAHU2Y/9KducvBHLOps32U/zfpRKR7io9tTVRetFZ+a8zyP+N/f+RRsvEbst16S+UuBtxdLcoyitL3XRtMz4rJgcHGUXUn6qvlpe2rZbS7Co9xRafB6X+ZOmt7D2jrZ5d6eZg2fFupG3B3fRFEcVQdOTj70+aPMLBSnFPRvM1bYknNLlHP5mfBe0j+JF6RoxWHhGrCKXovdurvi2i7EUKFJ3km76RV3bm9TzG+3h+XxZVtn11+DzZFX1sHSaVRZRtd24rh0FOhRqxe4t1r4p8L8zyf+Mui8SOxNZ9I+ZOhiwzgm+0TdlklzN2H7Cq91QcXbJ/yjzAYeLc5yV7Sdlr36E8FjpTmoqMVGz0vdLhmWjEsI+07Pv1/663NdZUKb3HFyfF8V77lkJJYiXfCy62T8jBtGm1Ulfi7rvQ5GrE4SnGk5Rz0ad3o2irCYaG52tTTgufA014NYez1tHxROnUtRUlFSslddMmTRRRhRrXjGLhJK6ObOLTaeqbRvjtRLSnFdH/BirVN6Tlpd3saiIAAoAAAAAAAAAAAaMPi3CLgknvXz6qxnAA11doSlDcaWaSvnfL6GQEF+FxUqemj1T0NL2o/uwjFvjqc8DB7OTbu829WSo1N2SlydyAKNNbFuU1OyvG2XDJ3IYvEuo02krK2RSCYNLxjdPs7K2WfHW55hMW6d7JO9te76mcDBpw2MlTbas1J3a7+4ue03f0Yxjnd9/VmADBdVrynPeWUm1a3PRGz7Qq+q4el0lf4HPhNxaa1TujYtq1OUfg/3Fg046TVFKXrStfrqzBhcZKnpmnwfkV168pu8nfwXQrEg6D2nxVOKfP8AqOewBgAAoAAAAAAAAAAAAAALaeGnLNRk1ztkQqU5RykmuoEQTnSlHNxkuqaPIU5S0TfRNgRBZGjNuyjJta5PLqKmHnHOUWlz4AVkqdNyyim+mZp2dVcW2ouWX3dUXbMlerJ2tdSy5ZrImjnyi07PJrgzw0YxN1JJXfpPTMj/APJU13JfDyApSvkuPiSqU5R9ZNdciWG9eP44+KN+14OUopJt7ryWY0cwnCjKWai3bkrntWhOPrRa66HS2P6kuvkLRyQIoueFqJX3ZW6FFIAAAAAAAAAAAAAAAAB7C11fS6v0A6FBYiSVnupJJXsrrxNOMpt0Xv2coq91pf6DaFGdRR3HlxV7J8meSpblBxum0ne2l73aMKgn2tDvivnH+PEjs30Kcqj4+C0+ZXseraTi9JL5r+PAntNqEI0l1fRfz4DwUYSdZ3UOLu3lq+9nTwtOpZqo1JP+u+RRhU5ULQdpZrlnfM92bhnBveavJaXu7Li/iKKdkRtOa5ZfBsbP9tP8/wCo92X7Sp1fizzZ/tp/n/UBRUlJVpOGct524m3D08RdOUla+adtPciOEku2qX1enmQeDn2m/NrdUr3b4XySQEcdBKtBr7zg31uX7TxThZRsm1rq7Fe0fa0+sf1Fm0cN2jW61vRWj5P6D8DA1+2jKM87fNP6Edkq0ZrlJr5HuGpKhBym1d8F3aJEdkO8ZvnLyAhsejk52u1ki2jHEbycrWbzV1ZLuKNkVlZ027b2a4a5O3eJ4Kveym2ue9JDsVbVpqNTL7yT9+f7GMtxMZKTUm21xbb7+PUqNRAAFAAAAAAAAAAAAABKNSSVk5Jck2kebz0uzwAEz1tvX5ngAlCbWja6No833rd353dzwAeqT5sKT5s8AC/ElKpJ6tvq2yIA9cnzYU3e93fnd3PAB7Oberb6tsKTWjfuPAAJ9tPTel8WQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAGCVWNm1ybXwIgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAB0vsxgmwxHa+Hs99aS17mc8+mnBNWaunwOPi9myjnH0ly+8v3JKtjCAwaQAAAAAAAAAAAAAAAAAAAAAAAAAAAAADXs3D78r8I5vrwQw2z5z19Fc3r7kdqjSUFux0X9zM2rImADCgAA521eByADfx4SgANIAAAAAAAAAAAAAAAAAAAAAAAAHS2TqAS8EdYAHNoAAH//Z";
string conString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;
SqlConnection con = new SqlConnection(conString);
SqlCommand com = new SqlCommand("SELECT ItemId, ItemName, ItemDesc, ContentType, Image, Category, CreatedOn, UserName, IsActive, i.UserId, 1 AS Preference FROM ExchangeDB..Item i JOIN ExchangeDB..Users u ON u.UserId = i.UserId WHERE u.UserId = @UserId And i.IsActive = 1", con);
com.Parameters.Add("@UserId", SqlDbType.Int).Value = Convert.ToInt32(Session["UserId"]);
SqlCommand com2 = new SqlCommand("SELECT Top 15 fu.UserId As FromUserId, fu.UserName As FromUserName, tu.UserId As ToUserId, tu.UserName As ToUserName, i.ItemId, i.ItemName, m.MessageBody, m.CreatedOn FROM ExchangeDB..[Message] m JOIN ExchangeDB..Users fu ON fu.UserId = m.FromUserId JOIN ExchangeDB..Users tu ON tu.UserId = m.ToUserId LEFT JOIN ExchangeDB..Item i ON i.ItemId = m.ItemId WHERE m.ToUserId = @UserId Order by m.CreatedON Desc", con);
com2.Parameters.Add("@UserId", SqlDbType.Int).Value = Convert.ToInt32(Session["UserId"]);
con.Open();
var lDataAdapter = new SqlDataAdapter(com);
var lDataSet = new DataSet();
lDataAdapter.Fill(lDataSet);
var lDataAdapter2 = new SqlDataAdapter(com2);
var lDataSet2 = new DataSet();
lDataAdapter2.Fill(lDataSet2);
if (lDataSet.Tables[0].Rows.Count != 0)
{
items = lDataSet.Tables[0].AsEnumerable().Select(row => new Item2(row, Session["UserId"] == null ? 0 : Convert.ToInt32(Session["UserId"]))).ToList();
}
ItemList.DataSource = items;
ItemList.DataBind();
if (lDataSet2.Tables[0].Rows.Count != 0)
{
messages = lDataSet2.Tables[0].AsEnumerable().Select(row => new Message(row)).ToList();
}
MessageList.DataSource = messages;
MessageList.DataBind();
con.Close();
}
}
protected void LoadMessageDisplay(List <string> errmsgs, string style)
{
MessageList.CssClass = style;
MessageList.DataSource = errmsgs;
MessageList.DataBind();
}
protected void LoadMessageDisplay(List <string> errormsglist, string cssclass)
{
MessageList.CssClass = cssclass;
MessageList.DataSource = errormsglist;
MessageList.DataBind();
}
private bool ValidateForm()
{
bool returnValue = true;
BrokenRuleCollection brokenRules = new BrokenRuleCollection();
if (string.IsNullOrEmpty(txtFirstName.Text.Trim()))
{
brokenRules.Add("First Name", "Required field");
}
if (string.IsNullOrEmpty(txtLastName.Text.Trim()))
{
brokenRules.Add("Last Name", "Required field");
}
if (drpEmployeeType.SelectedValue == "0")
{
brokenRules.Add("Employee Type", "Select an Employee Type from the drop down list");
}
if (drpGender.SelectedValue == "0")
{
brokenRules.Add("Gender", "Select a Gender from the drop down list");
}
if (!string.IsNullOrEmpty(txtBirthDate.Text.Trim()))
{
if (txtBirthDate.Text.Trim().ToDate() == DateTime.MinValue)
{
brokenRules.Add("Date Of Birth", "Please enter a valid date.");
}
}
if (!string.IsNullOrEmpty(txtHireDate.Text.Trim()))
{
if (txtHireDate.Text.Trim().ToDate() == DateTime.MinValue)
{
brokenRules.Add("Date Of Hire", "Please enter a valid date.");
}
}
if (!string.IsNullOrEmpty(txtTermDate.Text.Trim()))
{
if (txtTermDate.Text.Trim().ToDate() == DateTime.MinValue)
{
brokenRules.Add("Date Of Term", "Please enter a valid date.");
}
}
if (brokenRules.Count() > 0)
{
MessageList.DataSource = brokenRules;
MessageList.DataBind();
if (brokenRules.Count() == 1)
{
this.DisplayLocalMessage("There was an error processing your form. Please correct and try saving again");
}
else
{
this.DisplayLocalMessage("There was some error processing your form. Please correct and try saving again");
}
returnValue = false;
}
return(returnValue);
}
protected void Page_Load(object sender, EventArgs e)
{
MessageList.DataSource = null;
MessageList.DataBind();
}
