public void DataBindToGridview()
{
ZWL.BLL.ERPSupplyLink MyModel = new ZWL.BLL.ERPSupplyLink();
string sql = "";
if (!string.IsNullOrEmpty(this.TextBox1.Text))
{
sql += "(SupplysName Like '%" + this.TextBox1.Text + "%' or LinkManName Like '%" + this.TextBox1.Text + "%' or ZhiWei Like '%" + this.TextBox1.Text + "%' or Sex Like '%" + this.TextBox1.Text + "%' or UserName Like '%" + this.TextBox1.Text + "%' or IFFirstLink Like '%" + this.TextBox1.Text + "%' or JobTel Like '%" + this.TextBox1.Text + "%' or MobTel Like '%" + this.TextBox1.Text + "%' or QQorMsn Like '%" + this.TextBox1.Text + "%')";
}
if (!string.IsNullOrEmpty(this.TextBox3.Text))
{
if (string.IsNullOrEmpty(sql))
{
sql += " TimeStr >='" + this.TextBox3.Text.Trim() + " 00:00:00' and TimeStr<='" + this.TextBox4.Text.Trim() + " 23:59:59' ";
}
else
{
sql += "and TimeStr >='" + this.TextBox3.Text.Trim() + " 00:00:00' and TimeStr<='" + this.TextBox4.Text.Trim() + " 23:59:59' ";
}
sql += " order by ID desc";
}
GVData.DataSource = MyModel.GetList(sql);
GVData.DataBind();
LabPageSum.Text = Convert.ToString(GVData.PageCount);
LabCurrentPage.Text = Convert.ToString(((int)GVData.PageIndex + 1));
this.GoPage.Text = LabCurrentPage.Text.ToString();
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
ZWL.BLL.ERPSupplyLink Model = new ZWL.BLL.ERPSupplyLink();
Model.ID = int.Parse(Request.QueryString["ID"].ToString());
Model.SupplysName = this.txtSupplysName.Text.ToString();
Model.LinkManName = this.txtLinkManName.Text.ToString();
Model.ZhiWei = this.txtZhiWei.Text.ToString();
Model.Sex = this.txtSex.Text.ToString();
Model.ShengRi = DateTime.Parse(this.txtShengRi.Text);
Model.AiHao = this.txtAiHao.Text.ToString();
Model.IFFirstLink = this.txtIFFirstLink.Text.ToString();
Model.YouBian = this.txtYouBian.Text.ToString();
Model.DiZhi = this.txtDiZhi.Text.ToString();
Model.JobTel = this.txtJobTel.Text.ToString();
Model.JiaTingTel = this.txtJiaTingTel.Text.ToString();
Model.MobTel = this.txtMobTel.Text.ToString();
Model.EmailStr = this.txtEmailStr.Text.ToString();
Model.QQorMsn = this.txtQQorMsn.Text.ToString();
Model.BackInfo = this.txtBackInfo.Text.ToString();
Model.UserName = this.txtUserName.Text.ToString();
Model.TimeStr = DateTime.Parse(this.txtTimeStr.Text);
Model.Update();
//写系统日志
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "用户修改供应商联系人信息(" + this.txtSupplysName.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
ZWL.Common.MessageBox.ShowAndRedirect(this, "供应商联系人信息修改成功！", "SupplysLink.aspx?GongYingShang=" + Request.QueryString["GongYingShang"].ToString());
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
ZWL.BLL.ERPSupplyLink Model = new ZWL.BLL.ERPSupplyLink();
Model.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
this.lblSupplysName.Text = Model.SupplysName.ToString();
this.lblLinkManName.Text = Model.LinkManName.ToString();
this.lblZhiWei.Text = Model.ZhiWei.ToString();
this.lblSex.Text = Model.Sex.ToString();
this.lblShengRi.Text = Model.ShengRi.ToString().Replace(" 0:00:00", "");
this.lblAiHao.Text = Model.AiHao.ToString();
this.lblIFFirstLink.Text = Model.IFFirstLink.ToString();
this.lblYouBian.Text = Model.YouBian.ToString();
this.lblDiZhi.Text = Model.DiZhi.ToString();
this.lblJobTel.Text = Model.JobTel.ToString();
this.lblJiaTingTel.Text = Model.JiaTingTel.ToString();
this.lblMobTel.Text = Model.MobTel.ToString();
this.lblEmailStr.Text = Model.EmailStr.ToString();
this.lblQQorMsn.Text = Model.QQorMsn.ToString();
this.lblBackInfo.Text = Model.BackInfo.ToString();
this.lblUserName.Text = Model.UserName.ToString();
this.lblTimeStr.Text = Model.TimeStr.ToString();
//写系统日志
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "用户查看供应商联系人信息(" + this.lblSupplysName.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
ZWL.BLL.ERPSupplyLink Model = new ZWL.BLL.ERPSupplyLink();
Model.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
this.txtSupplysName.Text = Model.SupplysName.ToString();
this.txtLinkManName.Text = Model.LinkManName.ToString();
this.txtZhiWei.Text = Model.ZhiWei.ToString();
this.txtSex.Text = Model.Sex.ToString();
this.txtShengRi.Text = Model.ShengRi.ToString().Replace(" 0:00:00", "");
this.txtAiHao.Text = Model.AiHao.ToString();
this.txtIFFirstLink.Text = Model.IFFirstLink.ToString();
this.txtYouBian.Text = Model.YouBian.ToString();
this.txtDiZhi.Text = Model.DiZhi.ToString();
this.txtJobTel.Text = Model.JobTel.ToString();
this.txtJiaTingTel.Text = Model.JiaTingTel.ToString();
this.txtMobTel.Text = Model.MobTel.ToString();
this.txtEmailStr.Text = Model.EmailStr.ToString();
this.txtQQorMsn.Text = Model.QQorMsn.ToString();
this.txtBackInfo.Text = Model.BackInfo.ToString();
this.txtUserName.Text = Model.UserName.ToString();
this.txtTimeStr.Text = Model.TimeStr.ToString();
}
}
public void DataBindToGridview()
{
ZWL.BLL.ERPSupplyLink MyModel = new ZWL.BLL.ERPSupplyLink();
GVData.DataSource = MyModel.GetList("SupplysName Like '%" + this.TextBox1.Text + "%' order by ID desc");
GVData.DataBind();
LabPageSum.Text = Convert.ToString(GVData.PageCount);
LabCurrentPage.Text = Convert.ToString(((int)GVData.PageIndex + 1));
this.GoPage.Text = LabCurrentPage.Text.ToString();
}
