/// <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, "提交成功")); } }