public List <DistinctArray> getDistinctGroup(string recid)
{
string sqlWhere = "select t.belongdistrict,t.belongdistrictid,t.BelongDistrictCode from BIS_SAFTYCHECKDATADETAILED t where RECID='" + recid + "' group by t.belongdistrict,t.belongdistrictid,t.BelongDistrictCode ";
DataTable dt = this.BaseRepository().FindTable(sqlWhere);
List <DistinctArray> listarr = new List <DistinctArray>();
foreach (DataRow item in dt.Rows)
{
DistinctArray arr = new DistinctArray();
arr.areaname = item[0].ToString();
arr.areanameid = item[1].ToString();
arr.areanamecode = item[2].ToString();
string sqlD = string.Format(@"select disreictchargeperson,b.userid as disreictchargepersonid,chargedept,chargedeptcode,b.mobile as linktel from bis_district a
left join base_user b on a.disreictchargepersonid=b.account where districtid='{0}'", item[1].ToString());
DataTable dtD = this.BaseRepository().FindTable(sqlD);
if (dtD.Rows.Count > 0)
{
arr.disreictchargeperson = dtD.Rows[0][0].ToString();
arr.disreictchargepersonid = dtD.Rows[0][1].ToString();
arr.chargedept = dtD.Rows[0][2].ToString();
arr.chargedeptcode = dtD.Rows[0][3].ToString();
arr.linktel = dtD.Rows[0][4].ToString();
}
string sqlWhere2 = "select t.riskName as riskname,id as risknameid from BIS_SAFTYCHECKDATADETAILED t where RECID='" + recid + "' and belongdistrictid='" + item[1].ToString() + "'";
arr.riskdescarray = this.BaseRepository().FindTable(sqlWhere2);
listarr.Add(arr);
}
return(listarr);
}
public List <DistinctArray> getDistinctGroupDj(string recid, string checkdatatype, Operator user)
{
var sqlWhere = "";
if (checkdatatype == "1")
{
sqlWhere = "select t.belongdistrict,t.belongdistrictid,t.BelongDistrictCode from BIS_SAFTYCHECKDATADETAILED t where RECID='" + recid + "' group by t.belongdistrict,t.belongdistrictid,t.BelongDistrictCode ";
}
else
{
sqlWhere = string.Format(@"select b.belongdistrict,b.belongdistrictid,b.BelongDistrictCode from BIS_SAFTYCONTENT a left join BIS_SAFTYCHECKDATADETAILED b
on a.DETAILID=b.id where instr(checkmanaccount,'{0}')>0 and a.recid='{1}'
and DETAILID in (select id from BIS_SAFTYCHECKDATADETAILED where recid='{1}')
group by b.belongdistrict,b.belongdistrictid,b.BelongDistrictCode", user.Account, recid);
}
DataTable dt = this.BaseRepository().FindTable(sqlWhere);
List <DistinctArray> listarr = new List <DistinctArray>();
foreach (DataRow item in dt.Rows)
{
DistinctArray arr = new DistinctArray();
arr.areaname = item[0].ToString();
arr.areanameid = item[1].ToString();
arr.areanamecode = item[2].ToString();
string sqlD = string.Format(@"select disreictchargeperson,b.userid as disreictchargepersonid,chargedept,chargedeptcode,b.mobile as linktel from bis_district a
left join base_user b on a.disreictchargepersonid=b.account where districtid='{0}'", item[1].ToString());
DataTable dtD = this.BaseRepository().FindTable(sqlD);
if (dtD.Rows.Count > 0)
{
arr.disreictchargeperson = dtD.Rows[0][0].ToString();
arr.disreictchargepersonid = dtD.Rows[0][1].ToString();
arr.chargedept = dtD.Rows[0][2].ToString();
arr.chargedeptcode = dtD.Rows[0][3].ToString();
arr.linktel = dtD.Rows[0][4].ToString();
}
if (checkdatatype == "1")
{
string sqlWhere2 = "select t.riskName as riskname,id as risknameid from BIS_SAFTYCHECKDATADETAILED t where RECID='" + recid + "' and belongdistrictid='" + item[1].ToString() + "'";
arr.riskdescarray = this.BaseRepository().FindTable(sqlWhere2);
}
else
{
string sqlWhere2 = string.Format(@"select b.riskname as riskname,b.id as risknameid,belongdistrictid from BIS_SAFTYCONTENT a left join BIS_SAFTYCHECKDATADETAILED b
on a.DETAILID=b.id where instr(checkmanaccount,'{0}')>0 and a.recid='{1}'
and DETAILID in (select id from BIS_SAFTYCHECKDATADETAILED where recid='{1}')
and belongdistrictid='{2}'", user.Account, recid, item[1].ToString());
arr.riskdescarray = this.BaseRepository().FindTable(sqlWhere2);
}
listarr.Add(arr);
}
return(listarr);
}
