private void tb_tm_KeyDown(object sender, KeyEventArgs e)
{
//e.Handled = true;
if (e.KeyCode == Keys.Enter)
{
if (tb_tm.Text.Trim() != "")
{
BLL.Xxfmx B_Xxfmx = new Hotel_app.BLL.Xxfmx();
List <Model.Xxfmx> list0 = new List <Hotel_app.Model.Xxfmx>();
list0 = B_Xxfmx.GetModelList(" yydh='" + common_file.common_app.yydh + "' and xftm='" + tb_tm.Text.Trim().Replace("'", "-") + "'");
if (list0 != null && list0.Count > 0)
{
M_Xxfmx = list0[0];
tB_xfrb.Text = M_Xxfmx.xfxr;
tB_xfxm.Text = M_Xxfmx.xfmx;
tB_xfje.Text = M_Xxfmx.xfje.ToString();
xfje = Decimal.Parse(M_Xxfmx.xfje.ToString());
tB_xfsl.Focus();
}
else
{
tB_xfrb.Focus();
}
}
//e.Handled = false;
}
}
private void tb_tm_TextChanged(object sender, EventArgs e)
{
if (tb_tm.Text.Trim() != "")
{
BLL.Xxfmx B_Xxfmx = new Hotel_app.BLL.Xxfmx();
List <Model.Xxfmx> list0 = new List <Hotel_app.Model.Xxfmx>();
list0 = B_Xxfmx.GetModelList(" yydh='" + common_file.common_app.yydh + "' and xftm='" + tb_tm.Text.Trim().Replace("'", "-") + "'");
if (list0 != null && list0.Count > 0)
{
M_Xxfmx = list0[0];
mxbh = M_Xxfmx.mxbh;
tB_xfrb.Text = M_Xxfmx.xfxr;
tB_xfxm.Text = M_Xxfmx.xfmx;
tB_xfje.Text = M_Xxfmx.xfje.ToString();
xfje = Decimal.Parse(M_Xxfmx.xfje.ToString());
tB_xfje.Text = (xfje * (decimal.Parse(tB_xfsl.Text.Trim()))).ToString();
tB_xfsl.Focus();
}
}
}
//将要统计的项目详细
public void Record_kc_tj_mx(string yydh, string qymc, string czsj, string czy_temp)
{
string s = common_file.common_app.get_suc;
string tj_qssj = DateTime.Parse(czsj).AddDays(-1).ToShortDateString();
string tj_jssj = DateTime.Parse(czsj).ToShortDateString();
BLL.Common B_Common = new Hotel_app.BLL.Common();
DataSet ds_tj = B_Common.GetList(" select * from View_kc_notsh ", " 1=1 ");
if (ds_tj != null && ds_tj.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds_tj.Tables[0].Rows.Count; i++)
{
string aa = " insert into Ssyxfmx_kc_sh_temp(yydh,qymc,ckeckTime,xfrq,id_app,mxbh,xfsl,xfje,xfxm,xftm) values('" + yydh + "','" + qymc + "','" + czsj + "','" + tj_qssj + "','" + ds_tj.Tables[0].Rows[i]["id_app"].ToString() + "','" + ds_tj.Tables[0].Rows[i]["mxbh"].ToString() + "','" + ds_tj.Tables[0].Rows[i]["xfsl"].ToString() + "','" + ds_tj.Tables[0].Rows[i]["xfje"].ToString() + "','" + ds_tj.Tables[0].Rows[i]["xfxm"].ToString() + "','" + ds_tj.Tables[0].Rows[i]["xftm"].ToString() + "')";
try
{
B_Common.ExecuteSql(" insert into Ssyxfmx_kc_sh_temp(yydh,qymc,ckeckTime,tjrq,id_app,mxbh,xfsl,xfje,xfxm,xftm,xfsj) values('" + yydh + "','" + qymc + "','" + czsj + "','" + tj_qssj + "','" + ds_tj.Tables[0].Rows[i]["id_app"].ToString() + "','" + ds_tj.Tables[0].Rows[i]["mxbh"].ToString() + "','" + ds_tj.Tables[0].Rows[i]["xfsl"].ToString() + "','" + ds_tj.Tables[0].Rows[i]["xfje"].ToString() + "','" + ds_tj.Tables[0].Rows[i]["xfxm"].ToString() + "','" + ds_tj.Tables[0].Rows[i]["xftm"].ToString() + "','" + ds_tj.Tables[0].Rows[i]["xfsj"].ToString() + "')");
}
catch (Exception ee)
{
FileStream filest = new FileStream(@"F:\ls\测试\error.txt", FileMode.Append, FileAccess.Write);
StreamWriter sw = new StreamWriter(filest);
sw.Write(ee.ToString() + "</br>" + aa);
sw.Close();
filest.Dispose();
}
}
}
//执行统计更新(更新每种代销品的库存数据) isCheck字段用来标识些条记录是否被用于库存统计过了
BLL.Ssyxfmx_kc_sh_temp B_Ssyxfmx_kc_sh_temp_new = new Hotel_app.BLL.Ssyxfmx_kc_sh_temp();
List <Model.Ssyxfmx_kc_sh_temp> lists = new List <Hotel_app.Model.Ssyxfmx_kc_sh_temp>();
int id = 0; decimal xf_sl = 0; string mxbh = ""; string xftm = "";
BLL.Xxfmx B_Xxfmx = new Hotel_app.BLL.Xxfmx();
List <Model.Xxfmx> list_1 = new List <Hotel_app.Model.Xxfmx>();
//lists = B_Ssyxfmx_kc_sh_temp_new.GetModelList(" isChecked=0 ");
lists = B_Ssyxfmx_kc_sh_temp_new.GetModelList(" ischecked=0 ");
if (lists != null && lists.Count > 0)
{
foreach (Model.Ssyxfmx_kc_sh_temp Ssyxfmx_kc_sh_temp in lists)
{
id = Ssyxfmx_kc_sh_temp.id;
xf_sl = Ssyxfmx_kc_sh_temp.xfsl;
mxbh = Ssyxfmx_kc_sh_temp.mxbh;
xftm = Ssyxfmx_kc_sh_temp.xftm;
//更新库存
list_1 = B_Xxfmx.GetModelList(" mxbh='" + mxbh + "' and xftm='" + xftm + "' ");
if (list_1 != null && list_1.Count > 0)
{
Model.Xxfmx M_Xxfmx = list_1[0];
M_Xxfmx.id = list_1[0].id;
M_Xxfmx.kcsl = list_1[0].kcsl - xf_sl;
if (B_Xxfmx.Update(M_Xxfmx))
{
common_file.common_czjl.add_czjl(yydh, qymc, czy_temp, M_Xxfmx.xfmx, xf_sl.ToString(), "新增消费", DateTime.Parse(czsj));
common_file.common_czjl.add_czjl(yydh, qymc, czy_temp, "更新库存数量", M_Xxfmx.mxbh, xf_sl.ToString(), DateTime.Parse(czsj));
Ssyxfmx_kc_sh_temp.ischecked = true;
Ssyxfmx_kc_sh_temp.id = id;
B_Ssyxfmx_kc_sh_temp_new.Update(Ssyxfmx_kc_sh_temp);
}
}
}
}
}
