/// <summary>
/// 选择订单时，右边显示订单详细
/// </summary>
private void BindOrderDetail()
{
if (this.dataGridView_OrderList.SelectedRows.Count != 1)
return;
string orderCode = this.dataGridView_OrderList.SelectedRows[0].Cells["Column_OrderCode"].Value.ToString();
VipSoft.BLL.OrderDetail detail = new VipSoft.BLL.OrderDetail();
DataTable dt = detail.GetList("OrderCode='" + orderCode + "'").Tables[0];
this.dataGridView_DetailList.DataSource = dt;
}
private void dgvSellWater_CellClick(object sender, DataGridViewCellEventArgs e)
{
this.dgvCollect.Rows.Clear();
if (this.dgvSellWater.SelectedRows.Count == 0)
return;
string orderCode = this.dgvSellWater.SelectedRows[0].Cells[0].Value.ToString();
//汇总表
DataSet ds = new VipSoft.BLL.OrderDetail().GetListCollect("SELECT GoodsCode,GoodsName,price,Number as numbers,DiscountPrice as sumMoneys from orderLog left join orderDetail on orderLog.orderCode=orderDetail.orderCode where orderDetail.orderCode='" + orderCode + "' ");
foreach (DataRow drt in ds.Tables[0].Rows)
{
this.dgvCollect.Rows.Add(drt["GoodsCode"], drt["GoodsName"], drt["price"], drt["numbers"], drt["sumMoneys"]);
}
}
private void Button_G_Query_Click(object sender, EventArgs e)
{
this.dgvGCollect.Rows.Clear();
this.dgvGWater.Rows.Clear();
StringBuilder sb = new StringBuilder();
sb.Append("1=1");
if (this.dateTimePicker_G_Start.Checked)
{
DateTime time1;
string t1 = this.dateTimePicker_G_Start.Value.ToShortDateString() + " " + this.maskedTextBox_G_Start.Text;
if (!DateTime.TryParse(t1, out time1))
{
MessageBox.Show("开始时间输入错误！");
this.maskedTextBox_G_Start.Text = "00:00:00";
t1 = this.dateTimePicker_G_Start.Value.ToShortDateString() + " " + "00:00:00";
DateTime.TryParse(t1, out time1);
}
sb.Append(" a.CreateDateTime >= '" + time1.ToString() + "'");
}
if (this.dateTimePicker_G_End.Checked)
{
DateTime time2;
string t2 = this.dateTimePicker_G_End.Value.ToShortDateString() + " " + this.maskedTextBox_G_End.Text;
if (!DateTime.TryParse(t2, out time2))
{
MessageBox.Show("结束时间输入错误！");
this.maskedTextBox_G_End.Text = "23:59:59";
t2 = this.dateTimePicker_G_End.Value.ToShortDateString() + " " + "23:59:59";
DateTime.TryParse(t2, out time2);
}
sb.Append(" a.CreateDateTime <= '" + time2.ToString() + "'");
}
string type;
if (this.comboBox_G_OrderType.SelectedIndex == 1)
{
sb.Append(" and a.OrderType=0");// 余额消费
if (this.comboBox_G_PayType.SelectedIndex != -1 && this.comboBox_G_PayType.SelectedIndex != 0)
{
type = ((DictionaryEntry)this.comboBox_G_PayType.SelectedItem).Value.ToString();
sb.Append(" and a.PayType=" + type);
}
}
else if (this.comboBox_G_OrderType.SelectedIndex == 2)
sb.Append(" and a.OrderType=1");// 记次
if (this.comboBox_G_Class.SelectedIndex != 0)
{
string classID = ((DataRowView)this.comboBox_G_Class.SelectedItem)["Value"].ToString();
DataTable dtClass = new VipSoft.BLL.GoodsClass().GetList("ShopID=" + PublicState.Master.ShopID).Tables[0];
string ids = Function.GetChildClassListStr(dtClass, classID);
if (ids != "")
sb.Append(" b.ID in (select ID from Goods where ClassID in (" + ids + "))");
else
sb.Append(" b.ID in (select ID from Goods where ClassID = " + classID + ")");
}
if (this.TextBox_G_Key.Text != "")
sb.Append(" a.GoodsCode='" + this.TextBox_G_Key.Text + "' or a.GoodsName like '%" + this.TextBox_G_Key.Text + "%'");
if (this.textBox_G_Price.Text != "￥0.00" && this.textBox_G_Price.Text != "")
sb.Append(" a.Price" + this.comboBox_G_Sign.Text + this.textBox_G_Price.Text.Replace("￥", ""));
if (this.searchMember3.CardID != "")
{
searchMember3.GetSearchMember();
sb.Append("MemID=" + this.searchMember3.MemID);
}
decimal gmoney = 0M;
decimal danprice = 0M;
decimal jinhuoprice = 0M;
int xinums = 0;
decimal lirun = 0M;
decimal Zprice = 0M;
decimal Cprice = 0M;
int SumN = 0;
//汇总表
DataSet ds = new VipSoft.BLL.OrderDetail().GetListCollect("SELECT a.GoodsCode,a.GoodsName,a.price,sum(a.Number) as numbers,sum(DiscountPrice) as sumMoneys,b.buyprice,(sum(b.price*a.Number)-sum(b.buyprice*a.Number)) as buyprices from (select orderDetail.GoodsCode,orderDetail.GoodsName,orderDetail.price,orderDetail.Number,OrderLog.PayType,OrderLog.MemID,OrderLog.CreateDateTime,OrderLog.OrderType,orderDetail.DiscountPrice from orderLog left join orderDetail on orderLog.orderCode=orderDetail.orderCode ) as a left join goods as b on b.goodscode=a.goodscode where " + sb.ToString() + " and a.OrderType not in (2,3,8) group by a.goodsCode,a.goodsName,a.price,b.buyprice");
if (ds.Tables[0].Rows.Count > 0)
{
this.lbl_G_Loading.Visible = false;
}
else
{
this.lbl_G_Loading.Visible = true;
}
foreach (DataRow drt in ds.Tables[0].Rows)
{
gmoney += Math.Round(decimal.Parse(drt["sumMoneys"].ToString()), 2);
danprice = Math.Round(decimal.Parse(drt["price"].ToString()), 2);
jinhuoprice = Math.Round(decimal.Parse(drt["buyprice"].ToString()), 2);
xinums = int.Parse(drt["Numbers"].ToString());
SumN += int.Parse(drt["Numbers"].ToString());
Zprice += xinums * danprice;
Cprice += xinums * jinhuoprice;
lirun += Math.Round(decimal.Parse(drt["buyprices"].ToString()), 2);
try
{
decimal sumMoney = Convert.ToDecimal(drt["price"].ToString()) * int.Parse(drt["numbers"].ToString());
if (sumMoney != 0)
this.dgvGCollect.Rows.Add(drt["GoodsCode"], drt["GoodsName"], drt["price"], drt["buyprice"], drt["numbers"], drt["sumMoneys"], Convert.ToDecimal(drt["buyprices"].ToString()), (Convert.ToDecimal(drt["buyprices"].ToString()) / sumMoney * 100).ToString("0.00") + "%");
else
this.dgvGCollect.Rows.Add(drt["GoodsCode"], drt["GoodsName"], drt["price"], drt["buyprice"], drt["numbers"], drt["sumMoneys"], Convert.ToDecimal(drt["buyprices"].ToString()), "0");
}
catch
{
}
}
lirun = (Zprice - Cprice);
this.lbl_g.Text = gmoney.ToString("￥0.00");
this.lbl_danprice.Text = Zprice.ToString("￥0.00");
this.lbl_jinprice.Text = Cprice.ToString("￥0.00");
this.lbl_lirun.Text = lirun.ToString("￥0.00");
this.lbl_xnum.Text = SumN.ToString();
}
