public FCainzOrderD(entity.CainzOrder order)
{
InitializeComponent();
btnSave.Text = "修改订单";
ORDER = order;
using (var db = PublicDB.getDB())
{
FCainzOrderD.FACTORY = (from a in db.CainzFactory
where a.FactoryID == order.FactoryID
select a).FirstOrDefault();
FCainzOrderD.ORDERDETAILLIST = new BindingList<entity.CainzOrderDetail>((from a in db.CainzOrderDetail
where a.OrderID == order.OrderID
orderby a.RowNo
select a).ToList());
}
cainzOrderDetailBindingSource.DataSource = ORDERDETAILLIST;
bdsCustomer.DataSource = FACTORY;
ReColorStatus();
///todo make faster
#region load
PublicTools.IniDatagridview(dataGridView1);
PublicTools.IniDatagridview(dataGridView2);
dataGridView2.AllowUserToAddRows = true;
dataGridView2.Height = dataGridView2[0, 0].Size.Height + 2;
dataGridView2.AllowUserToResizeColumns = false;
PublicTools.SetColumsAutoModeNone(dataGridView1);
PublicTools.SetColumsAutoModeNone(dataGridView2);
this.FormBorderStyle = FormBorderStyle.Sizable;
this.ControlBox = true;
dataGridView1_DataBindingComplete(null, null);
#endregion
//PublicTools.RecoverFormSize(this);
}
private void SearchForMain()
{
Frozen(true);
entity.CainzOrder _orderForSearch = new entity.CainzOrder();
_orderForSearch.OrderExNo = txbSearch.Text.Trim();
_orderForSearch.TraderName = txbTraderForSearch.Text.Trim();
BackgroundWorker work = new BackgroundWorker();
work.DoWork += Work_DoWork;
work.RunWorkerCompleted += Work_RunWorkerCompleted;
OrdersArgs oa = new OrdersArgs();
oa.OrderForSearch = _orderForSearch;
work.RunWorkerAsync(oa);
}
private void Worker_DoWork(object sender, DoWorkEventArgs e)
{
if (ORDER != null)
{
ORDER.IsDelete = 1;
using (var db = PublicDB.getDB())
{
db.CainzOrder.Attach(ORDER);
db.Entry(ORDER).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
var q = (from item in db.CainzOrderDetail
where item.CainzOrderOrderID == ORDER.OrderID
select item).ToArray();
if (q != null && q.Count() > 0)
{
foreach (var item in q)
{
item.IsDelete = 1;
db.Entry(item).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
}
}
entity.CainzOrder order = new entity.CainzOrder();
order.OrderID = Guid.NewGuid();
order.OrderNo = txbJingChenOrder.Text.Trim();
order.OrderExNo = txbOrder.Text.Trim();
order.ImageFile2 = txbFile.Text.Trim();
order.CreateTime = DateTime.Now;
order.IsDelete = 0;
order.Status = 0;
order.LastUpdate = DateTime.Now;
order.CainzFactoryFactoryID = FCainzOrderD.FACTORY.FactoryID;
order.FactoryID = order.CainzFactoryFactoryID;
order.FactoryName = txbFactory.Text.Trim();
order.Address = txbAdd.Text.Trim();
order.TraderName = FCainzOrderD.FACTORY.TraderName;
order.TraderID = FCainzOrderD.FACTORY.TraderID;
order.Contact = txbName.Text.Trim();
order.isDraft = 1;
if (txbDELdate.Tag != null)
{
order.SendDate = (DateTime)txbDELdate.Tag;
}
if (txbIssuedDate.Tag != null)
{
order.OrderDate = (DateTime)txbIssuedDate.Tag;
}
foreach (var odd in FCainzOrderD.ORDERDETAILLIST)
{
odd.OrderDetailID = Guid.NewGuid();
odd.OrderID = order.OrderID;
odd.CainzOrderOrderID = odd.OrderID;
order.Money += odd.TotalMoney;
}
order.CainzOrderDetail = FCainzOrderD.ORDERDETAILLIST.ToList();
using (var db = PublicDB.getDB())
{
db.CainzOrder.Add(order);
db.SaveChanges();
}
//throw new NotImplementedException();
}
private void btnImportOrder_Click(object sender, EventArgs e)
{
OpenFileDialog ofd = new OpenFileDialog();
//ofd.DefaultExt = ".xls";
ofd.Filter = "excel file |*.xls;*.xlsx";
if (ofd.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
entity.CainzOrder order = new entity.CainzOrder();
try
{
ReadOrderSheet2(ofd.FileName, out order);
}
catch(Exception ee)
{
MessageBox.Show("报错信息："+ee.Message,"导入失败",MessageBoxButtons.OK,MessageBoxIcon.Error,MessageBoxDefaultButton.Button1);
}
}
}
public void ReadOrderSheet2(string excelPath, out entity.CainzOrder order)
{
order = new entity.CainzOrder();
IWorkbook wb = WorkbookFactory.Create(excelPath);
if (wb.NumberOfSheets < 2) return;
ISheet ist = wb.GetSheetAt(1);
int rowofPage = ist.LastRowNum + 1;
string _IssuedDate = PublicTools.GetCellString(ist, 'a', 2).Replace("下单日期：", "").Trim();
string _TraderName = PublicTools.GetCellString(ist, 'a', 3).Replace("所属贸易公司：", "").Trim();
string _factoryName = PublicTools.GetCellString(ist, 'a', 4).Replace("订购工厂：", "").Trim();
string _factoryAdd = PublicTools.GetCellString(ist, 'a', 5).Replace("交货地址/电话：", "").Trim();
string _factoryContact = PublicTools.GetCellString(ist, 'a', 6).Replace("联系人：", "").Trim();
string _DELdate = PublicTools.GetCellString(ist, 'e', 6).Replace("交货期：", "").Trim();
string _FileName = PublicTools.GetCellString(ist, 'f', 9).Replace("文件位置：", "").Trim();
string _OrderNo = PublicTools.GetCellString(ist, 'a', 8).Replace("合 同 编 号:", "").Trim();
string _OrderJCNo = PublicTools.GetCellString(ist, 'a', 9).Replace("我司订单编号：", "").Trim();
order.OrderID = Guid.NewGuid();
order.Address = _factoryAdd;
entity.CainzFactory factory = PublicDB.GetFactoryByName(_factoryName);
if (factory != null)
{
order.CainzFactoryFactoryID = factory.FactoryID;
order.FactoryID = factory.FactoryID;
order.FactoryName = factory.FactoryName;
order.CainzFactory = factory;
}
order.IsDelete = 0;
order.isDraft = 0;
order.LastUpdate = DateTime.Now;
order.OrderDate = DateTime.Parse(_IssuedDate);
order.OrderExNo = _OrderJCNo;
order.OrderNo = _OrderNo;
order.TraderName = _TraderName;
order.CreateTime = DateTime.Now;
order.SendDate = DateTime.Parse(_DELdate);
order.Status = 0;
//order.Money =( (Decimal)PublicTools.GetCellNumic(ist, 'i', 31);
for (int i = 12; i < 31; i++)
{
entity.CainzOrderDetail detail = new entity.CainzOrderDetail();
detail.OrderDetailID = Guid.NewGuid();
detail.OrderID = order.OrderID;
detail.IsDelete = 0;
detail.CreateTime = DateTime.Now;
detail.RowNo = i - 11;
detail.Status = 0;
detail.ProductBarcode = PublicTools.GetCellString(ist, 'b', i);
if (detail.ProductBarcode != string.Empty)
{
entity.CainzProduct _product = PublicDB.GetProductByBarcode(detail.ProductBarcode);
if (_product != null)
{
detail.CainzProductProductID = _product.ProductID;
detail.ProductID = _product.ProductID;
detail.ProductName = _product.ProductName;
detail.ProductSize = _product.ProductSize;
detail.ProductColor = _product.ProductColor;
detail.ProductMaterial = _product.ProductMaterial;
detail.POPNum = (int)PublicTools.GetCellNumic(ist, 'g', i);
detail.ProductPrice = _product.ProductPrice;
detail.TotalMoney = (Decimal)(detail.POPNum * detail.ProductPrice);
string eDate = PublicTools.GetCellString(ist, 'j', i);
if (eDate != string.Empty)
{
try
{
detail.ExpectDate = DateTime.Parse(eDate);
}
catch(Exception ee)
{
}
}
detail.ExpectDateFormat = PublicTools.GetCellString(ist, 'j', i);
detail.Remark = PublicTools.GetCellString(ist, 'l', i);
order.CainzOrderDetail.Add(detail);
}
}
else
{
break;
}
}
FCainzOrderD.FACTORY = order.CainzFactory;
FCainzOrderD.ORDERDETAILLIST = new BindingList<entity.CainzOrderDetail>(order.CainzOrderDetail.ToList());
cainzOrderDetailBindingSource.DataSource = ORDERDETAILLIST;
bdsCustomer.DataSource = FACTORY;
//LoadOrder(order);
}
