public static void Main(string[] args) { // Let do this thing bool validResponse = false; string newOrReturn; string customerFirstName; string customerLastName; int customerID = 0; int employeeID = 1; int storeID = 1; // Database Connection is established using var context = new joshfordproject0Context(s_dbContextOptions); // User Interface implementation(html, css, js) will be added here Console.WriteLine("\t**********************************"); Console.WriteLine("\t* Welcome to Rise 'N Grind Cafe! *"); Console.WriteLine("\t**********************************"); Console.WriteLine("\t*N: New Customer\n\t*S: Sign In"); do { newOrReturn = Console.ReadLine().ToUpper(); if (newOrReturn != "N" && newOrReturn != "S") { Console.WriteLine("\tInvalid Input."); Console.WriteLine("\tPlease select option from menu below"); Console.WriteLine("\t*N: New Customer\n\t*S: Sign In"); } else { validResponse = true; } } while (!validResponse); // Returning customer will input ID for ID validation // New customer will input name, and receive a customer ID // NEEDS REVISING, DOES NOT PROPERLY VALIDATE if (newOrReturn == "S") { CustomerC returnCustomer = new CustomerC(); Console.WriteLine("Please enter customer ID: "); customerID = int.Parse(Console.ReadLine()); returnCustomer = returnCustomer.FindCustomerByID(customerID); } else { CustomerC newCustomer = new CustomerC(); // New Customer enters first and last name for record keeping Console.WriteLine("\t--New Customer Information--"); Console.WriteLine("\tPlease enter your first name: "); customerFirstName = Console.ReadLine(); while (!newCustomer.ValidateName(customerFirstName)) { Console.WriteLine("\tName cannot contain spaces"); Console.WriteLine("\tPlease enter a valid name: "); customerFirstName = Console.ReadLine(); } Console.WriteLine("\tPlease enter your last name: "); customerLastName = Console.ReadLine(); while (!newCustomer.ValidateName(customerLastName)) { Console.WriteLine("\tName cannot contain spaces"); Console.WriteLine("\tPlease enter a valid name: "); customerLastName = Console.ReadLine(); } CustomerC customerToAdd = new CustomerC(); customerToAdd.AddNewCustomer(customerFirstName, customerLastName); } // Create Customer Object CustomerC customer = new CustomerC(); try { OrderC order = new OrderC(customerID, employeeID, storeID); Menu.MenuUI(order); } catch (ApplicationException) { throw new ApplicationException("\tFatal Internal Error.\n\tExiting..."); } }
public void Click1() { int i = 0; OrderT order1 = new OrderT(); OrderC oc = new OrderC(); MingXi mx = new MingXi(); List <OrderC> olist = new List <OrderC>(); order1.OrdetType(odType); odType = order1.Quexian;//订单类型 string batch = txtbatch.Text.Trim().ToString(); string orderno = textBox1.Text.ToString(); string matnr = textBox2.Text.ToString(); string mold = textBox3.Text.ToString(); string[] splitStrings = txtDate.Text.Split(); string datestr = string.Join("", splitStrings); DateTime date = Convert.ToDateTime(datestr); string jitai1 = txtjitai1.Text.Trim(); string jitai2 = txtjitai2.Text.Trim(); string jitai3 = txtjitai3.Text.Trim(); string jitai4 = txtjitai4.Text.Trim(); string jitai5 = txtjitai5.Text.Trim(); string jitai6 = txtjitai6.Text.Trim(); string jitai7 = txtjitai7.Text.Trim(); string jitai8 = txtjitai8.Text.Trim(); string caozuo1 = txtcz1.Text.Trim(); string caozuo2 = txtcz2.Text.Trim(); string caozuo3 = txtcz3.Text.Trim(); string caozuo4 = txtcz4.Text.Trim(); string caozuo5 = txtcz5.Text.Trim(); string caozuo6 = txtcz6.Text.Trim(); string caozuo7 = txtcz7.Text.Trim(); string caozuo8 = txtcz8.Text.Trim(); int chanliang1 = int.Parse(txtcl1.Text.Trim()); int chanliang2 = int.Parse(txtcl2.Text.Trim()); int chanliang3 = int.Parse(txtcl3.Text.Trim()); int chanliang4 = int.Parse(txtcl4.Text.Trim()); int chanliang5 = int.Parse(txtcl5.Text.Trim()); int chanliang6 = int.Parse(txtcl6.Text.Trim()); int chanliang7 = int.Parse(txtcl7.Text.Trim()); int chanliang8 = int.Parse(txtcl8.Text.Trim()); int banhao = int.Parse(str2.Substring(8, 1)); float gongshi = float.Parse(txtgh.Text.Trim()); int bl1, bl2, bl3, bl4, bl5, bl6, bl7, bl8, intqx1, intqx2, intqx3, intqx4, intqx5, intqx6, intqx7, intqx8; int.TryParse(buliang1.Text.Trim().ToString(), out bl1); int.TryParse(buliang2.Text.Trim().ToString(), out bl2); int.TryParse(buliang3.Text.Trim().ToString(), out bl3); int.TryParse(buliang4.Text.Trim().ToString(), out bl4); int.TryParse(buliang5.Text.Trim().ToString(), out bl5); int.TryParse(buliang6.Text.Trim().ToString(), out bl6); int.TryParse(buliang7.Text.Trim().ToString(), out bl7); int.TryParse(buliang8.Text.Trim().ToString(), out bl8); int.TryParse(quexian1.Text.Trim().ToString(), out intqx1); int.TryParse(quexian2.Text.Trim().ToString(), out intqx2); int.TryParse(quexian3.Text.Trim().ToString(), out intqx3); int.TryParse(quexian4.Text.Trim().ToString(), out intqx4); int.TryParse(quexian5.Text.Trim().ToString(), out intqx5); int.TryParse(quexian6.Text.Trim().ToString(), out intqx6); int.TryParse(quexian7.Text.Trim().ToString(), out intqx7); int.TryParse(quexian8.Text.Trim().ToString(), out intqx8); int[] bl = new int[] { bl1, bl2, bl3, bl4, bl5, bl6, bl7, bl8 }; int[] intqx = new int[] { intqx1, intqx2, intqx3, intqx4, intqx5, intqx6, intqx7, intqx8 }; string[] jitai = new string[] { jitai1, jitai2, jitai3, jitai4, jitai5, jitai6, jitai7, jitai8 }; string[] caozuo = new string[] { caozuo1, caozuo2, caozuo3, caozuo4, caozuo5, caozuo6, caozuo7, caozuo8 }; int[] changliang = new int[] { chanliang1, chanliang2, chanliang3, chanliang4, chanliang5, chanliang6, chanliang7, chanliang8 }; string[] strqx = new string[8]; int mid = 0; bool x = true; //判断是否添加数据到数据库 string sql = string.Format("select QueXian,Number from Class_Table where Qclass='{0}'", odType); SqlDataReader reader = SqlDB.ExecuteReader(sql); while (reader.Read()) { oc = new OrderC() { Quexian = reader.GetString(0), Number = reader.GetInt32(1) }; olist.Add(oc); i++; } reader.Dispose();//关闭 sql = string.Format("select max(ID) from Master"); reader = SqlDB.ExecuteReader(sql); while (reader.Read()) { mid = reader.GetInt32(0) + 1; break; } reader.Dispose();//关闭 for (int j = 0; j < 8; j++) { if (bl[j] == 0 || jitai[j].Length == 0) { break; } if (olist.Count > 0) { strqx[j] = mx.PiDui(intqx[j], olist); if (strqx[j].Length == 0) { MessageBox.Show("没有找到" + intqx[j] + "所对应的缺陷", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); x = false; } else { sql = string.Format("insert into QueXIanNo(Number1,QueXian,MasterID,Number2,P_No,Number3) values({0},'{1}','{2}','{3}','{4}',{5})", bl[j], strqx[j], mid, jitai[j], caozuo[j], changliang[j]); SqlDB.ExecuteNonQuery(sql); //添加明细表信息 QueXianNo } } else { x = false; } } if (x == true) { DateTime nowdate = DateTime.Now; sql = string.Format("insert into Master(Batch,OrderNo,Matnr,Mold,Date,B_No,Time,Date2,OType) values('{0}','{1}','{2}','{3}','{4}',{5},{6},'{7}','{8}')", batch, orderno, matnr, mold, date, banhao, gongshi, nowdate, odType); SqlDB.ExecuteNonQuery(sql); //添加抬头表信息 Master } }