Beispiel #1
0
    //编辑谈判记录的时候进来
    protected void GetTPJLData()
    {
        string RecID = "";
        string ResID = "";

        if (Request["RecID"] != null)
        {
            RecID = Request["RecID"];
        }
        if (Request["ResID"] != null)
        {
            ResID = Request["ResID"];
        }
        WebServices.Services Resource = new WebServices.Services();
        DataTable            ppDt     = Resource.GetDataListByResourceID(ResID, false, " and id=" + RecID).Tables[0];

        Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
        timeConverter.DateTimeFormat = "yyyy'-'MM'-'dd";
        String str = Newtonsoft.Json.JsonConvert.SerializeObject(ppDt, timeConverter);

        if (ppDt.Rows.Count > 0)
        {
            DataTable sunDt = Resource.GetDataListByResourceID("383153238947", false, " and 谈判系统编号='" + ppDt.Rows[0]["谈判系统编号"] + "'").Tables[0];
            str = str.Substring(0, str.Length - 1);
            String str1 = Newtonsoft.Json.JsonConvert.SerializeObject(sunDt, timeConverter);
            str = str + "," + str1.Substring(1, str1.Length - 1);
        }
        Response.Write(str);
    }
Beispiel #2
0
    //通过业态名称来查询子业态名称,并返回字符串"
    protected void GetEJYT()
    {
        WebServices.Services Resource = new WebServices.Services();
        String ytValue = "";
        String ChildYT = "";

        if (Request.QueryString["ytValue"] != null)
        {
            ytValue = Request.QueryString["ytValue"];
        }
        if (ytValue != null && ytValue != "")
        {
            DataTable ejYTDt = Resource.GetDataListByResourceID("423743051439", false, " and 上级业态名称='" + ytValue + "'").Tables[0];
            if (ejYTDt.Rows.Count > 0)
            {
                for (int i = 0; i < ejYTDt.Rows.Count; i++)
                {
                    ChildYT += ejYTDt.Rows[i]["业态名称"].ToString();
                    if (i < ejYTDt.Rows.Count - 1)
                    {
                        ChildYT += ",";
                    }
                }
            }
        }
        Response.Write(ChildYT);
    }
Beispiel #3
0
    protected void GetEditorData()
    {
        String ResID     = Request.QueryString["ResID"];
        String RecID     = Request.QueryString["RecID"];
        string searchstr = "";

        WebServices.Services Resource = new WebServices.Services();

        if (ResID == "460222389874")
        {
            searchstr = " and DOCID ='" + RecID + "'";
        }
        else
        {
            searchstr = " and id=" + RecID;
        }

        DataTable ppDt = Resource.GetDataListByResourceID(ResID, false, searchstr).Tables[0];

        Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
        timeConverter.DateTimeFormat = "yyyy'-'MM'-'dd";
        String str = Newtonsoft.Json.JsonConvert.SerializeObject(ppDt, timeConverter);

        //方案系统编号,加载方案扩展表的时候用 430590206015//方案扩展表的ResID
        String FAXTBH = Request.QueryString["FAXTBH"];

        if (FAXTBH != null && FAXTBH != "")
        {
            DataTable sunDt = Resource.GetDataListByResourceID("430590206015", false, " and 方案系统编号='" + FAXTBH + "'").Tables[0];
            String    str1  = Newtonsoft.Json.JsonConvert.SerializeObject(sunDt, timeConverter);
            str = str + "[#]" + str1;
            String lxrxtbh = sunDt.Rows[0]["联系人系统编号"].ToString();
            if (lxrxtbh != null && lxrxtbh != "")
            {
                //查询品牌方案关联的联系人系统编号
                DataTable lxrDt = Resource.GetDataListByResourceID("379264068953", false, " and 联系人系统编号='" + lxrxtbh + "'").Tables[0];
                String    str2  = Newtonsoft.Json.JsonConvert.SerializeObject(lxrDt, timeConverter);
                str = str + "[#]" + str2;
            }
        }
        Response.Write(str);
    }