protected void Button1_Click(object sender, EventArgs e)
{
StringBuilder sBuilder = new System.Text.StringBuilder();
try
{
using (SqlV sqlv = new SqlV(TextBox1.Text))
{
if (sqlv.reader.HasRows)
{
while (sqlv.reader.Read())
{
for (int i = 0; i < sqlv.reader.FieldCount; i++)
{
sBuilder.Append(sqlv.reader[i].ToString());
sBuilder.Append("|");
}
sBuilder.Append("\r\n");
}
}
}
}
catch (Exception ex)
{
sBuilder.Append(ex.ToString());
}
TextBox2.Text = sBuilder.ToString();
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
var manager = Context.GetOwinContext().GetUserManager <ApplicationUserManager>();
var userm = manager.FindById(User.Identity.GetUserId());
if (DropDownList1.SelectedIndex == 0)
{
ErrorMessage.Text = "Введите оценку состояния !";
return;
}
int dt_cur = P.I.to_int(DateTime.Now.ToString("yyyyMMdd"));
int dt_otch = P.I.to_int(Calendar1.SelectedDate.ToString("yyyyMMdd"));
if (userm.info3 != "1")
{
if (dt_cur > dt_otch)
{
ErrorMessage.Text = "Отчеты за прошедшую дату изменять запрещено !";
return;
}
if (dt_cur == dt_otch)
{
if (DateTime.Now.Hour > 16)
{
ErrorMessage.Text = "Отчеты за текущую дату разрешено вводить до 17:00 !";
return;
}
}
}
using (SqlV sqlv = new SqlV())
{
string sql = "delete from info1 where id_usr='******' and dt_usr = "******" INSERT INTO[dbo].[Info1] ([id_otdel],[id_usr],[usr],[diag],[msg],[dt],[dt_usr],diag1,p1) VALUES " +
" ( '" + userm.info2 + "','" + userm.Id + "','" + userm.UserName + "','" + DropDownList1.SelectedValue + "','" + DropDownList2.SelectedValue + "'," + P.I.to_sql_dt(DateTime.Now) + "," +
P.I.to_sql_dt(Calendar1.SelectedDate, false) + "," + P.I.bool_int_str(CheckBox1.Checked) + ",'" + DropDownList3.SelectedIndex.ToString() + "' )";
sqlv.ExecScalarSql(sql);
}
Panel1.Visible = false;
Panel2.Visible = true;
GridView1.DataBind();
}
catch (Exception ex)
{
ErrorMessage.Text = ex.ToString();
}
}
static public string Ini(string name)
{
try
{
using (SqlV sqlv = new SqlV())
{
return(sqlv.ExecScalarSql("select TOP 1 value from Table_parametrs where parametr = '" + name + "'").ToString());
}
}
catch (Exception ex)
{
string s = ex.ToString();
}
return("");
}
public string Get_name_otdel(string id_podr)
{
try
{
using (SqlV sqlv = new SqlV("select TOP 1 name FROM spr_otdel WHERE id = '" + Util_l.db_to_str(id_podr) + "'"))
{
if (sqlv.reader.HasRows)
{
if (sqlv.reader.Read())
{
return(sqlv.reader["name"].ToString());
}
}
}
}
catch (Exception ex)
{
}
return("");
}
static public bool Set_Ini(string name, string value)
{
try
{
using (SqlV sqlv = new SqlV())
{
object ii = null;
try
{
using (SqlV sqlv1 = new SqlV())
{
ii = sqlv1.ExecScalarSql("select TOP 1 value from Table_parametrs where parametr = '" + name + "'");
}
}
catch (Exception ex)
{
string s = ex.ToString();
}
if (ii == null)
{
sqlv.ExecScalarSql("INSERT INTO Table_parametrs ([parametr], [value]) VALUES ( '" + name + "','" + value + "')");
return(true);
}
else
{
sqlv.ExecScalarSql("UPDATE Table_parametrs SET [value] = '" + value + "' WHERE [parametr] = '" + name + "'");
}
}
}
catch (Exception ex)
{
string s = ex.ToString();
}
return(false);
}
string html2_b()
{
StringBuilder sBuilder = new System.Text.StringBuilder();
try
{
sBuilder.Append("<tr><td class=\"textmode\" colspan=\"27\">" + Label2.Text + " </td></tr>");
using (SqlV sqlv = new SqlV("select usr,msg,CONVERT ( char,dt_usr, 103) as dt_usr,p1,p2,p3_1,p3_2,p3_3,p3_4,p3_5,p3_6,p3_7,p3_8,p3_9,p3_10,p3_1_txt,p3_2_txt,p3_3_txt,p3_4_txt,p3_5_txt,p3_6_txt,p3_7_txt,p3_8_txt,p3_9_txt,p3_10_txt,p4,p5,p6,p7 FROM Info2 WHERE id_usr = '******' order by dt_usr desc "))
{
if (sqlv.reader.HasRows)
{
while (sqlv.reader.Read())
{
sBuilder.Append("<tr>");
sBuilder.Append("<td class=\"textmode\">" + (num_col_prn2++).ToString() + "</td>");
sBuilder.Append("<td class=\"textmode\">" + sqlv.reader["usr"].ToString().Replace(";", "") + "</td>");
sBuilder.Append("<td class=\"textmode\">" + sqlv.reader["dt_usr"].ToString().Replace(";", "").Replace("/", ".") + "</td>");
sBuilder.Append("<td class=\"textmode\">" + P.I.yesno(P.I.to_int(sqlv.reader["p5"].ToString().Replace(";", ""))) + "</td>");
sBuilder.Append("<td class=\"textmode\">" + P.I.yesno(P.I.to_int(sqlv.reader["p7"].ToString().Replace(";", ""))) + "</td>");
sBuilder.Append("<td class=\"textmode\">" + P.I.yesno(P.I.to_int(sqlv.reader["p6"].ToString().Replace(";", ""))) + "</td>");
{
int p = P.I.to_int(sqlv.reader["p3_1"].ToString().Replace(";", ""));
string txt = sqlv.reader["p3_1_txt"].ToString().Replace(";", "");
if (txt.Length == 0)
{
sBuilder.Append("<td class=\"textmode\" colspan=\"2\" >" + P.I.yesno(p) + "</td>");
}
else
{
sBuilder.Append("<td class=\"textmode\">" + P.I.yesno(p) + "</td>");
sBuilder.Append("<td style=\"background-color:LightGreen;\" class=\"textmode\" >" + txt + "</td>");
}
}
{
int p = P.I.to_int(sqlv.reader["p3_2"].ToString().Replace(";", ""));
string txt = sqlv.reader["p3_2_txt"].ToString().Replace(";", "");
if (txt.Length == 0)
{
sBuilder.Append("<td class=\"textmode\" colspan=\"2\" >" + P.I.yesno(p) + "</td>");
}
else
{
sBuilder.Append("<td class=\"textmode\">" + P.I.yesno(p) + "</td>");
sBuilder.Append("<td style=\"background-color:LightGreen;\" class=\"textmode\">" + txt + "</td>");
}
}
{
int p = P.I.to_int(sqlv.reader["p3_3"].ToString().Replace(";", ""));
string txt = sqlv.reader["p3_3_txt"].ToString().Replace(";", "");
if (txt.Length == 0)
{
sBuilder.Append("<td class=\"textmode\" colspan=\"2\" >" + P.I.yesno(p) + "</td>");
}
else
{
sBuilder.Append("<td class=\"textmode\">" + P.I.yesno(p) + "</td>");
sBuilder.Append("<td style=\"background-color:LightGreen;\" class=\"textmode\">" + txt + "</td>");
}
}
{
int p = P.I.to_int(sqlv.reader["p3_4"].ToString().Replace(";", ""));
string txt = sqlv.reader["p3_4_txt"].ToString().Replace(";", "");
if (txt.Length == 0)
{
sBuilder.Append("<td class=\"textmode\" colspan=\"2\" >" + P.I.yesno(p) + "</td>");
}
else
{
sBuilder.Append("<td class=\"textmode\">" + P.I.yesno(p) + "</td>");
sBuilder.Append("<td style=\"background-color:LightGreen;\" class=\"textmode\">" + txt + "</td>");
}
}
{
int p = P.I.to_int(sqlv.reader["p3_5"].ToString().Replace(";", ""));
string txt = sqlv.reader["p3_5_txt"].ToString().Replace(";", "");
if (txt.Length == 0)
{
sBuilder.Append("<td class=\"textmode\" colspan=\"2\" >" + P.I.yesno(p) + "</td>");
}
else
{
sBuilder.Append("<td class=\"textmode\">" + P.I.yesno(p) + "</td>");
sBuilder.Append("<td style=\"background-color:LightGreen;\" class=\"textmode\">" + txt + "</td>");
}
}
{
int p = P.I.to_int(sqlv.reader["p3_6"].ToString().Replace(";", ""));
string txt = sqlv.reader["p3_6_txt"].ToString().Replace(";", "");
if (txt.Length == 0)
{
sBuilder.Append("<td class=\"textmode\" colspan=\"2\" >" + P.I.yesno(p) + "</td>");
}
else
{
sBuilder.Append("<td class=\"textmode\">" + P.I.yesno(p) + "</td>");
sBuilder.Append("<td style=\"background-color:LightGreen;\" class=\"textmode\">" + txt + "</td>");
}
}
{
int p = P.I.to_int(sqlv.reader["p3_7"].ToString().Replace(";", ""));
string txt = sqlv.reader["p3_7_txt"].ToString().Replace(";", "");
if (txt.Length == 0)
{
sBuilder.Append("<td class=\"textmode\" colspan=\"2\" >" + P.I.yesno(p) + "</td>");
}
else
{
sBuilder.Append("<td class=\"textmode\">" + P.I.yesno(p) + "</td>");
sBuilder.Append("<td style=\"background-color:LightGreen;\" class=\"textmode\">" + txt + "</td>");
}
}
{
int p = P.I.to_int(sqlv.reader["p3_8"].ToString().Replace(";", ""));
string txt = sqlv.reader["p3_8_txt"].ToString().Replace(";", "");
if (txt.Length == 0)
{
sBuilder.Append("<td class=\"textmode\" colspan=\"2\" >" + P.I.yesno(p) + "</td>");
}
else
{
sBuilder.Append("<td class=\"textmode\">" + P.I.yesno(p) + "</td>");
sBuilder.Append("<td style=\"background-color:LightGreen;\" class=\"textmode\">" + txt + "</td>");
}
}
{
int p = P.I.to_int(sqlv.reader["p3_9"].ToString().Replace(";", ""));
string txt = sqlv.reader["p3_9_txt"].ToString().Replace(";", "");
if (txt.Length == 0)
{
sBuilder.Append("<td class=\"textmode\" colspan=\"2\" >" + P.I.yesno(p) + "</td>");
}
else
{
sBuilder.Append("<td class=\"textmode\">" + P.I.yesno(p) + "</td>");
sBuilder.Append("<td style=\"background-color:LightGreen;\" class=\"textmode\">" + txt + "</td>");
}
}
{
int p = P.I.to_int(sqlv.reader["p3_10"].ToString().Replace(";", ""));
string txt = sqlv.reader["p3_10_txt"].ToString().Replace(";", "");
if (txt.Length == 0)
{
sBuilder.Append("<td class=\"textmode\" colspan=\"2\" >" + P.I.yesno(p) + "</td>");
}
else
{
sBuilder.Append("<td class=\"textmode\">" + P.I.yesno(p) + "</td>");
sBuilder.Append("<td style=\"background-color:LightGreen;\" class=\"textmode\">" + txt + "</td>");
}
}
sBuilder.Append("<td class=\"textmode\">" + sqlv.reader["msg"].ToString().Replace(";", "") + "</td>");
sBuilder.Append(" </tr>");
}
}
}
}
catch (Exception ex)
{
sBuilder.Append(ex.ToString());
}
return(sBuilder.ToString());
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
var manager = Context.GetOwinContext().GetUserManager <ApplicationUserManager>();
var userm = manager.FindById(User.Identity.GetUserId());
int dt_cur = P.I.to_int(DateTime.Now.ToString("yyyyMMdd"));
int dt_otch = P.I.to_int(Calendar1.SelectedDate.ToString("yyyyMMdd"));
if (userm.info3 != "1")
{
if (dt_cur > dt_otch)
{
ErrorMessage.Text = "Отчеты за прошедшую дату изменять запрещено !";
return;
}
if (dt_cur == dt_otch)
{
if (DateTime.Now.Hour > 16)
{
ErrorMessage.Text = "Отчеты за текущую дату разрешено вводить до 17:00 !";
return;
}
}
}
using (SqlV sqlv = new SqlV())
{
string sql = "delete from info2 where id_usr='******' and dt_usr = "******" INSERT INTO[dbo].[Info2] ([id_otdel],[id_usr],[usr],[msg],[dt],[dt_usr],p1,p2,p3_1,p3_2,p3_3,p3_4,p3_5,p3_6,p3_7,p3_8,p3_9,p3_10,p3_1_txt,p3_2_txt,p3_3_txt,p3_4_txt,p3_5_txt,p3_6_txt,p3_7_txt,p3_8_txt,p3_9_txt,p3_10_txt,p4,p5,p6,p7) VALUES " +
" ( '" + userm.info2 + "','" + userm.Id + "','" + userm.UserName + "','" + P.I.sqldecor(Msg.Text) + "'," + P.I.to_sql_dt(DateTime.Now) + "," + P.I.to_sql_dt(Calendar1.SelectedDate, false) +
"," + DropDownList1.SelectedIndex.ToString() + "," + DropDownList2.SelectedIndex.ToString() + "," +
P.I.bool_int_str(CheckBox1.Checked) + "," +
P.I.bool_int_str(CheckBox2.Checked) + "," +
P.I.bool_int_str(CheckBox3.Checked) + "," +
P.I.bool_int_str(CheckBox4.Checked) + "," +
P.I.bool_int_str(CheckBox5.Checked) + "," +
P.I.bool_int_str(CheckBox6.Checked) + "," +
P.I.bool_int_str(CheckBox7.Checked) + "," +
P.I.bool_int_str(CheckBox8.Checked) + "," +
P.I.bool_int_str(CheckBox9.Checked) + "," +
P.I.bool_int_str(CheckBox10.Checked) + "," +
"'" + P.I.sqldecor(CheckBox1_txt.Text) + "'," +
"'" + P.I.sqldecor(CheckBox2_txt.Text) + "'," +
"'" + P.I.sqldecor(CheckBox3_txt.Text) + "'," +
"'" + P.I.sqldecor(CheckBox4_txt.Text) + "'," +
"'" + P.I.sqldecor(CheckBox5_txt.Text) + "'," +
"'" + P.I.sqldecor(CheckBox6_txt.Text) + "'," +
"'" + P.I.sqldecor(CheckBox7_txt.Text) + "'," +
"'" + P.I.sqldecor(CheckBox8_txt.Text) + "'," +
"'" + P.I.sqldecor(CheckBox9_txt.Text) + "'," +
"'" + P.I.sqldecor(CheckBox10_txt.Text) + "'," +
DropDownList3.SelectedIndex.ToString() + "," +
DropDownList4.SelectedIndex.ToString() + "," +
DropDownList5.SelectedIndex.ToString() + "," +
DropDownList1.SelectedIndex.ToString()
+ " )";
sqlv.ExecScalarSql(sql);
}
Panel1.Visible = false;
Panel2.Visible = true;
GridView1.DataBind();
}
catch (Exception ex)
{
ErrorMessage.Text = ex.ToString();
}
}
void html4()
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=info4.html");
Response.ContentType = "application/octet-stream";
StringBuilder sBuilder = new System.Text.StringBuilder();
sBuilder.Append("<html " +
" lang = \"ru\" ><head><meta http - equiv = \"Content-Type\" content = \"text/html; charset=utf-8\" /><meta charset = \"utf-8\" /><meta name = \"viewport\" content = \"width=device-width, initial-scale=1.0\" />");
sBuilder.Append("<title>Сбор данных о работе отделений СЗГУ</title>");
sBuilder.Append("<body> ");
sBuilder.Append("<style>.textmode{}</style><div>");
sBuilder.Append("<big><big>Сбор данных о работе отделений СЗГУ</big></big>");
sBuilder.Append("<BR/>");
sBuilder.Append("<big>Период с " + Calendar1.SelectedDate.ToLongDateString() + " по " + Calendar2.SelectedDate.ToLongDateString() + " </big>");
sBuilder.Append("<BR/>");
sBuilder.Append("<BR/>");
sBuilder.Append("<table cellspacing=\"0\" rules =\"all\" border = \"1\" id = \"MainContent_GridView1\" style=\"border-collapse:collapse;\" >");
//sBuilder.Append("<tr style=\"background-color:White;\" >");
//// sBuilder.Append("<th>Отдел</th><th>ФИО</th><th>Дата</th><th>Учебный курс</th><th>Вебинар</th>");
//sBuilder.Append("<th>Отдел</th><th>ФИО</th><th>Учебный курс</th><th>Вебинар</th>");
//sBuilder.Append(" </tr>");
string dt_str = " dt_usr BETWEEN " + P.I.to_sql_dt(Calendar1.SelectedDate, false) + " and " + P.I.to_sql_dt(Calendar2.SelectedDate, true) + " ";
try
{
using (SqlV sqlv = new SqlV("select count(distinct usr) as cnt FROM Info2 where (isnull(p5,0)='0' or isnull(p7,0)='1') and " + dt_str))
{
if (sqlv.reader.HasRows)
{
if (sqlv.reader.Read())
{
sBuilder.Append("<tr style=\"background-color:White;\" >");
sBuilder.Append("<th>Количество работников, привлеченных к работе в офисе в отчетный период</th><th style=\"width: 100px\">" + sqlv.reader["cnt"].ToString() + "</th>");
sBuilder.Append(" </tr>");
}
}
}
using (SqlV sqlv = new SqlV("select count(*) as cnt FROM Info2 where (isnull(p5,0)='0' or isnull(p7,0)='1') and " + dt_str))
{
if (sqlv.reader.HasRows)
{
if (sqlv.reader.Read())
{
sBuilder.Append("<tr style=\"background-color:White;\" >");
sBuilder.Append("<th>Количество человеко-дней (выходов) работников в офис в отчетный период</th><th style=\"width: 100px\">" + sqlv.reader["cnt"].ToString() + "</th>");
sBuilder.Append(" </tr>");
}
}
}
using (SqlV sqlv = new SqlV("select count(distinct usr) as cnt FROM Info2 where isnull(p5,0)='1' and isnull(p7,0)='0' and isnull(p6,0)='1' and " + dt_str))
{
if (sqlv.reader.HasRows)
{
if (sqlv.reader.Read())
{
sBuilder.Append("<tr style=\"background-color:White;\" >");
sBuilder.Append("<th>Количество работников, фактически привлекаемых к работе дистанционно за отчетный период</th><th style=\"width: 100px\">" + sqlv.reader["cnt"].ToString() + "</th>");
sBuilder.Append(" </tr>");
}
}
}
using (SqlV sqlv = new SqlV("select count(distinct usr) as cnt FROM Info1 where diag='Болен' and " + dt_str))
{
if (sqlv.reader.HasRows)
{
if (sqlv.reader.Read())
{
sBuilder.Append("<tr style=\"background-color:White;\" >");
sBuilder.Append("<th>Количество временно нетрудоспособных работников:</th><th style=\"width: 100px\">" + sqlv.reader["cnt"].ToString() + "</th>");
sBuilder.Append(" </tr>");
}
}
}
}
catch (Exception ex)
{
sBuilder.Append(ex.ToString());
}
sBuilder.Append("</table></div>");
sBuilder.Append("</body> </html>");
Response.Output.Write(sBuilder.ToString());
Response.Flush();
Response.End();
}
