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(); }
City GetCityByID(CityID cityID) { // loop through all cites foreach (City city in transform.Find("Map/Cities").GetComponentsInChildren <City>()) { // compare city id to searchable id if (cityID == city.CityID) { return(city); } } Debug.LogError("Failed to find city by " + cityID.ToString() + " ID"); return(null); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { /* bool IsSysAdmin = true; * bool IsSceAdmin = true; * * if (null == Session["IsSYS"] || (Boolean)Session["IsSYS"] != true) * { * IsSysAdmin = false; * IsSceAdmin = false; * * AdminInfoBLL _AdminInfoBLL = new AdminInfoBLL(); * RoleBLL _RoleBLL = new RoleBLL(); * int AdminID = int.Parse(Session["AdminID"].ToString()); * int RoleID = _RoleBLL.GetRoleIDByAdminID(AdminID); * IsSceAdmin = _AdminInfoBLL.CheckFunction(RoleID, "娱乐场所管理"); * } * * if (!(IsSysAdmin || IsSceAdmin)) * Response.Redirect("../../NotAllowed.aspx"); * else * {*/ this.CityBind(); int CityID; CityID = int.Parse(this.DropDownCity.SelectedValue.ToString()); BLL.EntertainmentBLL.EntertainmentBLL _EntertainmentBLL = new BLL.EntertainmentBLL.EntertainmentBLL(); DT = _EntertainmentBLL.CityEnterTainMentSplit(CityID, this.AspNetPager4.PageSize, PageStart); if (Request.QueryString["CityID"] != null && Request.QueryString["CityID"] != "") { CityID = int.Parse(Request.QueryString["CityID"].ToString()); this.DropDownCity.SelectedValue = CityID.ToString(); } // } } }
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); }
protected void lvMDCity_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 CityID; Int64.TryParse(e.CommandArgument.ToString(), out CityID); if (CityID > 0) { if (string.Equals(e.CommandName, "EditItem")) { _CityID = CityID; PrepareEditView(); cpeEditor.Collapsed = false; cpeEditor.ClientState = "false"; } else if (string.Equals(e.CommandName, "DeleteItem")) { try { Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(MDCityEntity.FLD_NAME_CityID, CityID.ToString(), SQLMatchType.Equal); MDCityEntity mDCityEntity = new MDCityEntity(); result = FCCMDCity.GetFacadeCreate().Delete(mDCityEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { _CityID = 0; _MDCityEntity = new MDCityEntity(); PrepareInitialView(); BindMDCityList(); MiscUtil.ShowMessage(lblMessage, "City has been successfully deleted.", true); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete City.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }
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); }
private string SumbitWXT(out string errMsg) { errMsg = ""; string json = ""; json = FanXianHelper.Instance.SubmitFanxianOrder(UserID, UserName, Mobile, CarTypeID, int.Parse(MemberCode), CityID); #region 记日志 UpdateOrderData updateLogModel = new UpdateOrderData(); updateLogModel.APIType = 7; updateLogModel.CreateTime = DateTime.Now; updateLogModel.CreateUserID = BLL.Util.GetLoginUserID(); updateLogModel.IsUpdate = 1; updateLogModel.TaskID = TaskID; updateLogModel.UpdateErrorMsg = "提交网销通订单接口:汽车通UserID:" + UserID.ToString() + ",用户姓名:" + UserName + ",用户手机号:" + Mobile + ",车款ID:" + CarTypeID.ToString() + ",经销商ID:" + MemberCode + ",用户所在城市ID:" + CityID.ToString() + "。返回信息:" + json; BLL.UpdateOrderData.Instance.Insert(updateLogModel); #endregion return(json); }