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); } } } } }