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, "提交成功！");
}
}
