//编辑谈判记录的时候进来
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);
}
//通过业态名称来查询子业态名称，并返回字符串"
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);
}
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);
}
