/// <summary> /// 客服动态 /// </summary> /// <returns></returns> public string GetIncidentDynamic(DataRow row) { #region int iCommID = 0; if (row.Table.Columns.Contains("CommID")) { iCommID = AppGlobal.StrToInt(row["CommID"].ToString()); } string userCode = Global_Var.LoginUserCode; if (row.Table.Columns.Contains("UserCode")) { userCode = row["UserCode"].ToString(); } string organCode = null; string strCommName = AppGlobal.GetCommName(iCommID); string strOrganName = ""; //未分派的报事 int NoDispIncidentNum = 0; //未完结的协调单 int NoCoordinateIncidentNum = 0; //逾期的协调单 int BeOverdueIncidentNum = 0; string strDate = ""; string strReText = ""; int iIncidentNum1 = 0; int iIncidentNum2 = 0; int iIncidentNum3 = 0; int iIncidentNum4 = 0; int iIncidentNum5 = 0; decimal iIncidentRate1 = 0; decimal iIncidentRate2 = 0; decimal iIncidentRate3 = 0; decimal iIncidentRate4 = 0; #endregion string strSQL = ""; int temp = 3; // 项目客服动态 if (iCommID != 0) { strSQL = " and CommID = " + iCommID.ToString() + " and datediff(day,StatDate,getdate()) = 1 and StatType = 1 "; } else { if (row.Table.Columns.Contains("OrganCode")) { organCode = row["OrganCode"].ToString(); } if (string.IsNullOrEmpty(organCode)) { organCode = "01"; } strOrganName = AppGlobal.GetOrganName4(organCode); // 分公司 if (organCode.Length == 4) { temp = 2; strSQL = " and OrganCode like '" + organCode + "%' and datediff(day,StatDate,getdate()) = 1 and StatType = 2 "; } // 总公司 if (organCode.Length == 2) { temp = 1; strSQL = " and datediff(day,StatDate,getdate()) = 1 and StatType = 3 "; } } MobileSoft.BLL.Sys.Bll_Tb_Sys_TakePic Bll = new MobileSoft.BLL.Sys.Bll_Tb_Sys_TakePic(); DataTable dTable = Bll.GetListFromProc(strSQL).Tables[0]; if (dTable.Rows.Count > 0) { DataRow DRow = dTable.Rows[0]; NoDispIncidentNum = AppGlobal.StrToInt(DRow["NoDispIncidentNum"].ToString()); NoCoordinateIncidentNum = AppGlobal.StrToInt(DRow["NoCoordinateIncidentNum"].ToString()); BeOverdueIncidentNum = AppGlobal.StrToInt(DRow["BeOverdueIncidentNum"].ToString()); iIncidentNum1 = AppGlobal.StrToInt(DRow["IncidentNum1"].ToString()); iIncidentNum2 = AppGlobal.StrToInt(DRow["IncidentNum2"].ToString()); iIncidentNum3 = AppGlobal.StrToInt(DRow["IncidentNum3"].ToString()); iIncidentNum4 = AppGlobal.StrToInt(DRow["IncidentNum4"].ToString()); iIncidentNum5 = AppGlobal.StrToInt(DRow["IncidentNum5"].ToString()); iIncidentRate1 = AppGlobal.StrToDec(DRow["IncidentRate1"].ToString()); iIncidentRate2 = AppGlobal.StrToDec(DRow["IncidentRate2"].ToString()); iIncidentRate3 = AppGlobal.StrToDec(DRow["IncidentRate3"].ToString()); iIncidentRate4 = AppGlobal.StrToDec(DRow["IncidentRate4"].ToString()); strDate = AppGlobal.StrToDate(DRow["StatDate"].ToString()).ToString("yyyy年MM月dd日"); } dTable.Dispose(); if (string.IsNullOrEmpty(strDate)) { strDate = DateTime.Now.ToString("yyyy年MM月dd日"); } // 读取报时预警信息 MobileSoft.BLL.HSPR.Bll_Tb_HSPR_TempIncidentWarning Bll3 = new MobileSoft.BLL.HSPR.Bll_Tb_HSPR_TempIncidentWarning(); DataTable dTable3 = Bll3.GetList(userCode, iCommID).Tables[0]; string value1 = ""; string value2 = ""; string value3 = ""; if (dTable3.Rows.Count > 0) { DataRow DRow = dTable3.Rows[0]; value1 = DRow[0].ToString(); value2 = DRow[1].ToString(); value3 = DRow[2].ToString(); } switch (temp) { case 3: strReText = string.Format(@"【{0}】<br/>1、截止到{1},未分派报事{2}件,未完结的派工单{3}件(其中逾期{4}件),未完结的协调单{5}件(其中逾期{6}件);本月派工单完结率{7}%,本年累计{8}%;本月协调单完结率{9}%,本年累计{10}%。<br/>2、{11},共有{12}件报事,其中{13}件未完结。<br/>3、超时预警:已受理未分派超时工单{14}件,已分派未处理超时工单{15}件,已处理未回访超时工单{16}件;", strCommName, strDate, NoDispIncidentNum.ToString(), iIncidentNum1.ToString(), iIncidentNum2.ToString(), NoCoordinateIncidentNum.ToString(), BeOverdueIncidentNum.ToString(), iIncidentRate1.ToString("N2"), iIncidentRate2.ToString("N2"), iIncidentRate3.ToString("N2"), iIncidentRate4.ToString("N2"), strDate, iIncidentNum4.ToString(), iIncidentNum5.ToString(), value1, value2, value3); break; case 2: case 1: strReText = string.Format(@"【{0}】<br/>1、截止到{1},未分派报事{2}件,未完结的派工单{3}件(其中逾期{4}件),未完结的协调单{5}件(其中逾期{6}件);本月派工单完结率{7}%,本年累计{8}%;本月协调单完结率{9}%,本年累计{10}%。<br/>2、{11},共有{12}件报事,其中{13}件未完结。<br/>3、超时预警:已受理未分派超时工单{14}件,已分派未处理超时工单{15}件,已处理未回访超时工单{16}件;", strOrganName, strDate, NoDispIncidentNum.ToString(), iIncidentNum1.ToString(), iIncidentNum2.ToString(), NoCoordinateIncidentNum.ToString(), BeOverdueIncidentNum.ToString(), iIncidentRate1.ToString("N2"), iIncidentRate2.ToString("N2"), iIncidentRate3.ToString("N2"), iIncidentRate4.ToString("N2"), strDate, iIncidentNum4.ToString(), iIncidentNum5.ToString(), value1, value2, value3); break; } // 客服动态图表统计 MobileSoft.BLL.Sys.Bll_Tb_Sys_TakePicIncidentTypeDeskTop Bll2 = new MobileSoft.BLL.Sys.Bll_Tb_Sys_TakePicIncidentTypeDeskTop(); DataTable dTable2 = Bll2.GetList(organCode, iCommID).Tables[0]; string chart = JSONHelper.FromDataTable(dTable2); return(JSONHelper.FromJsonString(true, "{\"Info\":\"" + strReText + "\", \"Chart\":" + chart + "}")); }
/// <summary> /// 收费动态 /// </summary> /// <returns></returns> public string GetChargeDynamic(DataRow row) { #region int iCommID = 0; if (row.Table.Columns.Contains("CommID")) { iCommID = AppGlobal.StrToInt(row["CommID"].ToString()); } string strCommName = AppGlobal.GetCommName(iCommID); string strOrganName = ""; string strDate = ""; string strReText = ""; decimal iChargeRate1 = 0; decimal iChargeRate2 = 0; decimal iChargeRate3 = 0; int iFeesCreateNum = 0; int iFeesCancelNum = 0; #endregion string strSQL = ""; int temp = 3; // 项目收费动态 if (iCommID != 0) { strSQL = " and CommID = " + iCommID.ToString() + " and datediff(day,StatDate,getdate()) = 1 and StatType = 1 "; } else { string organCode = null; if (row.Table.Columns.Contains("OrganCode")) { organCode = row["OrganCode"].ToString(); } if (string.IsNullOrEmpty(organCode)) { organCode = "01"; } strOrganName = AppGlobal.GetOrganName4(organCode); // 分公司 if (organCode.Length == 4) { temp = 2; strSQL = " and OrganCode like '" + organCode + "%' and datediff(day,StatDate,getdate()) = 1 and StatType = 2 "; } // 总公司 if (organCode.Length == 2) { temp = 1; strSQL = " and datediff(day,StatDate,getdate()) = 1 and StatType = 3 "; } } MobileSoft.BLL.Sys.Bll_Tb_Sys_TakePic Bll = new MobileSoft.BLL.Sys.Bll_Tb_Sys_TakePic(); DataTable dTable = Bll.GetListFromProc(strSQL).Tables[0]; if (dTable.Rows.Count > 0) { DataRow DRow = dTable.Rows[0]; iChargeRate1 = AppGlobal.StrToDec(DRow["ChargeRate1"].ToString()); iChargeRate2 = AppGlobal.StrToDec(DRow["ChargeRate2"].ToString()); iChargeRate3 = AppGlobal.StrToDec(DRow["ChargeRate3"].ToString()); iFeesCreateNum = AppGlobal.StrToInt(DRow["FeesCreateNum"].ToString()); iFeesCancelNum = AppGlobal.StrToInt(DRow["FeesCancelNum"].ToString()); strDate = AppGlobal.StrToDate(DRow["StatDate"].ToString()).ToString("yyyy年MM月dd日"); } DataTable dt = new DataTable(); dt.Columns.AddRange(new DataColumn[] { new DataColumn() { ColumnName = dTable.Columns["ChargeRate1"].ColumnName, DataType = dTable.Columns["ChargeRate1"].DataType }, new DataColumn() { ColumnName = dTable.Columns["ChargeRate2"].ColumnName, DataType = dTable.Columns["ChargeRate2"].DataType }, new DataColumn() { ColumnName = "Info", DataType = typeof(string) } }); DataRow resultRow = dt.NewRow(); if (dTable.Rows.Count > 0) { DataRow DRow = dTable.Rows[0]; resultRow["ChargeRate1"] = DRow["ChargeRate1"]; resultRow["ChargeRate2"] = DRow["ChargeRate2"]; } else { resultRow["ChargeRate1"] = 0; resultRow["ChargeRate2"] = 0; } dTable.Dispose(); switch (temp) { case 3: strReText = string.Format(@"【{0}】<br/>1、截止到{1},物管费本月收费率{2}%,本年累计收费率{3}%,以前年度欠费回收率{4}%。<br/>2、截止到{5},本月共有{6}笔审核费用入账,{7}笔费用撤销。", strCommName, strDate, iChargeRate1.ToString("N2"), iChargeRate2.ToString("N2"), iChargeRate3.ToString("N2"), strDate, iFeesCreateNum.ToString(), iFeesCancelNum.ToString()); break; case 2: case 1: strReText = string.Format(@"【{0}】<br/>1、截止到{1},物管费本月收费率{2}%,本年累计收费率{3}%,以前年度欠费回收率{4}%。<br/>2、截止到{5},本月共有{6}笔审核费用入账,{7}笔费用撤销。", strOrganName, strDate, iChargeRate1.ToString("N2"), iChargeRate2.ToString("N2"), iChargeRate3.ToString("N2"), strDate, iFeesCreateNum.ToString(), iFeesCancelNum.ToString()); break; } resultRow["Info"] = strReText; dt.Rows.Add(resultRow); return(JSONHelper.FromString(dt)); }
public string GetDynamic(DataRow row, string Type) { String result = ""; StringBuilder strReText = new StringBuilder(""); #region 变量定义 //int iCommID = AppGlobal.StrToInt(Global_Var.LoginCommID); int iCommID = 0; if (row.Table.Columns.Contains("CommID")) { iCommID = AppGlobal.StrToInt(row["CommID"].ToString()); } string strCommName = AppGlobal.GetCommName(iCommID); string strOrganName = AppGlobal.GetOrganName4(Global_Var.LoginOrganCorp); string strDate = ""; string strPark = ""; string strRoomState = ""; string strOrganParkList = ""; string strStateList = ""; string strParkList = ""; string strOrganDate = ""; string strOrganRoomState = ""; string strOrganPark = ""; string strOrganStateList = ""; decimal iAllArea = 0; decimal iOrganAllArea = 0; decimal iChargeRate1 = 0; decimal iChargeRate2 = 0; decimal iChargeRate3 = 0; int iRoomNum4 = 0; int iRoomNum5 = 0; int iRoomNum6 = 0; int iFeesCreateNum = 0; int iFeesCancelNum = 0; int iIncidentNum1 = 0; int iIncidentNum2 = 0; int iIncidentNum3 = 0; int iIncidentNum4 = 0; int iIncidentNum5 = 0; decimal iIncidentRate1 = 0; decimal iIncidentRate2 = 0; decimal iIncidentRate3 = 0; decimal iIncidentRate4 = 0; #endregion // 项目 if (iCommID != 0) { string strSQL = " CommID = " + iCommID.ToString() + " and datediff(day,StatDate,getdate()) = 1 and StatType = 1 "; MobileSoft.BLL.Sys.Bll_Tb_Sys_TakePic Bll = new MobileSoft.BLL.Sys.Bll_Tb_Sys_TakePic(); //DataTable dTable = Bll.GetList(strSQL, "RoomNum4,RoomNum5,RoomNum6,ChargeRate1,ChargeRate2,ChargeRate3,FeesCreateNum,FeesCancelNum,AllArea,StatDate,IncidentNum1,IncidentNum2,IncidentNum3,IncidentNum4,IncidentNum5,IncidentRate1,IncidentRate2,IncidentRate3,IncidentRate4").Tables[0]; DataTable dTable = Bll.GetList(1000, strSQL, "CommID").Tables[0]; if (dTable.Rows.Count > 0) { DataRow DRow = dTable.Rows[0]; iRoomNum4 = AppGlobal.StrToInt(DRow["RoomNum4"].ToString()); iRoomNum5 = AppGlobal.StrToInt(DRow["RoomNum5"].ToString()); iRoomNum6 = AppGlobal.StrToInt(DRow["RoomNum6"].ToString()); iChargeRate1 = AppGlobal.StrToDec(DRow["ChargeRate1"].ToString()); iChargeRate2 = AppGlobal.StrToDec(DRow["ChargeRate2"].ToString()); iChargeRate3 = AppGlobal.StrToDec(DRow["ChargeRate3"].ToString()); iFeesCreateNum = AppGlobal.StrToInt(DRow["FeesCreateNum"].ToString()); iFeesCancelNum = AppGlobal.StrToInt(DRow["FeesCancelNum"].ToString()); iAllArea = AppGlobal.StrToDec(DRow["AllArea"].ToString()); strDate = AppGlobal.StrToDate(DRow["StatDate"].ToString()).ToString("yyyy年MM月dd日"); iIncidentNum1 = AppGlobal.StrToInt(DRow["IncidentNum1"].ToString()); iIncidentNum2 = AppGlobal.StrToInt(DRow["IncidentNum2"].ToString()); iIncidentNum3 = AppGlobal.StrToInt(DRow["IncidentNum3"].ToString()); iIncidentNum4 = AppGlobal.StrToInt(DRow["IncidentNum4"].ToString()); iIncidentNum5 = AppGlobal.StrToInt(DRow["IncidentNum5"].ToString()); iIncidentRate1 = AppGlobal.StrToDec(DRow["IncidentRate1"].ToString()); iIncidentRate2 = AppGlobal.StrToDec(DRow["IncidentRate2"].ToString()); iIncidentRate3 = AppGlobal.StrToDec(DRow["IncidentRate3"].ToString()); iIncidentRate4 = AppGlobal.StrToDec(DRow["IncidentRate4"].ToString()); } #region 房屋状态 string strSQL2 = " CommID = " + iCommID.ToString() + " and datediff(day,StatDate,getdate()) = 1 and StatType = 1 "; MobileSoft.BLL.Sys.Bll_Tb_Sys_TakePicRoomState BllState = new MobileSoft.BLL.Sys.Bll_Tb_Sys_TakePicRoomState(); DataTable dTable2 = BllState.GetList(strSQL2).Tables[0]; if (dTable2.Rows.Count > 0) { strRoomState = ",其中"; } else { strRoomState = "。"; } foreach (DataRow DRow in dTable2.Rows) { string strStateName = DRow["StateName"].ToString(); if (strStateName == "") { strStateName = "[无]"; } if (strStateList != "") { strStateList = strStateList + "," + strStateName + "" + DRow["Counts"].ToString() + "" + "套"; } else { strStateList = strStateName + "" + DRow["Counts"].ToString() + "" + "套"; } } if (strStateList != "") { strRoomState = strRoomState + strStateList + "。"; } dTable2.Dispose(); #endregion #region 车位数 string strSQL3 = " CommID = " + iCommID.ToString() + " and datediff(day,StatDate,getdate()) = 1 and StatType = 1 "; MobileSoft.BLL.Sys.Bll_Tb_Sys_TakePicPark BllPark = new MobileSoft.BLL.Sys.Bll_Tb_Sys_TakePicPark(); DataTable dTable3 = BllPark.GetList(strSQL3).Tables[0]; if (dTable3.Rows.Count > 0) { strPark = "车位:"; } else { strPark = "无车位信息"; } foreach (DataRow DRow in dTable3.Rows) { string strParkTypeName = DRow["ParkTypeName"].ToString(); if (strParkTypeName == "") { strParkTypeName = "[无]"; } if (strParkList != "") { strParkList = strParkList + "," + strParkTypeName + "" + DRow["Counts"].ToString() + "" + "个"; } else { strParkList = strParkTypeName + "" + DRow["Counts"].ToString() + "" + "个"; } } if (strParkList != "") { strPark = strPark + strParkList + "。"; } dTable3.Dispose(); #endregion #region 设置社区 switch (Type) { case "1": //获取资源动态 strReText.Append("【" + strCommName + "】<br/>"); strReText.Append("1、截止到" + strDate + ",可收物管费面积共" + iAllArea.ToString() + "平方米" + strRoomState + "<br/>2、截止到" + strDate + "," + strPark + "<br/>"); strReText.Append("3、" + strDate + "共有" + iRoomNum4.ToString() + "套办理转让," + iRoomNum5.ToString() + "套办理租赁," + iRoomNum6.ToString() + "套车位办理转让。"); break; case "2": //收费动态 strReText.Append("【" + strCommName + "】<br/>"); strReText.Append("1、截止到" + strDate + ",物管费本月收费率" + iChargeRate1.ToString("N2") + "%,本年累计收费率" + iChargeRate2.ToString("N2") + "%,以前年度欠费回收率" + iChargeRate3.ToString("N2") + "%。" + "<br/>"); strReText.Append("2、" + strDate + ",共有" + iFeesCreateNum.ToString() + "笔审核费用入账," + iFeesCancelNum.ToString() + "笔费用撤销。"); break; case "3": //客服动态 strReText.Append("【" + strCommName + "】<br/>"); strReText.Append("1、截止到" + strDate + ",未完结的派工单" + iIncidentNum1.ToString() + "件(其中逾期" + iIncidentNum2.ToString() + "件),超过60天未完结的协调单" + iIncidentNum3.ToString() + "件;本月派工单完结率" + iIncidentRate1.ToString("N2") + "%,本年累计" + iIncidentRate2.ToString("N2") + "%;本月协调单完结率" + iIncidentRate3.ToString("N2") + "%,本年累计" + iIncidentRate4.ToString("N2") + "%。<br/>"); strReText.Append("2、" + strDate + ",共有" + iIncidentNum4.ToString() + "件报事,其中" + iIncidentNum5.ToString() + "件未完结;<br/>"); break; } #endregion } else { #region if (Global_Var.LoginOrganCode == "" || Global_Var.LoginOrganCode == "01") { #region 集团 #region 集团 string strSQLOrgan = " datediff(day,StatDate,getdate()) = 1 and StatType = 3 "; MobileSoft.BLL.Sys.Bll_Tb_Sys_TakePic Bll = new MobileSoft.BLL.Sys.Bll_Tb_Sys_TakePic(); DataTable dTableOrgan = Bll.GetList(strSQLOrgan, "AllArea,StatDate,ChargeRate1,ChargeRate2,ChargeRate3,IncidentNum1,IncidentNum2,IncidentNum3,IncidentNum4,IncidentNum5,IncidentRate1,IncidentRate2,IncidentRate3,IncidentRate4").Tables[0]; // DataTable dTableOrgan = Bll.GetList(strSQLOrgan).Tables[0]; decimal iOrganChargeRate1 = 0; decimal iOrganChargeRate2 = 0; decimal iOrganChargeRate3 = 0; int iOrganIncidentNum1 = 0; int iOrganIncidentNum2 = 0; int iOrganIncidentNum3 = 0; int iOrganIncidentNum4 = 0; int iOrganIncidentNum5 = 0; decimal iOrganIncidentRate1 = 0; decimal iOrganIncidentRate2 = 0; decimal iOrganIncidentRate3 = 0; decimal iOrganIncidentRate4 = 0; if (dTableOrgan.Rows.Count > 0) { DataRow DRow = dTableOrgan.Rows[0]; iOrganAllArea = AppGlobal.StrToDec(DRow["AllArea"].ToString()); strOrganDate = AppGlobal.StrToDate(DRow["StatDate"].ToString()).ToString("yyyy年MM月dd日"); iOrganChargeRate1 = AppGlobal.StrToDec(DRow["ChargeRate1"].ToString()); iOrganChargeRate2 = AppGlobal.StrToDec(DRow["ChargeRate2"].ToString()); iOrganChargeRate3 = AppGlobal.StrToDec(DRow["ChargeRate3"].ToString()); iOrganIncidentNum1 = AppGlobal.StrToInt(DRow["IncidentNum1"].ToString()); iOrganIncidentNum2 = AppGlobal.StrToInt(DRow["IncidentNum2"].ToString()); iOrganIncidentNum3 = AppGlobal.StrToInt(DRow["IncidentNum3"].ToString()); iOrganIncidentNum4 = AppGlobal.StrToInt(DRow["IncidentNum4"].ToString()); iOrganIncidentNum5 = AppGlobal.StrToInt(DRow["IncidentNum5"].ToString()); iOrganIncidentRate1 = AppGlobal.StrToDec(DRow["IncidentRate1"].ToString()); iOrganIncidentRate2 = AppGlobal.StrToDec(DRow["IncidentRate2"].ToString()); iOrganIncidentRate3 = AppGlobal.StrToDec(DRow["IncidentRate3"].ToString()); iOrganIncidentRate4 = AppGlobal.StrToDec(DRow["IncidentRate4"].ToString()); } dTableOrgan.Dispose(); #endregion #region 房屋状态(集团) string strSQLOrgan2 = " OrganCode like '" + Global_Var.LoginOrganCorp + "%' and datediff(day,StatDate,getdate()) = 1 and StatType = 3 "; MobileSoft.BLL.Sys.Bll_Tb_Sys_TakePicRoomState BllState = new MobileSoft.BLL.Sys.Bll_Tb_Sys_TakePicRoomState(); DataTable dTableOrgan2 = BllState.GetList(strSQLOrgan2).Tables[0]; if (dTableOrgan2.Rows.Count > 0) { strOrganRoomState = ",其中"; } else { strOrganRoomState = "。"; } foreach (DataRow DRow in dTableOrgan2.Rows) { string strStateName = DRow["StateName"].ToString(); if (strStateName == "") { strStateName = "[无]"; } if (strOrganStateList != "") { strOrganStateList = strOrganStateList + "," + strStateName + "" + DRow["Counts"].ToString() + "" + "套"; } else { strOrganStateList = strStateName + "" + DRow["Counts"].ToString() + "" + "套"; } } if (strOrganStateList != "") { strOrganRoomState = strOrganRoomState + strOrganStateList + "。"; } dTableOrgan2.Dispose(); #endregion #region 车位数(集团) string strSQLOrgan3 = " OrganCode like '" + Global_Var.LoginOrganCorp + "%' and datediff(day,StatDate,getdate()) = 1 and StatType = 3 "; MobileSoft.BLL.Sys.Bll_Tb_Sys_TakePicPark BllPark = new MobileSoft.BLL.Sys.Bll_Tb_Sys_TakePicPark(); DataTable dTableOrgan3 = BllPark.GetList(strSQLOrgan3).Tables[0]; if (dTableOrgan3.Rows.Count > 0) { strOrganPark = "车位:"; } else { strOrganPark = "无车位信息"; } foreach (DataRow DRow in dTableOrgan3.Rows) { string strParkTypeName = DRow["ParkTypeName"].ToString(); if (strParkTypeName == "") { strParkTypeName = "[无]"; } if (strOrganParkList != "") { strOrganParkList = strOrganParkList + "," + strParkTypeName + "" + DRow["Counts"].ToString() + "" + "个"; } else { strOrganParkList = strParkTypeName + "" + DRow["Counts"].ToString() + "" + "个"; } } if (strOrganParkList != "") { strOrganPark = strOrganPark + strOrganParkList + "。"; } dTableOrgan3.Dispose(); #endregion #region 设置集团 switch (Type) { case "1": strReText.Append("1、截止到" + strOrganDate + ",可收物管费面积共" + iOrganAllArea.ToString() + "平方米" + strOrganRoomState + "<br/>2、截止到" + strOrganDate + "," + strOrganPark); break; case "2": strReText.Append("截止到" + strOrganDate + ":<br/>1、物管费本月收费率" + iOrganChargeRate1.ToString("N2") + "%;<br/>2、本年累计收费率" + iOrganChargeRate2.ToString("N2") + "%;<br/>3、以前年度欠费回收率" + iOrganChargeRate3.ToString("N2") + "%。"); break; case "3": strReText.Append("1、截止到" + strOrganDate + ",未完结的派工单" + iOrganIncidentNum1.ToString() + "件(其中逾期" + iOrganIncidentNum2.ToString() + "件),超过60天未完结的协调单" + iOrganIncidentNum3.ToString() + "件;<br/>2、本月派工单完结率" + iOrganIncidentRate1.ToString("N2") + "%,本年累计" + iOrganIncidentRate2.ToString("N2") + "%;本月协调单完结率" + iOrganIncidentRate3.ToString("N2") + "%,本年累计" + iOrganIncidentRate4.ToString("N2") + "%;<br/>"); break; } #endregion #endregion } else { #region 公司 #region 地区公司 string strSQLOrgan = " OrganCode like '" + Global_Var.LoginOrganCorp + "%' and datediff(day,StatDate,getdate()) = 1 and StatType = 2 "; MobileSoft.BLL.Sys.Bll_Tb_Sys_TakePic Bll = new MobileSoft.BLL.Sys.Bll_Tb_Sys_TakePic(); decimal iOrganChargeRate1 = 0; decimal iOrganChargeRate2 = 0; decimal iOrganChargeRate3 = 0; int iOrganIncidentNum1 = 0; int iOrganIncidentNum2 = 0; int iOrganIncidentNum3 = 0; int iOrganIncidentNum4 = 0; decimal iOrganIncidentRate1 = 0; decimal iOrganIncidentRate2 = 0; decimal iOrganIncidentRate3 = 0; decimal iOrganIncidentRate4 = 0; DataTable dTableOrgan = Bll.GetList(strSQLOrgan, "AllArea,StatDate,ChargeRate1,ChargeRate2,ChargeRate3,IncidentNum1,IncidentNum2,IncidentNum3,IncidentNum4,IncidentRate1,IncidentRate2,IncidentRate3,IncidentRate4").Tables[0]; if (dTableOrgan.Rows.Count > 0) { #region 取值 DataRow DRow = dTableOrgan.Rows[0]; iOrganAllArea = AppGlobal.StrToDec(DRow["AllArea"].ToString()); strOrganDate = AppGlobal.StrToDate(DRow["StatDate"].ToString()).ToString("yyyy年MM月dd日"); iOrganChargeRate1 = AppGlobal.StrToDec(DRow["ChargeRate1"].ToString()); iOrganChargeRate2 = AppGlobal.StrToDec(DRow["ChargeRate2"].ToString()); iOrganChargeRate3 = AppGlobal.StrToDec(DRow["ChargeRate3"].ToString()); iOrganIncidentNum1 = AppGlobal.StrToInt(DRow["IncidentNum1"].ToString()); iOrganIncidentNum2 = AppGlobal.StrToInt(DRow["IncidentNum2"].ToString()); iOrganIncidentNum3 = AppGlobal.StrToInt(DRow["IncidentNum3"].ToString()); iOrganIncidentNum4 = AppGlobal.StrToInt(DRow["IncidentNum4"].ToString()); iOrganIncidentRate1 = AppGlobal.StrToDec(DRow["IncidentRate1"].ToString()); iOrganIncidentRate2 = AppGlobal.StrToDec(DRow["IncidentRate2"].ToString()); iOrganIncidentRate3 = AppGlobal.StrToDec(DRow["IncidentRate3"].ToString()); iOrganIncidentRate4 = AppGlobal.StrToDec(DRow["IncidentRate4"].ToString()); #endregion } dTableOrgan.Dispose(); #endregion #region 房屋状态(地区公司) string strSQLOrgan2 = " OrganCode like '" + Global_Var.LoginOrganCorp + "%' and datediff(day,StatDate,getdate()) = 1 and StatType = 2 "; MobileSoft.BLL.Sys.Bll_Tb_Sys_TakePicRoomState BllState = new MobileSoft.BLL.Sys.Bll_Tb_Sys_TakePicRoomState(); DataTable dTableOrgan2 = BllState.GetList(strSQLOrgan2).Tables[0]; if (dTableOrgan2.Rows.Count > 0) { strOrganRoomState = ",其中"; } else { strOrganRoomState = "。"; } foreach (DataRow DRow in dTableOrgan2.Rows) { string strStateName = DRow["StateName"].ToString(); if (strStateName == "") { strStateName = "[无]"; } if (strOrganStateList != "") { strOrganStateList = strOrganStateList + "," + strStateName + "" + DRow["Counts"].ToString() + "" + "套"; } else { strOrganStateList = strStateName + "" + DRow["Counts"].ToString() + "" + "套"; } } if (strOrganStateList != "") { strOrganRoomState = strOrganRoomState + strOrganStateList + "。"; } dTableOrgan2.Dispose(); #endregion #region 车位数(地区公司) string strSQLOrgan3 = " OrganCode like '" + Global_Var.LoginOrganCorp + "%' and datediff(day,StatDate,getdate()) = 1 and StatType = 2 "; MobileSoft.BLL.Sys.Bll_Tb_Sys_TakePicPark BllPark = new MobileSoft.BLL.Sys.Bll_Tb_Sys_TakePicPark(); DataTable dTableOrgan3 = BllPark.GetList(strSQLOrgan3).Tables[0]; if (dTableOrgan3.Rows.Count > 0) { strOrganPark = "车位:"; } else { strOrganPark = "无车位信息"; } foreach (DataRow DRow in dTableOrgan3.Rows) { string strParkTypeName = DRow["ParkTypeName"].ToString(); if (strParkTypeName == "") { strParkTypeName = "[无]"; } if (strOrganParkList != "") { strOrganParkList = strOrganParkList + "," + strParkTypeName + "" + DRow["Counts"].ToString() + "" + "个"; } else { strOrganParkList = strParkTypeName + "" + DRow["Counts"].ToString() + "" + "个"; } } if (strOrganParkList != "") { strOrganPark = strOrganPark + strOrganParkList + "。"; } dTableOrgan3.Dispose(); #endregion #region 设置地区公司 switch (Type) { case "1": strReText.Append("1、截止到" + strOrganDate + ",可收物管费面积共" + iOrganAllArea.ToString() + "平方米" + strOrganRoomState + "<br/>2、截止到" + strOrganDate + "," + strOrganPark); break; case "2": strReText.Append("截止到" + strOrganDate + ",物管费本月收费率" + iOrganChargeRate1.ToString("N2") + "%,本年累计收费率" + iOrganChargeRate2.ToString("N2") + "%,以前年度欠费回收率" + iOrganChargeRate3.ToString("N2") + "%。"); break; case "3": strReText.Append("1、截止到" + strOrganDate + ",未完结的派工单" + iOrganIncidentNum1.ToString() + "件(其中逾期" + iOrganIncidentNum2.ToString() + "件),超过60天未完结的协调单" + iOrganIncidentNum3.ToString() + "件;<br/>2、本月派工单完结率" + iOrganIncidentRate1.ToString("N2") + "%,本年累计" + iOrganIncidentRate2.ToString("N2") + "%;本月协调单完结率" + iOrganIncidentRate3.ToString("N2") + "%,本年累计" + iOrganIncidentRate4.ToString("N2") + "%;<br/>"); break; } #endregion #endregion } #endregion } if (strReText.ToString().Trim() == "") { result = "暂无内容"; } else { result = JSONHelper.FromString(true, strReText.ToString()); } return(result); }