/// <summary>
/// 巡查催办
/// </summary>
private string RectificationUrge(DataRow row)
{
if (!row.Table.Columns.Contains("IncidentID") || string.IsNullOrEmpty(row["IncidentID"].ToString()))
{
return(JSONHelper.FromString(false, "报事编号不能为空"));
}
using (IDbConnection conn = new SqlConnection(PubConstant.hmWyglConnectionString))
{
string sql = @"SELECT * FROM Tb_HSPR_IncidentAccept WHERE IncidentID=@IncidentID";
dynamic incidentInfo = conn.Query(sql, new { IncidentID = row["IncidentID"].ToString() }).FirstOrDefault();
if (incidentInfo.MainEndDate != null && !string.IsNullOrEmpty(incidentInfo.MainEndDate))
{
return(JSONHelper.FromString(false, "该报事已经处理完毕"));
}
Tb_HSPR_IncidentAccept incidentAccept = new Tb_HSPR_IncidentAccept()
{
Phone = incidentInfo.Phone,
CommID = incidentInfo.CommID,
TypeID = incidentInfo.TypeID,
IncidentID = incidentInfo.IncidentID,
IncidentPlace = incidentInfo.IncidentPlace,
IncidentMan = incidentInfo.IncidentMan,
DispMan = incidentInfo.DispMan,
CoordinateNum = incidentInfo.CoordinateNum
};
// 已分派，推送给处理人
if (incidentInfo.DispUserCode != null)
{
IncidentAcceptPush.SynchPushAfterAssign(incidentAccept);
}
else
{
// 推送分派和抢单
IncidentAcceptPush.SynchPushPublicIncident(incidentAccept, "综合巡查");
}
// 金辉、实地、海亮、华宇、俊发，都是用的金辉版本报事
if (Global_Var.LoginCorpID == "1329" || Global_Var.LoginCorpID == "2021" || Global_Var.LoginCorpID == "1940" || Global_Var.LoginCorpID == "1985")
{
conn.Execute(@"INSERT INTO Tb_HSPR_IncidentRemindersInfo(IncidentID,CommID,RemindersDate,UserID,UserName,IsDelete)
VALUES(@IncidentID,@CommID,getdate(),@UserID,@UserName,0)",
new
{
IncidentID = incidentInfo.IncidentID,
CommID = incidentInfo.CommID,
UserID = Global_Var.LoginUserCode,
UserName = Global_Var.LoginUserName
});
}
return(JSONHelper.FromString(true, "催办成功"));
}
}
/// <summary>
/// 投诉建议列表
/// </summary>
private string SaveSuggestion(DataRow row)
{
if (!row.Table.Columns.Contains("CommID") || string.IsNullOrEmpty(row["CommID"].ToString()))
{
return(JSONHelper.FromString(false, "小区编号不能为空"));
}
if (!row.Table.Columns.Contains("CustID") || string.IsNullOrEmpty(row["CustID"].ToString()))
{
return(JSONHelper.FromString(false, "客户编号不能为空"));
}
if (!row.Table.Columns.Contains("Content") || string.IsNullOrEmpty(row["Content"].ToString()))
{
return(JSONHelper.FromString(false, "报事内容不能为空"));
}
if (!row.Table.Columns.Contains("RoomID") || string.IsNullOrEmpty(row["RoomID"].ToString()))
{
return(JSONHelper.FromString(false, "房间编号不能为空"));
}
if (!row.Table.Columns.Contains("Phone") || string.IsNullOrEmpty(row["Phone"].ToString()))
{
return(JSONHelper.FromString(false, "联系方式不能为空"));
}
string Content = row["Content"].ToString();
string CommID = row["CommID"].ToString();
string CustID = row["CustID"].ToString();
string RoomID = row["RoomID"].ToString();
string Phone = row["Phone"].ToString();
string Imgs = "";
if (row.Table.Columns.Contains("Imgs") && !string.IsNullOrEmpty(row["Imgs"].ToString()))
{
Imgs = row["Imgs"].ToString();
}
//查询小区
Tb_Community Community = GetCommunityByCommID(CommID);
if (Community == null)
{
return(JSONHelper.FromString(false, "该小区不存在"));
}
Global_Var.CorpId = Community.CorpID.ToString();
Global_Var.CorpID = Community.CorpID.ToString();
Global_Var.LoginCorpID = Community.CorpID.ToString();
PubConstant.hmWyglConnectionString = GetConnectionStr(Community);
Regex regex = new Regex(@"(initial catalog = [^;]+);");
if (regex.IsMatch(PubConstant.hmWyglConnectionString))
{
PubConstant.tw2bsConnectionString = regex.Replace(PubConstant.hmWyglConnectionString, @"initial catalog = tw2_bs;");
}
using (IDbConnection conn = new SqlConnection(PubConstant.hmWyglConnectionString))
{
var custName = conn.Query <string>(@"SELECT CustName FROM Tb_HSPR_Customer WHERE CustID=@CustID",
new { CustID = CustID }).FirstOrDefault();
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@CommID", Community.CommID);
parameters.Add("@CustID", CustID);
parameters.Add("@RoomID", RoomID);
parameters.Add("@IncidentDate", DateTime.Now);
parameters.Add("@IncidentMan", custName);
parameters.Add("@IncidentContent", Content);
parameters.Add("@ReserveDate", null);
parameters.Add("@Phone", Phone);
parameters.Add("@IncidentImgs", Imgs);
parameters.Add("@TypeID", null);
parameters.Add("@DealLimit", null);
parameters.Add("@EmergencyDegree", 0);
parameters.Add("@IncidentMode", "App爱我家园");
parameters.Add("@IncidentID", 0, DbType.Int64, ParameterDirection.Output);
//需求4067 业主APP填报爱我家园信息时，自动转为工单（incidentaccept表数据），默认将报事类别设定为：投诉-物业管理-综合服务类
conn.Execute("Proc_HSPR_IncidentAccept_PhoneInsert", parameters, null, null, CommandType.StoredProcedure);
//获取当前报事
string str = "SELECT * FROM Tb_HSPR_IncidentAccept WHERE IncidentID=@IncidentID";
dynamic model = conn.Query(str, new
{
IncidentID = parameters.Get <long>(@"IncidentID")
}).LastOrDefault();
//zw增加model非空验证
if (model != null)
{
IncidentAcceptPush.SynchPushIndoorIncidentWithoutIncidentType(new Tb_HSPR_IncidentAccept()
{
TypeID = model.TypeID,
CommID = model.CommID,
RoomID = model.RoomID,
IncidentID = model.IncidentID,
IncidentPlace = model.IncidentPlace,
IncidentMan = model.IncidentMan,
});
}
return(JSONHelper.FromString(true, "提交成功"));
}
}
