protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
DataEntityDataContext context = new DataEntityDataContext();
ERPRecive Model = new ERPRecive();
Model = context.ERPRecive.SingleOrDefault(p => p.ID == int.Parse(Request.QueryString["ID"].ToString()));
this.lblHeTongName.Text = Model.HeTongName.ToString();
HeTongName = Model.HeTongName.ToString();
this.lblQianYueKeHu.Text = Model.QianYueKeHu.ToString();
this.lblHeTongMiaoShu.Text = Model.HTJE.ToString();
this.lblShengXiaoDate.Text = Model.TiXingDate.ToString().Replace(" 0:00:00", "");
this.lblTiXingDate.Text = Model.DaoKuanDate.ToString().Replace(" 0:00:00", "");
this.Label1.Text = Model.SFDK;
this.lblCreateTime.Text = Model.CreateTime.ToString();
this.lblCreateUser.Text = Model.CreateUser.ToString();
this.lblBackInfo.Text = Model.BackInfo.ToString();
//写系统日志
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "用户查看收款计划信息(" + this.lblHeTongName.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
}
}
public void DataBindToGridview()
{
string XiaShuUser = ZWL.DBUtility.DbHelperSQL.GetSHSLInt("select top 1 XiaShuUser from ERPUser where UserName='******'");
DataEntityDataContext context = new DataEntityDataContext();
ERPRecive Model = new ERPRecive();
var T = context.ERPRecive.Where(p => p.ID > 0 && p.NowState == "S");
if (!string.IsNullOrEmpty(this.TextBox1.Text))
{
T = T.Where(p => p.HeTongName.Contains(this.TextBox1.Text) || p.QianYueKeHu.Contains(this.TextBox1.Text) || p.SFDK.Contains(this.TextBox1.Text) || p.HTJE.Contains(this.TextBox1.Text));
}
if (!string.IsNullOrEmpty(this.TextBox3.Text))
{
T = T.Where(p => p.DaoKuanDate >= DateTime.Parse(this.TextBox3.Text) || p.TiXingDate >= DateTime.Parse(this.TextBox3.Text) || p.CreateTime >= DateTime.Parse(this.TextBox3.Text));
}
if (!string.IsNullOrEmpty(this.TextBox4.Text))
{
T = T.Where(p => p.DaoKuanDate >= DateTime.Parse(this.TextBox4.Text) || p.TiXingDate >= DateTime.Parse(this.TextBox4.Text) || p.CreateTime >= DateTime.Parse(this.TextBox4.Text));
}
GVData.DataSource = T;
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)
{
DataEntityDataContext context = new DataEntityDataContext();
ERPRecive Model = new ERPRecive();
Model.HeTongName = this.txtHeTongName.Text.ToString();
Model.QianYueKeHu = this.txtQianYueKeHu.Text.ToString();
Model.HTJE = this.txtHeTongMiaoShu.Text.ToString();
Model.TiXingDate = DateTime.Parse(this.txtShengXiaoDate.Text);
Model.DaoKuanDate = DateTime.Parse(this.txtTiXingDate.Text);
Model.CreateTime = DateTime.Now;
Model.CreateUser = ZWL.Common.PublicMethod.GetSessionValue("UserName");
Model.BackInfo = this.txtBackInfo.Text.ToString();
Model.SFDK = this.DZ.Value;
Model.NowState = "S";
Model.SFDK = "否";
context.ERPRecive.InsertOnSubmit(Model);
context.SubmitChanges();
int id = Model.ID;
ERPYS ys = new ERPYS();
ys.FKID = id;
ys.HeTongName = this.txtHeTongName.Text.ToString();
ys.QianYueKeHu = this.txtQianYueKeHu.Text.ToString();
ys.HTJE = this.txtHeTongMiaoShu.Text.ToString();
ys.TiXingDate = DateTime.Parse(this.txtShengXiaoDate.Text);
ys.DaoKuanDate = DateTime.Parse(this.txtTiXingDate.Text);
ys.CreateTime = DateTime.Now;
ys.CreateUser = ZWL.Common.PublicMethod.GetSessionValue("UserName");
ys.BackInfo = this.txtBackInfo.Text.ToString();
ys.SFDK = this.DZ.Value;
ys.NowState = "S";
context.ERPYS.InsertOnSubmit(ys);
context.SubmitChanges();
//写系统日志
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "用户添加收款计划信息(" + this.txtHeTongName.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
ZWL.Common.MessageBox.ShowAndRedirect(this, "收款计划信息添加成功！", "Revice.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
this.txtHeTongName.Attributes.Add("readonly", "true");
this.txtQianYueKeHu.Attributes.Add("readonly", "true");
DataEntityDataContext context = new DataEntityDataContext();
ERPRecive Model = new ERPRecive();
Model = context.ERPRecive.SingleOrDefault(p => p.ID == int.Parse(Request.QueryString["ID"].ToString()));
this.txtHeTongName.Text = Model.HeTongName.ToString();
this.txtQianYueKeHu.Text = Model.QianYueKeHu.ToString();
this.txtHeTongMiaoShu.Text = Model.HTJE.ToString();
this.txtShengXiaoDate.Text = Model.TiXingDate.ToString().Replace(" 0:00:00", "");
this.txtTiXingDate.Text = Model.DaoKuanDate.ToString().Replace(" 0:00:00", "");
this.DZ.Value = Model.SFDK;
this.txtBackInfo.Text = Model.BackInfo.ToString();
}
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
DataEntityDataContext context = new DataEntityDataContext();
ERPYS Model = new ERPYS();
Model = context.ERPYS.SingleOrDefault(p => p.ID == int.Parse(Request.QueryString["ID"].ToString()));
Model.SFDK = this.DZ.Value;
ERPRecive model2 = context.ERPRecive.SingleOrDefault(p => p.ID == Model.FKID);
model2.SFDK = this.DZ.Value;
context.SubmitChanges();
//写系统日志
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "用户修改应付信息(" + this.txtHeTongName.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
ZWL.Common.MessageBox.ShowAndRedirect(this, "应付信息修改成功！", "YF.aspx");
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
DataEntityDataContext context = new DataEntityDataContext();
ERPRecive Model = new ERPRecive();
Model = context.ERPRecive.SingleOrDefault(p => p.ID == int.Parse(Request.QueryString["ID"].ToString()));
Model.ID = int.Parse(Request.QueryString["ID"].ToString());
Model.HeTongName = this.txtHeTongName.Text.ToString();
Model.QianYueKeHu = this.txtQianYueKeHu.Text.ToString();
Model.HTJE = this.txtHeTongMiaoShu.Text.ToString();
Model.TiXingDate = DateTime.Parse(this.txtShengXiaoDate.Text);
Model.DaoKuanDate = DateTime.Parse(this.txtTiXingDate.Text);
Model.SFDK = this.DZ.Value;
Model.BackInfo = this.txtBackInfo.Text.ToString();
ERPYS ys = new ERPYS();
ys = context.ERPYS.SingleOrDefault(p => p.FKID == Model.ID);
ys.HeTongName = this.txtHeTongName.Text.ToString();
ys.QianYueKeHu = this.txtQianYueKeHu.Text.ToString();
ys.HTJE = this.txtHeTongMiaoShu.Text.ToString();
ys.TiXingDate = DateTime.Parse(this.txtShengXiaoDate.Text);
ys.DaoKuanDate = DateTime.Parse(this.txtTiXingDate.Text);
ys.BackInfo = this.txtBackInfo.Text.ToString();
ys.SFDK = this.DZ.Value;
ys.NowState = "F";
context.SubmitChanges();
//写系统日志
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "用户修改付款计划信息(" + this.txtHeTongName.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
ZWL.Common.MessageBox.ShowAndRedirect(this, "付款计划信息修改成功！", "FK.aspx");
}
partial void DeleteERPRecive(ERPRecive instance);
partial void UpdateERPRecive(ERPRecive instance);
partial void InsertERPRecive(ERPRecive instance);
