Esempio n. 1
0
        public List <ZcProcessOrderItem> getItemByid(string orderId)
        {
            List <ZcProcessOrderItem> list = new List <ZcProcessOrderItem>();
            OracleConnection          conn = null;

            try
            {
                conn = OracleUtil.OpenConn();
                string        sql     = "select * from zc_order_process_item where order_id='" + orderId + "'";
                OracleCommand command = new OracleCommand(sql);
                command.Connection = conn;
                var reader = command.ExecuteReader();
                while (reader.Read())
                {
                    ZcProcessOrderItem user = new ZcProcessOrderItem();
                    user.id           = reader.IsDBNull(0) ? string.Empty : reader.GetString(0);
                    user.createTime   = reader.IsDBNull(1) ? default(DateTime) : reader.GetDateTime(1);
                    user.updateTime   = reader.IsDBNull(2) ? default(DateTime) : reader.GetDateTime(2);
                    user.addon        = reader.IsDBNull(3) ? default(double) : reader.GetDouble(3);
                    user.amount       = reader.IsDBNull(4) ? string.Empty : reader.GetString(4);
                    user.bn           = reader.IsDBNull(5) ? string.Empty : reader.GetString(5);
                    user.cost         = reader.IsDBNull(6) ? string.Empty : reader.GetString(6);
                    user.g_price      = reader.IsDBNull(7) ? string.Empty : reader.GetString(7);
                    user.goodsState   = reader.IsDBNull(8) ? string.Empty : reader.GetString(8);
                    user.item_type    = reader.IsDBNull(9) ? string.Empty : reader.GetString(9);
                    user.name         = reader.IsDBNull(10) ? string.Empty : reader.GetString(10);
                    user.nums         = reader.IsDBNull(11) ? string.Empty : reader.GetString(11);
                    user.obj_id       = reader.IsDBNull(12) ? string.Empty : reader.GetString(12);
                    user.order_id     = reader.IsDBNull(13) ? string.Empty : reader.GetString(13);
                    user.price        = reader.IsDBNull(14) ? string.Empty : reader.GetString(14);
                    user.product_id   = reader.IsDBNull(15) ? string.Empty : reader.GetString(15);
                    user.score        = reader.IsDBNull(16) ? string.Empty : reader.GetString(16);
                    user.sendNum      = reader.IsDBNull(17) ? string.Empty : reader.GetString(17);
                    user.type_id      = reader.IsDBNull(18) ? string.Empty : reader.GetString(18);
                    user.weight       = reader.IsDBNull(19) ? string.Empty : reader.GetString(19);
                    user.goodsFile    = reader.IsDBNull(20) ? string.Empty : reader.GetString(20);
                    user.providerInfo = reader.IsDBNull(21) ? string.Empty : reader.GetString(21);
                    list.Add(user);
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
            finally
            {
                OracleUtil.CloseConn(conn);
            }
            return(list);
        }
Esempio n. 2
0
        public void updateStoreHouse(ZcProcessOrderItem zcProcessOrderItem)
        {
            string            sql  = "update zc_storehouse set store = :store, storemoney = :money where id = :id";
            OracleConnection  conn = null;
            OracleTransaction tran = null;
            OracleCommand     cmd  = new OracleCommand();

            try
            {
                StoreHouse storeHouse = FindByGoodsFileId(zcProcessOrderItem.goodsFile);
                float      old        = float.Parse(storeHouse.Store);
                storeHouse.Store      = (old - float.Parse(zcProcessOrderItem.nums)).ToString();
                storeHouse.StoreMoney = ((old - float.Parse(zcProcessOrderItem.nums)) * (float.Parse(storeHouse.StoreMoney) / old)).ToString();
                conn            = OracleUtil.OpenConn();
                tran            = conn.BeginTransaction();
                cmd.Connection  = conn;
                cmd.CommandText = sql;
                cmd.Parameters.Add(":store", storeHouse.Store);
                cmd.Parameters.Add(":money", storeHouse.StoreMoney);
                cmd.Parameters.Add(":id", storeHouse.Id);
                cmd.ExecuteNonQuery();
                tran.Commit();
            }
            catch (Exception ex)
            {
                if (tran != null)
                {
                    tran.Rollback();
                }
                Console.WriteLine(ex.Message);
            }
            finally
            {
                OracleUtil.CloseConn(conn);
            }
        }
Esempio n. 3
0
        private void endButton_Click(object sender, EventArgs e)
        {
            if (sortFlag == false)
            {
                DataTable dt      = ConstantUtil.Branchds.Tables["Zc_sorte_item"];
                object    sorteId = dt.Rows[0][8];
                if (ConstantUtil.index + 1 >= dt.Rows.Count)
                {
                    for (int i = 0; i < goodDataGridView.Rows.Count; i++)
                    {
                        string oldCount = goodDataGridView.Rows[i].Cells[3].Value == null ? "" : goodDataGridView.Rows[i].Cells[3].Value.ToString();
                        string newCount = goodDataGridView.Rows[i].Cells[4].Value == null ? "" : goodDataGridView.Rows[i].Cells[4].Value.ToString();
                        if (oldCount.Equals(newCount))
                        {
                        }
                        else
                        {
                            DialogResult dr = MessageBox.Show("存在分拣份数不符合的商品,确定结束分拣?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
                            if (dr == DialogResult.OK)
                            {
                                break;
                            }
                            else
                            {
                                return;
                            }
                        }
                    }

                    orderDao orderdao = new orderDao();
                    orderdao.deleteSorteStatus(ConstantUtil.ip1);
                    orderdao.deleteSorteStatus(ConstantUtil.ip2);
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        object id       = dt.Rows[i][0];
                        object streetId = dt.Rows[i][14];
                        List <ZcProcessOrder> ZcProcessOrderList = orderdao.FindAll(streetId.ToString());
                        if (ZcProcessOrderList != null && ZcProcessOrderList.Count() > 0)
                        {
                            for (int a = 0; a < ZcProcessOrderList.Count; a++)
                            {
                                ZcProcessOrder            zcprocessOrder         = ZcProcessOrderList[a];
                                string                    orderId                = zcprocessOrder.id;
                                List <ZcProcessOrderItem> ZcProcessOrderItemList = orderdao.getItemByid(orderId);
                                if (ZcProcessOrderItemList != null && ZcProcessOrderItemList.Count() > 0)
                                {
                                    orderdao.AddtransitItem(ZcProcessOrderItemList);
                                    for (int b = 0; b < ZcProcessOrderItemList.Count; b++)
                                    {
                                        ZcProcessOrderItem zcProcessOrderItem = ZcProcessOrderItemList[b];
                                        string             itemId             = zcProcessOrderItem.id;
                                        orderdao.deletePorcessItem(itemId);
                                        orderdao.updateStoreHouse(zcProcessOrderItem);
                                    }
                                }
                                if ("全部完成".Equals(zcprocessOrder.pullFlag))
                                {
                                    zcprocessOrder.orderStatus = "5";
                                    orderdao.deletePorcessOrder(zcprocessOrder.id);
                                    int count = orderdao.getTransitOrderCount(zcprocessOrder.id);

                                    if (count == 0)
                                    {
                                        orderdao.AddtransitOrder(zcprocessOrder);
                                    }
                                    else
                                    {
                                    }
                                }
                                else
                                {
                                }
                            }
                        }
                    }
                    //改变订单状态
                    orderdao.UpdateStatus(sorteId);
                    MessageBox.Show("分拣完毕!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    sortFlag = true;
                }
                else
                {
                    MessageBox.Show("所有分店尚未分拣完毕,请分拣完毕后再提交数据");
                }
            }
            else
            {
                MessageBox.Show("订单已分拣结束,请返回或退出操作");
            }
        }