void GetXfmx(string strWhere, string type)
{
BLL.Xxfmx B_Xxfmx = new Hotel_app.BLL.Xxfmx();
DataSet ds = B_Xxfmx.GetList(strWhere);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
if (type == "zjm")
{
tB_xftm.Text = ds.Tables[0].Rows[0]["xftm"].ToString();
}
else
{
tB_zjm.Text = ds.Tables[0].Rows[0]["zjm"].ToString();
}
tB_mxbh.Text = ds.Tables[0].Rows[0]["mxbh"].ToString();
tB_xfrb.Text = ds.Tables[0].Rows[0]["xfxr"].ToString();
tB_xfxm.Text = ds.Tables[0].Rows[0]["xfmx"].ToString();
drbh = ds.Tables[0].Rows[0]["drbh"].ToString();
xfdr = ds.Tables[0].Rows[0]["xfdr"].ToString();
xrbh = ds.Tables[0].Rows[0]["xrbh"].ToString();
mxbh = ds.Tables[0].Rows[0]["mxbh"].ToString();
tB_xfsl.Text = "1";
tB_xfsl.Focus();
}
}
public static string Getjjje(string xrbh, string mxbh) //小类编号，明细编号
{
DataSet ds_temp; BLL.Xxfmx B_Xxfmx = new Hotel_app.BLL.Xxfmx();
ds_temp = B_Xxfmx.GetList("id>=0 " + common_file.common_app.yydh_select + " and xrbh='" + xrbh + "' and mxbh='" + mxbh + "'");
if (ds_temp != null && ds_temp.Tables[0].Rows.Count > 0)
{
return(ds_temp.Tables[0].Rows[0]["jjje"].ToString());
}
else
{
return("0.0");
}
}
//日审成功后生成日出库表(如果当日是期末那么,会自动生成当期的月出库期末,如果当日是期初,生成月期初库存 )
public void Gen_r_kc_bb(string yydh, string qymc, string czsj, string _renew_tj_kc, string czy_temp, string xxzs)
{
int ybtqts = 0;
DataSet DS_temp; bool shqm_y = false, shqc_y = false; BLL.Common B_Common = new Hotel_app.BLL.Common();
DataSet ds = null;
DS_temp = B_Common.GetList("select ybtqts from Qcounter", " id>=0");
if (DS_temp != null && DS_temp.Tables[0].Rows.Count > 0)
{
if (DS_temp.Tables[0].Rows[0]["ybtqts"].ToString() != "")
{
ybtqts = int.Parse(DS_temp.Tables[0].Rows[0]["ybtqts"].ToString());
}
}
//看是否要生成期末库存
DateTime rq = DateTime.Parse(DateTime.Parse(czsj).ToShortDateString()).AddDays(-1);
DateTime rq_Now = DateTime.Parse(DateTime.Parse(czsj).ToShortDateString());
//找到本月的期初时间
DateTime yfcssj = common_bb.judge_yfcssj(rq, ybtqts);
//后一天的期初
DateTime yfcssj_new = common_bb.judge_yfcssj(rq_Now, ybtqts);
if (yfcssj_new > yfcssj) //当天为期末(生成期末报表)
{
shqm_y = true;
}
if (yfcssj.ToShortDateString().Equals(rq.ToShortDateString()))
{
shqc_y = true;
}
//生成日统计出库报表
string mxbh = ""; decimal sjxfje = 0;
decimal jjje_qc_y = 0, sl_qc_y = 0, sl_r_rk = 0, sl_r_ck = 0, sl_r_qm_kc = 0, sl_r_qc_kc = 0, sl_r_tz_kc = 0;
BLL.Xxfmx B_Xxfmx = new Hotel_app.BLL.Xxfmx();
ds = B_Xxfmx.GetList(" yydh='" + yydh + "' and is_tj_kc=1 ");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
{
mxbh = ds.Tables[0].Rows[j]["mxbh"].ToString();
sjxfje = decimal.Parse(ds.Tables[0].Rows[j]["xfje"].ToString());
Get_qc_Info(qymc, yydh, czsj, mxbh, ref jjje_qc_y, ref sl_qc_y, ref sl_r_qc_kc, ref sl_r_tz_kc);
Get_kc_ck(qymc, yydh, mxbh, czsj, czy_temp, jjje_qc_y, ref sl_r_ck);
Get_Import_Today(qymc, yydh, mxbh, czy_temp, czsj, ref sl_r_rk);
Get_Tz_Today(qymc, yydh, mxbh, czy_temp, czsj, ref sl_r_tz_kc);
//生成日审后当天的库存数
sl_r_qm_kc = sl_r_qc_kc + sl_r_rk - sl_r_ck + sl_r_tz_kc;
StringBuilder sb = new StringBuilder();
sb.Append(" insert into BB_kc_mx(yydh,qymc,xfdr,drbh,xfxr,xrbh,xfxm,mxbh,sl,rq,xftm,jjdj,xsdj,yhbl,sjxsdj,Total_cb,Total_yye,rx,xfsj) ");
sb.Append(" select yydh,qymc,xfdr,drbh,xfxr,xrbh,xfmx,mxbh,'" + sl_r_qm_kc + "','" + DateTime.Parse(czsj).AddDays(-1).ToShortDateString() + "',xftm,'" + jjje_qc_y + "',xfje,'1',xfje,'" + jjje_qc_y * sl_r_qm_kc + "','" + sjxfje * sl_r_qm_kc + "','" + Xxtsz.common_kc.kc_rx_qm_r + "','" + rq.ToShortDateString() + " 23:59:59' from Xxfmx ");
sb.Append(" where yydh='" + yydh + "' and mxbh='" + mxbh + "'");
B_Common.ExecuteSql(sb.ToString());
//生成下一日的期初行
sb = new StringBuilder();
sb.Append(" insert into BB_kc_mx(yydh,qymc,xfdr,drbh,xfxr,xrbh,xfxm,mxbh,sl,rq,xftm,jjdj,xsdj,yhbl,sjxsdj,Total_cb,Total_yye,rx,xfsj) ");
sb.Append(" select yydh,qymc,xfdr,drbh,xfxr,xrbh,xfmx,mxbh,'" + sl_r_qm_kc + "','" + DateTime.Parse(czsj).ToShortDateString() + "',xftm,'" + jjje_qc_y + "',xfje,'1',xfje,'" + jjje_qc_y * sl_r_qm_kc + "','" + sjxfje * sl_r_qm_kc + "','" + Xxtsz.common_kc.kc_rx_qc_r + "','" + DateTime.Parse(czsj).AddDays(-1).ToShortDateString() + "' from Xxfmx ");
sb.Append(" where yydh='" + yydh + "' and mxbh='" + mxbh + "'");
B_Common.ExecuteSql(sb.ToString());
}
}
if (shqm_y) //是期末的话就成生月报表
{
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
jjje_qc_y = 0; sl_qc_y = 0; sl_r_qc_kc = 0; sl_r_tz_kc = 0;
decimal sl_y_qm_kc = 0; decimal sl_y_rk = 0; decimal sl_y_ck = 0; DataSet ds_000 = null;
decimal sl_y_tz = 0; decimal je_y_tz_cb = 0;
decimal je_y_rk_cb = 0, jjje_qc_y_jc = 0, je_y_ck = 0;//加权销售成本
decimal sl_qm_y = 0; decimal xfje = 0, je_y_qm_cb = 0;
StringBuilder sb; string sel_s;
for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
{
mxbh = ds.Tables[0].Rows[j]["mxbh"].ToString();
xfje = decimal.Parse(ds.Tables[0].Rows[j]["xfje"].ToString());
Get_qc_Info(qymc, yydh, czsj, mxbh, ref jjje_qc_y, ref sl_qc_y, ref sl_r_qc_kc, ref sl_r_tz_kc);
//本月总入库
sel_s = " id>=0 and yydh='" + yydh + "' and mxbh='" + mxbh + "' and lksj>='" + yfcssj.ToShortDateString() + "' and lksj<'" + DateTime.Parse(czsj).ToShortDateString() + "'";
ds_000 = B_Common.GetList(" SELECT sum(xfsl) as rk_Today_sl,sum(Total_cb) as rk_cb FROM View_Xxfmx_lk ", sel_s);
if (ds_000 != null && ds_000.Tables[0].Rows.Count > 0)
{
if (ds_000.Tables[0].Rows[0]["rk_Today_sl"] != null && ds_000.Tables[0].Rows[0]["rk_Today_sl"].ToString() != "" && ds_000.Tables[0].Rows[0]["rk_cb"] != null && ds_000.Tables[0].Rows[0]["rk_cb"].ToString() != "")
{
sl_y_rk = decimal.Parse(ds_000.Tables[0].Rows[0]["rk_Today_sl"].ToString());
je_y_rk_cb = decimal.Parse(ds_000.Tables[0].Rows[0]["rk_cb"].ToString());
}
}
if (ds_000 != null && ds_000.Tables[0].Rows.Count > 0)
{
sb = new StringBuilder();
sb.Append(" insert into bb_kc_y_tj (yydh, qymc, rq, xfdr, drbh, xfxr, xrbh, xfmx, mxbh, xftm, jjje, sjxsdj, yhbl, xsdj, sl, Total_cb, Total_yye, bz, rx )");
//sb.Append(" select yydh,qymc,'" + DateTime.Parse(DateTime.Parse(czsj).ToShortDateString()) + "',xfdr,drbh,xfxr,xrbh,xfmx,mxbh,xftm,jjdj,'" + xfje + "',1,'" + xfje + "','" + sl_y_rk + "','" + je_y_qm_cb + "','" + xfje * sl_y_rk + "','','" + Xxtsz.common_kc.kc_rx_rc_y + "' from Xxfmx_lkmx where ");
sb.Append(" select yydh,qymc,'" + rq.ToShortDateString() + "',xfdr,drbh,xfxr,xrbh,xfmx,mxbh,xftm,jjdj,'" + xfje + "',1,'" + xfje + "','" + sl_y_rk + "','" + je_y_rk_cb + "','" + xfje * sl_y_rk + "','','" + Xxtsz.common_kc.kc_rx_rc_y + "' from Xxfmx_lkmx where ");
sb.Append(sel_s);
B_Common.ExecuteSql(sb.ToString());
}
else//本月没有入库
{
sb = new StringBuilder();
sb.Append(" insert into bb_kc_y_tj (yydh, qymc, rq, xfdr, drbh, xfxr, xrbh, xfmx, mxbh, xftm, jjje, sjxsdj, yhbl, xsdj, sl, Total_cb, Total_yye, bz, rx )");
sb.Append(" select yydh,qymc,'" + rq.ToShortDateString() + "',xfdr,drbh,xfxr,xrbh,xfmx,mxbh,xftm,jjdj,'" + xfje + "',1,'" + xfje + "','0','0','0','','" + Xxtsz.common_kc.kc_rx_rc_y + "' from Xxfmx_lkmx where 1=1 ");
B_Common.ExecuteSql(sb.ToString());
}
//本月总出库
sel_s = " yydh='" + yydh + "' and xfsj>='" + yfcssj + "' and xfsj<='" + rq.ToShortDateString() + " 23:59:59' and ischecked='1' and mxbh='" + mxbh + "'";
ds_000 = B_Common.GetList(" select * from Ssyxfmx_kc_sh_temp ", sel_s);
if (ds_000 != null && ds_000.Tables[0].Rows.Count > 0)
{
for (int k = 0; k < ds_000.Tables[0].Rows.Count; k++)
{
sl_y_ck += decimal.Parse(ds_000.Tables[0].Rows[k]["xfsl"].ToString());
je_y_ck += decimal.Parse(ds_000.Tables[0].Rows[k]["xfje"].ToString());
}
}
if (ds_000 != null && ds_000.Tables[0].Rows.Count > 0)
{
sb = new StringBuilder();
sb.Append(" insert into bb_kc_y_tj (yydh, qymc, rq, xfdr, drbh, xfxr, xrbh, xfmx, mxbh, xftm, jjje, sjxsdj, yhbl, xsdj, sl, Total_cb, Total_yye, bz, rx )");
sb.Append(" select yydh,qymc,'" + rq.ToShortDateString() + "',xfdr,drbh,xfxr,xrbh,xfmx,mxbh,xftm,'" + jjje_qc_y + "','" + xfje + "',1,'" + xfje + "','" + sl_y_ck + "','" + je_y_ck + "','" + xfje * sl_y_ck + "','','" + Xxtsz.common_kc.kc_rx_ck_y + "' from Xxfmx ");
sb.Append(" where yydh='" + yydh + "' and mxbh='" + mxbh + "'");
B_Common.ExecuteSql(sb.ToString());
}
else
{
sb = new StringBuilder();
sb.Append(" insert into bb_kc_y_tj (yydh, qymc, rq, xfdr, drbh, xfxr, xrbh, xfmx, mxbh, xftm, jjje, sjxsdj, yhbl, xsdj, sl, Total_cb, Total_yye, bz, rx )");
sb.Append(" select yydh,qymc,'" + rq.ToShortDateString() + "',xfdr,drbh,xfxr,xrbh,xfmx,mxbh,xftm,'" + jjje_qc_y + "','" + xfje + "',1,'" + xfje + "','0','0','0','','" + Xxtsz.common_kc.kc_rx_ck_y + "' from Xxfmx ");
sb.Append(" where yydh='" + yydh + "' and mxbh='" + mxbh + "'");
B_Common.ExecuteSql(sb.ToString());
}
//本月总调整
sel_s = " zb_sj between '" + yfcssj.ToShortDateString() + "' and '" + rq.ToShortDateString() + " 23:59:59" + "' and mxbh='" + mxbh + "' ";
ds_000 = B_Common.GetList("select sum(zb_sl ) as zzb_sl,sum(zb_total_cb) as zb_Total_cb from View_Xxfmx_zb ", sel_s);
{
if (ds_000.Tables[0].Rows.Count > 0 && ds_000.Tables[0].Rows[0]["zzb_sl"] != null && ds_000.Tables[0].Rows[0]["zzb_sl"].ToString() != "")
{
sl_y_tz = sl_y_tz + decimal.Parse(ds_000.Tables[0].Rows[0]["zzb_sl"].ToString());
je_y_tz_cb = je_y_tz_cb + decimal.Parse(ds_000.Tables[0].Rows[0]["zb_Total_cb"].ToString());
}
}
if (ds_000.Tables[0].Rows.Count > 0 && ds_000.Tables[0].Rows[0]["zzb_sl"] != null && ds_000.Tables[0].Rows[0]["zzb_sl"].ToString() != "")
{
sb = new StringBuilder();
sb.Append(" insert into bb_kc_y_tj (yydh, qymc, rq, xfdr, drbh, xfxr, xrbh, xfmx, mxbh, xftm, jjje, sjxsdj, yhbl, xsdj, sl, Total_cb, Total_yye, bz, rx )");
sb.Append(" select yydh,qymc,'" + rq.ToShortDateString() + "',xfdr,drbh,xfxr,xrbh,xfmx,mxbh,xftm,zb_jjje,'" + xfje + "',1,'" + xfje + "','" + sl_y_tz + "','" + je_y_tz_cb + "','" + xfje * sl_y_tz + "','','" + Xxtsz.common_kc.kc_rx_tz_y + "' from Xxfmx_zbmx where ");
sb.Append(sel_s);
B_Common.ExecuteSql(sb.ToString());
}
else
{
sb = new StringBuilder();
sb.Append(" insert into bb_kc_y_tj (yydh, qymc, rq, xfdr, drbh, xfxr, xrbh, xfmx, mxbh, xftm, jjje, sjxsdj, yhbl, xsdj, sl, Total_cb, Total_yye, bz, rx )");
sb.Append(" select yydh,qymc,'" + rq.ToShortDateString() + "',xfdr,drbh,xfxr,xrbh,xfmx,mxbh,xftm,zb_jjje,'" + xfje + "',1,'" + xfje + "','0','0','0','','" + Xxtsz.common_kc.kc_rx_tz_y + "' from Xxfmx_zbmx ");
sb.Append(" where yydh='" + yydh + "' and mxbh='" + mxbh + "'");
B_Common.ExecuteSql(sb.ToString());
}
sl_y_qm_kc = sl_qc_y + sl_y_rk - sl_y_ck + sl_y_tz;
//计算本期的销售成本
//总成本
//计算出下一个月的期初成本值
jjje_qc_y_jc = (jjje_qc_y * sl_qc_y + je_y_rk_cb + je_y_tz_cb) / (sl_qc_y + sl_y_rk + sl_y_tz);
//下月的期初数量
sl_qm_y = sl_qc_y + sl_y_rk - sl_y_ck + sl_y_tz;
//期末的库存金额
je_y_qm_cb = jjje_qc_y_jc * sl_qm_y;
decimal je_y_qm_yye = xfje * sl_qm_y;
//生成期末库存
sb = new StringBuilder();
sb.Append(" insert into bb_kc_y_tj (yydh, qymc, rq, xfdr, drbh, xfxr, xrbh, xfmx, mxbh, xftm, jjje, sjxsdj, yhbl, xsdj, sl, Total_cb, Total_yye, bz, rx )");
sb.Append(" select yydh,qymc,'" + rq.ToShortDateString() + "',xfdr,drbh,xfxr,xrbh,xfmx,mxbh,xftm,'" + jjje_qc_y_jc + "',xfje,1,xfje,'" + sl_qm_y + "','" + je_y_qm_cb + "','" + je_y_qm_yye + "','','" + Xxtsz.common_kc.kc_rx_qm_y + "' from Xxfmx ");
sb.Append(" where mxbh='" + mxbh + "' and yydh='" + yydh + "'");
B_Common.ExecuteSql(sb.ToString());
//插入下月期初库存
sb = new StringBuilder();
sb.Append(" insert into bb_kc_y_tj (yydh, qymc, rq, xfdr, drbh, xfxr, xrbh, xfmx, mxbh, xftm, jjje, sjxsdj, yhbl, xsdj, sl, Total_cb, Total_yye, bz, rx )");
sb.Append(" select yydh,qymc,'" + DateTime.Parse(DateTime.Parse(czsj).ToShortDateString()) + "',xfdr,drbh,xfxr,xrbh,xfmx,mxbh,xftm,'" + jjje_qc_y_jc + "',xfje,1,xfje,'" + sl_qm_y + "','" + je_y_qm_cb + "','" + je_y_qm_yye + "','','" + Xxtsz.common_kc.kc_rx_qc_y + "' from Xxfmx ");
sb.Append(" where mxbh='" + mxbh + "' and yydh='" + yydh + "'");
B_Common.ExecuteSql(sb.ToString());
}
}
}
}
