private void LoadData(string id) { bool isD = false;//查询哪个表的产品,false没有生成合同时,根据询价单ID查询,true已生成合同,根据合同ID查询 DataTable dt = bll.GetContactDataByID(id.Trim()); if (dt != null && dt.Rows.Count > 0) { if (string.IsNullOrEmpty(dt.Rows[0]["CreateTime"].ToString())) { lbTime.Text = DateTime.Now.ToString(); } else { lbTime.Text = dt.Rows[0]["CreateTime"].ToString(); } lbBuyOrg.Text = dt.Rows[0]["BuyOrg"].ToString(); string srmNo = dt.Rows[0]["SRM_Contract_NO"].ToString(); if (string.IsNullOrEmpty(srmNo)) { //srmNo = "90000001"; srmNo = bll.GetSRMNo();//取得合同号 hdfSRMNo.Value = ""; isD = false; } else { hdfSRMNo.Value = srmNo; isD = true; } lbSrmNo.Text = srmNo; hdfid.Value = dt.Rows[0]["id"].ToString(); lbERPNo.Text = dt.Rows[0]["ERP_Contract_NO"].ToString(); lbGrantNo.Text = dt.Rows[0]["GrantNo"].ToString(); lbDistributorName.Text = dt.Rows[0]["DistributorName"].ToString(); lbDistributorAddr.Text = dt.Rows[0]["DistributorAddr"].ToString(); lbContactName.Text = dt.Rows[0]["ContactName"].ToString(); lbReceivingParty.Text = dt.Rows[0]["ReceivingParty"].ToString(); lbAcquiringParty.Text = dt.Rows[0]["AcquiringParty"].ToString(); string currency = dt.Rows[0]["Currency"].ToString(); if (string.IsNullOrEmpty(currency)) { currency = dt.Rows[0]["AbCurrency"].ToString(); } if (string.IsNullOrEmpty(currency)) { currency = "CNY"; } lbCurrency.Text = currency; sltCurrency.Value = currency; lbBuyerAccount.Text = dt.Rows[0]["BuyerAccount"].ToString(); string workFlowStatus = dt.Rows[0]["WorkFlowStatus"].ToString().Trim(); lbWorkFlowStatus.Text = CommonCode.GetWorkFlowStatusText(workFlowStatus); //判断显示功能按钮 switch (workFlowStatus) { case "1": //明细维护 btnSave.Visible = true; btnCom.Visible = true; btnAud.Visible = false; hdfStatus.Value = "1"; hdfBackStatus.Value = "1"; break; case "2": //供应商确认中 btnSave.Visible = true; btnCom.Visible = false; btnAud.Visible = false; hdfStatus.Value = "2"; hdfBackStatus.Value = "0"; break; case "3": //供应商回退 btnSave.Visible = true; btnCom.Visible = true; btnAud.Visible = false; hdfStatus.Value = "1"; hdfBackStatus.Value = "1"; aStatus.Title = dt.Rows[0]["DistributorRemark"].ToString(); break; case "4": //供应商确认 btnSave.Visible = true; btnCom.Visible = false; btnAud.Visible = true; hdfStatus.Value = "4"; hdfBackStatus.Value = "0"; break; case "5": //经理审批中 btnSave.Visible = true; btnCom.Visible = false; btnAud.Visible = false; hdfStatus.Value = "5"; hdfBackStatus.Value = "0"; break; case "6": //经理回退 btnSave.Visible = true; btnCom.Visible = false; btnAud.Visible = true; hdfStatus.Value = "6"; hdfBackStatus.Value = "0"; aStatus.Title = dt.Rows[0]["AuditRemark"].ToString(); break; case "7": //合同生效 btnSave.Visible = true; btnCom.Visible = false; btnAud.Visible = false; hdfStatus.Value = "7"; hdfBackStatus.Value = "0"; hdfUrl.Value = "ContractEffectiveList.aspx"; break; default: //未创建 btnSave.Visible = true; btnCom.Visible = false; btnAud.Visible = false; hdfStatus.Value = "1"; hdfBackStatus.Value = "1"; break; } sltPlay.Value = dt.Rows[0]["PlayType"].ToString(); //付款方式 sltPlay2.Value = dt.Rows[0]["PlayType"].ToString(); //付款方式 sltTemple.Value = dt.Rows[0]["TemplateId"].ToString(); //合同模板 sltPriceClause.Value = dt.Rows[0]["PriceClause"].ToString(); //价格条款 txtRemark.Text = dt.Rows[0]["Remark"].ToString(); //摘要 string bDate = dt.Rows[0]["AgreementBDate"].ToString(); if (string.IsNullOrEmpty(bDate)) { bDate = DateTime.Now.ToString("yyyy-MM-dd"); } else { bDate = Convert.ToDateTime(bDate).ToString("yyyy-MM-dd"); } txtBeginDate.Value = bDate; bDate = dt.Rows[0]["AgreementEDate"].ToString(); if (string.IsNullOrEmpty(bDate)) { bDate = DateTime.Now.AddDays(7).ToString("yyyy-MM-dd"); } else { bDate = Convert.ToDateTime(bDate).ToString("yyyy-MM-dd"); } txtEndDate.Value = bDate; DataTable dtp = null; //isD = false;//查询哪个表的产品,false没有生成合同时,根据询价单ID查询,true已生成合同,根据合同ID查询 if (isD) { dtp = bll.GetContactProductByCID(dt.Rows[0]["id"].ToString()); } else { string xjNo = dt.Rows[0]["XunJiaWorkflowID"].ToString(); dtp = bll.GetContactProduct(xjNo);//Amount } Repeater1.DataSource = dtp; Repeater1.DataBind(); //金额合计 double amount = 0; if (dtp != null && dtp.Rows.Count > 0) { foreach (DataRow r in dtp.Rows) { amount += string.IsNullOrEmpty(r["Amount"].ToString()) ? 0 : double.Parse(r["Amount"].ToString()); } } lbTotal.Text = amount.ToString(); } }