private void BindData()
{
int count = -1;
BitAuto.YanFa.Crm2009.Entities.QueryCustInfo query = new BitAuto.YanFa.Crm2009.Entities.QueryCustInfo();
Entities.ProjectTask_DelCustRelation model = BLL.ProjectTask_DelCustRelation.Instance.GetProjectTask_DelCustRelationByTID(TID);
if (IsShowdDelCustRelation && model != null &&
!string.IsNullOrEmpty(model.DelCustIDs))
{
query.DelCustIDs = model.DelCustIDs;
}
else
{
if (!string.IsNullOrEmpty(CustName))
{
if (!string.IsNullOrEmpty(CustNameAllMatch) &&
CustNameAllMatch.ToLower().Equals("yes"))
{
query.ExistCustName = CustName;
}
else
{
query.CustName = CustName;
}
}
if (ProvinceID > 0)
{
query.ProvinceID = ProvinceID.ToString();
}
if (CityID > 0)
{
query.CityID = CityID.ToString();
}
if (CountyID > 0)
{
query.CountyID = CountyID.ToString();
}
if (ExceptCustID > 0)
{
query.ExistCustID = ExceptCustID.ToString();
}
if (!string.IsNullOrEmpty(CustAddress))
{
query.Address = CustAddress;
}
//if (!string.IsNullOrEmpty(TradeMarketID))
//{
// query.TradeMarketID = TradeMarketID;
//}
if (!string.IsNullOrEmpty(CustContactName))
{
query.ContactAllName = CustContactName;
}
}
DataTable dt = BitAuto.YanFa.Crm2009.BLL.CustInfo.Instance.GetCustInfo(query, "CustName", 1, 100, out count);
repterCustInfo.DataSource = dt;
repterCustInfo.DataBind();
}
private string GetList()
{
QueryCrmCustInfo queryCustInfo = new QueryCrmCustInfo();
#region 条件
if (CustID != string.Empty)
{
queryCustInfo.CustID = CustID;
}
if (CustName != string.Empty)
{
queryCustInfo.CustName = CustName;
}
if (CustAbbr != string.Empty)
{
queryCustInfo.AbbrName = CustAbbr;
}
if (BrandIDs != string.Empty)
{
queryCustInfo.BrandID = BrandIDs;
}
if (CarType != string.Empty)
{
queryCustInfo.CarType = CarType;
}
if (ProvinceID > 0)
{
queryCustInfo.ProvinceID = ProvinceID.ToString();
}
if (CityID > 0)
{
queryCustInfo.CityID = CityID.ToString();
}
if (CountyID > 0)
{
queryCustInfo.CountyID = CountyID.ToString();
}
//if (IsHavMember)
//{
// queryCustInfo.IsHaveMember = true;
//}
//if (IsNoHavMember)
//{
// queryCustInfo.IsHaveNoMember = true;
//}
if (!string.IsNullOrEmpty(CustType))
{
queryCustInfo.TypeID = CustType;
}
if (!string.IsNullOrEmpty(Address))
{
queryCustInfo.Address = Address;
}
if (!string.IsNullOrEmpty(TradeMarketID))
{
queryCustInfo.TradeMarketID = TradeMarketID;
}
if (CustStatus != string.Empty && CustStatus != "0,1")
{
queryCustInfo.StatusIDs = CustStatus;
}
if (CooperateStatusIDs != string.Empty)
{
queryCustInfo.CooperateStatusIDs = CooperateStatusIDs;
}
if (CooperatedStatusIDs != string.Empty)
{
queryCustInfo.CooperatedStatusIDs = CooperatedStatusIDs;
}
if (CustLockStatus != string.Empty && CustLockStatus != "0,1")
{
queryCustInfo.Lock = int.Parse(CustLockStatus);
}
if (DataSource != string.Empty && DataSource != "1,0")
{
queryCustInfo.TaskType = int.Parse(DataSource);
}
if (!string.IsNullOrEmpty(RequestBeginMemberCooperatedTime))
{
queryCustInfo.BeginMemberCooperatedTime = RequestBeginMemberCooperatedTime;
}
if (!string.IsNullOrEmpty(RequestEndMemberCooperatedTime))
{
queryCustInfo.EndMemberCooperatedTime = RequestEndMemberCooperatedTime;
}
if (!string.IsNullOrEmpty(RequestBeginNoMemberCooperatedTime))
{
queryCustInfo.BeginNoMemberCooperatedTime = RequestBeginNoMemberCooperatedTime;
}
if (!string.IsNullOrEmpty(RequestEndNoMemberCooperatedTime))
{
queryCustInfo.EndNoMemberCooperatedTime = RequestEndNoMemberCooperatedTime;
}
if (!string.IsNullOrEmpty(RequestMemberCooperateStatus))
{
queryCustInfo.MemberCooperateStatus = RequestMemberCooperateStatus;
}
if (!string.IsNullOrEmpty(RequestCreateCustStartDate))
{
queryCustInfo.CreateTimeStart = RequestCreateCustStartDate;
}
if (!string.IsNullOrEmpty(RequestCreateCustEndDate))
{
queryCustInfo.CreateTimeEnd = RequestCreateCustEndDate;
}
if (!string.IsNullOrEmpty(RequestAreaTypeIDs))
{
queryCustInfo.AreaTypeIDs = RequestAreaTypeIDs;
}
if (!string.IsNullOrEmpty(RequestProjectName))
{
queryCustInfo.ProjectName = RequestProjectName.Trim();
}
if (!string.IsNullOrEmpty(RequestStartMemberCooperatedBeginTime) ||
!string.IsNullOrEmpty(RequestEndMemberCooperatedBeginTime))
{
queryCustInfo.CooperatedStatusIDs = "1";
if (!string.IsNullOrEmpty(RequestStartMemberCooperatedBeginTime))
{
queryCustInfo.StartMemberCooperatedBeginTime = RequestStartMemberCooperatedBeginTime.Trim();
}
if (!string.IsNullOrEmpty(RequestEndMemberCooperatedBeginTime))
{
queryCustInfo.EndMemberCooperatedBeginTime = RequestEndMemberCooperatedBeginTime.Trim();
}
}
#endregion
DataTable dt = BLL.CrmCustInfo.Instance.GetCC_CrmCustIDsByAlone(queryCustInfo);
List <string> colList = new List <string>();
colList.Add("CustID");
string jsonStr = Converter.DataTable2Json(dt, colList);
return(jsonStr);
}
private DataTable GetData()
{
QueryCrmCustInfo queryCustInfo = new QueryCrmCustInfo();
if (CustID != string.Empty)
{
queryCustInfo.CustID = CustID;
}
if (CustName != string.Empty)
{
queryCustInfo.CustName = CustName;
}
if (CustAbbr != string.Empty)
{
queryCustInfo.AbbrName = CustAbbr;
}
if (BrandIDs != string.Empty)
{
queryCustInfo.BrandID = BrandIDs;
}
if (CarType != string.Empty)
{
queryCustInfo.CarType = CarType;
}
if (ProvinceID > 0)
{
queryCustInfo.ProvinceID = ProvinceID.ToString();
}
if (CityID > 0)
{
queryCustInfo.CityID = CityID.ToString();
}
if (CountyID > 0)
{
queryCustInfo.CountyID = CountyID.ToString();
}
if (IsHavMember)
{
queryCustInfo.IsHaveMember = true;
}
if (IsNoHavMember)
{
queryCustInfo.IsHaveNoMember = true;
}
if (!string.IsNullOrEmpty(CustType))
{
queryCustInfo.TypeID = CustType;
}
if (!string.IsNullOrEmpty(Address))
{
queryCustInfo.Address = Address;
}
if (!string.IsNullOrEmpty(TradeMarketID))
{
queryCustInfo.TradeMarketID = TradeMarketID;
}
if (CustStatus != string.Empty && CustStatus != "0,1")
{
queryCustInfo.StatusIDs = CustStatus;
}
if (CooperateStatusIDs != string.Empty)
{
queryCustInfo.CooperateStatusIDs = CooperateStatusIDs;
}
if (CooperatedStatusIDs != string.Empty)
{
queryCustInfo.CooperatedStatusIDs = CooperatedStatusIDs;
}
if (CustLockStatus != string.Empty && CustLockStatus != "0,1")
{
queryCustInfo.Lock = int.Parse(CustLockStatus);
}
if (DataSource != string.Empty && DataSource != "1,0")
{
queryCustInfo.TaskType = int.Parse(DataSource);
}
if (!string.IsNullOrEmpty(RequestBeginMemberCooperatedTime))
{
queryCustInfo.BeginMemberCooperatedTime = RequestBeginMemberCooperatedTime;
}
if (!string.IsNullOrEmpty(RequestEndMemberCooperatedTime))
{
queryCustInfo.EndMemberCooperatedTime = RequestEndMemberCooperatedTime;
}
if (!string.IsNullOrEmpty(RequestBeginNoMemberCooperatedTime))
{
queryCustInfo.BeginNoMemberCooperatedTime = RequestBeginNoMemberCooperatedTime;
}
if (!string.IsNullOrEmpty(RequestEndNoMemberCooperatedTime))
{
queryCustInfo.EndNoMemberCooperatedTime = RequestEndNoMemberCooperatedTime;
}
if (!string.IsNullOrEmpty(RequestMemberCooperateStatus))
{
queryCustInfo.MemberCooperateStatus = RequestMemberCooperateStatus;
}
if (!string.IsNullOrEmpty(RequestCreateCustStartDate))
{
queryCustInfo.CreateTimeStart = RequestCreateCustStartDate;
}
if (!string.IsNullOrEmpty(RequestCreateCustEndDate))
{
queryCustInfo.CreateTimeEnd = RequestCreateCustEndDate;
}
if (!string.IsNullOrEmpty(RequestDistrictName))
{
queryCustInfo.DistrictName = RequestDistrictName;
}
DataTable dt = BLL.CrmCustInfo.Instance.GetCC_CrmCustInfoByAloneForExportCustID(queryCustInfo);
return(dt);
}
private void rptDataBind()
{
QueryCrmCustInfo queryCustInfo = new QueryCrmCustInfo();
if (CustID != string.Empty)
{
queryCustInfo.CustID = CustID;
}
if (CustName != string.Empty)
{
queryCustInfo.CustName = CustName;
}
if (CustAbbr != string.Empty)
{
queryCustInfo.AbbrName = CustAbbr;
}
if (BrandIDs != string.Empty)
{
queryCustInfo.BrandID = BrandIDs;
}
if (CarType != string.Empty)
{
queryCustInfo.CarType = CarType;
}
if (ProvinceID > 0)
{
queryCustInfo.ProvinceID = ProvinceID.ToString();
}
if (CityID > 0)
{
queryCustInfo.CityID = CityID.ToString();
}
if (CountyID > 0)
{
queryCustInfo.CountyID = CountyID.ToString();
}
if (IsHavMember)
{
queryCustInfo.IsHaveMember = true;
}
if (IsNoHavMember)
{
queryCustInfo.IsHaveNoMember = true;
}
if (!string.IsNullOrEmpty(CustType))
{
queryCustInfo.TypeID = CustType;
}
if (!string.IsNullOrEmpty(Address))
{
queryCustInfo.Address = Address;
}
if (!string.IsNullOrEmpty(TradeMarketID))
{
queryCustInfo.TradeMarketID = TradeMarketID;
}
if (CustStatus != string.Empty && CustStatus != "0,1")
{
queryCustInfo.StatusIDs = CustStatus;
}
if (CooperateStatusIDs != string.Empty)
{
queryCustInfo.CooperateStatusIDs = CooperateStatusIDs;
}
if (CooperatedStatusIDs != string.Empty)
{
queryCustInfo.CooperatedStatusIDs = CooperatedStatusIDs;
}
if (CustLockStatus != string.Empty && CustLockStatus != "0,1")
{
queryCustInfo.Lock = int.Parse(CustLockStatus);
}
if (DataSource != string.Empty && DataSource != "1,0")
{
queryCustInfo.TaskType = int.Parse(DataSource);
}
if (!string.IsNullOrEmpty(RequestBeginMemberCooperatedTime))
{
queryCustInfo.BeginMemberCooperatedTime = RequestBeginMemberCooperatedTime;
}
if (!string.IsNullOrEmpty(RequestEndMemberCooperatedTime))
{
queryCustInfo.EndMemberCooperatedTime = RequestEndMemberCooperatedTime;
}
if (!string.IsNullOrEmpty(RequestBeginNoMemberCooperatedTime))
{
queryCustInfo.BeginNoMemberCooperatedTime = RequestBeginNoMemberCooperatedTime;
}
if (!string.IsNullOrEmpty(RequestEndNoMemberCooperatedTime))
{
queryCustInfo.EndNoMemberCooperatedTime = RequestEndNoMemberCooperatedTime;
}
if (!string.IsNullOrEmpty(RequestMemberCooperateStatus))
{
queryCustInfo.MemberCooperateStatus = RequestMemberCooperateStatus;
}
if (!string.IsNullOrEmpty(RequestCreateCustStartDate))
{
queryCustInfo.CreateTimeStart = RequestCreateCustStartDate;
}
if (!string.IsNullOrEmpty(RequestCreateCustEndDate))
{
queryCustInfo.CreateTimeEnd = RequestCreateCustEndDate;
}
if (!string.IsNullOrEmpty(RequestDistrictName))
{
queryCustInfo.DistrictName = RequestDistrictName;
}
DataTable dt = BLL.CrmCustInfo.Instance.GetCC_CrmCustInfoByAlone(queryCustInfo, "", PageCommon.Instance.PageIndex, PageCommon.Instance.PageSize, out RecordCount);
Repeater_Custs.DataSource = dt;
Repeater_Custs.DataBind();
this.AjaxPager_Custs.InitPager(RecordCount);
}
public void ExportToXML(XmlNode node)
{
XmlDocument xmlDocument = TambonHelper.XmlDocumentFromNode(node);
var newElement = (XmlElement)xmlDocument.CreateNode("element", "entity", "");
newElement.SetAttribute("geocode", Geocode().ToString());
newElement.SetAttribute("name", AmphoeName);
node.AppendChild(newElement);
var nodeAmphoeCom = (XmlElement)xmlDocument.CreateNode("element", "amphoe.com", "");
nodeAmphoeCom.SetAttribute("amphoe", AmphoeID.ToString());
nodeAmphoeCom.SetAttribute("changwat", ProvinceID.ToString());
newElement.AppendChild(nodeAmphoeCom);
var nodeSlogan = (XmlElement)xmlDocument.CreateNode("element", "slogan", "");
nodeSlogan.InnerText = AmphoeSlogan;
newElement.AppendChild(nodeSlogan);
var nodeAddress = (XmlElement)xmlDocument.CreateNode("element", "address", "");
nodeAddress.InnerText = DistrictOffice;
newElement.AppendChild(nodeAddress);
var nodeHistory = (XmlElement)xmlDocument.CreateNode("element", "history", "");
nodeHistory.InnerText = History;
newElement.AppendChild(nodeHistory);
var nodeClimate = (XmlElement)xmlDocument.CreateNode("element", "climate", "");
nodeClimate.InnerText = Climate;
newElement.AppendChild(nodeClimate);
var nodeArea = (XmlElement)xmlDocument.CreateNode("element", "area", "");
nodeArea.InnerText = Area;
newElement.AppendChild(nodeArea);
var nodeUrl = (XmlElement)xmlDocument.CreateNode("element", "website", "");
nodeUrl.InnerText = Website;
newElement.AppendChild(nodeUrl);
var nodeTelephone = (XmlElement)xmlDocument.CreateNode("element", "telephone", "");
nodeTelephone.InnerText = Telephone;
newElement.AppendChild(nodeTelephone);
var nodeFax = (XmlElement)xmlDocument.CreateNode("element", "fax", "");
nodeFax.InnerText = Fax;
newElement.AppendChild(nodeFax);
var nodeSubEntities = (XmlElement)xmlDocument.CreateNode("element", "subdivision", "");
nodeSubEntities.SetAttribute("tambon", Tambon.ToString());
nodeSubEntities.SetAttribute("thesaban", Thesaban.ToString());
nodeSubEntities.SetAttribute("muban", Muban.ToString());
nodeSubEntities.SetAttribute("TAO", TAO.ToString());
newElement.AppendChild(nodeSubEntities);
}
