API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 11th, 2017
124
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 24.71 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.Drawing;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Threading.Tasks;
  9. using System.Windows.Forms;
  10. using MySql.Data.MySqlClient;
  11. using System.Data.SqlClient;
  12. using System.Diagnostics;
  13.  
  14.  
  15. namespace WindowsFormsApplication1
  16. {
  17. public partial class Form1 : Form
  18. {
  19. // put constring here
  20. string conString =
  21. "SERVER=10.252.1.13;" +
  22. "DATABASE=barcodemysqldb;" +
  23. "port=10852;" +
  24. "USER=dbuser;" +
  25. "PASSWORD=gT9MxrRdFH3wDY@N;";
  26.  
  27. string GPconString =
  28. "SERVER=RGV-HP-SQL01;" +
  29. "DATABASE=UC;" +
  30. "USER=sa;" +
  31. "PASSWORD=Pass@word1;";
  32.  
  33.  
  34.  
  35. public Form1()
  36. {
  37. InitializeComponent();
  38. }
  39.  
  40. private void Form1_Load(object sender, EventArgs e)
  41. {
  42.  
  43. }
  44.  
  45. private void label13_Click(object sender, EventArgs e)
  46. {
  47.  
  48.  
  49.  
  50. }
  51.  
  52. private void label22_Click(object sender, EventArgs e)
  53. {
  54.  
  55. }
  56.  
  57. private void searchBtn_Click(object sender, EventArgs e)
  58. {
  59. string input = "";
  60. string model = "";
  61. string assemblytime = "";
  62. string kit = "";
  63. string assemblyline = "";
  64. string lidstatus = "";
  65. string comment = "";
  66. string key = "";
  67. string recordid = "";
  68. string outerid = "";
  69. string innerid = "";
  70. string gluefixture = "";
  71. string thermo = "";
  72. string outerplasticlot = "";
  73. string innerplasticlot = "";
  74. string gluebatch = "";
  75. string outertime = "";
  76. string innertime = "";
  77. string gluetime = "";
  78. string gluebatchtime = "";
  79. string outerplasticlottime = "";
  80. string innerplasticlottime = "";
  81. string rmanumber = "";
  82. string pasm = "";
  83. string invoice = "";
  84.  
  85.  
  86.  
  87. input = serialTB.Text;
  88.  
  89. modelTB.Clear();
  90. recordTB.Clear();
  91. outerTB.Clear();
  92. innerTB.Clear();
  93. thermoTB.Clear();
  94. outerplTB.Clear();
  95. innerplTB.Clear();
  96. outertiTB.Clear();
  97. innertiTB.Clear();
  98. rmaTB.Clear();
  99. claimTB.Clear();
  100. keyTB.Clear();
  101. glueTB.Clear();
  102. gluetiTB.Clear();
  103. gluefiTB.Clear();
  104. gluebatiTB.Clear();
  105. pasmTB.Clear();
  106. kitTB.Clear();
  107. assemblyliTB.Clear();
  108. assemblyTB.Clear();
  109. invTB.Clear();
  110.  
  111.  
  112.  
  113. using (SqlConnection gpcon = new SqlConnection(GPconString))
  114. {
  115. using (SqlCommand gpcmd = gpcon.CreateCommand())
  116. {
  117.  
  118. gpcmd.CommandText = "SELECT [SOPNUMBE] FROM [UC].[dbo].[SOP10201] where serltnum = @sn;";
  119. gpcmd.Parameters.AddWithValue("@sn", input);
  120. gpcon.Open();
  121.  
  122. SqlDataReader reader = gpcmd.ExecuteReader();
  123. while (reader.Read())
  124. {
  125. invoice = reader.GetString(0);
  126. modelTB.Enabled = false;
  127. recordTB.Enabled = false;
  128. outerTB.Enabled = false;
  129. innerTB.Enabled = false;
  130. thermoTB.Enabled = false;
  131. outerplTB.Enabled = false;
  132. innerplTB.Enabled = false;
  133. outertiTB.Enabled = false;
  134. innertiTB.Enabled = false;
  135. rmaTB.Enabled = false;
  136. claimTB.Enabled = false;
  137. keyTB.Enabled = false;
  138. glueTB.Enabled = false;
  139. gluetiTB.Enabled = false;
  140. gluefiTB.Enabled = false;
  141. gluebatiTB.Enabled = false;
  142. pasmTB.Enabled = false;
  143. kitTB.Enabled = false;
  144. assemblyliTB.Enabled = false;
  145. assemblyTB.Enabled = false;
  146. invTB.Enabled = false;
  147. invTB.Text = invoice;
  148. }
  149. }
  150. }
  151. if (input.Length > 1)
  152. {
  153. if (input.Substring(0, 2) == "FX" && input.Length == 9
  154. || input.Substring(0, 2) == "UX" && input.Length == 9)
  155. {
  156. using (MySqlConnection con = new MySqlConnection(conString))
  157. {
  158.  
  159. using (MySqlCommand cmd = con.CreateCommand())
  160. {
  161. cmd.CommandText = "SELECT model, assemblytime, kit, assemblyline, lidstatus,"
  162. + "comment from barcodemysqldb.flex_table where sn = @sn";
  163.  
  164.  
  165. cmd.Parameters.AddWithValue("@sn", input);
  166.  
  167.  
  168. con.Open();
  169. MySqlDataReader reader = cmd.ExecuteReader();
  170. while (reader.Read())
  171. {
  172. model = reader.GetString(0);
  173. assemblytime = reader.GetString(1);
  174. kit = reader.GetString(2);
  175. assemblyline = reader.GetString(3);
  176. lidstatus = reader.GetString(4);
  177. comment = reader.GetString(5);
  178. modelTB.Enabled = false;
  179. recordTB.Enabled = false;
  180. outerTB.Enabled = false;
  181. innerTB.Enabled = false;
  182. thermoTB.Enabled = false;
  183. outerplTB.Enabled = false;
  184. innerplTB.Enabled = false;
  185. outertiTB.Enabled = false;
  186. innertiTB.Enabled = false;
  187. rmaTB.Enabled = false;
  188. claimTB.Enabled = false;
  189. keyTB.Enabled = false;
  190. glueTB.Enabled = false;
  191. gluetiTB.Enabled = false;
  192. gluefiTB.Enabled = false;
  193. gluebatiTB.Enabled = false;
  194. pasmTB.Enabled = false;
  195. kitTB.Enabled = false;
  196. assemblyliTB.Enabled = false;
  197. assemblyTB.Enabled = false;
  198. invTB.Enabled = false;
  199.  
  200. }
  201. }
  202. }
  203. modelTB.Text = model;
  204. assemblyTB.Text = assemblytime;
  205. kitTB.Text = kit;
  206. assemblyliTB.Text = assemblyline;
  207. lidstatusCB.Text = lidstatus;
  208. commentsRTB.Text = comment;
  209. }
  210. else if (input.Substring(0, 2) == "SC" && input.Length == 9)
  211. {
  212. using (MySqlConnection con = new MySqlConnection(conString))
  213. {
  214. using (MySqlCommand cmd = con.CreateCommand())
  215. {
  216. cmd.CommandText = "SELECT model, bracket, keyid, assemblytime, assemblyline, casestatus, comment "
  217. + "FROM barcodemysqldb.swingcase where sn = @sn";
  218. cmd.Parameters.AddWithValue("@sn", input);
  219. con.Open();
  220. MySqlDataReader reader = cmd.ExecuteReader();
  221. while (reader.Read())
  222. {
  223. {
  224.  
  225. model = reader.GetString(0);
  226. assemblytime = reader.GetString(3);
  227. kit = reader.GetString(1);
  228. assemblyline = reader.GetString(4);
  229. lidstatus = reader.GetString(5);
  230. comment = reader.GetString(6);
  231. key = reader.GetString(2);
  232. modelTB.Enabled = false;
  233. recordTB.Enabled = false;
  234. outerTB.Enabled = false;
  235. innerTB.Enabled = false;
  236. thermoTB.Enabled = false;
  237. outerplTB.Enabled = false;
  238. innerplTB.Enabled = false;
  239. outertiTB.Enabled = false;
  240. innertiTB.Enabled = false;
  241. rmaTB.Enabled = false;
  242. claimTB.Enabled = false;
  243. keyTB.Enabled = false;
  244. glueTB.Enabled = false;
  245. gluetiTB.Enabled = false;
  246. gluefiTB.Enabled = false;
  247. gluebatiTB.Enabled = false;
  248. pasmTB.Enabled = false;
  249. kitTB.Enabled = false;
  250. assemblyliTB.Enabled = false;
  251. assemblyTB.Enabled = false;
  252. keyTB.Enabled = false;
  253. invTB.Enabled = false;
  254. }
  255. }
  256. }
  257. {
  258.  
  259. modelTB.Text = model;
  260. assemblyTB.Text = assemblytime;
  261. kitTB.Text = kit;
  262. assemblyliTB.Text = assemblyline;
  263. lidstatusCB.Text = lidstatus;
  264. commentsRTB.Text = comment;
  265. keyTB.Text = key;
  266.  
  267.  
  268.  
  269.  
  270. }
  271. }
  272. }
  273.  
  274. else if (input.Substring(0, 2) == "DF" && input.Length == 8)
  275. {
  276. using (MySqlConnection con = new MySqlConnection(conString))
  277. {
  278. using (MySqlCommand cmd = con.CreateCommand())
  279. {
  280. cmd.CommandText = "Select model, kit, assemblytime, lidstatus, df_lid_table.key, comment from "
  281. + "ucdb.df_lid_table where sn = @sn";
  282. cmd.Parameters.AddWithValue("@sn", input);
  283. con.Open();
  284. MySqlDataReader reader = cmd.ExecuteReader();
  285. while (reader.Read())
  286. {
  287. model = reader.GetString(0);
  288. assemblytime = reader.GetString(2);
  289. kit = reader.GetString(1);
  290. lidstatus = reader.GetString(3);
  291. comment = reader.GetString(5);
  292. key = reader.GetString(4);
  293. modelTB.Enabled = false;
  294. recordTB.Enabled = false;
  295. outerTB.Enabled = false;
  296. innerTB.Enabled = false;
  297. thermoTB.Enabled = false;
  298. outerplTB.Enabled = false;
  299. innerplTB.Enabled = false;
  300. outertiTB.Enabled = false;
  301. innertiTB.Enabled = false;
  302. rmaTB.Enabled = false;
  303. claimTB.Enabled = false;
  304. keyTB.Enabled = false;
  305. glueTB.Enabled = false;
  306. gluetiTB.Enabled = false;
  307. gluefiTB.Enabled = false;
  308. gluebatiTB.Enabled = false;
  309. pasmTB.Enabled = false;
  310. kitTB.Enabled = false;
  311. assemblyliTB.Enabled = false;
  312. assemblyTB.Enabled = false;
  313. keyTB.Enabled = false;
  314. invTB.Enabled = false;
  315. }
  316. {
  317.  
  318. modelTB.Text = model;
  319. assemblyTB.Text = assemblytime;
  320. kitTB.Text = kit;
  321. lidstatusCB.Text = lidstatus;
  322. commentsRTB.Text = comment;
  323. keyTB.Text = key;
  324. }
  325. }
  326. }
  327. }
  328. else if (input.Substring(0, 2) == "NH" && input.Length == 10)
  329. {
  330. using (MySqlConnection con = new MySqlConnection(conString))
  331. {
  332. using (MySqlCommand cmd = con.CreateCommand())
  333. {
  334. cmd.CommandText = "Select model, baseassembly, paintassembly, lidstatus, comment from ucdb.nh_table where sn = @sn;";
  335. cmd.Parameters.AddWithValue("@sn", input);
  336. con.Open();
  337. MySqlDataReader reader = cmd.ExecuteReader();
  338. while (reader.Read())
  339. {
  340. model = reader.GetString(0);
  341. assemblytime = reader.GetString(1);
  342. pasm = reader.GetString(2);
  343. lidstatus = reader.GetString(3);
  344. comment = reader.GetString(4);
  345. modelTB.Enabled = false;
  346. recordTB.Enabled = false;
  347. outerTB.Enabled = false;
  348. innerTB.Enabled = false;
  349. thermoTB.Enabled = false;
  350. outerplTB.Enabled = false;
  351. innerplTB.Enabled = false;
  352. outertiTB.Enabled = false;
  353. innertiTB.Enabled = false;
  354. rmaTB.Enabled = false;
  355. claimTB.Enabled = false;
  356. keyTB.Enabled = false;
  357. glueTB.Enabled = false;
  358. gluetiTB.Enabled = false;
  359. gluefiTB.Enabled = false;
  360. gluebatiTB.Enabled = false;
  361. pasmTB.Enabled = false;
  362. kitTB.Enabled = false;
  363. assemblyliTB.Enabled = false;
  364. assemblyTB.Enabled = false;
  365. keyTB.Enabled = false;
  366. invTB.Enabled = false;
  367. }
  368. {
  369. modelTB.Text = model;
  370. assemblyTB.Text = assemblytime;
  371. pasmTB.Text = pasm;
  372. lidstatusCB.Text = lidstatus;
  373. commentsRTB.Text = comment;
  374.  
  375. }
  376. }
  377. }
  378. }
  379. else
  380. {
  381. using (MySqlConnection con = new MySqlConnection(conString))
  382.  
  383. {
  384. using (MySqlCommand cmd = con.CreateCommand())
  385.  
  386. {
  387. cmd.CommandText = "Select modelnumber, kitid, recordid, outerid, innerid, keyid, GlueFixture, Thermo, OuterPlasticLot, InnerPlasticLot, GlueBatch, outertime, innertime, gluetime, assemblytime, GlueBatchTime, OuterPlasticLotTime,"
  388. + "InnerPlasticLotTime, LidStatus, rmanumber, barcodemysqldb.serialnumbertable.comment from barcodemysqldb.serialnumbertable where SerialNumber = @sn; ";
  389. cmd.Parameters.AddWithValue("@sn", input);
  390. con.Open();
  391. MySqlDataReader reader = cmd.ExecuteReader();
  392. while (reader.Read())
  393. {
  394. model = reader.GetString(0);
  395. assemblytime = reader.GetString(14);
  396. kit = reader.GetString(1);
  397. lidstatus = reader.GetString(18);
  398. comment = reader.GetString(20);
  399. key = reader.GetString(5);
  400. recordid = reader.GetString(2);
  401. outerid = reader.GetString(3);
  402. innerid = reader.GetString(4);
  403. gluefixture = reader.GetString(6);
  404. thermo = reader.GetString(7);
  405. outerplasticlot = reader.GetString(8);
  406. innerplasticlot = reader.GetString(9);
  407. gluebatch = reader.GetString(10);
  408. outertime = reader.GetString(11);
  409. innertime = reader.GetString(12);
  410. gluetime = reader.GetString(13);
  411. gluebatchtime = reader.GetString(15);
  412. outerplasticlottime = reader.GetString(16);
  413. innerplasticlottime = reader.GetString(17);
  414. rmanumber = reader.GetString(19);
  415. modelTB.Enabled = false;
  416. recordTB.Enabled = false;
  417. outerTB.Enabled = false;
  418. innerTB.Enabled = false;
  419. thermoTB.Enabled = false;
  420. outerplTB.Enabled = false;
  421. innerplTB.Enabled = false;
  422. outertiTB.Enabled = false;
  423. innertiTB.Enabled = false;
  424. rmaTB.Enabled = false;
  425. claimTB.Enabled = false;
  426. keyTB.Enabled = false;
  427. glueTB.Enabled = false;
  428. gluetiTB.Enabled = false;
  429. gluefiTB.Enabled = false;
  430. gluebatiTB.Enabled = false;
  431. pasmTB.Enabled = false;
  432. kitTB.Enabled = false;
  433. assemblyliTB.Enabled = false;
  434. assemblyTB.Enabled = false;
  435. keyTB.Enabled = false;
  436. invTB.Enabled = false;
  437. }
  438. modelTB.Text = model;
  439. assemblyTB.Text = assemblytime;
  440. kitTB.Text = kit;
  441. lidstatusCB.Text = lidstatus;
  442. commentsRTB.Text = comment;
  443. keyTB.Text = key;
  444. recordTB.Text = recordid;
  445. outerTB.Text = outerid;
  446. innerTB.Text = innerid;
  447. gluefiTB.Text = gluefixture;
  448. thermoTB.Text = thermo;
  449. outerplTB.Text = outerplasticlot;
  450. innerplTB.Text = innerplasticlot;
  451. gluetiTB.Text = gluetime;
  452. gluebatiTB.Text = gluebatchtime;
  453. outertiTB.Text = outertime;
  454. innertiTB.Text = innertime;
  455. gluetiTB.Text = gluetime;
  456. gluebatiTB.Text = gluebatchtime;
  457. outertiTB.Text = outerplasticlottime;
  458. innertiTB.Text = innerplasticlottime;
  459. rmaTB.Text = rmanumber;
  460. }
  461. }
  462. }
  463. }
  464. else
  465. {
  466. MessageBox.Show("The serial number entered is invalid.");
  467. }
  468. }
  469.  
  470.  
  471.  
  472.  
  473. private void exitBtn_Click(object sender, EventArgs e)
  474. {
  475. //string message = "Are you sure you would like to Exit?";
  476. //string caption = "Are you sure?";
  477.  
  478. //var result = MessageBox.Show(message, caption,
  479. // MessageBoxButtons.YesNo,
  480. // MessageBoxIcon.Question);
  481.  
  482. //if (result == DialogResult.Yes)
  483. // Environment.Exit(0);
  484. close();
  485. }
  486.  
  487.  
  488. public static void close()
  489. {
  490. string message = "Are you sure you would like to Exit?";
  491. string caption = "Are you sure?";
  492.  
  493. var result = MessageBox.Show(message, caption,
  494. MessageBoxButtons.YesNo,
  495. MessageBoxIcon.Question);
  496.  
  497. if (result == DialogResult.Yes)
  498. Environment.Exit(0);
  499. }
  500.  
  501. private void Form1_FormClosing(object sender, FormClosingEventArgs e)
  502. {
  503. close();
  504. }
  505. }
  506. }
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!