public bool Add(BaseCompany model, DbOperator dbOperator)
{
model.DataStatus = DataStatus.Normal;
model.LastUpdateTime = DateTime.Now;
model.HaveUpdate = SystemDefaultConfig.DataUpdateFlag;
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BaseCompany(CPID,CPName,CityID,Address,LinkMan,Mobile,MasterID,LastUpdateTime,HaveUpdate,DataStatus)");
strSql.Append(" values(@CPID,@CPName,@CityID,@Address,@LinkMan,@Mobile,@MasterID,@LastUpdateTime,@HaveUpdate,@DataStatus)");
dbOperator.ClearParameters();
dbOperator.AddParameter("CPID", model.CPID);
dbOperator.AddParameter("CPName", model.CPName);
dbOperator.AddParameter("CityID", model.CityID);
dbOperator.AddParameter("Address", model.Address);
dbOperator.AddParameter("LinkMan", model.LinkMan);
dbOperator.AddParameter("Mobile", model.Mobile);
if (string.IsNullOrWhiteSpace(model.MasterID))
{
dbOperator.AddParameter("MasterID", DBNull.Value);
}
else
{
dbOperator.AddParameter("MasterID", model.MasterID);
}
dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime);
dbOperator.AddParameter("HaveUpdate", model.HaveUpdate);
dbOperator.AddParameter("DataStatus", (int)model.DataStatus);
return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0);
}
public string GetSellerTreeData()
{
try
{
StringBuilder strTree = new StringBuilder();
if (GetLoginUserVillages.Count == 0)
{
return(strTree.ToString());
}
List <ParkSeller> sellers = ParkSellerServices.QueryByVillageIds(GetLoginUserVillages.Select(p => p.VID).ToList());
BaseCompany currCompany = GetLoginUserRoleCompany.FirstOrDefault(p => p.CPID == GetCurrentUserCompanyId);
if (currCompany == null)
{
return(string.Empty);
}
strTree.Append("[{\"id\":\"" + currCompany.CPID + "\",");
strTree.Append("\"iconCls\":\"my-company-icon\",");
strTree.Append("\"attributes\":{\"type\":0},");
strTree.Append("\"text\":\"" + currCompany.CPName + "\"");
GetVillageTree(sellers, currCompany.CPID, strTree);
strTree.Append("}]");
return(strTree.ToString());
}
catch (Exception ex)
{
ExceptionsServices.AddExceptions(ex, "构建商家树结构失败");
return(string.Empty);
}
}
/// <summary>
/// get the keywords from the SearchKeyWord column of the company, separate them out by the commas, and get rid of duplicates
/// </summary>
/// <param name="company"></param>
/// <returns>a distrinct list of keywords to search based on the training links</returns>
public string[] getSupportKeywords(BaseCompany company)
{
string sql = "select * from SupportLinks where CompanyId = @p1";
SupportLink[] exps = mapSupportLinks(getDataSetBySql(sql, company.CompanyId));
ArrayList keywords = new ArrayList();
foreach (SupportLink es in exps)
{
string[] kws = es.SearchKeywords.Split(',');
foreach (string kw in kws)
{
if (!keywords.Contains(kw))
{
keywords.Add(kw);
}
}
}
if (keywords.Count > 0)
{
return((string[])keywords.ToArray(typeof(string)));
}
else
{
return new string[1] {
"No Keywords to search on!"
}
};
}
public ServiceOffLink[] getServiceOfferings(BaseCompany company)
{
string sql = "Select * " +
"from ServiceOfferings where companyId = @p1 order by ServiceOffName";
return(mapServiceOffLinks(getDataSetBySql(sql, company.CompanyId)));
}
/// <summary>
/// get the keywords from the SearchKeyWord column of the company, separate them out by the commas, and get rid of duplicates
/// </summary>
/// <param name="company"></param>
/// <returns>a distrinct list of keywords to search based on the training links</returns>
public string[] getTrainingKeywords(BaseCompany company)
{
string sql = "select * from TrainingLinks where CompanyId = @p1";
TrainingLink[] tls = mapTrainingLinks(getDataSetBySql(sql, company.CompanyId));
ArrayList keywords = new ArrayList();
foreach (TrainingLink tl in tls)
{
string[] kws = tl.SearchKeywords.Split(',');
foreach (string kw in kws)
{
if (!keywords.Contains(kw))
{
keywords.Add(kw);
}
}
}
if (keywords.Count > 0)
{
return((string[])keywords.ToArray(typeof(string)));
}
else
{
return new string[1] {
"No Keywords to search on!"
}
};
}
public string Search_Company()
{
String str = Request.Params["str"];
// List<BaseCompany> companys = CompanyServices.QueryCompanyAndSubordinateCompany(GetCurrentUserCompanyId);
List <BaseCompany> companys = CompanyServices.QueryAllCompanyByName(GetCurrentUserCompanyId, str);
BaseCompany currCompany = companys.FirstOrDefault(p => p.CPID == GetCurrentUserCompanyId);
if (currCompany == null)
{
return(string.Empty);
}
List <BaseCity> citys = CityServices.QueryAllCitys();
StringBuilder strTree = new StringBuilder();
strTree.Append("{\"rows\":[{");
strTree.AppendFormat("\"CPID\":\"{0}\"", currCompany.CPID);
strTree.AppendFormat(",\"CPName\":\"{0}\"", currCompany.CPName);
strTree.AppendFormat(",\"Address\":\"{0}\"", currCompany.Address);
strTree.AppendFormat(",\"LinkMan\":\"{0}\"", currCompany.LinkMan);
strTree.AppendFormat(",\"Mobile\":\"{0}\"", currCompany.Mobile);
strTree.AppendFormat(",\"MasterID\":\"{0}\"", currCompany.MasterID);
strTree.AppendFormat(",\"CityID\":\"{0}\"", currCompany.CityID);
strTree.AppendFormat(",\"ProvinceID\":\"{0}\"", "0");
strTree.Append(",\"iconCls\":\"my-company-icon\"}");
GetSubordinateCompany(companys, citys, currCompany.CPID, strTree);
strTree.Append("]}");
return(strTree.ToString());
}
public ServiceOffLink[] getUserSearchedServiceOffLink(BaseCompany company, string[] keywords)
{
StringBuilder sql =
new StringBuilder("Select ServiceOffId, ServiceOffName, ServiceOffCost, ServiceOffLink,ServiceOffImage, CompanyId,SearchKeywords from ServiceOfferings where companyId = @p1");
sql.Append(" where CompanyId = @p1 and (");
int size = keywords.Length;
int index = 0;
//build the OR clause
foreach (string s in keywords)
{
index++;
sql.Append("SearchKeywords like '%").Append(s).Append("%' ");
if (index < size)
{
sql.Append(" OR ");
}
else
{
sql.Append(" ) ");
}
}
return(mapServiceOffLinks(getDataSetBySql(sql.ToString())));
}
public bool Update(BaseCompany model)
{
using (DbOperator dbOperator = ConnectionManager.CreateConnection())
{
return(Update(model, dbOperator));
}
}
public ExpertTimeSlot[] getUserSearchedExpertSlot(BaseCompany company, string[] keywords)
{
StringBuilder sql =
new StringBuilder("Select CompanyId, ExpertTimeSlotId, ExpertTimeSlotDesc, ExpertTimeSlotName, ExpertTimeSlotDate, ExpertTimeSlotType,SearchKeywords from ExpertTimeSlots ");
sql.Append(" where CompanyId = @p1 and (");
int size = keywords.Length;
int index = 0;
//build the OR clause
foreach (string s in keywords)
{
index++;
sql.Append("SearchKeywords like '%").Append(s).Append("%' ");
if (index < size)
{
sql.Append(" OR ");
}
else
{
sql.Append(" ) ");
}
}
return(mapExpertTimeSlots(getDataSetBySql(sql.ToString())));
}
public bool Update(BaseCompany model, DbOperator dbOperator)
{
model.LastUpdateTime = DateTime.Now;
model.HaveUpdate = SystemDefaultConfig.DataUpdateFlag;
StringBuilder strSql = new StringBuilder();
strSql.Append("update BaseCompany set CPName=@CPName,CityID=@CityID,Address=@Address,LinkMan=@LinkMan,Mobile=@Mobile,MasterID=@MasterID,LastUpdateTime=@LastUpdateTime,HaveUpdate=@HaveUpdate");
strSql.Append(" where CPID=@CPID");
dbOperator.ClearParameters();
dbOperator.AddParameter("CPID", model.CPID);
dbOperator.AddParameter("CPName", model.CPName);
dbOperator.AddParameter("CityID", model.CityID);
dbOperator.AddParameter("Address", model.Address);
dbOperator.AddParameter("LinkMan", model.LinkMan);
dbOperator.AddParameter("Mobile", model.Mobile);
if (string.IsNullOrWhiteSpace(model.MasterID))
{
dbOperator.AddParameter("MasterID", DBNull.Value);
}
else
{
dbOperator.AddParameter("MasterID", model.MasterID);
}
dbOperator.AddParameter("LastUpdateTime", model.LastUpdateTime);
dbOperator.AddParameter("HaveUpdate", model.HaveUpdate);
return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0);
}
public ExpertTimeSlot[] getExpertTimeSlots(BaseCompany company)
{
string sql = "Select CompanyId, ExpertTimeSlotId, ExpertTimeSlotDesc, ExpertTimeSlotName, ExpertTimeSlotDate, ExpertTimeSlotType,SearchKeywords from ExpertTimeSlots " +
"where CompanyId = @p1";
return(mapExpertTimeSlots(getDataSetBySql(sql, company.CompanyId)));
}
public SupportLink[] getUserSearchedSupportLinks(BaseCompany company, string[] keywords)
{
StringBuilder sql =
new StringBuilder("Select SupportlinkId, SupportlinkName, Supportlink, SupportlinkImage, CompanyId, SearchKeywords from SupportLinks ");
sql.Append(" where CompanyId = @p1 and (");
int size = keywords.Length;
int index = 0;
//build the OR clause
foreach (string s in keywords)
{
index++;
sql.Append("SearchKeywords like '%").Append(s).Append("%' ");
if (index < size)
{
sql.Append(" OR ");
}
else
{
sql.Append(" ) ");
}
}
return(mapSupportLinks(getDataSetBySql(sql.ToString(), company.CompanyId)));
}
public string CreateVillageTreeOnLineStatus()
{
try
{
StringBuilder str = new StringBuilder();
if (GetLoginUserVillages.Count == 0)
{
return(str.ToString());
}
List <BaseCompany> companys = GetLoginUserRoleCompany;
BaseCompany topCompany = companys.FirstOrDefault(p => p.CPID == GetCurrentUserCompanyId);
if (topCompany == null)
{
return(str.ToString());
}
str.Append("[");
str.Append("{\"id\":\"" + topCompany.CPID + "\",");
str.Append("\"iconCls\":\"my-company-icon\",");
str.Append("\"attributes\":{\"type\":0},");
str.Append("\"text\":\"" + topCompany.CPName + "\"");
CreateSubordinateVillageTreeDataOnlineStatus(companys, topCompany.CPID, str);
str.Append("}");
str.Append("]");
return(str.ToString());
}
catch (Exception ex)
{
ExceptionsServices.AddExceptions(ex, "构建小区树结构失败");
return(string.Empty);
}
}
public JsonResult DownloadQRCode(string gateId, int size)
{
try
{
List <int> dics = new List <int>();
dics.Add(258);
dics.Add(344);
dics.Add(430);
dics.Add(860);
dics.Add(1280);
List <string> imgs = new List <string>();
ParkGate gate = ParkGateServices.QueryByRecordId(gateId);
if (gate == null)
{
throw new MyException("获取通道信息失败");
}
BaseCompany company = CompanyServices.QueryByBoxID(gate.BoxID);
if (company == null)
{
throw new MyException("获取单位信息失败");
}
ParkBox box = ParkBoxServices.QueryByRecordId(gate.BoxID);
if (box == null)
{
throw new MyException("获取岗亭信息失败");
}
ParkArea area = ParkAreaServices.QueryByRecordId(box.AreaID);
if (area == null)
{
throw new MyException("获取区域信息失败");
}
BaseParkinfo parking = ParkingServices.QueryParkingByParkingID(area.PKID);
if (parking == null)
{
throw new MyException("获取车场信息失败");
}
string content = string.Format("{0}/qrl/scio_ix_pid={1}^io={2}", SystemDefaultConfig.SystemDomain, parking.PKID, gate.GateID);
foreach (var item in dics)
{
string parkingName = string.Format("{0}_{1}_{2}_{3}_{4}", parking.PKName, area.AreaName, box.BoxName, gate.GateName, item);
string result = QRCodeServices.GenerateQRCode(company.CPID, content, item, parkingName);
imgs.Add(item.ToString() + "|" + result);
}
return(Json(MyResult.Success("", imgs)));
}
catch (MyException ex)
{
return(Json(MyResult.Error(ex.Message)));
}
catch (Exception ex)
{
ExceptionsServices.AddExceptions(ex, "下载二维码失败");
return(Json(MyResult.Error("下载二维码失败")));
}
}
//initial links ordered by the initial ordering. if it is 0 then it is not initial
public TrainingLink[] getInitialTrainingLinks(BaseCompany company)
{
string sql = "Select TrainingLinkId, TraininglinkName, Traininglink, TraininglinkImage, CompanyId, SearchKeywords, InitialOrdering from TrainingLinks " +
"where CompanyId = @p1 and InitialOrdering <> 0 order by InitialOrdering ASC";
return(mapTrainingLinks(getDataSetBySql(sql, company.CompanyId)));
}
private string GetCompanyId(string pid, string bid, string gid)
{
try
{
if (!string.IsNullOrWhiteSpace(gid))
{
ParkGate gate = ParkGateServices.QueryByRecordId(gid);
if (gate != null)
{
bid = gate.BoxID;
}
}
if (!string.IsNullOrWhiteSpace(pid))
{
BaseCompany company = CompanyServices.QueryByParkingId(pid);
if (company != null)
{
return(company.CPID);
}
}
if (!string.IsNullOrWhiteSpace(bid))
{
BaseCompany company = CompanyServices.QueryByBoxID(bid);
if (company != null)
{
return(company.CPID);
}
}
}
catch (Exception ex)
{
ExceptionsServices.AddExceptionToDbAndTxt("QRCodeParkPayment", "GetCompanyId方法处理异常", ex, LogFrom.WeiXin);
}
return(string.Empty);
}
public JsonResult EditCompany(BaseCompany model)
{
try
{
bool result = false;
if (string.IsNullOrWhiteSpace(model.CPID))
{
result = CompanyServices.Add(model);
}
else
{
BaseCompany company = CompanyServices.QueryCompanyByRecordId(model.CPID);
if (string.IsNullOrWhiteSpace(company.MasterID) && !string.IsNullOrWhiteSpace(model.MasterID))
{
throw new MyException("当前修改单位为顶级单位，不能属于任何单位");
}
result = CompanyServices.Update(model);
}
if (!result)
{
throw new MyException("保存单位信息失败");
}
UpdateCompanyCacheData(model);
return(Json(MyResult.Success()));
}
catch (MyException ex)
{
return(Json(MyResult.Error(ex.Message)));
}
catch (Exception ex)
{
ExceptionsServices.AddExceptions(ex, "单位管理保存单位信息失败");
return(Json(MyResult.Error("保存单位信息失败")));
}
}
//get info for constructor
//need an id to play
//private so that it is internal to this constructor
private BaseCompany getCompanyInfo(BaseCompany company)
{
if (String.IsNullOrEmpty(company.CompanyGUID) & company.CompanyId == 0)
{
throw new Exception("We need a GUID or a companyId to load the company info");
}
return(db.getCompanyByGUID(company));
}
/* public DatabaseUtils(System.Web.SessionState.HttpSessionState session)
* {
* Initialize();
* Session = session;
* }*/
public BaseCompany getCompanyByGUID(BaseCompany gcompany)
{
if (String.IsNullOrEmpty(gcompany.CompanyGUID) & gcompany.CompanyId == 0)
{
throw new Exception("We need a GUID or a companyId to load the company info");
}
return(getCompanyInfo(gcompany));
}
//get info for constructor
//need an id to play
//private so that it is internal to this constructor
private BaseCompany getCompanyInfo(BaseCompany company)
{
if (String.IsNullOrEmpty(company.CompanyGUID))
{
throw new Exception("Company GUID cannot be null, we need a GUID!");
}
return(db.getCompanyByGUID(company));
}
/* public DatabaseUtils(System.Web.SessionState.HttpSessionState session)
* {
* Initialize();
* Session = session;
* }*/
public BaseCompany getCompanyByGUID(BaseCompany gcompany)
{
if (String.IsNullOrEmpty(gcompany.CompanyGUID))
{
throw new Exception("we don't have a guid to look for");
}
return(getCompanyInfo(gcompany));
}
private static BaseCompany GetCompanyModel()
{
BaseCompany model = new BaseCompany();
model.CPID = GuidGenerator.GetGuidString();
model.CPName = "系统默认单位";
model.UserAccount = "admin";
model.UserPassword = "******";
return(model);
}
private WX_ApiConfig GetApiConfig(string id)
{
TxtLogServices.WriteTxtLogEx("RedirectHandle", "获取微信配置信息，id:{0}", id);
var separator = new[] { '|', '_' };
var param = new[] { '^' };//^参数分隔符
var ids = id.Split(separator, StringSplitOptions.RemoveEmptyEntries);
var parameters = ids[2].Split(param, StringSplitOptions.RemoveEmptyEntries);
if (parameters.Length == 0)
{
throw new MyException("获取单位失败");
}
foreach (var item in parameters)
{
var parame = item.Split(new[] { '=' });
if (parame.Length == 2)
{
if (parame[0].ToUpper() == "CID")
{
WX_ApiConfig config = WXApiConfigServices.QueryWXApiConfig(parame[1]);
if (config == null)
{
throw new MyException("获取微信配置失败");
}
if (config.CompanyID != parame[1])
{
throw new MyException("该公众号暂停使用");
}
return(config);
}
if (parame[0] == "PARKINGID" || parame[0] == "PID")
{
BaseCompany company = CompanyServices.QueryByParkingId(parame[1]);
if (company == null)
{
throw new MyException("获取单位信息失败");
}
WX_ApiConfig config = WXApiConfigServices.QueryWXApiConfig(company.CPID);
if (config == null)
{
throw new MyException("获取微信配置失败");
}
if (config.CompanyID != parame[1])
{
throw new MyException("该公众号暂停使用");
}
return(config);
}
}
}
throw new MyException("获取微信配置失败，id:" + id);
}
public List <BaseCompany> QueryCompanyAndSubordinateCompany(string recordId)
{
List <BaseCompany> models = new List <BaseCompany>();
BaseCompany model = QueryCompanyByRecordId(recordId);
if (model != null)
{
models.Add(model);
QueryAllSubordinateCompany(model.CPID, models);
}
return(models);
}
public Integrations getIntegrations(BaseCompany company)
{
if (company.CompanyId == 0)
{
throw new Exception("we need a company with an ID");
}
string sqlWemail = "select * from Integrations where CompanyId = @p1";
DataRow dr = getFirstRow(getDataSetBySqlOneP(sqlWemail, company.CompanyId));
return(mapIntegration(dr, new Integrations()));
}
private static void GetCurrLoginUserRoleCompany(List <BaseCompany> companys, List <BaseCompany> allComapnys, string companyId)
{
BaseCompany company = allComapnys.FirstOrDefault(p => p.CPID == companyId);
if (company != null)
{
if (companys.Count(p => p.CPID == company.CPID) == 0)
{
companys.Add(company);
}
GetCurrLoginUserRoleCompany(companys, allComapnys, company.MasterID);
}
}
private void UpdateCompanyCacheData(BaseCompany model)
{
if (model.CPID == GetCurrentUserCompanyId)
{
Session["SmartCity_CurrLoginUser_Role_Company"] = model;
}
if (GetLoginUserRoleCompany.FirstOrDefault(p => p.CPID == model.CPID) != null)
{
GetLoginUserRoleCompany.Remove(GetLoginUserRoleCompany.FirstOrDefault(p => p.CPID == model.CPID));
GetLoginUserRoleCompany.Add(model);
}
}
/// <summary>
/// 查询父节点递归调用
/// </summary>
/// <param name="model"></param>
/// <param name="models"></param>
private void QueryAllmasterCompany(BaseCompany model, List <BaseCompany> result)
{
BaseCompany mastermodel = QueryCompanyByRecordId(model.MasterID);
if (mastermodel != null)
{
if (!result.Contains(mastermodel))
{
result.Add(mastermodel);
}
QueryAllmasterCompany(mastermodel, result);
}
}
public SalesforceUtils(BaseCompany company)
{
this.company = company;
this.intgr = company.Intgr;
//if the company doesn't have basic SF access info
if (intgr == null || String.IsNullOrEmpty(intgr.SFuser))
{
throw new Exception("You need to Setup SF access!");
}
username = intgr.SFuser;
password = intgr.SFpwd + intgr.SFToken;
}
//initial links ordered by the initial ordering. if it is 0 then it is not initial
public TrainingLink getFirstTrainingLink(BaseCompany company)
{
string sql = "Select TrainingLinkId, TraininglinkName, Traininglink, TraininglinkImage, CompanyId, SearchKeywords, InitialOrdering from TrainingLinks " +
"where CompanyId = @p1 and InitialOrdering = 1 order by InitialOrdering ASC";
TrainingLink[] tl = mapTrainingLinks(getDataSetBySql(sql, company.CompanyId));
//if no first one set, return null
if (tl != null && tl.Length > 0)
{
return(tl[0]);
}
return(null);
}
