Example #1
0
        public override long Insert(BoxItemInfo obj, TransactionManager trans)
        {
            var sqlStatement = "Insert Into BoxItem(BoxDate,BoxNo,ItemName,ItemModel,ItemNum) Values (@BoxDate,@BoxNo,@ItemName,@ItemModel,@ItemNum)";
            var parms = new[] { new OleDbParameter("@BoxDate", OleDbType.Date) { Value = obj.BoxDate },
                new OleDbParameter("@BoxNo",OleDbType.Integer){Value = obj.BoxNo},
                new OleDbParameter("@ItemName",OleDbType.VarWChar,50){Value = obj.ItemName},
                new OleDbParameter("@ItemModel",OleDbType.VarWChar,50){Value = obj.ItemModel},
                new OleDbParameter("@ItemNum",OleDbType.Integer){Value = obj.ItemNum},
            };

            try
            {
                AccessHelper.ExecuteNonQuery(trans.TransactionObject as OleDbTransaction, sqlStatement, parms);
                var id = GetIdentity(trans);

                return id;
            }
            catch (Exception ex)
            {
                Logger.Error(ex.Message, ex);
                return 0;
            }
        }
Example #2
0
 /// <summary>
 /// 将dr转变到装箱物料实体。
 /// </summary>
 /// <param name="dr"></param>
 /// <returns>装箱物料实体。</returns>
 private static BoxItemInfo ConvertToBoxItemInfo(IDataRecord dr)
 {
     var obj = new BoxItemInfo();
     obj.Id = long.Parse(dr["Id"].ToString());
     obj.BoxDate = DateTime.Parse(dr["BoxDate"].ToString());
     obj.BoxNo = int.Parse(dr["BoxNo"].ToString());
     obj.ItemName = dr["ItemName"].ToString();
     obj.ItemModel = dr["ItemModel"]== DBNull.Value?string.Empty:dr["ItemName"].ToString();
     obj.ItemNum = int.Parse(dr["ItemNum"].ToString());
     return obj;
 }
