public override void Operate(ref Common.Transfer Trans)
{
Trans.Result = JSONHelper.FromString(false, "未知错误");
DataTable dAttributeTable = base.XmlToDatatTable(Trans.Attribute);
DataRow Row = dAttributeTable.Rows[0];
switch (Trans.Command)
{
case "Add":
Trans.Result = Add(Row);
break;
case "Delete":
Trans.Result = Delete(Row);
break;
case "Audit":
Trans.Result = Audit(Row);
break;
case "WaitingAuditList":
Trans.Result = WaitingAuditList(Row);
break;
case "AuditList":
Trans.Result = AuditList(Row);
break;
}
}
private string GetCommunityServiceTel_ZhongJi(DataRow row)
{
if (!row.Table.Columns.Contains("CommunityId") || string.IsNullOrEmpty(row["CommunityId"].ToString()))
{
return(JSONHelper.FromString(false, "小区编号不能为空"));
}
if (!row.Table.Columns.Contains("RoomID") || string.IsNullOrEmpty(row["RoomID"].ToString()))
{
return(JSONHelper.FromString(false, "房屋编号不能为空"));
}
string roomId = row["RoomID"].ToString();
string communityId = row["CommunityId"].ToString();
//查询小区
Tb_Community Community = new MobileSoft.BLL.Unified.Bll_Tb_Community().GetModel(communityId);
//构造链接字符串
if (Community == null)
{
return(JSONHelper.FromString(false, "该小区不存在"));
}
string strcon = new Business.CostInfo().GetConnectionStringStr(Community);
using (IDbConnection conn = new SqlConnection(strcon))
{
string sql = @"SELECT Heading AS UserName,InfoContent AS MobileTel FROM view_Tb_HSPR_CommunityInfo_filter_CommServiceTel WHERE CommID = @CommID";
DataTable dt = conn.ExecuteReader(sql, new { CommID = Community.CommID }).ToDataSet().Tables[0];
return(JSONHelper.FromString(dt));
}
}
private string SetVisitorConfirm(DataRow Row)
{
if (!Row.Table.Columns.Contains("VisitorId") || string.IsNullOrEmpty(Row["VisitorId"].ToString()))
{
return(JSONHelper.FromString(false, "缺少VisitorId参数"));
}
if (!Row.Table.Columns.Contains("CommID") || string.IsNullOrEmpty(Row["CommID"].AsString()))
{
return(new ApiResult(false, "缺少参数CommID").toJson());
}
string commID = Row["CommID"].AsString();
string VisitorId = Row["VisitorId"].ToString();
string connStr;
if (!GetDBServerPath(commID, out connStr))
{
return(new ApiResult(false, "获取数据库信息失败").toJson());
}
int result = 0;
DateTime ScanDate = DateTime.Now;
using (IDbConnection conn = new SqlConnection(connStr))
{
result = conn.Execute("UPDATE Tb_HSPR_APP_Visitor SET ScanDate = @ScanDate WHERE Id = @Id", new { ScanDate = ScanDate, Id = VisitorId }, null, null, CommandType.Text);
}
if (result > 0)
{
return(new ApiResult(true, ScanDate.ToString()).toJson());
}
return(new ApiResult(false, "确认失败,请重试").toJson());
}
/// <summary>
/// 获取部门下用户列表
/// </summary>
private string GetUserListWithDep(DataRow row)
{
if (!row.Table.Columns.Contains("CorpID") || string.IsNullOrEmpty(row["CorpID"].ToString()))
{
return(JSONHelper.FromString(false, "公司ID不能为空"));
}
if (!row.Table.Columns.Contains("DepCode") || string.IsNullOrEmpty(row["DepCode"].ToString()))
{
return(JSONHelper.FromString(false, "部门不能为空"));
}
string corpId = row["CorpID"].ToString();
//构建链接字符串
string strcon = "";
bool bl = GetDBServerPathWithCorpID(corpId, out strcon);
if (bl == false)
{
return(JSONHelper.FromString(false, strcon));
}
string sql = "SELECT DepCode,UserCode,UserName FROM Tb_Sys_User WHERE DepCode='" + row["DepCode"] + "' AND isnull(IsDelete,0)=0 ORDER BY UserCode";
using (IDbConnection con = new SqlConnection(strcon))
{
return(JSONHelper.FromString(con.ExecuteReader(sql).ToDataSet().Tables[0]));
}
}
/// <summary>
/// 获取汇报对象
/// </summary>
private string GetReportUserList(DataRow row)
{
if (!row.Table.Columns.Contains("UserCode") || string.IsNullOrEmpty(row["UserCode"].ToString()))
{
return(JSONHelper.FromString(false, "用户编号不能为空"));
}
if (!row.Table.Columns.Contains("CorpID") || string.IsNullOrEmpty(row["CorpID"].ToString()))
{
return(JSONHelper.FromString(false, "公司ID不能为空"));
}
string corpId = row["CorpID"].ToString();
//构建链接字符串
string strcon = "";
bool bl = GetDBServerPathWithCorpID(corpId, out strcon);
if (bl == false)
{
return(JSONHelper.FromString(false, strcon));
}
using (IDbConnection con = new SqlConnection(strcon))
{
DataTable dt = con.ExecuteReader(@"SELECT UserCode,UserName FROM Tb_Sys_User WHERE UserCode IN (SELECT DISTINCT ToUserCode FROM Tb_OAPublicWork_WorkRecordNoticeUser WHERE MyUserCode=@UserCode)", new { UserCode = row["UserCode"].ToString() }).ToDataSet().Tables[0];
return(JSONHelper.FromString(dt));
}
}
/// <summary>
/// 修改密码
/// </summary>
/// <param name="row"></param>
/// Mobile 手机号【必填】
/// Pwd 密码【必填】
/// 返回：
/// true:密码修改成功
/// false:错误信息
/// <returns></returns>
private string UpdateUserPwd(DataRow row)
{
if (!row.Table.Columns.Contains("Mobile") || string.IsNullOrEmpty(row["Mobile"].ToString()))
{
return(JSONHelper.FromString(false, "手机号不能为空"));
}
if (!row.Table.Columns.Contains("Pwd") || string.IsNullOrEmpty(row["Pwd"].ToString()))
{
return(JSONHelper.FromString(false, "密码不能为空"));
}
IDbConnection Connectionstr = new SqlConnection(Connection.GetConnection("4"));
string Sql = "SELECT * FROM Tb_User where Mobile=@Mobile";
Tb_User user = Connectionstr.Query <Tb_User>(Sql, new { Mobile = row["Mobile"].ToString() }).SingleOrDefault();
if (user == null)
{
return(JSONHelper.FromString(false, "该用户不存在"));
}
else
{
user.Pwd = row["Pwd"].ToString();
Connectionstr.Update(user);
return(JSONHelper.FromString(true, "密码修改成功"));
}
}
/// <summary>
/// 标记短信为已读
/// </summary>
private string MarkMessageRead(DataRow row)
{
if (!row.Table.Columns.Contains("MessageCode") || string.IsNullOrEmpty(row["MessageCode"].ToString()))
{
return(JSONHelper.FromString(false, "短信ID不能为空"));
}
if (!row.Table.Columns.Contains("CorpID") || string.IsNullOrEmpty(row["CorpID"].ToString()))
{
return(JSONHelper.FromString(false, "公司ID不能为空"));
}
string corpId = row["CorpID"].ToString();
//构建链接字符串
string strcon = "";
bool bl = GetDBServerPathWithCorpID(corpId, out strcon);
if (bl == false)
{
return(JSONHelper.FromString(false, strcon));
}
string sql = "UPDATE Tb_Sys_Message SET MsgState=2 WHERE MessageCode='" + row["MessageCode"].ToString() + "'";
using (IDbConnection con = new SqlConnection(strcon))
{
return(JSONHelper.FromString(true, con.Execute(sql).ToString()));
}
}
public override void Operate(ref Common.Transfer Trans)
{
Trans.Result = JSONHelper.FromString(false, "未知错误");
DataTable dAttributeTable = base.XmlToDatatTable(Trans.Attribute);
DataRow Row = dAttributeTable.Rows[0];
switch (Trans.Command)
{
case "IncidentAccept": // 报事提交
Trans.Result = IncidentAccept(Row);
break;
case "IncidentCancel": // 报事提交
Trans.Result = IncidentCancel(Row);
break;
case "GetIncidentHistory": // 获取报事历史
Trans.Result = GetIncidentHistory(Row);
break;
case "GetIncidentDetail": // 获取报事详情
Trans.Result = GetIncidentDetail(Row);
break;
case "IncidentEvaluate": // 获取报事详情
Trans.Result = IncidentEvaluate(Row);
break;
default:
break;
}
}
/// <summary>
/// 业主取消报事
/// </summary>
private string IncidentCancel(DataRow row)
{
if (!row.Table.Columns.Contains("CommunityId") || string.IsNullOrEmpty(row["CommunityId"].ToString()))
{
return(JSONHelper.FromString(false, "小区编号不能为空"));
}
if (!row.Table.Columns.Contains("IncidentID") || string.IsNullOrEmpty(row["IncidentID"].ToString()))
{
return(JSONHelper.FromString(false, "报事编号不能为空"));
}
string communityId = row["CommunityId"].ToString();
Tb_Community Community = new MobileSoft.BLL.Unified.Bll_Tb_Community().GetModel(communityId);
//构造链接字符串
if (Community == null)
{
return(JSONHelper.FromString(false, "该小区不存在"));
}
string strcon = GetConnectionStringStr(Community);
using (IDbConnection conn = new SqlConnection(strcon))
{
conn.Execute(@"UPDATE Tb_HSPR_IncidentAccept SET IsDelete=1 WHERE IncidentID=@IncidentID", new { IncidentID = row["IncidentID"].ToString() });
return(JSONHelper.FromString(true, "操作成功"));
}
}
/// <summary>
/// 查询用户租赁信息
/// </summary>
/// <param name="Row"></param>
/// <returns></returns>
public string RentalHistoryList(DataRow Row)
{
string backstr = "";
DataTable dt = null;
try
{
string ConnStr = ConnectionDb.GetUnifiedConnectionString();
string UserId = Row["UserId"].ToString();
IDbConnection com = new SqlConnection(ConnStr);
//Tb_User User = com.Query<Tb_User>("select * from Tb_User where Id=@Id", new { Id = UserId }).ToList<Tb_User>().SingleOrDefault();
//if (User==null)
//{
// return JSONHelper.FromString(false, "该用户不存在");
//}
int page = AppGlobal.StrToInt(Row["Page"].ToString());
int row = AppGlobal.StrToInt(Row["PageSize"].ToString());
dt = BaseGetData.GetList(ConnStr, " and UserId='" + UserId + "'", page, row, "RegisterDate", 0, "View_Tb_Rental", "Id").Tables[0];
}
catch (Exception ex)
{
backstr = ex.Message;
}
if (backstr == "")
{
return(JSONHelper.FromString(dt));
}
else
{
return(JSONHelper.FromString(false, backstr));
}
}
/// <summary>
/// 清空购物车 DelShoppingCarAll
/// </summary>
/// <param name="row"></param>
/// UserId 用户编码【必填】
/// 返回：
/// true:
/// false:删除失败
/// <returns></returns>
private string DelShoppingCarAll(DataRow row)
{
if (!row.Table.Columns.Contains("UserId") || string.IsNullOrEmpty(row["UserId"].ToString()))
{
return(JSONHelper.FromString(false, "用户编码不能为空"));
}
string str = "";
try
{
IDbConnection con = new SqlConnection(PubConstant.GetConnectionString("BusinessContionString"));
//批量删除购物车明细
con.ExecuteScalar(" update Tb_ShoppingCar set IsDelete=1 where UserId=@ShoppingId", new { ShoppingId = row["UserId"].ToString() }, null, null, CommandType.Text);
}
catch (Exception ex)
{
str = ex.Message;
}
if (str != "")
{
return(JSONHelper.FromString(false, str));
}
else
{
return(JSONHelper.FromString(true, ""));
}
}
// 房屋租赁详情
public string RentalDetail_v2(DataRow row)
{
// 筛选地区
if (!row.Table.Columns.Contains("Id") || row["Id"].ToString() == "")
{
return(JSONHelper.FromString(false, "租售记录id不能为空"));
}
var id = row["Id"].ToString();
var sql = @"SELECT a.Id,replace(isnull(a.Province,''),'省','') AS Province, replace(isnull(a.City,''),'市','') AS City,
CASE WHEN a.Rent IS NULL THEN '面议'
WHEN convert(nvarchar(20),a.Rent)='面议' THEN '面议'
WHEN convert(decimal(12,2),a.Rent)=0 THEN '面议'
ELSE convert(nvarchar(20),convert(decimal(12,0),isnull(Rent,0))) END AS Rent,
CASE WHEN a.Amount IS NULL THEN '面议'
WHEN convert(nvarchar(20),a.Amount)='面议' THEN '面议'
WHEN convert(decimal(12,2),a.Amount)=0 THEN '面议'
ELSE convert(nvarchar(20),CONVERT(decimal(12,1),isnull(Amount,0.0)/10000.0))+'万' END AS Amount,
isnull(a.Img,'') AS Img,isnull(a.Title,b.CommName) AS Title,isnull(a.HouseType,'住宅') AS HouseType,
isnull(a.Orientation,'无') AS Orientation,isnull(a.Renovation,'无') AS Renovation,
isnull(a.BuildingType,'住宅') AS BuildingType,a.BuildingAge,isnull(a.ProcessDate,a.RegisterDate) PubDate,
isnull(a.SalesMobile,a.Mobile) AS Mobile,isnull(a.Address,b.CommName) AS Address,
isnull(BussType,'租售') AS BussType,a.Description,b.CommName,a.BuildArea,a.Floor
FROM Tb_Rental a
LEFT JOIN Tb_Community b ON a.CommunityId=b.Id
WHERE a.Id=@Id;";
using (var conn = new SqlConnection(PubConstant.UnifiedContionString))
{
var result = conn.Query(sql, new { Id = id }).FirstOrDefault();
return(new ApiResult(true, result).toJson());
}
}
/// <summary>
/// 设置我的汇报对象
/// </summary>
private string AddReportObjects(DataRow row)
{
if (!row.Table.Columns.Contains("ReportUsers") || string.IsNullOrEmpty(row["ReportUsers"].AsString()))
{
return(new ApiResult(false, "缺少参数ReportUsers").toJson());
}
var reportUsers = row["ReportUsers"].AsString();
using (var conn = new SqlConnection(PubConstant.hmWyglConnectionString))
{
var sql = @"INSERT INTO Tb_OAPublicWork_WorkRecordNoticeUser(MyUserCode,ToUserCode)
SELECT @UserCode,UserCode
FROM Tb_Sys_User
WHERE UserCode IN(SELECT Value FROM SplitString(@ToUserCode,',',1))
AND UserCode NOT IN(SELECT ToUserCode FROM Tb_OAPublicWork_WorkRecordNoticeUser
WHERE MyUserCode=@UserCode AND ToUserCode IN(SELECT Value FROM SplitString(@ToUserCode,',',1)))";
var i = conn.Execute(sql, new { ToUserCode = reportUsers.Trim(','), UserCode = Global_Var.LoginUserCode });
if (i > 0)
{
return(JSONHelper.FromString(true, "添加成功"));
}
return(JSONHelper.FromString(true, "添加失败"));
}
}
/// <summary>
/// 获取某单元下楼层信息
/// </summary>
private string GetFloorsWithBuildSNumAndUnitNum(DataRow row)
{
if (!row.Table.Columns.Contains("CommID") || string.IsNullOrEmpty(row["CommID"].ToString()))
{
return(JSONHelper.FromString(false, "小区ID不能为空"));
}
if (!row.Table.Columns.Contains("BuildSNum") || string.IsNullOrEmpty(row["BuildSNum"].ToString()))
{
return(JSONHelper.FromString(false, "楼宇编号不能为空"));
}
if (!row.Table.Columns.Contains("UnitSNum") || string.IsNullOrEmpty(row["UnitSNum"].ToString()))
{
return(JSONHelper.FromString(false, "单元编号不能为空"));
}
string commId = row["CommID"].ToString();
string BuildSNum = row["BuildSNum"].ToString();
string UnitSNum = row["UnitSNum"].ToString();
string sql = $@"SELECT DISTINCT FloorSNum FROM Tb_HSPR_Room
WHERE isnull(IsDelete, 0)=0 AND UnitSNum IS NOT NULL AND FloorSNum IS NOT NULL AND
CommID={commId} AND BuildSNum='{BuildSNum}' AND UnitSNum='{UnitSNum}' ORDER BY FloorSNum;";
using (IDbConnection con = new SqlConnection(PubConstant.hmWyglConnectionString))
{
return(new ApiResult(true, con.Query <string>(sql)).toJson());
}
}
public string RefreshOrder(string CommunityId, string out_trade_no)
{
string ConnStr = GetConnection(CommunityId);
string BankResult = SearchBankOrder(CommunityId, out_trade_no);
IDbConnection conn = new SqlConnection(GetConnection(CommunityId));
string query = "SELECT * FROM Tb_OL_AlipayOrder WHERE out_trade_no=@out_trade_no";
Tb_OL_AlipayOrder T_Order = conn.Query <Tb_OL_AlipayOrder>(query, new { out_trade_no = out_trade_no }).SingleOrDefault();
if (BankResult == "TRADE_SUCCESS")
{
//更新订单状态
UpdateProperyOrder(T_Order.CommunityId.ToString(), T_Order.out_trade_no.ToString(), BankResult, "TRADE_SUCCESS");
if (T_Order.IsSucc.ToString() != "1")
{
//下账
ReceProperyOrder(0, T_Order.CommunityId.ToString(), T_Order.out_trade_no.ToString(), null);
return(JSONHelper.FromString(true, "订单状态已更新并下账成功，请刷新订单"));
}
else
{
return(JSONHelper.FromString(true, "订单状态已更新,请刷新订单"));
}
}
else
{
//更新订单状态
UpdateProperyOrder(T_Order.CommunityId.ToString(), T_Order.out_trade_no.ToString(), BankResult, "");
}
return("");
}
/// <summary>
/// 复验确认
/// </summary>
private string SaveHouseInspectionReview(DataRow row)
{
if (!row.Table.Columns.Contains("CommID") || string.IsNullOrEmpty(row["CommID"].ToString()))
{
return(JSONHelper.FromString(false, "小区编号不能为空"));
}
if (!row.Table.Columns.Contains("IID") || string.IsNullOrEmpty(row["IID"].ToString()))
{
return(JSONHelper.FromString(false, "验房项目不能为空"));
}
if (!row.Table.Columns.Contains("Review") || string.IsNullOrEmpty(row["Review"].ToString()))
{
return(JSONHelper.FromString(false, "验房项目不能为空"));
}
string commID = row["CommID"].ToString();
string iid = row["IID"].ToString();
string result = row["Review"].ToString();
using (IDbConnection con = new SqlConnection(PubConstant.hmWyglConnectionString))
{
string sql = @"UPDATE Tb_HSPR_HousingInspDetail SET Review=@Result WHERE IID=@IID";
con.Execute(sql, new { Result = result, IID = iid });
return(JSONHelper.FromString(true, "保存成功"));
}
}
/// <summary>
/// 验证验证码 10分钟有效
/// </summary>
/// <param name="Row"></param>
/// Mobile 手机号【必填】
/// VerifyCode 验证码【必填】
/// 返回：
/// true:验证成功
/// false:错误信息
/// <returns></returns>
private string CheckVerifyCode(DataRow Row)
{
if (Row["Mobile"] == null || Row["Mobile"].ToString() == "")
{
return(JSONHelper.FromString(false, "缺少参数Mobile"));
}
if (Row["VerifyCode"] == null || Row["VerifyCode"].ToString() == "")
{
return(JSONHelper.FromString(false, "缺少参数VerifyCode"));
}
string conStr = PubConstant.UnifiedContionString.ToString();
IDbConnection con = new SqlConnection(conStr);
string sql = "select * from Tb_SendMessageRecord where Mobile=@Mobile and SendContent='您的验证码为：'+@SendContent+'【天问互联】' and SendType='忘记密码' and SendState=0 and DATEDIFF(mi,SendTime,GETDATE())<10";
Tb_SendMessageRecord model = con.Query <Tb_SendMessageRecord>(sql, new { Mobile = Row["Mobile"].ToString(), SendContent = Row["VerifyCode"] }).ToList <Tb_SendMessageRecord>().SingleOrDefault();
if (model == null)
{
return(JSONHelper.FromString(false, "验证失败"));
}
else
{
return(JSONHelper.FromString(true, "验证成功"));
}
}
/// <summary>
/// 获取建议
/// </summary>
/// <param name="row">评价ID</param>
/// 返回：
/// SuggestionsID 建议ID
/// CommID 小区ID
/// CustID 客户ID
/// RoomID 房间ID
/// RoomSign 房间编号
/// CustName 客户名称
/// LinkPhone 联系方式
/// SuggestionsType 建议类型
/// SuggestionsTitle 建议标题
/// SuggestionsImages 建议图片
/// IsDelete 是否删除
/// SuggestionsContent 建议内容
/// CustEvaluation 评价内容
/// ReplyStats 回复状态
/// ReplyContent 回复内容
/// ReplyDate 回复日期
/// EvaluationDate 评价日期
/// EvaluationLevel 评价级别
/// <returns></returns>
private string GetProposalInfo(DataRow row)
{
if (!row.Table.Columns.Contains("CommunityId") || string.IsNullOrEmpty(row["CommunityId"].ToString()))
{
return(JSONHelper.FromString(false, "小区编码不能为空"));
}
if (!row.Table.Columns.Contains("Id") || string.IsNullOrEmpty(row["Id"].ToString()))
{
return(JSONHelper.FromString(false, "建议ID不能为空"));
}
string Id = row["Id"].ToString();
string CommunityId = row["CommunityId"].ToString();
//运营连接字符串
IDbConnection Conn = new SqlConnection(Connection.GetConnection("4"));
//获取小区信息
string sql_com = "select * from dbo.Tb_Community where Id=@Id";
Tb_Community Community = Conn.Query <Tb_Community>(sql_com, new { Id = CommunityId }).SingleOrDefault();
if (Community == null)
{
return(JSONHelper.FromString(false, "该小区不存在"));
}
Conn = new SqlConnection(new CostInfo().GetConnectionStringStr(Community));
string query = "SELECT * FROM Tb_HSPR_CommunitySuggestions WHERE SuggestionsID='" + Id + "'";
DataTable dt = Conn.ExecuteReader(query, null, null, null, CommandType.Text).ToDataSet().Tables[0];
return(JSONHelper.FromString(dt));
}
/// <summary>
/// //微信公共号登录 UserLogin_WeiXin
/// </summary>
/// <param name="row"></param>
/// OpenId 必填
/// <returns></returns>
private string UserLogin_WeiXin(DataRow row)
{
if (!row.Table.Columns.Contains("OpenId"))
{
return(JSONHelper.FromString(false, "OpenId不能为空"));
}
string openId = row["OpenId"].ToString();
string headImgUrl = "";
if (row.Table.Columns.Contains("HeadImgUrl"))
{
headImgUrl = row["HeadImgUrl"].ToString();
}
//如果存在该用户.并且头像不为空,就修改用户头像
if (!string.IsNullOrEmpty(headImgUrl))
{
using (IDbConnection conn = new SqlConnection(PubConstant.UnifiedContionString)) {
conn.Execute("UPDATE Tb_User SET UserPic = @UserPic FROM Tb_User AS u INNER JOIN Tb_User_WeiXin wx ON u.Id = wx.UserId WHERE wx.WeChatToken = @openId", new { UserPic = headImgUrl, openId = openId }, null, null, CommandType.Text);
}
}
DataTable dt = null;
using (IDbConnection conn = new SqlConnection(PubConstant.UnifiedContionString))
{
dt = conn.ExecuteReader("SELECT u.Id,u.Name,u.Mobile,u.Email,u.QQ,u.QQToken,w.WeChatToken,u.WeChatNum,u.NickName,u.UserPic,u.Sex FROM Tb_User as u left join Tb_User_WeiXin as w on u.id = w.UserId where w.WeChatToken = @WeChatToken", new { WeChatToken = openId }, null, null, CommandType.Text).ToDataSet().Tables[0];
}
if (null == dt || dt.Rows.Count == 0)
{
return(JSONHelper.FromString(false, "账号名或者密码错误"));
}
return(JSONHelper.FromString(dt));
}
public override void Operate(ref Common.Transfer Trans)
{
Trans.Result = JSONHelper.FromString(false, "未知错误");
DataTable dAttributeTable = base.XmlToDatatTable(Trans.Attribute);
DataRow Row = dAttributeTable.Rows[0];
switch (Trans.Command)
{
case "SubmitProposal":
Trans.Result = SubmitProposal(Row); //提交建议
break;
case "SetEvaluation":
Trans.Result = SetEvaluation(Row); //评价
break;
case "GetProposalInfo":
Trans.Result = GetProposalInfo(Row); //获取建议
break;
case "GetProposalInfoList": //所有建议
Trans.Result = GetProposalInfoList(Row);
break;
default:
break;
}
}
/// <summary>
/// 读取短信详情
/// </summary>
private string GetMessageDetail(DataRow row)
{
if (!row.Table.Columns.Contains("MessageCode") || string.IsNullOrEmpty(row["MessageCode"].ToString()))
{
return(JSONHelper.FromString(false, "短信ID不能为空"));
}
if (!row.Table.Columns.Contains("CorpID") || string.IsNullOrEmpty(row["CorpID"].ToString()))
{
return(JSONHelper.FromString(false, "公司ID不能为空"));
}
string corpId = row["CorpID"].ToString();
//构建链接字符串
string strcon = "";
bool bl = GetDBServerPathWithCorpID(corpId, out strcon);
if (bl == false)
{
return(JSONHelper.FromString(false, strcon));
}
string sql = "SELECT Content FROM Tb_Sys_Message WHERE MessageCode='" + row["MessageCode"].ToString() + "'";
string contentHtml = "";
using (IDbConnection con = new SqlConnection(strcon))
{
dynamic messageContent = con.Query(sql).ToList().FirstOrDefault();
if (messageContent != null && !string.IsNullOrEmpty(messageContent.Content.ToString()))
{
contentHtml = messageContent.Content.ToString();
contentHtml = contentHtml.ToLower();
if (contentHtml.Contains(hrefString1))
{
contentHtml = contentHtml.Replace(hrefString1, " href=\"#\" onclick=\"openFile(this);return false;\" x=\"/HM/M_Main/Jscript-Ui/UEditor/net/upload/");
}
if (contentHtml.Contains(hrefString2))
{
contentHtml = contentHtml.Replace(hrefString2, " href=\"#\" onclick=\"openFile(this);return false;\" x=\"/HM/M_Main/oauploadfile/");
}
if (contentHtml.Contains(hrefString3))
{
contentHtml = contentHtml.Replace(hrefString3, "src=\"/HM/M_Main/Jscript-Ui/UEditor/net/upload/");
}
if (contentHtml.Contains(hrefString4))
{
contentHtml = contentHtml.Replace(hrefString4, " href=\"#\" onclick=\"openFile(this);return false;\" x=\"/hm/m_main/jscript-ui/ueditor/net/upload/");
}
}
contentHtml = contentHtml.Replace("\"", "\\\"");
return(JSONHelper.FromString(true, contentHtml));
}
}
public string RefreshOrder(string CommunityId, string out_trade_no)
{
string strcon = PubConstant.GetConnectionString("APPConnection");
string BankResult = SearchBankOrder(CommunityId, out_trade_no);
IDbConnection conn = new SqlConnection(strcon);
string query = "SELECT * FROM Tb_OL_WeiXinOrder WHERE out_trade_no=@out_trade_no";
Tb_OL_WeiXinPayOrder T_Order = conn.Query <Tb_OL_WeiXinPayOrder>(query, new { out_trade_no = out_trade_no }).SingleOrDefault();
if (BankResult == "00")
{
//更新订单状态
UpdateProperyOrder(T_Order.CommunityId.ToString(), T_Order.out_trade_no.ToString(), BankResult, "成功");
if (T_Order.IsSucc.ToString() != "1")
{
//下账
ReceProperyOrder(T_Order.CommunityId.ToString(), T_Order.out_trade_no.ToString());
return(JSONHelper.FromString(true, "订单状态已更新并下账成功，请刷新订单"));
}
else
{
return(JSONHelper.FromString(true, "订单状态已更新,请刷新订单"));
}
}
else
{
//更新订单状态
UpdateProperyOrder(T_Order.CommunityId.ToString(), T_Order.out_trade_no.ToString(), BankResult, "失败");
}
return("");
}
/// <summary>
/// 获取下属列表
/// </summary>
private string GetSubordinateList(DataRow row)
{
if (!row.Table.Columns.Contains("UserCode") || string.IsNullOrEmpty(row["UserCode"].ToString()))
{
return(JSONHelper.FromString(false, "用户编号不能为空"));
}
if (!row.Table.Columns.Contains("CorpID") || string.IsNullOrEmpty(row["CorpID"].ToString()))
{
return(JSONHelper.FromString(false, "公司ID不能为空"));
}
string corpId = row["CorpID"].ToString();
//构建链接字符串
string strcon = "";
bool bl = GetDBServerPathWithCorpID(corpId, out strcon);
if (bl == false)
{
return(JSONHelper.FromString(false, strcon));
}
using (IDbConnection con = new SqlConnection(strcon))
{
DataTable dt = con.ExecuteReader(@"SELECT b.UserCode,b.UserName,b.DepCode,
DepName=(SELECT top 1 DepName FROM Tb_Sys_Department WHERE DepCode=b.DepCode)
FROM Tb_OAPublicWork_WorkRecordNoticeUser a LEFT JOIN Tb_Sys_User b ON a.MyUserCode=b.UserCode
WHERE ToUserCode=@ToUserCode", new { ToUserCode = row["UserCode"].ToString() }).ToDataSet().Tables[0];
return(JSONHelper.FromString(dt));
}
}
/// <summary>
/// 获取当前可用的优惠券余额
/// </summary>
public string GetCanUseCouponBalanceInBuss(DataRow row)
{
if (!row.Table.Columns.Contains("UserId") || string.IsNullOrEmpty(row["UserId"].ToString()))
{
return(JSONHelper.FromString(false, "用户id不能为空"));
}
if (!row.Table.Columns.Contains("CorpId") || string.IsNullOrEmpty(row["CorpId"].ToString()))
{
return(JSONHelper.FromString(false, "物业公司id不能为空"));
}
if (!row.Table.Columns.Contains("BussId") || string.IsNullOrEmpty(row["BussId"].ToString()))
{
return(JSONHelper.FromString(false, "商家id不能为空"));
}
using (IDbConnection conn = new SqlConnection(ConnectionDb.GetBusinessConnection()))
{
DataTable dt = conn.ExecuteReader(@"SELECT CorpId,BussId,isnull(Balance,0) as Balance FROM Tb_Resources_CouponBalance WHERE UserId=@UserId
AND CorpId=@CorpId AND (BussId=@BussId OR BussId IS NULL)",
new { UserId = row["UserId"], CorpId = row["CorpId"], BussId = row["BussId"] }).ToDataSet().Tables[0];
return(JSONHelper.FromString(dt));
}
}
/// <summary>
/// 获取小区信息
/// </summary>
private string GetCommunityInfo(DataRow row)
{
if (!row.Table.Columns.Contains("CommunityId") || string.IsNullOrEmpty(row["CommunityId"].ToString()))
{
return(JSONHelper.FromString(false, "小区编号不能为空"));
}
string communityId = row["CommunityId"].AsString();
//查询小区
Tb_Community Community = new MobileSoft.BLL.Unified.Bll_Tb_Community().GetModel(communityId);
//构造链接字符串
if (Community == null)
{
return(JSONHelper.FromString(false, "该小区不存在"));
}
return(new ApiResult(true, new
{
Id = communityId,
CorpID = Community.CorpID,
CorpName = Community.CorpName,
CommID = Community.CommID,
CommName = Community.CommName,
Province = Community.Province,
Area = Community.Area,
City = Community.City,
Tel = Community.Tel,
ModuleRights = Community.ModuleRights,
IsMultiDoorControlServer = Community.IsMultiDoorControlServer
}).toJson());
}
/// <summary>
/// 优惠券使用历史
/// </summary>
public string GetCouponUsedHistoryList(DataRow row)
{
if (!row.Table.Columns.Contains("UserId") || string.IsNullOrEmpty(row["UserId"].ToString()))
{
return(JSONHelper.FromString(false, "用户id不能为空"));
}
int pageCount = 0;
int Counts = 0;
int PageIndex = 1;
int PageSize = 10;
if (row.Table.Columns.Contains("PageIndex") && AppGlobal.StrToInt(row["PageIndex"].ToString()) > 0)
{
PageIndex = AppGlobal.StrToInt(row["PageIndex"].ToString());
}
if (row.Table.Columns.Contains("PageSize") && AppGlobal.StrToInt(row["PageSize"].ToString()) > 0)
{
PageSize = AppGlobal.StrToInt(row["PageSize"].ToString());
}
using (IDbConnection conn = new SqlConnection(ConnectionDb.GetBusinessConnection()))
{
string sql = @"SELECT * FROM
(
select R.Id, R.Amount, B.BussName,R.ReceiptDate,R.PayDate,
OffsetMoney=(SELECT sum(isnull(x.OffsetMoney,0)) FROM Tb_Charge_ReceiptDetail x WHERE x.ReceiptCode=R.Id)
FROM Tb_Charge_Receipt as R left join Tb_System_BusinessCorp as B on b.BussId = R.BussId
WHERE R.UserId='" + row["UserId"].ToString() + @"'
) t WHERE t.OffsetMoney>0";
DataTable dt = BussinessCommon.GetList(out pageCount, out Counts, sql, PageIndex, PageSize, "PayDate", 1, "Id", ConnectionDb.GetBusinessConnection(), "*").Tables[0];
return(JSONHelper.FromString(dt));
}
}
/// <summary>
/// 泰禾高端定制
/// </summary>
private string GetCommunityServices(DataRow row)
{
if (!row.Table.Columns.Contains("CommunityId") || string.IsNullOrEmpty(row["CommunityId"].ToString()))
{
return(JSONHelper.FromString(false, "小区编号不能为空"));
}
string communityId = row["CommunityId"].AsString();
//查询小区
Tb_Community Community = new MobileSoft.BLL.Unified.Bll_Tb_Community().GetModel(communityId);
//构造链接字符串
if (Community == null)
{
return(JSONHelper.FromString(false, "该小区不存在"));
}
string strcon = new Business.CostInfo().GetConnectionStringStr(Community);
using (IDbConnection conn = new SqlConnection(PubConstant.UnifiedContionString))
{
DataTable dataTable = conn.ExecuteReader(string.Format(@"SELECT TOP 9 Sort,CustomizedType,CustomizedImage,CarouselDescribe,CarouselImage,ImgLink,Phone FROM Tb_CommunityService
WHERE isnull(IsDelete,0)=0 AND CommunityId LIKE '%{0}%'", communityId)).ToDataSet().Tables[0];
return(JSONHelper.FromString(dataTable));
}
}
/// <summary>
/// 获取App下载链接
/// </summary>
private string GetAppDownloadUrl(DataRow row)
{
if (!row.Table.Columns.Contains("AppID") || string.IsNullOrEmpty(row["AppID"].AsString()))
{
return(new ApiResult(false, "缺少参数AppID").toJson());
}
if (!row.Table.Columns.Contains("Platform") || string.IsNullOrEmpty(row["Platform"].AsString()))
{
return(new ApiResult(false, "缺少参数Platform").toJson());
}
var appId = row["AppID"].AsString();
var platform = row["Platform"].AsString().ToLower();
using (var conn = new SqlConnection(PubConstant.UnifiedContionString))
{
var sql = @"SELECT DownloadUrl FROM Tb_App_DownloadInfo WHERE IsDelete=0";
if (platform == "ios")
{
sql += " AND AppleBundleID=@AppID";
}
if (platform == "android")
{
sql += " AND AndroidPackageName=@AppID";
}
var url = conn.Query <string>(sql, new { AppID = appId }).FirstOrDefault();
if (url != null)
{
return(JSONHelper.FromString(true, url));
}
return(JSONHelper.FromString(false, "还未配置App下载路径"));
}
}
public override void Operate(ref Common.Transfer Trans)
{
Trans.Result = JSONHelper.FromString(false, "未知错误");
DataTable dAttributeTable = base.XmlToDatatTable(Trans.Attribute);
DataRow Row = dAttributeTable.Rows[0];
switch (Trans.Command)
{
case "GetFeesStatistics": // 获取欠费或预存信息
Trans.Result = GetFeesStatistics(Row);
break;
case "GetFeesStatistics_ZhongJi": // 获取欠费或预存信息
Trans.Result = GetFeesStatistics_ZhongJi(Row);
break;
case "GetDebtsFeesList": // 获取欠费列表
Trans.Result = GetDebtsFeesList(Row);
break;
case "GetDebtsFeesList_ZhongJi": // 获取欠费列表
Trans.Result = GetDebtsFeesList_ZhongJi(Row);
break;
case "GetFeesHistoryList": // 获取历史账单
Trans.Result = GetFeesHistoryList(Row);
break;
default:
break;
}
}
/// <summary>
/// 审核操作
/// </summary>
private string Audit(DataRow row)
{
if (!row.Table.Columns.Contains("IID") || string.IsNullOrEmpty(row["IID"].ToString()))
{
return(JSONHelper.FromString(false, "缺少IID参数"));
}
if (!row.Table.Columns.Contains("IsAllows") || string.IsNullOrEmpty(row["IsAllows"].ToString()))
{
return(JSONHelper.FromString(false, "缺少IsAllows参数"));
}
if (!row.Table.Columns.Contains("Remark"))
{
return(JSONHelper.FromString(false, "缺少Remark参数"));
}
int IsAllows = 0;
if (row["IsAllows"].ToString() == "1" || row["IsAllows"].ToString() == "通过")
{
IsAllows = 1;
}
string IID = row["IID"].ToString();
string Remark = row["Remark"].ToString();
return(Audit(IsAllows, IID, Remark));
}
