static List <sp_values> __RepPerList(int YY, int MM)
{
List <sp_values> tmpList = new List <sp_values>();
DateTime dtB = new DateTime(YY, MM, 1);
DateTime dtE = DateTime.Today;
//if(dtB)
//while((dtB.Year*12+dtB.Month%6) <= (dtE.Year*12+dtE.Month%6))
while (dtB <= dtE)
{
sp_values tmp_sp = new sp_values();
if (dtB.Month > 6)
{
tmp_sp.ID = dtB.Year.ToString() + "/2";
}
else
{
tmp_sp.ID = dtB.Year.ToString() + "/1";
}
tmp_sp.Text = tmp_sp.ID;
dtB = dtB.AddMonths(6);
tmpList.Add(tmp_sp);
}
return(tmpList);
}
public static SelectList repMOList(int y, int m, string f)
{
List <sp_values> tmpList = new List <sp_values>();
DateTime dtB = new DateTime(y, m, 1);
DateTime dtE = DateTime.Today;
tmpList.Add(new sp_values()
{
ID = "",
Text = "-все-"
});
while (dtB <= dtE)
{
sp_values tmp_sp = new sp_values
{
ID = dtB.ToString("MM yyyy"),//dtB.Month.ToString(),
Text = mmm[dtB.Month - 1] + " " + dtB.Year.ToString()
};
dtB = dtB.AddMonths(1);
tmpList.Add(tmp_sp);
}
var sl = new SelectList(tmpList, "ID", "Text");
foreach (var item in sl)
{
if (item.Value == f)
{
item.Selected = true;
break;
}
}
return(sl);//new SelectList(tmpList,"ID","Text");
}
public static SelectList KIDdisList()
{
List <sp_values> tmpList = new List <sp_values>();
tmpList.Add(new sp_values {
ID = "", Text = ""
});
using (SqlConnection _conn = new SqlConnection(connStr))
{
SqlCommand cmd = new SqlCommand("SELECT KID, Disease FROM [d2DISEASES] order by Disease", _conn);
_conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
sp_values tmp = new sp_values();
{
tmp.ID = dr["KID"].ToString();
tmp.Text = dr["Disease"].ToString().Trim();
}
tmpList.Add(tmp);
}
_conn.Close();
}
return(new SelectList(tmpList, "ID", "Text"));
}
public static SelectList ReportToToday()
{
List <sp_values> tmpList = new List <sp_values>();
DateTime dtB = new DateTime(DateTime.Today.Year - 1, 1, 1);
DateTime dtE = DateTime.Today;
while (dtB <= dtE)
{
sp_values tmp_sp = new sp_values
{
ID = dtB.ToString("MM yyyy"),//dtB.Month.ToString(),
Text = mmm[dtB.Month - 1] + " " + dtB.Year.ToString()
};
dtB = dtB.AddMonths(1);
tmpList.Add(tmp_sp);
}
SelectList sl = new SelectList(tmpList, "ID", "Text");
string dv = DateTime.Today.ToString("MM yyyy");
foreach (var it in sl)
{
if (it.Value.ToString() == dv)
{
it.Selected = true;
}
}
return(sl);//new SelectList(tmpList,"ID","Text");
}
public static SelectList RaionsList()
{
List <sp_values> tmpList = new List <sp_values>();
tmpList.Add(new sp_values()
{
ID = "", Text = "ВСЕ районы"
});
using (SqlConnection _conn = new SqlConnection(connStr))
{
SqlCommand cmd = new SqlCommand("SELECT SocUnit as ID, SocUnit FROM [72GEO2]" +
" ORDER BY SocUnit",
_conn);
_conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
sp_values tmp = new sp_values();
{
tmp.ID = dr["ID"].ToString();
tmp.Text = dr["Socunit"].ToString().Trim();
}
tmpList.Add(tmp);
}
_conn.Close();
}
return(new SelectList(tmpList, "ID", "Text", tmpList[0].ID));
}
public static List <sp_values> __RepMO1YearList(int YY, int MM)
{
List <sp_values> tmpList = new List <sp_values>();
DateTime dtB = new DateTime(YY, MM, 1);
DateTime dtE = DateTime.Today;
while (dtB <= dtE)
{
sp_values tmp_sp = new sp_values
{
ID = dtB.ToString().Trim(),
Text = mmm[dtB.Month - 1] + " " + dtB.Year.ToString()
};
dtB = dtB.AddMonths(1);
tmpList.Add(tmp_sp);
}
return(tmpList);
}
public static SelectList KIDspcList()
{
List <sp_values> tmpList = new List <sp_values>();
using (SqlConnection _conn = new SqlConnection(connStr))
{
SqlCommand cmd = new SqlCommand("SELECT KID, Species FROM [d2SPECIES]", _conn);
_conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
sp_values tmp = new sp_values();
{
tmp.ID = dr["KID"].ToString();
tmp.Text = dr["Species"].ToString().Trim();
}
tmpList.Add(tmp);
}
_conn.Close();
}
return(new SelectList(tmpList, "ID", "Text"));
}
public static SelectList testList()
{
List <sp_values> tmpList = new List <sp_values>();
using (SqlConnection _conn = new SqlConnection(connStr))
{
SqlCommand cmd = new SqlCommand(@"SELECT KID,Testname FROM [d2TESTS]", _conn);
_conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
sp_values tmp = new sp_values();
{
//tmp.ID = dr["KID"].ToString().Trim();
tmp.ID = dr["KID"].ToString();
tmp.Text = dr["Testname"].ToString().Trim();
}
tmpList.Add(tmp);
}
_conn.Close();
}
//return new SelectList(tmpList, "ID", "Text", tmpList[0].ID);
return(new SelectList(tmpList, "ID", "Text"));
}
public static SelectList KIDdivList(string KIDro)
{
List <sp_values> tmpList = new List <sp_values>();
using (SqlConnection _conn = new SqlConnection(connStr))
{
SqlCommand cmd = new SqlCommand("SELECT gAID as KID,Socunit FROM[73GEO3] " +
"INNER JOIN[1VETUNITS] ON[1VETUNITS].KIDray =[73GEO3].gRID " +
"WHERE[1VETUNITS].KID = '" + KIDro + "'", _conn);
_conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
sp_values tmp = new sp_values();
{
tmp.ID = dr["KID"].ToString();
tmp.Text = dr["Socunit"].ToString().Replace("АИЛЬНЫЙ ОКРУГ", "").Trim();
}
tmpList.Add(tmp);
}
_conn.Close();
}
return(new SelectList(tmpList, "ID", "Text", tmpList[0].ID));
}