Example #3
0
        private void button1_Click(object sender, EventArgs e)
        {
            #region clear oldData
            using (var trans = DataRepository.Provider.CreateTransaction())
            {
                trans.BeginTransaction();
                var boxs = DataRepository.BoxProvider.GetByBoxDate(this.CurrentDate, trans);
                if (boxs.Count > 0)
                {
                    if (MessageBox.Show("指定日期已经存在记录,是否覆盖原有的记录!", "确认", MessageBoxButtons.YesNo) == DialogResult.Yes)
                    {
                            foreach (var obj in boxs)
                            {
                                if (DataRepository.BoxProvider.Delete(obj, trans) == false)
                                {
                                    trans.Rollback();
                                    return;
                                }
                            }
                            var boxContracts = DataRepository.BoxContractProvider.GetByBoxDate(this.CurrentDate, trans);
                            foreach (var obj in boxContracts)
                            {
                                if (DataRepository.BoxContractProvider.Delete(obj, trans) == false)
                                {
                                    trans.Rollback();
                                    return;
                                }
                            }
                            var boxItems = DataRepository.BoxItemProvider.GetByBoxDate(this.CurrentDate, trans);
                            foreach (var obj in boxItems)
                            {
                                if (DataRepository.BoxItemProvider.Delete(obj, trans) == false)
                                {
                                    trans.Rollback();
                                    return;
                                }
                            }
                        }
                    }
                trans.Commit();
            }
            #endregion

            var path = DataRepository.PathProvider.Get();
            if (path != null)
            {
                this.LastPath = path.LastPath;
                this.openFileDialog1.InitialDirectory = path.LastPath;
            }
            this.openFileDialog1.Filter = "文本文件(*.txt)|*.txt";

            if(this.openFileDialog1.ShowDialog()==DialogResult.OK)
            {
                var fileName = this.openFileDialog1.FileName;
                var currentPath = Directory.GetParent(fileName).FullName;
                if (!string.IsNullOrEmpty(this.LastPath))
                {
                    if (this.LastPath != currentPath)
                    {
                        this.LastPath = currentPath;
                        DataRepository.PathProvider.Delete();
                        DataRepository.PathProvider.Insert(new PathInfo { LastPath = this.LastPath });
                    }
                }
                StreamReader sr = new StreamReader(this.openFileDialog1.FileName, System.Text.Encoding.Default);
                var linenumber = 0;
                var line = sr.ReadLine().Trim();
                //var IsTaskRegion = false;
                if (line.Contains("任务清单"))
                {
                    //IsTaskRegion = true;
                }
                line = sr.ReadLine().Trim();
                if (string.IsNullOrEmpty(line))
                    line = sr.ReadLine().Trim();

                using (var trans = DataRepository.Provider.CreateTransaction())
                {
                    trans.BeginTransaction();
                    while (!string.IsNullOrEmpty(line))
                    {
                        //Task

                        var tasks = line.Split("\t".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
                        var obj = new BoxContractInfo { BoxNo = int.Parse(tasks[0].Trim()), ContractNo = tasks[1].Trim(), BoxDate = this.CurrentDate };
                        DataRepository.BoxContractProvider.Insert(obj, trans);
                        line = sr.ReadLine().Trim();
                        linenumber++;
                    }
                    //IsTaskRegion = false;

                    var items = DataRepository.ItemProvider.GetAll(trans) as List<ItemInfo>;

                    BoxItemInfo mainBoxItemInfo = null;
                    line = sr.ReadLine().Trim();
                    while (line != null)//End of File.
                    {
                        if (!string.IsNullOrEmpty(line) && !line.Contains("装箱日期:") && !line.Contains("打印日期"))
                        {
                            if (!line.Contains("<="))
                            {
                                var boxItems = line.Split("\t".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
                                if (boxItems.Length == 5)
                                {
                                    string model = "";
                                    if (boxItems[1].LastIndexOf('L') < 0 && boxItems[1].LastIndexOf('A')<0)
                                        model = boxItems[1];
                                    else if (boxItems[1].LastIndexOf('L')>=0)
                                        model = boxItems[1].Substring(0,boxItems[1].LastIndexOf('L'));
                                    else if(boxItems[1].LastIndexOf('A')>=0)
                                        model = boxItems[1].Substring(0, boxItems[1].LastIndexOf('A'));

                                    mainBoxItemInfo = new BoxItemInfo { ItemModel = boxItems[1].Trim(), ItemName = boxItems[2].Trim() };

                                    //if (items.Find(item => item.ItemName == boxItems[2].Trim()) != null)
                                    //if(items.Find(item=>item.ItemName.Equals(model,StringComparison.OrdinalIgnoreCase))!=null)
                                    //    mainBoxItemInfo = new BoxItemInfo { ItemModel = boxItems[1].Trim(), ItemName = boxItems[2].Trim() };
                                    //else if (boxItems[2].Contains("#箱~"))
                                    //{
                                    //    mainBoxItemInfo = new BoxItemInfo { ItemModel = boxItems[1].Trim(), ItemName = boxItems[2].Trim() };
                                    //}
                                    //else
                                    //    mainBoxItemInfo = null;
                                }
                            }
                            else
                            {
                                if (mainBoxItemInfo != null)
                                {
                                    var detailItems = line.Split("\t".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
                                    if (detailItems.Length % 3 == 0)
                                    {
                                        if (mainBoxItemInfo.ItemName.Contains("#箱~"))
                                        {
                                            for (var i = 0; i < detailItems.Length; i = i + 3)
                                            {
                                                var boxInfo = new BoxInfo();
                                                boxInfo.BoxModel = mainBoxItemInfo.ItemModel;
                                                boxInfo.BoxName = mainBoxItemInfo.ItemName.Split("~".ToCharArray())[0];
                                                boxInfo.BoxSpec = mainBoxItemInfo.ItemName.Split("~".ToCharArray())[1];
                                                boxInfo.BoxNo = int.Parse(detailItems[i].Trim());
                                                boxInfo.BoxDate = this.CurrentDate;
                                                if (DataRepository.BoxProvider.Insert(boxInfo, trans) == 0)
                                                {
                                                    trans.Rollback();
                                                    return;
                                                }
                                            }
                                        }

                                        for (var i = 0; i < detailItems.Length; i = i + 3)
                                        {
                                            var boxItemInfo = new BoxItemInfo();
                                            boxItemInfo.ItemModel = mainBoxItemInfo.ItemModel;
                                            boxItemInfo.ItemName = mainBoxItemInfo.ItemName;
                                            boxItemInfo.BoxNo = int.Parse(detailItems[i].Trim());
                                            boxItemInfo.ItemNum = int.Parse(detailItems[i + 2].Trim());
                                            boxItemInfo.BoxDate = this.CurrentDate;
                                            if (DataRepository.BoxItemProvider.Insert(boxItemInfo, trans) == 0)
                                            {
                                                trans.Rollback();
                                                return;
                                            }
                                        }

                                    }
                                }
                            }
                        }
                        line = sr.ReadLine();
                    }

                    trans.Commit();

                    MessageBox.Show("解析成功!");

                }
            }
        }