/// <summary> /// 启用、停用 /// </summary> /// <param name="source"></param> /// <param name="e"></param> public void Rpt_Distribute__ItemCommand(object source, RepeaterCommandEventArgs e) { string id = e.CommandArgument.ToString(); Hi.Model.YZT_Contract cont = new Hi.BLL.YZT_Contract().GetModel(id.ToInt(0)); if (cont != null) { cont.ts = DateTime.Now; cont.modifyuser = this.UserID; if (e.CommandName == "BUP") { //停用 cont.CState = 0; } else { //启用 cont.CState = 1; } if (new Hi.BLL.YZT_Contract().Update(cont)) { DataBinds(); } } }
/// <summary> /// 修改绑定 /// </summary> public void Bind() { string ContID = Request.QueryString["cid"]; if (!string.IsNullOrWhiteSpace(ContID)) { Hi.Model.YZT_Contract contractModel = new Hi.BLL.YZT_Contract().GetModel(Convert.ToInt32(ContID)); if (contractModel != null) { this.txtcontractNO.Value = contractModel.contractNO; this.txtcontractDate.Value = contractModel.contractDate.ToString("yyyy-MM-dd"); this.txtForceDate.Value = contractModel.ForceDate.ToString("yyyy-MM-dd"); this.txtInvalidDate.Value = contractModel.InvalidDate.ToString("yyyy-MM-dd"); this.txtRemark.Value = contractModel.Remark; this.DropDis.SelectedValue = contractModel.DisID.ToString(); this.CState.Value = contractModel.CState.ToString(); } DataTable dt = new Hi.BLL.YZT_ContractDetail().getDataTable(ContID); if (dt.Rows.Count > 0) { this.RepContractDetail.DataSource = dt; this.RepContractDetail.DataBind(); } } }
/// <summary> /// 修改绑定 /// </summary> public void Bind() { string ContID = Request.QueryString["cid"]; if (!string.IsNullOrWhiteSpace(ContID)) { Hi.Model.YZT_Contract contractModel = new Hi.BLL.YZT_Contract().GetModel(Convert.ToInt32(ContID)); if (contractModel != null) { Hi.Model.BD_Company comp = new Hi.BLL.BD_Company().GetModel(Convert.ToInt32(contractModel.CompID)); if (comp != null) { this.txtCompName.Value = comp.CompName; this.contractCompId = comp.ID; if (this.CompID <= 0) { this.hidCompId.Value = comp.ID.ToString(); } } this.txtcontractNO.Value = contractModel.contractNO; this.txtcontractDate.Value = contractModel.contractDate.ToString("yyyy-MM-dd"); this.txtForceDate.Value = contractModel.ForceDate.ToString("yyyy-MM-dd"); this.txtInvalidDate.Value = contractModel.InvalidDate.ToString("yyyy-MM-dd"); this.txtRemark.Value = contractModel.Remark; this.txtState.Value = contractModel.CState.ToString() == "1" ? "启用" : "停用"; } DataTable dt = new Hi.BLL.YZT_ContractDetail().getDataTable(ContID); if (dt.Rows.Count > 0) { this.RepContractDetail.DataSource = dt; this.RepContractDetail.DataBind(); } } }
/// <summary> /// 绑定合同列表 /// </summary> public void getContract() { int Counts = 0; int pageCount = 0; List <Hi.Model.YZT_Contract> LDis = new Hi.BLL.YZT_Contract().GetList(Pager.PageSize, Pager.CurrentPageIndex, "Createdate", true, " and isnull(dr,0)=0 and CompID=" + CompID + " and DisID=" + KeyID + "", out pageCount, out Counts); if (LDis.Count > 0) { if (LDis[0].InvalidDate > DateTime.Now) { liContract.Visible = false; } } this.ContractRep.DataSource = LDis; this.ContractRep.DataBind(); Page1.RecordCount = Counts; page = Page1.CurrentPageIndex.ToString(); }
/// <summary> /// 修改绑定 /// </summary> /// <param name="type">入库or出库</param> /// <param name="no">单据ID</param> public void Bind() { string ContID = Request.QueryString["cid"]; this.Cid.Value = Request.QueryString["cid"]; if (!string.IsNullOrWhiteSpace(ContID)) { Hi.Model.YZT_Contract contractModel = new Hi.BLL.YZT_Contract().GetModel(Convert.ToInt32(ContID)); if (contractModel != null) { this.txtcontractNO.Value = contractModel.contractNO; this.txtcontractDate.Value = contractModel.contractDate.ToString("yyyy-MM-dd"); this.txtForceDate.Value = contractModel.ForceDate.ToString("yyyy-MM-dd"); this.txtInvalidDate.Value = contractModel.InvalidDate.ToString("yyyy-MM-dd"); this.txtRemark.Value = contractModel.Remark; this.DropDis.SelectedValue = contractModel.DisID.ToString(); this.CState.Value = contractModel.CState.ToString(); } DataTable dt = new Hi.BLL.YZT_ContractDetail().getDataTable(ContID); if (dt.Rows.Count > 0) { tbodyTR.Visible = false; this.RepContractDetail.DataSource = dt; this.RepContractDetail.DataBind(); } List <Hi.Model.YZT_Annex> AnnexDelList = new Hi.BLL.YZT_Annex().GetList("", " dr=0 and fcID=" + ContID + " and fileAlias=3", ""); if (AnnexDelList.Count > 0) { string fileName = ""; foreach (Hi.Model.YZT_Annex item in AnnexDelList) { fileName += item.fileName + ","; } HidFfileName.Value = fileName; } } }
public void DataBinds() { int pageCount = 0; int Counts = 0; if (this.txtPageSize.Value.ToString() != "") { if (this.txtPageSize.Value.Trim().Length >= 5) { Pager.PageSize = 100; this.txtPageSize.Value = "100"; } else { Pager.PageSize = this.txtPageSize.Value.Trim().ToInt(0); } } DataTable dt = new Hi.BLL.YZT_Contract().getDataTable(Pager.PageSize, Pager.CurrentPageIndex, SearchWhere(), out pageCount, out Counts); this.Rpt_Distribute.DataSource = dt; this.Rpt_Distribute.DataBind(); Pager.RecordCount = Counts; page = Pager.CurrentPageIndex.ToString(); }
/// <summary> /// 上传合同 /// </summary> /// <param name="Name"></param> /// <param name="vDate"></param> public void insertContract(string Name, string txtForceDate, string txtInvalidDate) { string json = ""; SqlTransaction tran = null; if (!string.IsNullOrWhiteSpace(Name)) { try { tran = SqlHelper.CreateStoreTranSaction(); DateTime time = DateTime.Now; Hi.Model.YZT_Contract contractModel = new Hi.Model.YZT_Contract(); contractModel.contractNO = ""; contractModel.contractDate = time; contractModel.DisID = KeyID; contractModel.CState = 3;//线下合同 contractModel.ForceDate = Convert.ToDateTime(txtForceDate); contractModel.InvalidDate = Convert.ToDateTime(txtInvalidDate); contractModel.Remark = "线下合同"; contractModel.CreateDate = DateTime.Now; contractModel.CreateUserID = UserID; contractModel.dr = 0; contractModel.ts = DateTime.Now; contractModel.modifyuser = UserID; contractModel.CompID = CompID; int Cid = new Hi.BLL.YZT_Contract().Add(contractModel, tran); Hi.Model.YZT_Annex annexModel = new Hi.Model.YZT_Annex(); annexModel.fcID = Convert.ToInt32(Cid); annexModel.type = 10; annexModel.fileName = Name; annexModel.fileAlias = "3"; annexModel.validDate = Convert.ToDateTime(txtInvalidDate); annexModel.CreateDate = time; annexModel.dr = 0; annexModel.ts = time; annexModel.modifyuser = UserID; annexModel.CreateUserID = UserID; int count = new Hi.BLL.YZT_Annex().Add(annexModel, tran); tran.Commit(); if (count > 0) { json = "{\"ret\":\"ok\"}"; } else { json = "{\"ret\":\"上传失败\"}"; } } catch (Exception e) { tran.Rollback(); json = "{\"ret\":\"" + e.Message + "\"}"; } } else { json = "{\"ret\":\"附件不能为空!\"}"; } Response.Write(json); Response.End(); }