/// <summary> /// 改房态时修改预订的初始值 /// </summary> /// <param name="zyzt"></param> /// <param name="fjbh"></param> /// <param name="ddsj"></param> /// <param name="lksj"></param> /// <param name="czsj"></param> /// <param name="cznr"></param> /// <param name="czy"></param> /// <param name="xxzs"></param> /// <returns></returns> public string set_yd_ft(string zyzt, string fjbh, DateTime ddsj, DateTime lksj, string czsj, string cznr, string czy, string xxzs) { string s = common_file.common_app.get_failure; string krxm0 = ""; string sktt0 = ""; string lsbh0 = ""; string zyzt_second0 = ""; DateTime yd_ddsj0 = DateTime.Parse(common_file.common_app.cssj); DateTime yd_lksj0 = DateTime.Parse(common_file.common_app.cssj); bool shlf0 = false; bool shts0 = false; bool shvip0 = false; bool fjbm0 = false; BLL.Ffjzt B_Ffjzt = new Hotel_app.BLL.Ffjzt(); DataSet ds_temp = B_Ffjzt.GetList("fjbh='" + fjbh + "'"); if (ds_temp.Tables[0].Rows.Count > 0) { Model.Ffjzt M_Ffjzt = B_Ffjzt.GetModel(int.Parse(ds_temp.Tables[0].Rows[0]["id"].ToString())); //设置初始值 set_fj_value(out krxm0, out sktt0, out lsbh0, out zyzt_second0, out yd_ddsj0, out yd_lksj0, out shlf0, out shts0, out shvip0, out fjbm0, "fjbh='" + fjbh + "' and ddsj='" + M_Ffjzt.yd_ddsj + "' and lksj='" + M_Ffjzt.yd_lksj + "'"); Ffjzt_xgft(zyzt, M_Ffjzt.zyzt_second, M_Ffjzt.zybz, M_Ffjzt.fjbh, krxm0, ddsj, lksj, M_Ffjzt.yd_ddsj, M_Ffjzt.yd_lksj, shlf0, shts0, shvip0, fjbm0, sktt0, lsbh0, DateTime.Parse(czsj), czy, cznr, xxzs); s = common_file.common_app.get_suc; } ds_temp.Dispose(); return(s); }
/// <summary> /// 修改干净、脏房、已洁房、在住脏房、取消在住脏房 /// </summary> /// <param name="id"></param> /// <param name="yydh"></param> /// <param name="qymc"></param> /// <param name="fjbh"></param> /// <param name="xgzt"></param>"干净gj","脏zf","已洁yj","在住脏zzzf","取消在住脏qxzz" /// <param name="add_edit_delete"></param> /// <param name="xxzs"></param> /// <returns></returns> public string set_gj_zf_yj_zzzf_qxzz(string id, string yydh, string qymc, string fjbh, string xgzt, string czy, DateTime czsj, string xxzs) { string s = common_file.common_app.get_failure; BLL.Common B_Common = new Hotel_app.BLL.Common(); BLL.Ffjzt B_Ffjzt = new Hotel_app.BLL.Ffjzt(); //common_file.common_czjl common_czjl_new = new Hotel_app.common_file.common_czjl(); Model.Ffjzt M_Ffjzt = B_Ffjzt.GetModel(int.Parse(id)); string update_s = ""; switch (xgzt) { case "gj": if (M_Ffjzt.zyzt == common_file.common_fjzt.wxf || M_Ffjzt.zyzt == common_file.common_fjzt.qtf) { B_Common.ExecuteSql("delete from Fwx_other where fjbh='" + fjbh + "' and ddsj='" + M_Ffjzt.ddsj.ToString() + "' and lksj='" + M_Ffjzt.lksj.ToString() + "'"); } update_s = "update Ffjzt set zyzt='" + common_file.common_fjzt.gjf + "',lsbh='',krxm='',sktt='',zybz='',zyzt_second='',shlf=0,shts=0,shvip=0,fjbm=0,yd_ddsj='" + common_file.common_app.cssj + "',yd_lksj='" + common_file.common_app.cssj + "',ddsj='" + common_file.common_app.cssj + "',lksj='" + common_file.common_app.cssj + "',czy='" + czy + "',cznr='" + "修改房态-干净房" + "',czsj='" + DateTime.Now.ToString() + "' where id='" + id + "' and zyzt_second<>'" + common_file.common_fjzt.ydf + "'"; if (B_Common.ExecuteSql(update_s) > 0) { common_file.common_czjl.add_czjl(yydh, qymc, czy, "修改房间状态" + M_Ffjzt.zyzt + "-" + common_file.common_fjzt.gjf, fjbh, "", czsj); s = common_file.common_app.get_suc; } update_s = "update Ffjzt set zyzt='" + common_file.common_fjzt.gjf + "',ddsj='" + common_file.common_app.cssj + "',lksj='" + common_file.common_app.cssj + "',czy='" + czy + "',cznr='" + "修改房态-干净房" + "',czsj='" + DateTime.Now.ToString() + "' where id='" + id + "' and zyzt_second='" + common_file.common_fjzt.ydf + "'"; if (B_Common.ExecuteSql(update_s) > 0) { common_file.common_czjl.add_czjl(yydh, qymc, czy, "修改房间状态" + M_Ffjzt.zyzt + "-" + common_file.common_fjzt.gjf, fjbh, "", czsj); s = common_file.common_app.get_suc; } break; case "zf": if (M_Ffjzt.zyzt == common_file.common_fjzt.wxf || M_Ffjzt.zyzt == common_file.common_fjzt.qtf) { B_Common.ExecuteSql("delete from Fwx_other where fjbh='" + fjbh + "' and ddsj='" + M_Ffjzt.ddsj.ToString() + "' and lksj='" + M_Ffjzt.lksj.ToString() + "'"); } update_s = "update Ffjzt set zyzt='" + common_file.common_fjzt.zf + "',lsbh='',krxm='',sktt='',zybz='',zyzt_second='',shlf=0,shts=0,shvip=0,fjbm=0,yd_ddsj='" + common_file.common_app.cssj + "',yd_lksj='" + common_file.common_app.cssj + "',ddsj='" + common_file.common_app.cssj + "',lksj='" + common_file.common_app.cssj + "',czy='" + czy + "',cznr='" + "修改房态-脏房" + "',czsj='" + DateTime.Now.ToString() + "' where id='" + id + "' and zyzt_second<>'" + common_file.common_fjzt.ydf + "'"; if (B_Common.ExecuteSql(update_s) > 0) { common_file.common_czjl.add_czjl(yydh, qymc, czy, "修改房间状态" + M_Ffjzt.zyzt + "-" + common_file.common_fjzt.zf, fjbh, "", czsj); s = common_file.common_app.get_suc; } update_s = "update Ffjzt set zyzt='" + common_file.common_fjzt.zf + "',zybz='" + "" + "',ddsj='" + common_file.common_app.cssj + "',lksj='" + common_file.common_app.cssj + "',czy='" + czy + "',cznr='" + "修改房态-脏房" + "',czsj='" + DateTime.Now.ToString() + "' where id='" + id + "' and zyzt_second='" + common_file.common_fjzt.ydf + "'"; if (B_Common.ExecuteSql(update_s) > 0) { common_file.common_czjl.add_czjl(yydh, qymc, czy, "修改房间状态" + M_Ffjzt.zyzt + "-" + common_file.common_fjzt.zf, fjbh, "", czsj); s = common_file.common_app.get_suc; } break; case "yj": update_s = "update Ffjzt set zybz='" + common_file.common_fjzt.yjf + "',czy='" + czy + "',cznr='" + "修改房态-已洁房" + "',czsj='" + DateTime.Now.ToString() + "' where id='" + id + "'"; if (B_Common.ExecuteSql(update_s) > 0) { common_file.common_czjl.add_czjl(yydh, qymc, czy, "设置已洁房", fjbh, "", czsj); s = common_file.common_app.get_suc; } break; case "zzzf": update_s = "update Ffjzt set zybz='" + common_file.common_fjzt.yjf + "',czy='" + czy + "',cznr='" + "修改房态-在住脏房" + "',czsj='" + DateTime.Now.ToString() + "' where id='" + id + "'"; if (B_Common.ExecuteSql(update_s) > 0) { common_file.common_czjl.add_czjl(yydh, qymc, czy, "设置在住脏房", fjbh, "", czsj); s = common_file.common_app.get_suc; } break; case "qxzz": update_s = "update Ffjzt set zybz='" + "" + "',czy='" + czy + "',cznr='" + "修改房态-取消在住脏房" + "',czsj='" + DateTime.Now.ToString() + "' where id='" + id + "'"; if (B_Common.ExecuteSql(update_s) > 0) { common_file.common_czjl.add_czjl(yydh, qymc, czy, "取消在住脏房", fjbh, "", czsj); s = common_file.common_app.get_suc; } break; case "lszyf": update_s = "update Ffjzt set zybz='" + common_file.common_fjzt.lszy + "',czy='" + czy + "',cznr='" + "修改房态-临时占用房" + "',czsj='" + DateTime.Now.ToString() + "' where id='" + id + "'"; if (B_Common.ExecuteSql(update_s) > 0) { common_file.common_czjl.add_czjl(yydh, qymc, czy, "设置临时占用房", fjbh, "", czsj); s = common_file.common_app.get_suc; } break; case "qxlszyf": update_s = "update Ffjzt set zybz='" + "" + "',czy='" + czy + "',cznr='" + "修改房态-取消临时占用房" + "',czsj='" + DateTime.Now.ToString() + "' where id='" + id + "'"; if (B_Common.ExecuteSql(update_s) > 0) { common_file.common_czjl.add_czjl(yydh, qymc, czy, "取消临时占用房", fjbh, "", czsj); s = common_file.common_app.get_suc; } break; } return(s); }