protected void Button1_Click(object sender, EventArgs e) { WX.CRM.CustomerAgreement.MODEL agreement = WX.CRM.CustomerAgreement.GetModel("SELECT * FROM CRM_CustomerAgreement where TrackID=" + Request["TrackID"]); agreement.Content.value = FORM_CONTENT.Value; agreement.Update(); Response.Redirect("CRM_SingleM_ShowAgreement.aspx?AgreementID=" + agreement.id.ToString()); }
private void SetTr2() { Tr2.Visible = true; if (DropProgram.Items.Count == 0) { DropProgram.DataSource = ULCode.QDA.XSql.GetDataTable("select Title,id from CRM_CustomerProgram where CustomerID=" + WX.Request.rCustomerID); DropProgram.DataTextField = "Title"; DropProgram.DataValueField = "id"; DropProgram.DataBind(); DropProgram.Items.Add(new ListItem("无", "0")); DropProgram.SelectedValue = "0"; } string sql = "SELECT *,null ccpID,null ZDFee,null Remarks FROM [PDT_Products] where IsEnable=1"; if (Request["TrackID"] != null && Request["TrackID"] != "") { WX.CRM.CustomerAgreement.MODEL agreement = WX.CRM.CustomerAgreement.GetModel("SELECT * FROM CRM_CustomerAgreement where TrackID=" + Request["TrackID"]); if (agreement != null) { DropProgram.SelectedValue = agreement.ProgramID.ToString(); txtOverFee.Text = agreement.OverFee.ToString(); txtOverTime.Text = agreement.OverTime.ToString() != ""? agreement.OverTime.ToDateTime().ToString("yyyy-MM-dd"):""; txtInvoice.Text = agreement.Invoice.ToString(); txtAddtime.Text = agreement.Addtime.ToString() != ""? agreement.Addtime.ToDateTime().ToString("yyyy-MM-dd"):""; txtStartTime.Text = agreement.StartTime.ToString() != ""? agreement.StartTime.ToDateTime().ToString("yyyy-MM-dd"):""; txtStopTime.Text = agreement.StopTime.ToString() != "" ? agreement.StopTime.ToDateTime().ToString("yyyy-MM-dd") : ""; } sql = "SELECT pp.*,ccp.id ccpID,ccp.ZDFee,ccp.Remarks FROM [PDT_Products] pp left join CRM_CustomerProducts ccp on pp.id=ccp.ProductID and PID=" + agreement.id.ToString() + " and ccp.Type=2 where pp.IsEnable=1"; } System.Data.DataTable dt = ULCode.QDA.XSql.GetDataTable(sql); Repeater2.DataSource = dt; Repeater2.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { WX.CRM.CustomerAgreement.MODEL agreement = WX.CRM.CustomerAgreement.NewDataModel(Request["AgreementID"]); Literal1.Text = agreement.Content.ToString(); } }
public void SetAgreement(WX.CRM.CustomerAgreement.MODEL agreementmodel, int pid) { decimal allfee = 0; for (int i = 0; i < Repeater2.Items.Count; i++) { if (((CheckBox)Repeater2.Items[i].FindControl("CheckBox2")).Checked) { try { allfee += Convert.ToDecimal(((TextBox)Repeater2.Items[i].FindControl("zdfee2")).Text); } catch { } } } agreementmodel.CustomerID.value = WX.Request.rCustomerID; agreementmodel.TrackID.value = pid; agreementmodel.TempID.value = 0; agreementmodel.AllFee.value = allfee; agreementmodel.OverFee.value = txtOverFee.Text; agreementmodel.Fee.value = Convert.ToDecimal(agreementmodel.AllFee.value) - Convert.ToDecimal(agreementmodel.OverFee.value); agreementmodel.OverTime.value = txtOverTime.Text; agreementmodel.Invoice.value = txtInvoice.Text; agreementmodel.OverInvoice.value = Convert.ToDecimal(agreementmodel.AllFee.value) - Convert.ToDecimal(agreementmodel.Invoice.value); agreementmodel.Addtime.value = txtAddtime.Text; agreementmodel.StartTime.value = txtStartTime.Text; agreementmodel.StopTime.value = txtStopTime.Text; if (DropProgram.SelectedValue != "0") { agreementmodel.ProgramID.value = DropProgram.SelectedValue; } int agreementid = 0; if (Request["TrackID"] != null && Request["TrackID"] != "") { agreementmodel.Update(); agreementid = agreementmodel.id.ToInt32(); WX.Main.ExecuteDelete("CRM_CustomerProducts", "PID=" + agreementid + " and Type", "2"); } else { agreementmodel.UserID.value = WX.Main.CurUser.UserID; agreementid = agreementmodel.Insert(true); } SetProduct(agreementid, 2); }
public void PageInit() { System.Net.WebClient wc = new System.Net.WebClient(); byte[] buff = wc.DownloadData(Server.MapPath("AgreementTemp/Default.htm")); FORM_CONTENT.Value = System.Text.Encoding.GetEncoding("utf-8").GetString(buff); WX.CRM.Customer.MODEL customer = WX.CRM.Customer.GetModel("select * from CRM_Customers where ID=(select CustomerID from CRM_Track where ID=" + Request["TrackID"] + ")"); if (customer != null) { FORM_CONTENT.Value = FORM_CONTENT.Value.Replace("$CustomerName", customer.CustomerName.ToString()).Replace("$jiafang", customer.CustomerName.ToString()); } WX.Main.CurUser.LoadMyCompany(); FORM_CONTENT.Value = FORM_CONTENT.Value.Replace("$yifang", WX.Main.CurUser.MyCompany.Name.ToString()); string product = ""; string allfee = ""; if (Request["TrackID"] != null && Request["TrackID"] != "") { WX.CRM.CustomerAgreement.MODEL agreement = WX.CRM.CustomerAgreement.GetModel("SELECT * FROM CRM_CustomerAgreement where TrackID=" + Request["TrackID"]); if (agreement != null) { allfee = agreement.AllFee.ToString(); string sql = "SELECT * FROM CRM_CustomerProducts where PID=" + agreement.id.ToString() + " and Type=2"; System.Data.DataTable dt = ULCode.QDA.XSql.GetDataTable(sql); if (dt.Rows.Count > 0) { product = "<table border='1' cellpadding=\"0\" cellspacing=\"0\" style='width:100%;'>\n <tr style=\"text-align: center;height:30px; font-weight: bold;\">\n<td>\n 合作形式\n</td>\n<td>\n服务内容\n</td>\n<td>\n报价\n</td>\n<td>\n 其它补充\n</td>\n </tr>"; } for (int i = 0; i < dt.Rows.Count; i++) { product += "<tr>\n<td height='28' align=\"left\">\n" + dt.Rows[i]["ProductName"] + "</td>\n<td width=\"200\">\n" + dt.Rows[i]["Services"] + "</td>\n<td>\n" + dt.Rows[i]["ZDFee"] + "</td>\n<td>\n" + dt.Rows[i]["Remarks"] + "</td>\n</tr>"; } product = product == "" ? "" : product + "</table>"; } } FORM_CONTENT.Value = FORM_CONTENT.Value.Replace("$Products", product).Replace("$AllFee", allfee.ToString()); }
protected void Button1_Click(object sender, EventArgs e) { if (ddlProcessState.SelectedValue == "4") { ccp.Visible = true; } else { ccp.Visible = false; } WX.CRM.Track.MODEL track; if (Request["TrackID"] != null && Request["TrackID"] != "") { track = WX.CRM.Track.NewDataModel(Request["TrackID"]); } else { track = WX.CRM.Track.NewDataModel(); track.UserID.value = WX.Main.CurUser.UserID; } track.ProcessState.value = ddlProcessState.SelectedValue; track.CustomerID.value = WX.Request.rCustomerID; track.TrackNo.value = txtTrackNo.Text; track.Fee.value = txtFee.Text; track.Remarks.value = txtremark.Text + "|" + txtremark2.Text + "|" + txtremark3.Text + "|" + txtremark4.Text; track.IP.value = System.Web.HttpContext.Current.Request.UserHostAddress; track.LogParaments.value = txtLogParaments.Text; track.Type.value = 0; if (txtTrackTime.Text.Trim() == "") { mess = "Messages('跟踪时间必填!')"; return; } track.TrackTime.value = txtTrackTime.Text; track.State.value = rblstate.SelectedValue; //track.TrackTime.ToDateTime() < DateTime.Now ? 1 : 0; if (Request["TrackID"] != null && Request["TrackID"] != "") { track.Update(); if (track.ProcessState.ToInt32() == 4) { WX.CRM.CustomerProgram.MODEL programmodel = WX.CRM.CustomerProgram.GetModel("SELECT * FROM CRM_CustomerProgram where TrackID=" + Request["TrackID"]); if (programmodel != null) { SetProgram(programmodel, track.id.ToInt32()); } } else if (track.ProcessState.ToInt32() == 5) { WX.CRM.CustomerAgreement.MODEL agreementmodel = WX.CRM.CustomerAgreement.GetModel("SELECT * FROM CRM_CustomerAgreement where TrackID=" + Request["TrackID"]); SetAgreement(agreementmodel, track.id.ToInt32()); } } else { int trackid = track.Insert(true); if (track.ProcessState.ToInt32() == 4) { WX.CRM.CustomerProgram.MODEL programmodel = WX.CRM.CustomerProgram.NewDataModel(); SetProgram(programmodel, trackid); } else if (track.ProcessState.ToInt32() == 5) { WX.CRM.CustomerAgreement.MODEL agreementmodel = WX.CRM.CustomerAgreement.NewDataModel(); SetAgreement(agreementmodel, trackid); } } //当签订协议后更改促成方案的状态 if (track.ProcessState.ToInt32() == 5 && track.State.ToInt32() == 1 && DropProgram.SelectedValue != "0") { WX.CRM.CustomerProgram.MODEL cprogram = WX.CRM.CustomerProgram.NewDataModel(DropProgram.SelectedValue); cprogram.State.value = 1; cprogram.Updatetime.value = DateTime.Now; cprogram.Update(); } WX.CRM.Customer.MODEL customer = WX.CRM.Customer.NewDataModel(track.CustomerID.value); if (customer.StageID.ToInt32() == 0 && (track.ProcessState.ToInt32() == 0 || track.ProcessState.ToInt32() == 1)) { customer.StageID.value = 1; } else if (customer.StageID.ToInt32() == 1 && (track.ProcessState.ToInt32() == 2 || track.ProcessState.ToInt32() == 3 || track.ProcessState.ToInt32() == 4)) { customer.StageID.value = 2; } else if (customer.StageID.ToInt32() == 2 && (track.ProcessState.ToInt32() == 5 || track.ProcessState.ToInt32() == 6 || track.ProcessState.ToInt32() == 7 || track.ProcessState.ToInt32() == 8)) { customer.StageID.value = 3; } else if (customer.StageID.ToInt32() == 3 && track.ProcessState.ToInt32() > 8) { customer.StageID.value = 4; } if (rblstate.SelectedValue == "1" && Convert.ToDouble(track.Fee.value) > 0) { WX.CRM.CustomerTemp.MODEL temp = WX.Request.rCustomerTempToCID; if (temp != null) { temp.LastMaintainMoney.value = track.Fee.value; temp.MaintainMoney.value = Convert.ToDouble(temp.MaintainMoney.value) + Convert.ToDouble(track.Fee.value); temp.Update(); customer.LastMaintainMoney.value = temp.LastMaintainMoney.value; customer.MaintainMoney.value = temp.MaintainMoney.value; } else { customer.LastMaintainMoney.value = track.Fee.value; customer.MaintainMoney.value = Convert.ToDouble(customer.MaintainMoney.value) + Convert.ToDouble(track.Fee.value); } } customer.Update(); WX.CRM.Customer.AddLog(customer.ID.ToInt32(), customer.CustomerName.ToString(), WX.Main.CurUser.UserID, 11, ddlProcessState.SelectedItem.Text); if (track.ProcessState.ToInt32() == 5) { Response.Redirect("CRM_SingleM_EditAgreement.aspx?TrackID=" + track.id.ToString()); } else { WX.Main.CloseDialog_In_EasyUIDialog(this, "提交成功!"); } }