public SalesOrder(string userId, string userName, Customer customer, string shipMethod, Address billToAddress, Address shipToAddress, CreditCard creditCard, string cardSecurityNumber, string cardHolderName) { RevisionNumber = 1; OrderDate = DateTime.Today; DueDate = OrderDate.AddDays(12); Status = SalesOrderStatus.InProcess; OnlineOrderFlag = true; Customer = customer; ShipMethod = shipMethod; TaxRate = 8; Freight = 0; BillToAddress = billToAddress; ShipToAddress = shipToAddress; CreditCard = creditCard; AddOrderStartedDomainEvent(userId, userName, creditCard.CardType, creditCard.CardNumber, cardSecurityNumber, cardHolderName, new DateTime( creditCard.ExpYear, creditCard.ExpMonth, 1 ) ); }
public Order(string description, string adress) { //OrderId = ++noOfOrder; OrderDescription = description; OrderDeliveryAdress = adress; OrderStatus = OrderStatus.Requested; OrderDate = DateTime.UtcNow; DeliveryDate = OrderDate.AddDays(1); }
// sets the order status then returns list of possible errors public void SetStatus() { if (Status == "Новый") { // Let's suppose the company has fixed delivery time ShipmentDate = OrderDate.AddDays(20); Status = "Выполняется"; } else if (Status == "Выполняется") { Status = "Выполнен"; } }
private void button2_Click(object sender, EventArgs e) { if (this.dataGridView1.Rows.Count == 0) { MessageBox.Show("请先选择需要生成的记录"); } else if (comboBox3.Text.ToString().Length <= 0 || comboBox4.Text.ToString().Length <= 0 || comboBox5.Text.ToString().Length <= 0 || comboBox7.Text.ToString().Length <= 0 || comboBox9.Text.ToString().Length <= 0 || comboBox11.Text.ToString().Length <= 0 || comboBox13.Text.ToString().Length <= 0 || comboBox15.Text.ToString().Length <= 0) { MessageBox.Show("请先设置各类审批人和申请人"); } else { try { String BID, Name, Invoice; //invoic 如果不为空 需要自动生成一个 String pNmae; //提供者公司 对应BuyId : provider String Ename; //审批者 如果为空选择框中读取 对应BuyId 的person String Sub; //总金额 对应BuyId SumMoney String BDate; //购买日期 对应BuyId OrderDate DateTime Temp_BDate; //转化的过度 String PJID, BAPID, GDID; String sql1_1, sql1_2, sql1_3, sql5_1, sql4_1; String sql1, sql2, sql3, sql4, sql5, sql6; String OrderPerson, Person; String BIID, ID; String type, unit; String Num, CurrentNum; //买入数量和当前库存 String Price; String PlanID; DateTime PlanDate, GetDate, OrderDate, PlanGetDate, CheckDate; //入库日期是BDate 预计到货 PlanDate = BDate-3 GetDate = BDate-1 OrderDate = BDate -7 DateTime EndDate; //截止日期 DataGridViewCheckBoxCell checkCell; //PlanGetDate 计划到货时间 Boolean flag; Random r = new Random(); for (int row = 0; row <= this.dataGridView1.Rows.Count - 1; row++) { checkCell = (DataGridViewCheckBoxCell)dataGridView1.Rows[row].Cells[0]; flag = Convert.ToBoolean(checkCell.Value); if (flag == false) { continue; } ID = this.dataGridView1["ID", row].Value.ToString(); BID = this.dataGridView1["BID", row].Value.ToString(); Name = this.dataGridView1["Name", row].Value.ToString(); Invoice = this.dataGridView1["Invoice", row].Value.ToString(); pNmae = this.dataGridView1["PName", row].Value.ToString(); Ename = this.dataGridView1["Ename", row].Value.ToString(); Sub = this.dataGridView1["Sub", row].Value.ToString(); BDate = this.dataGridView1["BDate", row].Value.ToString(); Temp_BDate = Convert.ToDateTime(BDate); //强制转化 PJID = this.dataGridView1["PJID", row].Value.ToString(); type = this.dataGridView1["Type", row].Value.ToString(); unit = this.dataGridView1["Unit", row].Value.ToString(); Num = this.dataGridView1["Num", row].Value.ToString(); Price = this.dataGridView1["Price", row].Value.ToString(); CurrentNum = this.dataGridView1["CurrentNum", row].Value.ToString(); OrderPerson = comboBox3.Text.ToString(); //申请人 if (Ename.Length <= 0) { Person = comboBox4.Text.ToString(); } else { Person = Ename; } if (Invoice.Length <= 0) { TimeSpan cha = (DateTime.Now - TimeZone.CurrentTimeZone.ToLocalTime(new System.DateTime(1970, 1, 1))); long t = (long)cha.TotalSeconds; //用时间戳生成一个不会重复的表示符 Invoice = t.ToString(); } if (Sub.Length <= 0) { Sub = "0"; } if (CurrentNum.Length <= 0) { CurrentNum = "0"; } PlanDate = Temp_BDate.AddDays(-3); OrderDate = Temp_BDate.AddDays(-7); GetDate = Temp_BDate.AddDays(-1); CheckDate = PlanDate.AddDays(r.Next(0, 1)); //审核日期 0-1 PlanGetDate = PlanDate.AddDays(r.Next(2, 3)); //PlanGetDate 计划到货时间 PlanDate 0-3 //入库日期是BDate 预计到货 PlanDate = BDate-3 GetDate = BDate-1 OrderDate = BDate -7 EndDate = OrderDate.AddDays(5); //截止日期是申请日期+1 sql1_1 = @"INSERT INTO BuyPlan (PlanDate,Maker,Checker,CheckDate,State,IsInShopping,PlanType) VALUES('" + PlanDate + "','" + comboBox5.Text.ToString() + "','" + comboBox7.Text.ToString() + "','" + CheckDate + "','1','3','1')"; SQLHelper db1_1 = new SQLHelper(); DataTable dt1_1 = db1_1.ExecuteDataTable(sql1_1); sql1_2 = "select top(1) ID from BuyPlan order by id desc"; SQLHelper db1_2 = new SQLHelper(); DataTable dt1_2 = db1_2.ExecuteDataTable(sql1_2); PlanID = dt1_2.Rows[0][0].ToString(); //获取planID sql1_3 = @"INSERT INTO BuyPlanDetail (BPID,Name,Type,Unit,MonthNeedAmount,PJDate,PJAmount,LowAmount,TopAmount,NeedAmount,PlanBuyAmount,PlanGetDate,BuyType,Remark,BuyAmount,toothcolor,pjid) VALUES('" + PlanID + "','" + Name + "','" + type + "','" + unit + "','0','" + PlanDate + "','" + CurrentNum + "','1','0','" + Num + "','" + Num + "','" + PlanGetDate + "','0','库存报警','" + Num + "','','" + PJID + "')"; SQLHelper db1_3 = new SQLHelper(); DataTable dt1_3 = db1_3.ExecuteDataTable(sql1_3); sql1 = @"INSERT INTO BuyIn (Invoice,OrderPerson,Provider,Person,SumMoney,OrderDate,PlanID,Phone,Fax,Address,PayKind) VALUES ('" + Invoice + "','" + comboBox3.Text.ToString() + "','" + pNmae + "','" + comboBox4.Text.ToString() + "','" + Sub + "','" + OrderDate + "','" + PlanID + "','','','','')"; SQLHelper db = new SQLHelper(); DataTable dt = db.ExecuteDataTable(sql1); sql2 = "select top(1) ID from BuyIn order by id desc"; SQLHelper db2 = new SQLHelper(); DataTable dt2 = db2.ExecuteDataTable(sql2); BIID = dt2.Rows[0][0].ToString(); //获取BII sql3 = @"INSERT INTO BuyInDetail (BIID,BIName,BItype,BIUnit,BIAmount,Price,PlanDate,GetAmount,pjid,BIArea,Remark,toothcolor) VALUES ('" + BIID + "','" + Name + "','" + type + "','" + unit + "','" + Num + "','" + Price + "','" + PlanDate + "','" + Num + "','" + PJID + "','','','')"; SQLHelper db3 = new SQLHelper(); DataTable dt3 = db3.ExecuteDataTable(sql3); sql4 = @"INSERT INTO BuyInGetDetail (BIID,Name,type,unit,Price,GetDate,GetAmount,BID,pjid,Area,Remark,toothcolor,State) VALUES ('" + BIID + "','" + Name + "','" + type + "','" + unit + "','" + Price + "','" + GetDate + "','" + Num + "','" + BID + "','" + PJID + "','','','','1')"; SQLHelper db4 = new SQLHelper(); DataTable dt4 = db4.ExecuteDataTable(sql4); sql4_1 = "select top(1) ID from BuyInGetDetail order by id desc"; SQLHelper db4_1 = new SQLHelper(); DataTable dt4_1 = db4_1.ExecuteDataTable(sql4_1); GDID = dt4_1.Rows[0][0].ToString(); //获取GDID sql5 = @"INSERT INTO BuyApplyPay(ApplyPerson,ApplyDate,Provider,Person,Bank,BankAccount,SumMoney,endPayDate,GetDate,verify1State,verify1,verify1Date,verify2State,verify2,verify2Date,IsPayed,PayMoney,Remark,PayDate,PayPerson) VALUES('" + comboBox11.Text.ToString() + "','" + OrderDate + "','" + pNmae + "','','','','" + Sub + "','" + EndDate + "','','1','" + comboBox13.Text.ToString() + "','" + CheckDate + "','1','" + comboBox13.Text.ToString() + "','" + CheckDate + "','1','" + Sub + "','','" + CheckDate + "','" + comboBox15.Text.ToString() + "')"; SQLHelper db5 = new SQLHelper(); DataTable dt5 = db5.ExecuteDataTable(sql5); sql5_1 = "select top(1) ID from BuyApplyPay order by id desc"; SQLHelper db5_1 = new SQLHelper(); DataTable dt5_1 = db5_1.ExecuteDataTable(sql5_1); BAPID = dt5_1.Rows[0][0].ToString(); //获取BAPID sql6 = @"INSERT INTO BuyApplyPayDetail(BAPID,GDID,BIID,Name,type,Unit,Price,Area,GetDate,GetAmount,Remark) VALUES('" + BAPID + "','" + GDID + "','" + BIID + "','" + Name + "','" + type + "','" + unit + "','" + Price + "','','" + GetDate + "','" + Num + "','')"; SQLHelper db6 = new SQLHelper(); DataTable dt6 = db6.ExecuteDataTable(sql6); string newLine = "入库ID:" + ID + "已生成对应的采购记录和采购计划\n"; // 将textBox1的内容插入到第一行 // 索引0是 richText1 第一行位置 richTextBox1.Text = richTextBox1.Text.Insert(0, newLine); richTextBox1.ScrollToCaret(); } MessageBox.Show("生成完成"); GetGridView(); } catch (Exception e3) { WriteLog.Write_Log(e3); MessageBox.Show(e3.Message); } } }