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; } }
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"); } }
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 string Xxfmx_add_edit(string id, string yydh, string qymc, string drbh, string xfdr, string xrbh, string xfxr, string mxbh, string xfmx, string xfje, string zjm, string xfgg, string jjje, string xftm, string xfcd, string xfdw, string jldw, bool is_tj_kc, string kcsl, string add_edit_delete, string xxzs) { string s = common_file.common_app.get_failure; BLL.Xxfmx B_Xxfmx = new Hotel_app.BLL.Xxfmx(); Model.Xxfmx M_Xxfmx = new Hotel_app.Model.Xxfmx(); if (xxzs == common_file.common_app.xxzs_xxvalue) { } if (xxzs == common_file.common_app.xxzs_zsvalue) { } if (add_edit_delete == common_file.common_app.get_add) { M_Xxfmx.yydh = yydh; M_Xxfmx.qymc = qymc; M_Xxfmx.drbh = drbh; M_Xxfmx.xfdr = xfdr; M_Xxfmx.xrbh = xrbh; M_Xxfmx.xfxr = xfxr; M_Xxfmx.mxbh = mxbh; M_Xxfmx.xfmx = xfmx; M_Xxfmx.zjm = zjm; M_Xxfmx.xfje = common_file_server.common_app.ValideStringCheck(xfje, 0); // Convert.ToDecimal(xfje); M_Xxfmx.xfgg = xfgg; M_Xxfmx.jjje = common_file_server.common_app.ValideStringCheck(jjje, 0); // Convert.ToDecimal(jjje); M_Xxfmx.xftm = xftm; M_Xxfmx.xf_cd = xfcd; M_Xxfmx.xf_dw = xfdw; M_Xxfmx.jldw = jldw; M_Xxfmx.is_tj_kc = is_tj_kc; M_Xxfmx.kcsl = common_file_server.common_app.ValideStringCheck(kcsl, 1);// Convert.ToDecimal(kcsl); if (B_Xxfmx.Add(M_Xxfmx) > 0) { s = common_file.common_app.get_suc; } } else if (add_edit_delete == common_file.common_app.get_edit) { M_Xxfmx = B_Xxfmx.GetModel(Convert.ToInt32(id)); M_Xxfmx.yydh = yydh; M_Xxfmx.qymc = qymc; M_Xxfmx.drbh = drbh; M_Xxfmx.xfdr = xfdr; M_Xxfmx.xrbh = xrbh; M_Xxfmx.xfxr = xfxr; M_Xxfmx.mxbh = mxbh; M_Xxfmx.xfmx = xfmx; M_Xxfmx.zjm = zjm; M_Xxfmx.xfje = Convert.ToDecimal(xfje); M_Xxfmx.xfgg = xfgg; M_Xxfmx.jjje = Convert.ToDecimal(jjje); M_Xxfmx.xftm = xftm; M_Xxfmx.xf_cd = xfcd; M_Xxfmx.xf_dw = xfdw; M_Xxfmx.jldw = jldw; M_Xxfmx.is_tj_kc = is_tj_kc; M_Xxfmx.kcsl = Convert.ToDecimal(kcsl); //M_Xxfxr.is_top = Convert.ToBoolean(is_top); //M_Xxfxr.is_select = Convert.ToBoolean(is_select); M_Xxfmx.id = int.Parse(id); if (B_Xxfmx.Update(M_Xxfmx)) { s = common_file.common_app.get_suc; } } else if (add_edit_delete == common_file.common_app.get_delete) { if (id != "") { B_Xxfmx.Delete(Convert.ToInt32(id)); s = common_file.common_app.get_suc; } } return(s); }
//将要统计的项目详细 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); } } } } }
//日审成功后生成日出库表(如果当日是期末那么,会自动生成当期的月出库期末,如果当日是期初,生成月期初库存 ) 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()); } } } }