API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 25th, 2018
161
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 17.51 KB | None | 0 0
raw download clone embed print report
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Data.SqlClient;
  6. using System.Drawing;
  7. using System.Linq;
  8. using System.Text;
  9. using System.Threading.Tasks;
  10. using System.Windows.Forms;
  11.  
  12. namespace WindowsFormsApp6
  13. {
  14. public partial class Form1 : Form
  15. {
  16. SqlConnection sqlConnection;
  17. public Form1()
  18. {
  19. InitializeComponent();
  20. }
  21.  
  22. private async void Form1_Load(object sender, EventArgs e)
  23. {
  24. string connectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\ZZZ\source\repos\WindowsFormsApp6\Forces of Evil.mdf;Integrated Security=True;Connect Timeout=30";
  25. sqlConnection = new SqlConnection(connectionString);
  26. await sqlConnection.OpenAsync();
  27. SqlDataReader sqlReader = null;
  28. SqlCommand command = new SqlCommand("SELECT *FROM[detal],[nomer],[postavhik],[remont],[tip_tehiki]", sqlConnection);
  29. try
  30. {
  31. sqlReader = await command.ExecuteReaderAsync();
  32.  
  33. while (await sqlReader.ReadAsync())
  34. {
  35. //name,got,idpa,jahr,ceha,kolvo,idto
  36. //"nain_delnomerproijvoditelkol_votype_tehikiind
  37. // listBox1.Items.Add(Convert.ToString(sqlReader["nain_del"]) + " " + Convert.ToString(sqlReader["nomer"]) + " " + Convert.ToString(sqlReader["proijvoditel"]) + " " + Convert.ToString(sqlReader["kol_vo"]) + " " + Convert.ToString(sqlReader["type_tehiki"]) + " " + Convert.ToString(sqlReader["ind"]));
  38. //type_tehiki,model,nomer,potracheho_ha_remoht,garahtihi_crok,cislitca_c,kolvo_remontov,ind"]));
  39. //type_tehiki,data,jakypleho_ha_cymmy,adrec,naim_del,ind,ima;
  40. // nomer,model,data",voditel,prichiha,vrema_remonta,remonty_podlejit,type_tehiki,ind;
  41. //type_tehiki,proizvoditel,model,potracheho_ha_remoht,ha_remonte,ind
  42.  
  43. listBox1.Items.Add(Convert.ToString(sqlReader["naim_del"]) + " " + Convert.ToString(sqlReader["nomer"]) + " " + Convert.ToString(sqlReader["proijvoditel"]) + " " + Convert.ToString(sqlReader["kol_vo"]) + " " + Convert.ToString(sqlReader["type_tehiki"]) + " " + Convert.ToString(sqlReader["ind"]));
  44. listBox2.Items.Add(Convert.ToString(sqlReader["type_tehiki"]) + " " + Convert.ToString(sqlReader["model"]) + " " + Convert.ToString(sqlReader["nomer"]) + " " + Convert.ToString(sqlReader["potracheho_ha_remoht"])+" "+ Convert.ToString(sqlReader["garahtihi_crok"]) +" "+ Convert.ToString(sqlReader["cislitca_c"]) +" "+ Convert.ToString(sqlReader["kolvo_remontov"])+" " + Convert.ToString(sqlReader["ind"]));
  45. listBox3.Items.Add(Convert.ToString(sqlReader["type_tehiki"]) + " " + Convert.ToString(sqlReader["data"]) + " " + Convert.ToString(sqlReader["jakypleho_ha_cymmy"]) + " " + Convert.ToString(sqlReader["adrec"]) + " " + Convert.ToString(sqlReader["naim_del"]) + " " + Convert.ToString(sqlReader["ind"]) + " " + Convert.ToString(sqlReader["ima"]));
  46. listBox4.Items.Add(Convert.ToString(sqlReader["nomer"]) + " " + Convert.ToString(sqlReader["model"]) + " " + Convert.ToString(sqlReader["data"]) + " " + Convert.ToString(sqlReader["voditel"])+ " " + Convert.ToString(sqlReader["prichiha"]) + " " + Convert.ToString(sqlReader["vrema_remonta"]) + " " + Convert.ToString(sqlReader["remonty_podlejit"]) + " " + Convert.ToString(sqlReader["type_tehiki"]) + " " + Convert.ToString(sqlReader["ind"]));
  47. listBox5.Items.Add(Convert.ToString(sqlReader["type_tehiki"]) + " " + Convert.ToString(sqlReader["proizvoditel"]) + " " + Convert.ToString(sqlReader["model"]) + " " + Convert.ToString(sqlReader["potracheho_ha_remoht"]) + " " + Convert.ToString(sqlReader["ha_remonte"]) + " " + Convert.ToString(sqlReader["ind"]));
  48. }
  49. }
  50. catch (Exception ex)
  51. {
  52. MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
  53.  
  54. }
  55. finally
  56. {
  57. if (sqlReader != null)
  58. sqlReader.Close();
  59. }
  60. }
  61. private void выходToolStripMenuItem_Click(object sender, EventArgs e)
  62. {
  63. if (sqlConnection != null && sqlConnection.State != ConnectionState.Closed)
  64. sqlConnection.Close();
  65. }
  66.  
  67. private void Form1_FormClosing(object sender, FormClosingEventArgs e)
  68. {
  69. if (sqlConnection != null && sqlConnection.State != ConnectionState.Closed)
  70. sqlConnection.Close();
  71. }
  72. private async void button1_Click(object sender, EventArgs e)
  73. {
  74. SqlCommand command = new SqlCommand("INSERT [detal] (naim_del,nomer,proijvoditel,kol_vo,type_tehiki,ind)VALUES (@naim_del,@nomer,@proijvoditel,@kol_vo,@type_tehiki,@ind)", sqlConnection);
  75. command.Parameters.AddWithValue("naim_del", textBox15.Text);
  76. command.Parameters.AddWithValue("nomer", textBox14.Text);
  77. command.Parameters.AddWithValue("proijvoditel", textBox13.Text);
  78. command.Parameters.AddWithValue("kol_vo", textBox12.Text);
  79. command.Parameters.AddWithValue("type_tehiki", textBox11.Text);
  80. command.Parameters.AddWithValue("ind", textBox20.Text);
  81.  
  82. await command.ExecuteNonQueryAsync();
  83. }
  84. private async void button6_Click(object sender, EventArgs e)
  85. {
  86. SqlCommand command = new SqlCommand("INSERT [nomer] (type_tehiki,model,nomer,potracheho_ha_remoht,garahtihi_crok,cislitca_c,kolvo_remontov,ind)VALUES (@type_tehiki,@model,@nomer,@potracheho_ha_remoht,@garahtihi_crok,@cislitca_c,@kolvo_remontov,@ind)", sqlConnection);
  87. command.Parameters.AddWithValue("type_tehiki", textBox27.Text);
  88. command.Parameters.AddWithValue("model", textBox26.Text);
  89. command.Parameters.AddWithValue("nomer", textBox23.Text);
  90. command.Parameters.AddWithValue("potracheho_ha_remoht", textBox25.Text);
  91. command.Parameters.AddWithValue("garahtihi_crok", textBox24.Text);
  92. command.Parameters.AddWithValue("cislitca_c", textBox32.Text);
  93. command.Parameters.AddWithValue("kolvo_remontov", textBox31.Text);
  94. command.Parameters.AddWithValue("ind", textBox28.Text);
  95. await command.ExecuteNonQueryAsync();
  96. }
  97. private async void button9_Click(object sender, EventArgs e)
  98. {
  99. SqlCommand command = new SqlCommand("INSERT [postavhik] (type_tehiki,data,jakypleho_ha_cymmy,adrec,naim_del,ind,ima)VALUES (@type_tehiki,@data,@jakypleho_ha_cymmy,@adrec,@naim_del,@ind,@ima)", sqlConnection);
  100. command.Parameters.AddWithValue("type_tehiki", textBox48.Text);
  101. command.Parameters.AddWithValue("data", textBox47.Text);
  102. command.Parameters.AddWithValue("jakypleho_ha_cymmy", textBox44.Text);
  103. command.Parameters.AddWithValue("adrec", textBox46.Text);
  104. command.Parameters.AddWithValue("naim_del", textBox45.Text);
  105. command.Parameters.AddWithValue("ind", textBox53.Text);
  106. command.Parameters.AddWithValue("ima", textBox52.Text);
  107. await command.ExecuteNonQueryAsync();
  108. }
  109. private async void button12_Click(object sender, EventArgs e)
  110. {
  111. SqlCommand command = new SqlCommand("INSERT [remont] (nomer,model,data, voditel, prichiha, vrema_remonta, remonty_podlejit, type_tehiki, ind)VALUES (@nomer,@model,@data,@voditel,@prichiha,@vrema_remonta,@remonty_podlejit,@type_tehiki,@ind)", sqlConnection);
  112. command.Parameters.AddWithValue("nomer", textBox69.Text);
  113. command.Parameters.AddWithValue("model", textBox68.Text);
  114. command.Parameters.AddWithValue("data", textBox65.Text);
  115. command.Parameters.AddWithValue("voditel", textBox67.Text);
  116. command.Parameters.AddWithValue("prichiha", textBox66.Text);
  117. command.Parameters.AddWithValue("vrema_remonta", textBox74.Text);
  118. command.Parameters.AddWithValue("remonty_podlejit", textBox73.Text);
  119. command.Parameters.AddWithValue("type_tehiki", textBox70.Text);
  120. command.Parameters.AddWithValue("ind", textBox72.Text);
  121. await command.ExecuteNonQueryAsync();
  122. }
  123. private async void button15_Click(object sender, EventArgs e)
  124. {
  125. SqlCommand command = new SqlCommand("INSERT [tip_tehiki] (type_tehiki,proizvoditel,model,potracheho_ha_remoht,ha_remonte,ind)VALUES (@type_tehiki,@proizvoditel,@model,@potracheho_ha_remoht,@ha_remonte,@ind)", sqlConnection);
  126. command.Parameters.AddWithValue("type_tehiki", textBox90.Text);
  127. command.Parameters.AddWithValue("proizvoditel", textBox89.Text);
  128. command.Parameters.AddWithValue("model", textBox86.Text);
  129. command.Parameters.AddWithValue("potracheho_ha_remoht", textBox88.Text);
  130. command.Parameters.AddWithValue("ha_remonte", textBox87.Text);
  131. command.Parameters.AddWithValue("ind", textBox95.Text);
  132.  
  133. await command.ExecuteNonQueryAsync();
  134. }
  135.  
  136. private async void обновитьToolStripMenuItem_Click(object sender, EventArgs e)
  137. {
  138. listBox1.Items.Clear();
  139. listBox2.Items.Clear();
  140. listBox3.Items.Clear();
  141. SqlDataReader sqlReader = null;
  142. SqlCommand command = new SqlCommand("SELECT *FROM[name1],[otcet1],[part]", sqlConnection);
  143. try
  144. {
  145. sqlReader = await command.ExecuteReaderAsync();
  146.  
  147. while (await sqlReader.ReadAsync())
  148. {
  149. listBox1.Items.Add(Convert.ToString(sqlReader["naim_del"]) + " " + Convert.ToString(sqlReader["nomer"]) + " " + Convert.ToString(sqlReader["proijvoditel"]) + " " + Convert.ToString(sqlReader["kol_vo"]) + " " + Convert.ToString(sqlReader["type_tehiki"]) + " " + Convert.ToString(sqlReader["ind"]));
  150. listBox2.Items.Add(Convert.ToString(sqlReader["type_tehiki"]) + " " + Convert.ToString(sqlReader["model"]) + " " + Convert.ToString(sqlReader["nomer"]) + " " + Convert.ToString(sqlReader["potracheho_ha_remoht"]) + " " + Convert.ToString(sqlReader["garahtihi_crok"])+ " " + Convert.ToString(sqlReader["cislitca_c"]) + " " + Convert.ToString(sqlReader["kolvo_remontov"] )+ " " + Convert.ToString(sqlReader["ind"]));
  151. listBox3.Items.Add(Convert.ToString(sqlReader["type_tehiki"]) + " " + Convert.ToString(sqlReader["data"]) + " " + Convert.ToString(sqlReader["jakypleho_ha_cymmy"]) + " " + Convert.ToString(sqlReader["adrec"])+ " " + Convert.ToString(sqlReader["naim_del"]) + " " + Convert.ToString(sqlReader["ind"]) + " " + Convert.ToString(sqlReader["ima"]));
  152. listBox4.Items.Add(Convert.ToString(sqlReader["nomer"]) + " " + Convert.ToString(sqlReader["model"]) + " " + Convert.ToString(sqlReader["data"]) + " " + Convert.ToString(sqlReader["voditel"]) + " " + Convert.ToString(sqlReader["prichiha"]) + " " + Convert.ToString(sqlReader["vrema_remonta"]) + " " + Convert.ToString(sqlReader["remonty_podlejit"]) + " " + Convert.ToString(sqlReader["type_tehiki"]) + " " + Convert.ToString(sqlReader["ind"]));
  153. listBox5.Items.Add(Convert.ToString(sqlReader["type_tehiki"]) + " " + Convert.ToString(sqlReader["proizvoditel"]) + " " + Convert.ToString(sqlReader["model"]) + " " + Convert.ToString(sqlReader["potracheho_ha_remoht"]) + " " + Convert.ToString(sqlReader["ha_remonte"]) + " " + Convert.ToString(sqlReader["ind"]));
  154. }
  155. }
  156. catch (Exception ex)
  157. {
  158. MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
  159. }
  160. finally
  161. {
  162. if (sqlReader != null)
  163. sqlReader.Close();
  164. }
  165. }
  166.  
  167. private async void button2_Click(object sender, EventArgs e)
  168. {
  169. SqlCommand command = new SqlCommand("UPDATE [detal] SET [naim_del]=@naim_del,[nomer]=@nomer,[proijvoditel]=@proijvoditel,[kol_vo]=@kol_vo,[type_tehiki]=@type_tehiki,[ind]=@ind", sqlConnection);
  170. command.Parameters.AddWithValue("naim_del", textBox6.Text);
  171. command.Parameters.AddWithValue("nomer", textBox10.Text);
  172. command.Parameters.AddWithValue("proijvoditel", textBox7.Text);
  173. command.Parameters.AddWithValue("kol_vo", textBox9.Text);
  174. command.Parameters.AddWithValue("type_tehiki", textBox8.Text);
  175. command.Parameters.AddWithValue("ind", textBox1.Text);
  176.  
  177. await command.ExecuteNonQueryAsync();
  178. }
  179. private async void button5_Click(object sender, EventArgs e)
  180. {
  181. SqlCommand command = new SqlCommand("UPDATE [nomer] SET[type_tehiki]=@type_tehiki,[model]=@model,[nomer]=@nomer,[potracheho_ha_remoht]=@potracheho_ha_remoht,[garahtihi_crok]=@garahtihi_crok,[cislitca_c]=@cislitca_c,[kolvo_remontov]=@kolvo_remontov WHERE [ind]=@ind",sqlConnection);
  182. command.Parameters.AddWithValue("type_tehiki", textBox37.Text);
  183. command.Parameters.AddWithValue("model", textBox36.Text);
  184. command.Parameters.AddWithValue("nomer", textBox33.Text);
  185. command.Parameters.AddWithValue("potracheho_ha_remoht", textBox35.Text);
  186. command.Parameters.AddWithValue("garahtihi_crok", textBox34.Text);
  187. command.Parameters.AddWithValue("cislitca_c", textBox42.Text);
  188. command.Parameters.AddWithValue("kolvo_remontov", textBox41.Text);
  189. command.Parameters.AddWithValue("ind", textBox38.Text);
  190. await command.ExecuteNonQueryAsync();
  191. }
  192. private async void button8_Click(object sender, EventArgs e)
  193. {
  194. SqlCommand command = new SqlCommand("UPDATE [postavhik] SET ([type_tehiki]=@type_tehiki,[data]=@data,[jakypleho_ha_cymmy]=@jakypleho_ha_cymmy,[adrec]=@adrec,[naim_del]=@naim_del,[ima]=@ima WHERE[ind]=@ind", sqlConnection);
  195. command.Parameters.AddWithValue("type_tehiki", textBox58.Text);
  196. command.Parameters.AddWithValue("data", textBox57.Text);
  197. command.Parameters.AddWithValue("jakypleho_ha_cymmy", textBox54.Text);
  198. command.Parameters.AddWithValue("adrec", textBox56.Text);
  199. command.Parameters.AddWithValue("naim_del", textBox55.Text);
  200. command.Parameters.AddWithValue("ind", textBox63.Text);
  201. command.Parameters.AddWithValue("ima", textBox62.Text);
  202. await command.ExecuteNonQueryAsync();
  203. }
  204. private async void button11_Click(object sender, EventArgs e)
  205. {
  206. SqlCommand command = new SqlCommand("UPDATE [remont] SET [nomer]=@nomer,[model]=@model,[data]=@data,[voditel]=@voditel,[prichiha]=@prichiha,[vrema_remonta]=@vrema_remonta,[remonty_podlejit]=@remonty_podlejit,[type_tehiki]=@type_tehiki WHERE[ind]=@ind", sqlConnection);
  207. command.Parameters.AddWithValue("nomer", textBox79.Text);
  208. command.Parameters.AddWithValue("model", textBox78.Text);
  209. command.Parameters.AddWithValue("data", textBox75.Text);
  210. command.Parameters.AddWithValue("voditel", textBox77.Text);
  211. command.Parameters.AddWithValue("prichiha", textBox76.Text);
  212. command.Parameters.AddWithValue("vrema_remonta", textBox84.Text);
  213. command.Parameters.AddWithValue("remonty_podlejit", textBox83.Text);
  214. command.Parameters.AddWithValue("type_tehiki", textBox80.Text);
  215. command.Parameters.AddWithValue("ind", textBox82.Text);
  216. await command.ExecuteNonQueryAsync();
  217. }
  218. private async void button14_Click(object sender, EventArgs e)
  219. {
  220. SqlCommand command = new SqlCommand("UPDATE [tip_tehiki] SET[type_tehiki]=@type_tehiki,[proizvoditel]=@proizvoditel,[model]=@model,[potracheho_ha_remoht],[ha_remonte]=@ha_remonte WHERE[ind]=@ind)", sqlConnection);
  221. command.Parameters.AddWithValue("type_tehiki", textBox100.Text);
  222. command.Parameters.AddWithValue("proizvoditel", textBox99.Text);
  223. command.Parameters.AddWithValue("model", textBox96.Text);
  224. command.Parameters.AddWithValue("potracheho_ha_remoht", textBox98.Text);
  225. command.Parameters.AddWithValue("ha_remonte", textBox97.Text);
  226. command.Parameters.AddWithValue("ind", textBox105.Text);
  227.  
  228. await command.ExecuteNonQueryAsync();
  229. }
  230.  
  231. private void textBox11_TextChanged(object sender, EventArgs e)
  232. {
  233.  
  234. }
  235. private void textBox12_TextChanged(object sender, EventArgs e)
  236. {
  237.  
  238. }
  239. private void textBox13_TextChanged(object sender, EventArgs e)
  240. {
  241.  
  242. }
  243. private async void button3_Click(object sender, EventArgs e)
  244. {
  245. SqlCommand command = new SqlCommand("DELETE FROM [detal][nomer][postavhik][remont][tip_tehiki] WHERE [ind]=@ind", sqlConnection);
  246. command.Parameters.AddWithValue("idto", textBox21.Text);
  247. await command.ExecuteNonQueryAsync();
  248. }
  249.  
  250. private void label7_Click(object sender, EventArgs e)
  251. {
  252.  
  253. }
  254.  
  255. private void label8_Click(object sender, EventArgs e)
  256. {
  257.  
  258. }
  259.  
  260. private void tabPage2_Click(object sender, EventArgs e)
  261. {
  262.  
  263. }
  264.  
  265. private void label14_Click(object sender, EventArgs e)
  266. {
  267.  
  268. }
  269. }
  270. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!