public commandSQL ( string command, SqlConnection myConnection ) : ].string[ | ||
command | string | |
myConnection | SqlConnection | |
리턴 | ].string[ |
public void Submit(object sender, EventArgs e) { string query = "select cmel, solod, voda from beer"; string[,] matrix = new string[Convert.ToInt32(text2.Text), 3]; WithMSSQL con1 = new WithMSSQL(); matrix = con1.commandSQL(query, con1.connectToSQL(auth_str)); /*WithMSSQL con1 = new WithMSSQL();*/ query = "select light, dark, smooth from calendar where week between " + text1.Text + " and " + (text1.Text + text2.Text + 2) + "order by week"; string[,] matrix2 = new string[3, 3]; matrix2 = con1.commandSQL(query, con1.connectToSQL(auth_str)); Label2.Text = "<table border='0' cellspacing='2' cellpadding='2' width='100%' bgcolor='#ffffff'>"; Label2.Text += "<tr style='color:#666; font-size: 100%;'><td>Номер недели/Сорт пива</td><td>Светлое</td><td>Тёмное</td><td>Нефильтрованное</td>"; int help = 0; for (int i = 0; i < (Convert.ToInt32(text2.Text) + 2); i++) { if (i == Convert.ToInt32(text2.Text)) { Label2.Text += "<tr><td style='color:#777; font-size: 80%;'> И поставки на следующие 2 недели</td></tr>"; } Label2.Text += "<tr style='color:#999; font-size: 80%;'>"; help = Convert.ToInt32(text1.Text) + i; Label2.Text += "<td>" + help + "</td>"; for (int j = 0; j < 3; j++) { Label2.Text += "<td>" + matrix2[i, j] + "</td>"; } Time.Text += "</tr>"; } int cmel = 0; int solod = 0; int voda = 0; for (int i = 0; i < Convert.ToInt32(text2.Text); i++) { cmel += Convert.ToInt32(matrix[0, 0]) * Convert.ToInt32(matrix2[i, 0]) + Convert.ToInt32(matrix[1, 0]) * Convert.ToInt32(matrix2[i, 1]) + Convert.ToInt32(matrix[2, 0]) * Convert.ToInt32(matrix2[i, 2]); solod += Convert.ToInt32(matrix[0, 1]) * Convert.ToInt32(matrix2[i, 0]) + Convert.ToInt32(matrix[1, 1]) * Convert.ToInt32(matrix2[i, 1]) + Convert.ToInt32(matrix[2, 1]) * Convert.ToInt32(matrix2[i, 2]);; voda += Convert.ToInt32(matrix[0, 2]) * Convert.ToInt32(matrix2[i, 0]) + Convert.ToInt32(matrix[1, 2]) * Convert.ToInt32(matrix2[i, 1]) + Convert.ToInt32(matrix[2, 2]) * Convert.ToInt32(matrix2[i, 2]);;; } Label1.Text = "<p>Итого: к " + text1.Text + "ой неделе понадобится единиц ХМЕЛЯ, СОЛОДА и ВОДЫ соответственно"; Label1.Text += cmel + " " + solod + " " + voda + "</p>"; }
public void Submit(object sender, EventArgs e) { string query = "select cmel, solod, voda from beer"; string[,] matrix = new string[Convert.ToInt32(text2.Text), 3]; WithMSSQL con1 = new WithMSSQL(); matrix = con1.commandSQL(query, con1.connectToSQL(auth_str)); /*WithMSSQL con1 = new WithMSSQL();*/ query = "select light, dark, smooth from calendar where week between " + text1.Text + " and " + (text1.Text + text2.Text + 2) + "order by week"; string[,] matrix2 = new string[3, 3]; matrix2 = con1.commandSQL(query, con1.connectToSQL(auth_str)); Label2.Text = "<table border='0' cellspacing='2' cellpadding='2' width='100%' bgcolor='#ffffff'>"; Label2.Text += "<tr style='color:#666; font-size: 100%;'><td>Номер недели/Сорт пива</td><td>Светлое</td><td>Тёмное</td><td>Нефильтрованное</td>"; int help = 0; for (int i = 0; i < (Convert.ToInt32(text2.Text) + 2); i++) { if (i == Convert.ToInt32(text2.Text)) Label2.Text += "<tr><td style='color:#777; font-size: 80%;'> И поставки на следующие 2 недели</td></tr>"; Label2.Text += "<tr style='color:#999; font-size: 80%;'>"; help = Convert.ToInt32(text1.Text) + i; Label2.Text += "<td>" + help + "</td>"; for (int j = 0; j < 3; j++) { Label2.Text += "<td>" + matrix2[i, j] + "</td>"; } Time.Text += "</tr>"; } int cmel = 0; int solod = 0; int voda = 0; for (int i = 0; i < Convert.ToInt32(text2.Text); i++) { cmel += Convert.ToInt32(matrix[0, 0]) * Convert.ToInt32(matrix2[i, 0]) + Convert.ToInt32(matrix[1, 0]) * Convert.ToInt32(matrix2[i, 1]) + Convert.ToInt32(matrix[2, 0]) * Convert.ToInt32(matrix2[i, 2]); solod += Convert.ToInt32(matrix[0, 1]) * Convert.ToInt32(matrix2[i, 0]) + Convert.ToInt32(matrix[1, 1]) * Convert.ToInt32(matrix2[i, 1]) + Convert.ToInt32(matrix[2, 1]) * Convert.ToInt32(matrix2[i, 2]); ; voda += Convert.ToInt32(matrix[0, 2]) * Convert.ToInt32(matrix2[i, 0]) + Convert.ToInt32(matrix[1, 2]) * Convert.ToInt32(matrix2[i, 1]) + Convert.ToInt32(matrix[2, 2]) * Convert.ToInt32(matrix2[i, 2]); ; ; } Label1.Text = "<p>Итого: к " + text1.Text + "ой неделе понадобится единиц ХМЕЛЯ, СОЛОДА и ВОДЫ соответственно"; Label1.Text += cmel + " " + solod + " " + voda + "</p>"; }
public void Add(object sender, EventArgs e) { string query = "insert into [planing].[dbo].[calendar]([week],[light],[smooth],[dark])values(" + TextBox4.Text + "," + TextBox1.Text + "," + TextBox2.Text + "," + TextBox3.Text + ")"; string[,] matrix = new string[3, 3]; WithMSSQL con1 = new WithMSSQL(); matrix = con1.commandSQL(query, con1.connectToSQL(auth_str)); }
protected void Page_Load(object sender, EventArgs e) { SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(); //builder["Provider"] = "provider=SQLOLEDB.1"; builder["Server"] = "(local)"; builder["Integrated Security"] = "true"; //builder["User Instance"] = "false"; builder["Database"] = "planing"; //builder["uid"] = "a"; //builder["password"] = ""; //builder["Pooling"] = "False"; auth_str = builder.ConnectionString; //Console.WriteLine(builder.ConnectionString); WithMSSQL con1 = new WithMSSQL(); string query = "select cmel, solod, voda from beer"; string[,] matrix = new string[3, 3]; matrix = con1.commandSQL(query, con1.connectToSQL(auth_str)); Time.Text = "<table border='0' cellspacing='2' cellpadding='2' width='100%' bgcolor='#ffffff'>"; Time.Text += "<tr style='color:#666; font-size: 100%;'><td>Сорт пива/Ингридиенты</td><td>Хмель</td><td>Солод</td><td>Вода</td>"; for (int i = 0; i < 3; i++) { Time.Text += "<tr style='color:#999; font-size: 80%;'>"; if (i == 0) { Time.Text += "<td>Светлое</td>"; } if (i == 1) { Time.Text += "<td>Тёмное</td>"; } if (i == 2) { Time.Text += "<td>Нефильтрованное</td>"; } for (int j = 0; j < 3; j++) { Time.Text += "<td>" + matrix[i, j] + "</td>"; } Time.Text += "</tr>"; } }
protected void Page_Load(object sender, EventArgs e) { SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(); //builder["Provider"] = "provider=SQLOLEDB.1"; builder["Server"] = "(local)"; builder["Integrated Security"] = "true"; //builder["User Instance"] = "false"; builder["Database"] = "planing"; //builder["uid"] = "a"; //builder["password"] = ""; //builder["Pooling"] = "False"; auth_str = builder.ConnectionString; //Console.WriteLine(builder.ConnectionString); WithMSSQL con1 = new WithMSSQL(); string query = "select cmel, solod, voda from beer"; string[,] matrix = new string[3, 3]; matrix = con1.commandSQL(query, con1.connectToSQL(auth_str)); Time.Text = "<table border='0' cellspacing='2' cellpadding='2' width='100%' bgcolor='#ffffff'>"; Time.Text += "<tr style='color:#666; font-size: 100%;'><td>Сорт пива/Ингридиенты</td><td>Хмель</td><td>Солод</td><td>Вода</td>"; for (int i = 0; i < 3; i++ ) { Time.Text += "<tr style='color:#999; font-size: 80%;'>"; if (i == 0) Time.Text += "<td>Светлое</td>"; if (i == 1) Time.Text += "<td>Тёмное</td>"; if (i == 2) Time.Text += "<td>Нефильтрованное</td>"; for (int j=0; j<3; j++) { Time.Text += "<td>" + matrix[i,j] + "</td>"; } Time.Text += "</tr>"; } }
public void Add(object sender, EventArgs e) { string query = "insert into [planing].[dbo].[calendar]([week],[light],[smooth],[dark])values(" + TextBox4.Text + "," + TextBox1.Text + "," + TextBox2.Text + "," + TextBox3.Text + ")"; string[,] matrix = new string[3, 3]; WithMSSQL con1 = new WithMSSQL(); matrix = con1.commandSQL(query, con1.connectToSQL(auth_str)); }