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(); }