/// <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();
}
