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