private void sorteGoodList_Load(object sender, EventArgs e)
{
numberTextBox.Focus();
Times times = new Times();
times.TopLevel = false;
this.timePanel.Controls.Add(times);
times.Show();
//if (goodDataGridView.Focused == true)
//{
// MessageBox.Show("true");
//}
//else
//{
// MessageBox.Show("false");
//}
//goodDataGridView.ClearSelection();
int hw = redButton.Height;
if (hw > redButton.Width)
{
hw = redButton.Width;
}
System.Drawing.Drawing2D.GraphicsPath gp = new System.Drawing.Drawing2D.GraphicsPath();
gp.AddEllipse(4, 4, hw - 8, hw - 8);
gp.FillMode = System.Drawing.Drawing2D.FillMode.Winding;
redButton.Region = new Region(gp);
redButton.BackColor = Color.Red;
yellowButton.Region = new Region(gp);
yellowButton.BackColor = Color.Yellow;
greenButton.Region = new Region(gp);
greenButton.BackColor = Color.Green;
//---
dt = ConstantUtil.Branchds.Tables["Zc_sorte_item"];
result = dt.Rows[ConstantUtil.index][14];
textBox2.Text = dt.Rows[ConstantUtil.index][9].ToString();
sortedao = new orderDao();
branchName = sortedao.getBranchName(result.ToString());
textBox1.Text = branchName;
//展示数据
showInfo();
//后台刷新数据
System.Timers.Timer pTimer = new System.Timers.Timer(1000); //每隔5秒执行一次，没用winfrom自带的
pTimer.Elapsed += new System.Timers.ElapsedEventHandler(pTimer_Elapsed); //委托，要执行的方法
pTimer.AutoReset = true; //获取该定时器自动执行
pTimer.Enabled = true; //这个一定要写，要不然定时器不会执行的
Control.CheckForIllegalCrossThreadCalls = false; //这个不太懂，有待研究
}
public orderDto OrderDaoToOrderDto(orderDao o)
{
orderDto od = new orderDto();
od.Id = o.Id;
od.Name = o.Name;
od.products = new List <productDto>();
foreach (var item in o.products)
{
od.products.Add(ProductDaoToProductDto(item));
}
od.totalPrice = o.totalPrice;
return(od);
}
private void startButton_Click(object sender, EventArgs e)
{
DataTable dt = ConstantUtil.Branchds.Tables["Zc_sorte_item"];
object result = dt.Rows[ConstantUtil.index][14];
//byte[] buffer = Encoding.Default.GetBytes(result.ToString());
orderDao orderdao = new orderDao();
if (ConstantUtil.ipList == null || ConstantUtil.ipList.Count == 0)
{
MessageBox.Show("工位或者工位IP尚未设定，请设定完毕后再开始分拣");
return;
}
else
{
for (int i = 0; i < ConstantUtil.ipList.Count; i++)
{
string ip = ConstantUtil.ipList[i];
orderdao.insertSorteStatus(result.ToString(), ip);
}
}
redButton.Hide();
redLabel.Hide();
greenButton.Show();
greenLabel.Show();
yellowButton.Hide();
yellowLabel.Hide();
numberTextBox.Focus();
//if (ConstantUtil.socketList.Count > 0)
//{
// orderDao orderdao = new orderDao();
// orderdao.insertSorteStatus(result.ToString(),ConstantUtil.ip1);
// orderdao.insertSorteStatus(result.ToString(), ConstantUtil.ip2);
// redButton.Hide();
// redLabel.Hide();
// greenButton.Show();
// greenLabel.Show();
// yellowButton.Hide();
// yellowLabel.Hide();
//}
//else
//{
// MessageBox.Show("目前未有子设备连接主机!");
//}
//byte[] buffer = Encoding.Default.GetBytes(str);
//connSocket.Send(buffer, buffer.Length, SocketFlags.None);
}
public string[] GetPrintStr()
{
//DataTable dt = ConstantUtil.Branchds.Tables["Zc_sorte_item"];
//string street = dt.Rows[ConstantUtil.index][13].ToString();
sortedao = new orderDao();
branchName = sortedao.getBranchName(ConstantUtil.street);
StringBuilder sb = new StringBuilder();
string tou = "宜鲜美配送有限公司";
string address = "南京市江宁区东麒路66号";
//string saleID = id_.Text;
//string item = "品名";
//decimal price = 25.00M;
//int count = 5;
//decimal total = 0.00M;
//decimal fukuan = 500.00M;
sb.Append(" " + tou + " \n");
sb.Append("-----------------------------------------------------------------\n");
sb.Append("日期:" + DateTime.Now.ToShortDateString() + " " + "分店:" + branchName + "\n");
sb.Append("-----------------------------------------------------------------\n");
sb.Append("品名" + "\t\t" + "单价" + "\t" + "重/数量" + "\t" + "小计" + "\n");
//for (int i = 0; i < itemDataGridView.RowCount; i++)
//{
// int actualnums = itemDataGridView[4, i].Value == null ? 0 : Convert.ToInt32(itemDataGridView[4, i].Value);
// if (actualnums != 0)
// {
// string name = itemDataGridView[1, i].Value == null ? "" : itemDataGridView[1, i].Value.ToString();
// if (name.Length < 4)
// {
// name += "\t\t";
// }
// else if (name.Length <= 6)
// {
// name += "\t";
// }
// else
// {
// name = name.Substring(0, 6) + "... ";
// }
// string price = itemDataGridView[2, i].Value == null ? "" : itemDataGridView[2, i].Value.ToString();
// price = float.Parse(price).ToString("0.00");
// string amount = itemDataGridView[7, i].Value == null ? "" : itemDataGridView[7, i].Value.ToString();
// amount = float.Parse(amount).ToString("0.00");
// sb.Append(name + price + "\t" + actualnums + "\t" + amount + "\n");
// }
//}
float totalSum = 0;
float totalAmount = 0;
string sql = "select a.goods_id, a.goods_name, a.SORTENUM, a.WEIGHT, b.GOODS_PRICE, b.GOODS_UNIT from ZC_ORDERS_SORTE a left join ZC_GOODS_MASTER b "
+ " on a.GOODS_ID = b.SERIALNUMBER where a.ADDRESS = :street and a.SORTEID = :sorteId order by b.serialnumber ";
OracleConnection conn = null;
OracleCommand cmd = new OracleCommand();
try
{
conn = OracleUtil.OpenConn();
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.Parameters.Add(":street", ConstantUtil.street);
cmd.Parameters.Add(":sorteId", ConstantUtil.sorte_id);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
string serialNumber = reader.IsDBNull(0) ? string.Empty : reader.GetString(0);
string name = reader.IsDBNull(1) ? string.Empty : reader.GetString(1);
string sorteNum = reader.IsDBNull(2) ? "0" : reader.GetString(2);
string weightString = reader.IsDBNull(3) ? "0" : reader.GetString(3);
string goodsPrice = reader.IsDBNull(4) ? "0" : reader.GetFloat(4).ToString("0.00");
string unit = reader.IsDBNull(5) ? string.Empty : reader.GetString(5);
float weight = float.Parse(weightString);
float price = float.Parse(goodsPrice);
float nums = float.Parse(sorteNum);
totalSum += nums;
totalAmount += price * nums;
if (name.Length < 4)
{
name += "\t\t";
}
else if (name.Length <= 6)
{
name += "\t";
}
else
{
name = name.Substring(0, 6) + "...\t";
}
if (serialNumber.Length == 5)
{
sb.Append(name + price.ToString("0.00") + "\t" + weight.ToString("0.000") + "\t" + (price * weight).ToString("0.00") + "\n");
}
else
{
sb.Append(name + price.ToString("0.00") + "\t" + sorteNum + unit + "\t" + (price * nums).ToString("0.00") + "\n");
}
}
}
catch (Exception ex)
{
log.Error(ex.Message, ex);
}
finally
{
cmd.Dispose();
OracleUtil.CloseConn(conn);
}
sb.Append("-----------------------------------------------------------------\n");
sb.Append("数量: " + totalSum.ToString("0.00") + "\t\t 合计: " + totalAmount.ToString("0.00") + "\n");
sb.Append("-----------------------------------------------------------------\n");
sb.Append("地址：" + address + "\n");
sb.Append(" 谢谢惠顾欢迎下次光临 ");
//log.Error(sb.ToString()+"--------->");
return(sb.ToString().Split('\n'));
}
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("订单已分拣结束，请返回或退出操作");
}
}
public DataSet getGridData()
{
result = dt.Rows[ConstantUtil.index][14];
string remark = dt.Rows[ConstantUtil.index][9].ToString().Trim();
if (string.IsNullOrEmpty(remark))
{
//topPanel.Height = 100;
messagePanel.Visible = false;
goodTablePanel.Location = new Point(3, 117);
//goodTablePanel.Anchor = AnchorStyles.Left | AnchorStyles.Right | AnchorStyles.Top | AnchorStyles.Bottom;
textBox2.Text = "";
//label1.Visible = false;
//textBox2.Visible = false;
// goodTablePanel.Height = goodTableGroupBox.Height - topPanel.Height - topPanel.Location.Y;
}
else
{
//topPanel.Height = 165;
messagePanel.Visible = true;
goodTablePanel.Location = new Point(3, 182);
//goodTablePanel.Anchor = AnchorStyles.Left | AnchorStyles.Right | AnchorStyles.Top | AnchorStyles.Bottom;
//goodTablePanel.Height = goodTableGroupBox.Height - topPanel.Height - topPanel.Location.Y - messagePanel.Location.Y - messagePanel.Height;
//label1.Visible = true;
//textBox2.Visible = true;
textBox2.Text = remark;
}
sortedao = new orderDao();
branchName = sortedao.getBranchName(result.ToString());
textBox1.Text = branchName;
try
{
OracleConnection connection = OracleUtil.OpenConn();
if (connection == null)
{
ds = null;
}
else
{
//在每次查找或填充数据前判断ds是否为null
if (ds != null)
{
if (ds.Tables.Count > 0)
{
ds.Tables[0].Rows.Clear();
ds.Tables[0].Columns.Clear();
ds.Tables[0].AcceptChanges();
}
}
else
{
ds = new DataSet();
}
string sql = "select name,serialNumber,goodsfile_id,sum(nums) as nums,branchid ,sorteNum ,workname,workcode from "
+ "(select a.goods_state,a.name,a.nums,c.id as goodsfile_id,c.serialNumber,b.branchid,d.sortenum,e.workname,e.workcode "
+ " from zc_order_process_item a "
+ " left join zc_order_process b on b.id=a.order_id left join zc_goods_master c on c.id=a.goodsfile_id left join (select SUM(sortenum) as sortenum,goods_id ,address from ZC_ORDERS_SORTE where sorteId = '" + ConstantUtil.sorte_id + "' GROUP by goods_id, address) d on d.goods_id = c.id and b.branchid=d.address left join zc_workstation e on e.id = c.zcuserinfo"
+ " where branchid = '" + result + "' ) "
+ "group by name,serialNumber,goodsfile_id,branchid,sorteNum,workname,workcode order by serialNumber";
OracleCommand cmd = new OracleCommand(sql, connection);
OracleDataAdapter da = new OracleDataAdapter(cmd);
da.Fill(ds, "Zc_sorte_item");
connection.Close();
}
}
catch (Exception ex)
{
log.Error("加载各分店商品信息失败", ex);
}
return(ds);
}
public bool DeleteOrder(orderDao od)
{
return(c.DeleteOrder(map.OrderDaoToOrder(od)));
}
public bool AddOrder(orderDao od)
{
return(c.AddOrder(map.OrderDaoToOrder(od)));
}
