private void Frm_JZ_Load(object sender, EventArgs e)
{
try
{
string str_sql = "select XS_goodsName,XS_dj,XS_Sum,XS_allprice,XS_sj from tb_DeskXS where XS_DeskName='" + Rname + "'";
dataGridView1.DataSource = db.GetDataFromSQL(str_sql).Tables[0];
//查询此桌台的类型编号
str_sql = "select a.DT_ZDXF from tb_DeskType a,tb_Desk b where b.Name=a.Id and Id='" + Rname + "'";
DataSet ds = db.GetDataFromSQL(str_sql);
double zdxf = 0;
if (ds.Tables[0].Rows.Count > 0)
{
zdxf = Convert.ToDouble(ds.Tables[0].Rows[0][0].ToString().Trim());
}
ds = db.GetDataFromSQL("select sum(convert(float,XS_allprice)) from tb_DeskXS where XS_DeskName='" + Rname + "'");
if (ds.Tables[0].Rows[0][0].ToString().Trim() == "")
{
LB_money.Text = zdxf.ToString("C");
}
else
{
if (Convert.ToDouble(ds.Tables[0].Rows[0][0].ToString().Trim()) < zdxf)
{
LB_money.Text = zdxf.ToString("C");
}
else
{
LB_money.Text = Convert.ToDouble(ds.Tables[0].Rows[0][0].ToString().Trim()).ToString("C").Trim();
}
}
LB_ZTH.Text = Rname;
fangfa();
//获取账单号
str_sql = "select max(XF_ID) from tb_XF where substring(XF_ID,1,2)='ZD' and substring(XF_ID,3,8)='" + DateTime.Now.ToString("yyyyMMdd").Trim() + "'";
ds = db.GetDataFromSQL(str_sql);
string zd = ds.Tables[0].Rows[0][0].ToString().Trim();
if (zd == "")
{
LB_ZDH.Text = "ZD" + DateTime.Now.ToString("yyyyMMdd") + "001";
}
else
{
LB_ZDH.Text = (Convert.ToInt64(zd.Substring(2, 11).ToString().Trim()) + 1).ToString("ZD00000000000").Trim();
}
TB_money.Focus();
}
catch { }
}
/// <summary>
/// 显示会员按钮
/// </summary>
private void fangfa()
{
try
{
but_PT.Visible = false; // 隐藏普通按钮
but_HY.Visible = true; //显示会员按钮
CB_ID.DropDownStyle = ComboBoxStyle.Simple; //隐藏下拉框
CB_ID.Text = "普通顾客";
CB_ID.Enabled = false;
TB_money.Focus();
LB_Name.Text = "普通顾客";
LB_JF.Text = "0";
LB_DJ.Text = "0";
LB_ZK.Text = "0";
LB_Ymoney.Text = LB_money.Text;
}
catch { }
//LB_Smoney.Text = LB_money.Text;
//LB_ZL.Text = "找零：0.00";
}