//获取菜单
public static List <ConsumerDetails> GetCD(int TableID)
{
string sql = @"proc_GetCB";
SqlParameter[] sp =
{
new SqlParameter("@TableID", TableID)
};
SqlDataReader dr = DBhelper.MySqlDataReaderProc(sql, sp);
List <ConsumerDetails> list = new List <ConsumerDetails>();
while (dr.Read())
{
ConsumerDetails cb = new ConsumerDetails();
cb.TableID = Convert.ToInt32(dr[0]);
cb.ProductName = dr[1].ToString();
cb.CDAmount = Convert.ToInt32(dr[2]);
cb.ProductPrice = Convert.ToDouble(dr[3]);
cb.CBID = dr[4].ToString();
cb.CBDate = dr[6].ToString();
cb.CBJE = Convert.ToInt32(dr[2]) * Convert.ToDouble(dr[3]);
cb.ProductID = dr[7].ToString();
list.Add(cb);
}
dr.Close();
return(list);
}
/// <summary>
/// 根据消费项目查询
/// </summary>
/// <param name="names"></param>
/// <returns></returns>
public static List <ConsumerDetails> SelectbyPname(string sj, string sji, string names)
{
List <ConsumerDetails> list = new List <ConsumerDetails>();
string sql = string.Format(@"select d.TableName ,b.ProductName ,a.CDPrice,a.CDAmount,a.CDDate from
ConsumerDetail a inner join Products b on a.ProdcutID=b.ProductID inner join ConsumerBill c on
a.CBID=c.CBID inner join Tables d on c.TableID=d.TableID where CDDate between cast(@sj as datetime) and cast(@sji as datetime)
and ProductName like '%'+@Pname+'%' order by a.CDDate desc");
SqlParameter[] sps = new SqlParameter[]
{
new SqlParameter("@sj", sj),
new SqlParameter("@sji", sji),
new SqlParameter("@Pname", names)
};
SqlDataReader sdr = DBHelper.ExecuteReader(sql, sps);
while (sdr.Read())
{
ConsumerDetails cd = new ConsumerDetails();
cd.CDPrice = Convert.ToInt32(sdr["CDPrice"]);
cd.CDAmount = Convert.ToInt32(sdr["CDAmount"]);
cd.CDDate = sdr["CDDate"].ToString();
cd.Tname = sdr["TableName"].ToString();
cd.Pname = sdr["ProductName"].ToString();
list.Add(cd);
}
sdr.Close();
return(list);
}
/// <summary>
/// 查询指定账单的消费信息
/// </summary>
/// <returns></returns>
public static List <ConsumerDetails> SelectX(String cbid)
{
String Sql = @"select a.CDID,b.ProductName,b.ProductPrice,a.CDAmount,a.CDMoney,a.CDDate
from ConsumerDetail a inner join Products b
on a.ProdcutID=b.ProductID where CDType=0 and CBID=@cbid";
SqlParameter[] Sps = new SqlParameter[] { new SqlParameter("@cbid", cbid) };
SqlDataReader sdr = DBHelper.ExecuteReader(Sql, Sps);
List <ConsumerDetails> list = new List <ConsumerDetails>();
while (sdr.Read())
{
ConsumerDetails c = new ConsumerDetails();
c.CDID = int.Parse(sdr["CDID"].ToString());
c.ProName = sdr["ProductName"].ToString();
c.CDPrice = int.Parse(sdr["ProductPrice"].ToString());
c.CDAmount = int.Parse(sdr["CDAmount"].ToString());
c.CDMoney = int.Parse(sdr["CDMoney"].ToString());
c.CDDate = sdr["CDDate"].ToString();
list.Add(c);
}
sdr.Close();
return(list);
}
private void button1_Click(object sender, EventArgs e)
{//点单
if (this.lv1.SelectedItems.Count == 0)
{
MessageBox.Show(this, "请选择商品!", "提示");
return;
}
if (int.Parse(this.sum.Value.ToString()) == 0)
{
MessageBox.Show(this, "请输入正确的商品数量!", "提示");
return;
}
Products p = this.lv1.SelectedItems[0].Tag as Products;
ConsumerDetails c = new ConsumerDetails();
c.CBID = this.txtzd.Text;
c.ProdcutID = p.ProductID;
c.CDPrice = p.ProductPrice;
c.CDAmount = int.Parse(this.sum.Value.ToString());
c.CDSale = 0;
c.CDMoney = c.CDAmount * c.CDPrice;
c.CDType = 0;
c.CDDate = DateTime.Now.ToString();
Boolean b = CMS.BLL.CDBLL.Insert(c);
if (b == true)
{
//加载已消费的信息到白道
Xf();
}
else
{
MessageBox.Show(this, "点单失败，请重试!", "提示");
}
}
/// <summary>
/// 添加消费详单
/// </summary>
public static Boolean Insert(ConsumerDetails c)
{
int count = CMS.DAL.CDDAL.Insert(c);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
public ActionResult <string> Get()
{
ConsumerDetails[] consumerDetails = new ConsumerDetails[2];
consumerDetails[0] = new ConsumerDetails {
firstName = "Williams", lastName = "Smith", dateOfBirth = "01-Jan-1980"
};
consumerDetails[1] = new ConsumerDetails {
firstName = "Steve", lastName = "Jobs", dateOfBirth = "22-Dec-1970"
};
string response = JsonConvert.SerializeObject(consumerDetails, Formatting.None);
return(response);
}
/// <summary>
/// 保存菜单
/// </summary>
/// <returns></returns>
public static int AddConsumerDetails(ConsumerDetails c)
{
string sql = "insert into dbo.ConsumerDetail values(@CBID,@ProdcutID,@CDPrice,@CDAmount,@CDSale,@CDMoney,@CDType,GETDATE())";
SqlParameter[] sp =
{
new SqlParameter("@CBID", c.CBID),
new SqlParameter("@ProdcutID", c.ProductID),
new SqlParameter("@CDPrice", c.CDPrice),
new SqlParameter("@CDAmount", c.CDAmount),
new SqlParameter("@CDSale", c.CDSale),
new SqlParameter("@CDMoney", c.CDMoney),
new SqlParameter("@CDType", c.CDType),
};
return(DBhelper.MyExecuteNonQuery(sql, sp));
}
/// <summary>
/// 添加消费详单
/// </summary>
/// <param name="c"></param>
/// <returns></returns>
public static int Insert(ConsumerDetails c)
{
String Sql = "insert into ConsumerDetail values(@cbid,@proid,@price,@amount,@sale,@money,@type,@date)";
SqlParameter[] Sps = new SqlParameter[]
{
new SqlParameter("@cbid", c.CBID),
new SqlParameter("@proid", c.ProdcutID),
new SqlParameter("@price", c.CDPrice),
new SqlParameter("@amount", c.CDAmount),
new SqlParameter("@sale", c.CDSale),
new SqlParameter("@money", c.CDMoney),
new SqlParameter("@type", c.CDType),
new SqlParameter("@date", c.CDDate)
};
return(DBHelper.ExecuteNonQuery(Sql, Sps));
}
private void button4_Click(object sender, EventArgs e)
{//退菜
if (this.lv2.SelectedItems.Count == 0)
{
MessageBox.Show(this, "没有选中任何菜品,请选择!", "提示");
return;
}
ConsumerDetails c = this.lv2.SelectedItems[0].Tag as ConsumerDetails;
Boolean b = CMS.BLL.CDBLL.Update(c.CDID.ToString());
if (b == true)
{
MessageBox.Show(this, "退菜成功!", "提示");
}
else
{
MessageBox.Show(this, "退菜失败,请重试!", "提示");
}
Xf();
}
public static int AddConsumerDetails(ConsumerDetails c)
{
return(ConsumerDetailsDAL.AddConsumerDetails(c));
}
private void button1_Click(object sender, EventArgs e)
{
//MessageBox.Show(tabControl1.SelectedIndex.ToString());
//验证内容
if (textBox2.Text.Trim().Length <= 0)
{
new Warning("数量不能为空", 图标.Erro).Show();
return;
}
if (tabControl1.SelectedIndex == 0)
{
if (dataGridView2.SelectedRows.Count <= 0)
{
new Warning("请选择需要添加的商品", 图标.Erro).Show();
return;
}
//获取数据保存到集合
ProductName = dataGridView2.SelectedRows[0].Cells[0].Value.ToString();
ProductPrice = dataGridView2.SelectedRows[0].Cells[1].Value.ToString();
ProductJE = (double.Parse(ProductPrice) * double.Parse(textBox2.Text)).ToString();
ProductID = dataGridView2.SelectedRows[0].Cells[2].Value.ToString();
}
else
{
if (treeView1.SelectedNode.Level == 1)
{
ProductName = treeView1.SelectedNode.Text;
ProductPrice = treeView1.SelectedNode.Name;
ProductJE = (double.Parse(ProductPrice) * double.Parse(textBox2.Text)).ToString();
ProductID = treeView1.SelectedNode.Tag.ToString();
}
else if (treeView1.SelectedNode.Level == 0)
{
return;
}
}
//添加到数据库
ConsumerDetails c = new ConsumerDetails();
c.CBID = lbl_CBID.Text;
c.ProductName = ProductName;
c.ProductPrice = Convert.ToDouble(ProductPrice);
c.CDAmount = Convert.ToInt32(textBox2.Text);
c.CDPrice = ProductPrice.ToString();
c.CDSale = "0";
c.CDType = "0";
c.ProductID = ProductID;
c.CDMoney = ProductJE.ToString();
int count = ConsumerDetailsBLL.AddConsumerDetails(c);
//添加到白道
ListViewItem lvi = new ListViewItem(ProductName);
lvi.SubItems.Add(ProductPrice.ToString());
lvi.SubItems.Add(textBox2.Text);
lvi.SubItems.Add(ProductJE);
lvi.SubItems.Add(DateTime.Now.ToString());
lvi.Tag = ProductID;
listView1.Items.Add(lvi);
price += double.Parse(ProductJE);
label9.Text = listView1.Items.Count.ToString();
label10.Text = price.ToString();
}
