private string CheckFjStatus(string fjbh, string fjrb, out string Result)
{
string fjCanUse = common_file.common_app.get_failure; BLL.Ffjzt B_Ffjzt = new Hotel_app.BLL.Ffjzt();
Result = "";
DataSet Ds_temp = B_Ffjzt.GetList("id>=0 and yydh='" + common_file.common_app.yydh + "' and fjbh='" + fjbh + "' and fjrb='" + fjrb + "'");
if (Ds_temp != null && Ds_temp.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < Ds_temp.Tables[0].Rows.Count; i++)
{
fjCanUse = common_file.common_app.get_failure;
string zyzt = Ds_temp.Tables[0].Rows[i]["zyzt"].ToString();
if (zyzt == common_file.common_fjzt.gjf || zyzt == common_file.common_fjzt.zf)//为赃房或者干净房的时候是可以撤销的
{
fjCanUse = common_file.common_app.get_suc; continue;
}
else
{
Result += "[" + Ds_temp.Tables[0].Rows[i]["fjrb"].ToString() + "-" + Ds_temp.Tables[0].Rows[i]["fjbh"].ToString() + "当前的占用状态为:" + Ds_temp.Tables[0].Rows[i]["zyzt"].ToString() + "] ";
}
}
}
else
{
Result += "[" + fjrb + "-" + fjbh + "-" + "没有找到此房间,系统无法撤销 ]";
}
result_all += Result;
return(fjCanUse);
}
public string clear_old_yd_fjzt(string old_fjbh, DateTime ddsj, DateTime lksj, DateTime czsj, string czy, string xxzs)
{
string s = common_file.common_app.get_failure;
string krxm0 = ""; string sktt0 = ""; string lsbh0 = "";
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='" + old_fjbh + "'");//选择旧房号
Model.Ffjzt M_Ffjzt;
Ffjzt.Ffjzt_add_edit Ffjzt_add_edit_new = new Hotel_app.Server.Ffjzt.Ffjzt_add_edit();
if (ds_temp != null && ds_temp.Tables[0].Rows.Count > 0)
{
s = common_file.common_app.get_suc;
M_Ffjzt = B_Ffjzt.GetModel(int.Parse(ds_temp.Tables[0].Rows[0]["id"].ToString()));
ds_temp = B_Ffjzt.GetList("zyzt_second='" + common_file.common_fjzt.ydf + "' and fjbh='" + old_fjbh + "' and yd_ddsj='" + ddsj.ToString() + "' and yd_lksj='" + lksj.ToString() + "'");
if (ds_temp != null && ds_temp.Tables[0].Rows.Count > 0)//原来如果有在房态里体现预订的话要先清除,但新的房号如果有排也要重新加载新房号的房态
{
s = common_file.common_app.get_failure;
//krxm0 = ""; sktt0 = ""; lsbh0 = "";
//shlf0 = false; shts0 = false; shvip0 = false;
//为什么要下面这步,为了在没在住房时清除以下三个值.
if (M_Ffjzt.zyzt == common_file.common_fjzt.zzf)
{
krxm0 = M_Ffjzt.krxm; lsbh0 = M_Ffjzt.lsbh; sktt0 = M_Ffjzt.sktt;
shlf0 = M_Ffjzt.shlf; shts0 = M_Ffjzt.shts; shvip0 = M_Ffjzt.shvip; fjbm0 = M_Ffjzt.fjbm;
}
Ffjzt_add_edit_new.Ffjzt_xgft(M_Ffjzt.zyzt, "", M_Ffjzt.zybz, old_fjbh, krxm0, M_Ffjzt.ddsj, M_Ffjzt.lksj, DateTime.Parse(common_file.common_app.cssj), DateTime.Parse(common_file.common_app.cssj), shlf0, shts0, shvip0, fjbm0, sktt0, lsbh0, czsj, czy, "预订清除", xxzs);
s = common_file.common_app.get_suc;
}
}
return(s);
}
//房间
public string Ffjzt_add_edit_delete(string id, string yydh, string qymc, string jdlh, string jdlh_name, string jdcs, string jdcs_name, string fjrb, string fjrb_code, string fjbh, string fjdh, string dhfj, string bz, string add_edit_delete, string xxzs)
{
string s = common_file.common_app.get_failure;
BLL.Ffjzt B_Ffjzt = new Hotel_app.BLL.Ffjzt();
BLL.Ffjzt B_Ffjzt_new = new Hotel_app.BLL.Ffjzt();
Model.Ffjzt M_Ffjzt = new Hotel_app.Model.Ffjzt();
if (xxzs == common_file.common_app.xxzs_xxvalue)
{
}
if (xxzs == common_file.common_app.xxzs_zsvalue)
{
}
s = add_edit_delete;
if (add_edit_delete == common_file.common_app.get_add)
{
M_Ffjzt.yydh = yydh; M_Ffjzt.qymc = qymc; M_Ffjzt.jdlh = jdlh;
M_Ffjzt.jdlh_name = jdlh_name; M_Ffjzt.jdcs = jdcs; M_Ffjzt.jdcs_name = jdcs_name;
M_Ffjzt.fjrb = fjrb; M_Ffjzt.fjrb_code = fjrb_code;
M_Ffjzt.fjbh = fjbh; M_Ffjzt.fjdh = fjdh; M_Ffjzt.dhfj = dhfj; M_Ffjzt.bz = bz;
M_Ffjzt.yd_ddsj = M_Ffjzt.yd_lksj = M_Ffjzt.ddsj = M_Ffjzt.lksj = DateTime.Parse(common_file.common_app.cssj);
M_Ffjzt.czsj = DateTime.Now;
M_Ffjzt.zyzt = common_file.common_fjzt.gjf;
M_Ffjzt.zyzt_second = "";
if (B_Ffjzt_new.Add(M_Ffjzt) > 0)//调用自定义类初始化房间
{
s = common_file.common_app.get_suc;
}
}
else
if (add_edit_delete == common_file.common_app.get_edit)
{
M_Ffjzt = B_Ffjzt.GetModel(Convert.ToInt32(id));
M_Ffjzt.jdlh = jdlh; M_Ffjzt.jdlh_name = jdlh_name;
M_Ffjzt.jdcs = jdcs; M_Ffjzt.jdcs_name = jdcs_name;
M_Ffjzt.fjrb = fjrb; M_Ffjzt.fjrb_code = fjrb_code;
M_Ffjzt.fjdh = fjdh; M_Ffjzt.dhfj = dhfj; M_Ffjzt.bz = bz;
M_Ffjzt.czsj = DateTime.Now;
if (B_Ffjzt.Update(M_Ffjzt))
{
s = common_file.common_app.get_suc;
}
}
else
if (add_edit_delete == common_file.common_app.get_delete)
{
if (id != null)
{
if (id != "")
{
if (B_Ffjzt.Delete(Convert.ToInt32(id)))
{
s = common_file.common_app.get_suc;
}
}
}
}
return(s);
}
public string add_fjbh_yd_fjzt(string lsbh, string fjbh, string sktt, DateTime czsj, string czy, string xxzs)
//预订时变更去修改房态,返回成功或失败
{
string s = common_file.common_app.get_failure;
string krxm0 = ""; string sktt0 = ""; string lsbh0 = "";
bool shlf0 = false; bool shts0 = false; bool shvip0 = false; bool fjbm0 = false;
BLL.Qskyd_fjrb B_Qskyd_fjrb = new Hotel_app.BLL.Qskyd_fjrb();
BLL.Ffjzt B_Ffjzt = new Hotel_app.BLL.Ffjzt();
Model.Ffjzt M_fjzt_temp;
Ffjzt.Ffjzt_add_edit Ffjzt_add_edit_new = new Hotel_app.Server.Ffjzt.Ffjzt_add_edit();
DataSet ds_temp = B_Qskyd_fjrb.GetList("lsbh='" + lsbh + "'");
if (ds_temp != null && ds_temp.Tables[0].Rows.Count > 0)
{
s = common_file.common_app.get_failure;
krxm0 = ds_temp.Tables[0].Rows[0]["krxm"].ToString();
sktt0 = ds_temp.Tables[0].Rows[0]["sktt"].ToString();
lsbh0 = ds_temp.Tables[0].Rows[0]["lsbh"].ToString();
DateTime yd_ddsj_0 = DateTime.Parse(ds_temp.Tables[0].Rows[0]["ddsj"].ToString());
DateTime yd_lksj_0 = DateTime.Parse(ds_temp.Tables[0].Rows[0]["lksj"].ToString());
s = common_file.common_app.get_suc;
if (yd_ddsj_0 >= DateTime.Now.Date && yd_ddsj_0 < DateTime.Now.Date.AddDays(1))
//当天预订才去修改房态
{
shlf0 = common_file.common_fjzt.Islf(lsbh0); //判断是否联房
shts0 = common_file.common_fjzt.Ists(lsbh0); //判断是否特殊
shvip0 = common_file.common_fjzt.IsVIP(lsbh0); //判断是否VIP或会员
fjbm0 = common_file.common_fjzt.Isbm(lsbh0);
s = common_file.common_app.get_suc;
ds_temp = B_Ffjzt.GetList("fjbh='" + fjbh + "'");
if (ds_temp != null && ds_temp.Tables[0].Rows.Count > 0)
{
s = common_file.common_app.get_failure;
M_fjzt_temp = B_Ffjzt.GetModel(int.Parse(ds_temp.Tables[0].Rows[0]["id"].ToString()));
if (M_fjzt_temp.zyzt == common_file.common_fjzt.zzf)
{
sktt0 = M_fjzt_temp.sktt;
lsbh0 = M_fjzt_temp.lsbh;
krxm0 = M_fjzt_temp.krxm;
shlf0 = M_fjzt_temp.shlf; //common_file.common_fjzt.Islf(lsbh); //判断是否联房
shts0 = M_fjzt_temp.shts; //common_file.common_fjzt.Ists(lsbh);//判断是否特殊
shvip0 = M_fjzt_temp.shvip; //common_file.common_fjzt.IsVIP(lsbh);//判断是否VIP或会员
fjbm0 = M_fjzt_temp.fjbm;
}
//else
//{ sktt0 = M_fjzt_temp.sktt; lsbh0 = M_fjzt_temp.lsbh; }
//重新加载新房号的房态
Ffjzt_add_edit_new.Ffjzt_xgft(M_fjzt_temp.zyzt, common_file.common_fjzt.ydf, M_fjzt_temp.zybz, fjbh, krxm0, M_fjzt_temp.ddsj, M_fjzt_temp.lksj, yd_ddsj_0, yd_lksj_0, shlf0, shts0, shvip0, fjbm0, sktt0, lsbh0, czsj, czy, "加载预订", xxzs);
s = common_file.common_app.get_suc;
}
}
}
return(s);
}
public void Ffjzt_xgft(string zyzt, string zyzt_second, string zybz, string fjbh, string krxm, DateTime ddsj, DateTime lksj, DateTime yd_ddsj, DateTime yd_lksj, bool shlf, bool shts, bool shvip, bool fjbm, string sktt, string lsbh, DateTime czsj, string czy, string cznr, string xxzs)
{
string s = common_file.common_app.get_failure;
if (xxzs == common_file.common_app.xxzs_xxvalue)
{
}
if (xxzs == common_file.common_app.xxzs_zsvalue)
{
}
BLL.Common B_Common = new Hotel_app.BLL.Common();
BLL.Ffjzt B_Ffjzt = new Hotel_app.BLL.Ffjzt();
Model.Ffjzt M_Ffjzt = new Hotel_app.Model.Ffjzt();
DataSet ds_temp;
ds_temp = B_Common.GetList("select id from Ffjzt", "fjbh='" + fjbh + "'");
int id = 0;
if (ds_temp != null && ds_temp.Tables[0].Rows.Count > 0)
{
id = Convert.ToInt32(ds_temp.Tables[0].Rows[0]["id"].ToString());
M_Ffjzt = B_Ffjzt.GetModel(id);
M_Ffjzt.zybz = zybz;
if (zyzt == common_file.common_fjzt.zzf && M_Ffjzt.zyzt == common_file.common_fjzt.zf)
{
M_Ffjzt.zybz = common_file.common_fjzt.yjf;
}
M_Ffjzt.zyzt = zyzt; M_Ffjzt.zyzt_second = zyzt_second;
M_Ffjzt.krxm = krxm; M_Ffjzt.ddsj = ddsj; M_Ffjzt.lksj = lksj;
M_Ffjzt.yd_ddsj = yd_ddsj; M_Ffjzt.yd_lksj = yd_lksj; M_Ffjzt.shlf = shlf; M_Ffjzt.fjbm = fjbm;
M_Ffjzt.shts = shts; M_Ffjzt.shvip = shvip; M_Ffjzt.sktt = sktt;
M_Ffjzt.lsbh = lsbh; M_Ffjzt.czsj = DateTime.Now; M_Ffjzt.czy = czy; M_Ffjzt.cznr = cznr;
if (B_Ffjzt.Update(M_Ffjzt))
{
s = common_file.common_app.get_suc;
}
}
ds_temp.Dispose();
}
//public string add_fjbh_dj_fjzt(string fjbh, Model.Qskyd_fjrb M_Qskyd_fjrb, DateTime czsj, string czy, string xxzs)
////登记时变更去修改房态,返回成功或失败
//{
// string s = common_file.common_app.get_failure;
// string krxm0 = ""; string sktt0 = ""; string lsbh0 = "";
// 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 + "'");
// Model.Ffjzt M_Ffjzt;
// Ffjzt.Ffjzt_add_edit Ffjzt_add_edit_new = new Hotel_app.Ffjzt.Ffjzt_add_edit();
// if (ds_temp != null && ds_temp.Tables[0].Rows.Count > 0)
// {
// M_Ffjzt = B_Ffjzt.GetModel(int.Parse(ds_temp.Tables[0].Rows[0]["id"].ToString()));
// lsbh0 = M_Qskyd_fjrb.lsbh;
// krxm0 = M_Qskyd_fjrb.krxm;
// sktt0 = M_Qskyd_fjrb.sktt;
// shlf0 = common_file.common_fjzt.Islf(lsbh0); //判断是否联房
// shts0 = common_file.common_fjzt.Ists(lsbh0);//判断是否特殊
// shvip0 = common_file.common_fjzt.IsVIP(lsbh0);//判断是否VIP或会员
// fjbm0 = common_file.common_fjzt.Isbm(lsbh0);
// Ffjzt_add_edit_new.Ffjzt_xgft(common_file.common_fjzt.zzf, M_Ffjzt.zyzt_second, M_Ffjzt.zybz, fjbh, krxm0, M_Qskyd_fjrb.ddsj, M_Qskyd_fjrb.lksj, M_Ffjzt.yd_ddsj, M_Ffjzt.yd_lksj, shlf0, shts0, shvip0,fjbm0, sktt0, lsbh0, czsj, czy, common_file.common_fjzt.ff, xxzs);
// s = common_file.common_app.get_suc;
// }
// return s;
//}
//登记时变更去修改房态,返回成功或失败
public string add_fjbh_dj_fjzt(string fjbh, Model.Qskyd_fjrb M_Qskyd_fjrb, DateTime czsj, string czy, string xxzs)
{
string s = common_file.common_app.get_failure;
string krxm0 = ""; string sktt0 = ""; string lsbh0 = "";
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 + "'");
Model.Ffjzt M_Ffjzt;
Ffjzt.Ffjzt_add_edit Ffjzt_add_edit_new = new Hotel_app.Server.Ffjzt.Ffjzt_add_edit();
if (ds_temp != null && ds_temp.Tables[0].Rows.Count > 0)
{
M_Ffjzt = B_Ffjzt.GetModel(int.Parse(ds_temp.Tables[0].Rows[0]["id"].ToString()));
lsbh0 = M_Qskyd_fjrb.lsbh;
krxm0 = M_Qskyd_fjrb.krxm;
sktt0 = M_Qskyd_fjrb.sktt;
DateTime yd_ddsj_temp = M_Qskyd_fjrb.ddsj;
DateTime yd_lksj_temp = M_Qskyd_fjrb.lksj;
shlf0 = common_file.common_fjzt.Islf(lsbh0); //判断是否联房
shts0 = common_file.common_fjzt.Ists(lsbh0); //判断是否特殊
shvip0 = common_file.common_fjzt.IsVIP(lsbh0); //判断是否VIP或会员
fjbm0 = common_file.common_fjzt.Isbm(lsbh0);
Ffjzt_add_edit_new.Ffjzt_xgft(common_file.common_fjzt.zzf, M_Ffjzt.zyzt_second, M_Ffjzt.zybz, fjbh, krxm0, M_Qskyd_fjrb.ddsj, M_Qskyd_fjrb.lksj, M_Ffjzt.yd_ddsj, M_Ffjzt.yd_lksj, shlf0, shts0, shvip0, fjbm0, sktt0, lsbh0, czsj, czy, common_file.common_fjzt.ff, xxzs);
M_Ffjzt = B_Ffjzt.GetModel(int.Parse(ds_temp.Tables[0].Rows[0]["id"].ToString()));
if (M_Ffjzt != null)
{
if (M_Ffjzt.yd_ddsj == yd_ddsj_temp && M_Ffjzt.yd_lksj == yd_lksj_temp)
{
M_Ffjzt.zyzt_second = "";
M_Ffjzt.yd_ddsj = DateTime.Parse(common_file.common_app.cssj);
M_Ffjzt.yd_lksj = DateTime.Parse(common_file.common_app.cssj);
B_Ffjzt.Update(M_Ffjzt);
}
}
s = common_file.common_app.get_suc;
}
//s = common_file.common_app.get_suc;
return(s);
}
public string clear_old_dj_fjzt(string old_fjbh, DateTime czsj, string czy, string xxzs)
//登记换房时清除旧的房态清除
{
string s = common_file.common_app.get_failure;
string krxm0 = ""; string sktt0 = ""; string lsbh0 = "";
bool shlf0 = false; bool shts0 = false; bool shvip0 = false; bool fjbm0 = false;
string zyzt_second0 = "";
BLL.Ffjzt B_Ffjzt = new Hotel_app.BLL.Ffjzt();
BLL.Qskyd_fjrb B_Qskyd_fjrb = new Hotel_app.BLL.Qskyd_fjrb();
Model.Ffjzt M_Ffjzt;
Ffjzt.Ffjzt_add_edit Ffjzt_add_edit_new = new Hotel_app.Server.Ffjzt.Ffjzt_add_edit();
DataSet ds_temp = B_Ffjzt.GetList("fjbh='" + old_fjbh + "'");
if (ds_temp != null && ds_temp.Tables[0].Rows.Count > 0)
{
M_Ffjzt = B_Ffjzt.GetModel(int.Parse(ds_temp.Tables[0].Rows[0]["id"].ToString()));
//在Qskyd_fjrb表里查询出预订客人的相关住房登记信息
DateTime yd_ddsj0 = DateTime.Parse(common_file.common_app.cssj);
DateTime yd_lksj0 = DateTime.Parse(common_file.common_app.cssj);
ds_temp = B_Qskyd_fjrb.GetList("yddj='" + common_file.common_yddj.yddj_yd + "' and fjbh='" + old_fjbh + "' and ddsj='" + M_Ffjzt.yd_ddsj.ToString() + "' and lksj='" + M_Ffjzt.yd_lksj.ToString() + "'");
if (ds_temp != null && ds_temp.Tables[0].Rows.Count > 0)
{
lsbh0 = ds_temp.Tables[0].Rows[0]["lsbh"].ToString();
shlf0 = common_file.common_fjzt.Islf(lsbh0); //判断是否联房
shts0 = common_file.common_fjzt.Ists(lsbh0); //判断是否特殊
shvip0 = common_file.common_fjzt.IsVIP(lsbh0); //判断是否VIP或会员
fjbm0 = common_file.common_fjzt.Isbm(lsbh0);
krxm0 = ds_temp.Tables[0].Rows[0]["krxm"].ToString();
sktt0 = ds_temp.Tables[0].Rows[0]["sktt"].ToString();
lsbh0 = ds_temp.Tables[0].Rows[0]["lsbh"].ToString();
zyzt_second0 = common_file.common_fjzt.ydf;
yd_ddsj0 = DateTime.Parse(ds_temp.Tables[0].Rows[0]["ddsj"].ToString());
yd_lksj0 = DateTime.Parse(ds_temp.Tables[0].Rows[0]["lksj"].ToString());
}
Ffjzt_add_edit_new.Ffjzt_xgft(common_file.common_fjzt.zf, zyzt_second0, common_file.common_fjzt.ff, old_fjbh, krxm0, DateTime.Parse(common_file.common_app.cssj), DateTime.Parse(common_file.common_app.cssj), yd_ddsj0, yd_lksj0, shlf0, shts0, shvip0, fjbm0, sktt0, lsbh0, czsj, czy, common_file.common_fjzt.ff, xxzs);
s = common_file.common_app.get_suc;
}
return(s);
}
/// <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>
/// 先写入Sjzzd，同时写sjzmx,Ffkfssz
/// 写入成功后，将zwmx里面的对应的记录写入到zwmx_bak,并删除当前lsbh对应下的zwmx记录
public static string Pladd(string lsbh, string jzbh, string xydw, string krly, string czsj, string syzd, string czy, string czy_bc, string jzzt, string cznr, string bz, string fkje, string xfje, string xxzs)
{
//修改房态时用到的变量
string id = "";//主单的ID
//
Ffjzt.Ffjzt_add_edit Ffjzt_add_edit_new = new Hotel_app.Ffjzt.Ffjzt_add_edit(); //用于修改房态
BLL.Ffjzt B_Ffjzt = new Hotel_app.BLL.Ffjzt(); //修改房态
Hotel_app.BLL.Qskyd_fjrb B_Qskyd_fjrb = new Hotel_app.BLL.Qskyd_fjrb();
Hotel_app.Model.Qskyd_mainrecord M_Qskyd_mainrecord;
Hotel_app.BLL.Qskyd_mainrecord B_Qskyd_mainrecord = new Hotel_app.BLL.Qskyd_mainrecord();
Hotel_app.Server.Qyddj.Qyddj_add_edit_delete Qyddj_add_edit_delete_new = new Hotel_app.Server.Qyddj.Qyddj_add_edit_delete();//房态及删除主单操作
string s = common_app.get_failure;
StringBuilder strSql = new StringBuilder();//注意jzzd只写入一次(公共信息查一次就好)
strSql.Append("insert into Sjzzd(yydh,qymc,lsbh,jzbh,krxm,sktt,fjbh,xydw,krly,tfsj,czsj,czy,czzt,jzzt,syzd,bz,fkje,xfje)");
strSql.Append(" select top 1 yydh,qymc,'" + lsbh + "',jzbh,krxm,sktt,fjbh,'" + xydw + "','" + krly + "','" + DateTime.Now + "','" + czsj + "','" + czy + "','" + common_file.common_jzzt.czzt_sz + "','" + common_file.common_jzzt.czzt_sz + "','" + syzd + "','" + bz + "','" + fkje + "','" + xfje + "' from Szw_temp");
strSql.Append(" where lsbh='" + lsbh + "' and czy_temp='" + czy + "'");
BLL.Common B_common = new Hotel_app.BLL.Common();
if (B_common.ExecuteSql(strSql.ToString()) > 0)//写入主单成功后，写入jzmx
{
strSql = new StringBuilder();
strSql.Append("insert into Sjzmx(yydh,qymc,id_app,jzbh,lsbh,krxm,fjrb,fjbh,sktt,xfrq,xfsj,czy,xfdr,xfrb,xfxm,xfbz,xfzy,jjje,xfje,yh,sjxfje,xfsl,shsc,czy_bc,czzt,czsj,syzd,jzzt,fkfs ) ");
strSql.Append(" select yydh,qymc,id_app,jzbh,'" + lsbh + "',krxm,fjrb,fjbh,sktt,xfrq,xfsj,czy,xfdr,xfrb,xfxm,xfbz,xfzy,jjje,xfje,yh,sjxfje,xfsl,shsc,'" + czy_bc + "','" + jzzt + "','" + czsj + "','" + syzd + "','" + jzzt + "',fkfs from Szw_temp");
strSql.Append(" where lsbh='" + lsbh + "' and czy_temp='" + czy + "'");
if (B_common.ExecuteSql(strSql.ToString()) > 0)//写入jzmx成功后,
{
//提取fkdr为付款的项目写入Ffkfssz
strSql = new StringBuilder();
strSql.Append("insert into Sfkfssz(yydh,qymc,jzbh,jzzt,lsbh,fjbh,krxm,fkfs,xfdr,xfrb,xfxm,xfje,sjxfje,fkrq,fksj,xfrq,xfsj,czy,czy_bc,syzd)");
strSql.Append(" select yydh,qymc,jzhb,'" + jzzt + "',lsbh,fjbh,krxm,fkfs,xfdr,xfxm,xfje,sjxfje,fkrq,fksj,xfrq,xfsj,czy,czy_bc,syzd from Szw_temp");
strSql.Append(" where lsbh='" + lsbh + "' and czy_temp='" + czy + "' and xfdr='" + common_app.fkdr + "'");
//删除zwmx里面此lsbh对应的帐务(同时通过zwmx上面的触发器来写入到zwmx_bak里面）
strSql = new StringBuilder();
strSql.Append("update Szwmx set jzbh='" + jzbh + "' where id>0 " + common_file.common_app.yydh_select + " and lsbh='" + lsbh + "'");
if (B_common.ExecuteSql(strSql.ToString()) > 0)//更新成功
{
strSql = new StringBuilder();
strSql.Append("delete from Szwmx where id>0 " + common_file.common_app.yydh_select + " and lsbh='" + lsbh + "'");
//删除的时候根据删除的触发器写入到对应的bak表中
if (B_common.ExecuteSql(strSql.ToString()) > 0)
{
//先更新押金操作表里面的jzbh，再删除yjcz表里面对应的记录，并写入其bak，写入Ffkfssz
strSql = new StringBuilder();
strSql.Append("update Syjcz set jzbh='" + jzbh + "' where id>0 " + common_app.yydh_select + " and lsbh='" + lsbh + "'");
if (B_common.ExecuteSql(strSql.ToString()) > 0) //押金更新成功
{
if (jzzt == common_file.common_jzzt.czzt_sz) //算帐
{
strSql = new StringBuilder();
strSql.Append("delete from Syjcz where id>0 " + common_app.yydh_select + " and lsbh='" + lsbh + "'");
if (B_common.ExecuteSql(strSql.ToString()) > 0)
{
//清除Szw_temp
strSql = new StringBuilder();
strSql.Append("delete from Szw_temp where id>0 " + common_app.yydh_select + " and lsbh='" + lsbh + "'");
if (B_common.ExecuteSql(strSql.ToString()) > 0) //清除Szw_temp里面的数据了
{
//调用修改房态的方法(第五步)
M_Qskyd_mainrecord = B_Qskyd_mainrecord.GetModelList("id>0 " + common_app.yydh_select + " and lsbh='" + lsbh + "'")[0];
id = M_Qskyd_mainrecord.id.ToString();
//删除主单并记录（这里有包含主单记录删除时的备份）
if (Qyddj_add_edit_delete_new.delete_sz_xgft(id, "jz", common_file.common_jzzt.czzt_sz, "", jzbh, czy, czsj, xxzs) == common_app.get_suc)
{
s = common_app.get_suc;
}
}
}
}
else if (jzzt == common_file.common_jzzt.czzt_gz || jzzt == common_file.common_jzzt.czzt_jz)//挂帐或者记帐
{
strSql = new StringBuilder();
strSql.Append("delete from Szw_temp where id>0 " + common_app.yydh_select + " and lsbh='" + lsbh + "'");
if (B_common.ExecuteSql(strSql.ToString()) > 0) //清除Szw_temp里面的数据了
{
//调用修改房态的方法(第五步)
M_Qskyd_mainrecord = B_Qskyd_mainrecord.GetModelList("id>0 " + common_app.yydh_select + " and lsbh='" + lsbh + "'")[0];
id = M_Qskyd_mainrecord.id.ToString();
//删除主单并记录（这里有包含主单记录删除时的备份）
if (Qyddj_add_edit_delete_new.delete_sz_xgft(id, "jz", jzzt, "", jzbh, czy, czsj, xxzs) == common_app.get_suc)
{
s = common_app.get_suc;
}
}
}
}
}
}
}
}
return(s);
}
public string Qskdj_add_edit_delete(string id, string yydh,
string qymc, string lsbh,
string ddbh, string hykh,
string hyrx, string krxm, string tlkr, string krgj,
string krmz, string yxzj, string zjhm, string krxb,
string krsr, string krdh, string krsj, string krEmail,
string krdz, string krjg, string krdw, string krzy,
string cxmd, string qzrx, string qzhm, string zjyxq,
string tlyxq, string tjrq, string lzka, string krly,
string xyh, string xydw, string xsy, string ddrx,
string ddwz, string zyzt, string krrx, string kr_children,
string ddsj, string lzts, string lksj, string qtyq, string czy,
string czsj, string cznr, string sktt, string yddj,
string main_sec, string yddj_rx,
string syzd, string vip_type, string tsyq, string add_edit_delete, string xxzs, string ddly, string hykh_bz)
{
string s = common_file.common_app.get_failure;
BLL.Qskyd_mainrecord B_Qskyd_mainrecord = new Hotel_app.BLL.Qskyd_mainrecord();
Model.Qskyd_mainrecord M_Qskyd_mainrecord = new Hotel_app.Model.Qskyd_mainrecord();
BLL.Qskyd_mainrecord_new B_Qskyd_mainrecord_new = new Hotel_app.BLL.Qskyd_mainrecord_new();
BLL.Ffjzt B_Ffjzt = new Hotel_app.BLL.Ffjzt();
Model.Ffjzt M_Ffjzt = new Hotel_app.Model.Ffjzt();
BLL.Qskyd_fjrb B_Qskyd_fjrb = new Hotel_app.BLL.Qskyd_fjrb();
Model.Qskyd_fjrb M_Qskyd_fjrb = new Hotel_app.Model.Qskyd_fjrb();
BLL.Common B_Common = new Hotel_app.BLL.Common();
if (add_edit_delete == common_file.common_app.get_add)
{
if (main_sec == common_file.common_app.main_sec_sec)
{
M_Qskyd_mainrecord = B_Qskyd_mainrecord.GetModel(int.Parse(id));
}
M_Qskyd_mainrecord.yydh = yydh;
M_Qskyd_mainrecord.qymc = qymc;
M_Qskyd_mainrecord.syzd = syzd;
M_Qskyd_mainrecord.lsbh = lsbh;
M_Qskyd_mainrecord.ddbh = ddbh;
M_Qskyd_mainrecord.hykh = hykh;
M_Qskyd_mainrecord.hyrx = hyrx;
M_Qskyd_mainrecord.krxm = krxm;
M_Qskyd_mainrecord.tlkr = tlkr;
M_Qskyd_mainrecord.krgj = krgj;
M_Qskyd_mainrecord.krmz = krmz;
M_Qskyd_mainrecord.yxzj = yxzj;
M_Qskyd_mainrecord.zjhm = zjhm;
M_Qskyd_mainrecord.krxb = krxb;
M_Qskyd_mainrecord.krsr = Convert.ToDateTime(krsr);
M_Qskyd_mainrecord.krdh = krdh;
M_Qskyd_mainrecord.krsj = krsj;
M_Qskyd_mainrecord.krEmail = krEmail;
M_Qskyd_mainrecord.krdz = krdz;
M_Qskyd_mainrecord.krjg = krjg;
M_Qskyd_mainrecord.krdw = krdw;
M_Qskyd_mainrecord.krzy = krzy;
M_Qskyd_mainrecord.cxmd = cxmd;
M_Qskyd_mainrecord.qzrx = qzrx;
M_Qskyd_mainrecord.qzhm = qzhm;
M_Qskyd_mainrecord.zjyxq = Convert.ToDateTime(zjyxq);
M_Qskyd_mainrecord.tlyxq = Convert.ToDateTime(tlyxq);
M_Qskyd_mainrecord.tjrq = Convert.ToDateTime(tjrq);
M_Qskyd_mainrecord.czy = czy;
M_Qskyd_mainrecord.czsj = Convert.ToDateTime(czsj);
M_Qskyd_mainrecord.cznr = cznr;
M_Qskyd_mainrecord.main_sec = main_sec;
M_Qskyd_mainrecord.vip_type = vip_type;
M_Qskyd_mainrecord.hykh_bz = hykh_bz;
M_Qskyd_mainrecord.krrx = krrx;
string krrx_0 = get_htk(krxm, zjhm);
if (krrx_0 != "")
{
M_Qskyd_mainrecord.krrx = krrx_0;
}
if (main_sec == common_file.common_app.main_sec_main)
{
M_Qskyd_mainrecord.lzka = lzka;
M_Qskyd_mainrecord.krly = krly;
if (krly == "")
{
string krly_0 = get_hy(hykh);
if (krly_0 != "")
{
M_Qskyd_mainrecord.krly = krly_0;
}
}
M_Qskyd_mainrecord.xyh = xyh;
M_Qskyd_mainrecord.xydw = xydw;
M_Qskyd_mainrecord.xsy = xsy;
M_Qskyd_mainrecord.ddrx = ddrx;
M_Qskyd_mainrecord.ddwz = ddwz;
M_Qskyd_mainrecord.zyzt = zyzt;
M_Qskyd_mainrecord.kr_children = Convert.ToInt32(kr_children);
M_Qskyd_mainrecord.ddsj = Convert.ToDateTime(ddsj);
M_Qskyd_mainrecord.lzts = Convert.ToInt32(lzts);
M_Qskyd_mainrecord.lksj = Convert.ToDateTime(lksj);
M_Qskyd_mainrecord.qtyq = qtyq;
M_Qskyd_mainrecord.sktt = sktt;
M_Qskyd_mainrecord.yddj = yddj;
M_Qskyd_mainrecord.tsyq = tsyq;
M_Qskyd_mainrecord.ddly = ddly;
}
B_Qskyd_mainrecord.Add(M_Qskyd_mainrecord);
{
if (main_sec == common_file.common_app.main_sec_main)
{
Q_ff_xyxf Q_ff_xyxf_new = new Q_ff_xyxf();
Q_ff_xyxf_new.Qyddj_otherfee_add(yydh, qymc, lsbh, krxm, sktt, "", czy);
}
}
s = common_file.common_app.get_suc;
}
else if (add_edit_delete == common_file.common_app.get_edit)
{
//M_Qskyd_mainrecord.id = int.Parse(id);
M_Qskyd_mainrecord = B_Qskyd_mainrecord.GetModel(int.Parse(id));
DateTime ddsj_temp = M_Qskyd_mainrecord.ddsj;
DateTime lksj_temp = M_Qskyd_mainrecord.lksj;
string krxm_temp = M_Qskyd_mainrecord.krxm;
DataSet DS_temp;
string fjbh_temp = "";
DS_temp = B_Qskyd_fjrb.GetList("lsbh='" + M_Qskyd_mainrecord.lsbh + "'");
if (DS_temp != null && DS_temp.Tables[0].Rows.Count > 0)
{
fjbh_temp = DS_temp.Tables[0].Rows[0]["fjbh"].ToString();
if (fjbh_temp != "")
{
//这边要判断是否有一间房间，两个主单的情况，另外如抵离时间有变动，房态里的抵离时间也要跟着变动
if (yddj == common_file.common_yddj.yddj_yd)
{
if (ddsj_temp != DateTime.Parse(ddsj))
{
//清除
if (ddsj_temp >= DateTime.Now.Date && ddsj_temp < DateTime.Now.Date.AddDays(1))
{
//清除预订
Qyddj.Qskyd_fjrb_add_edit_delete Qskyd_fjrb_add_edit_delete_new = new Qskyd_fjrb_add_edit_delete();
s = Qskyd_fjrb_add_edit_delete_new.clear_old_yd_fjzt(fjbh_temp, M_Qskyd_mainrecord.ddsj, M_Qskyd_mainrecord.lksj, DateTime.Parse(czsj), czy, xxzs);
}
B_Common.ExecuteSql("update Qskyd_mainrecord set ddsj='" + ddsj + "',shsc=0,czsj='" + czsj + "' where lsbh in(select lsbh from View_Qskzd where fjbh='" + fjbh_temp + "' and ddsj='" + ddsj_temp + "' and lksj='" + lksj_temp + "')");
//B_Common.ExecuteSql("update Qskyd_fjrb set ddsj='" + ddsj + "',shsc=0,czsj='" + czsj + "' where lsbh in(select lsbh from View_Qskzd where fjbh='" + fjbh_temp + "' and ddsj='" + ddsj_temp + "' and lksj='" + lksj_temp + "')");
//判断新的预订是否要改房态
if (DateTime.Parse(ddsj) >= DateTime.Now.Date && DateTime.Parse(ddsj) < DateTime.Now.Date.AddDays(1))
{
Qyddj.Qskyd_fjrb_add_edit_delete Qskyd_fjrb_add_edit_delete_new = new Qskyd_fjrb_add_edit_delete();
Qskyd_fjrb_add_edit_delete_new.add_fjbh_yd_fjzt(M_Qskyd_mainrecord.lsbh, fjbh_temp, M_Qskyd_mainrecord.sktt, DateTime.Parse(czsj), czy, xxzs);
}
}
if (lksj_temp != DateTime.Parse(lksj))
{
string s_temp = "update Qskyd_mainrecord set lksj='" + lksj + "',shsc=0,czsj='" + czsj + "' where lsbh in(select lsbh from View_Qskzd where fjbh='" + fjbh_temp + "' and ddsj='" + ddsj + "' and lksj='" + lksj_temp + "')";
B_Common.ExecuteSql(s_temp);
//B_Common.ExecuteSql("update Qskyd_fjrb set lksj='" + lksj + "',shsc=0,czsj='" + czsj + "' where lsbh in(select lsbh from View_Qskzd where fjbh='" + fjbh_temp + "' and ddsj='" + ddsj_temp + "' and lksj='" + lksj_temp + "')");
s_temp = "update Ffjzt set yd_lksj='" + lksj + "',czsj='" + DateTime.Now.ToString() + "' where fjbh='" + fjbh_temp + "' and yd_ddsj='" + ddsj + "' and yd_lksj='" + lksj_temp + "'";
B_Common.ExecuteSql(s_temp);
}
}
else
if (yddj == common_file.common_yddj.yddj_dj)
{
if (lksj_temp != DateTime.Parse(lksj))
{
B_Common.ExecuteSql("update Qskyd_mainrecord set lksj='" + lksj + "',shsc=0,czsj='" + czsj + "' where lsbh in(select lsbh from View_Qskzd where fjbh='" + fjbh_temp + "' and ddsj='" + ddsj_temp + "' and lksj='" + lksj_temp + "')");
// B_Common.ExecuteSql("update Qskyd_fjrb set lksj='" + lksj + "',shsc=0,czsj='" + czsj + "' where lsbh in(select lsbh from View_Qskzd where fjbh='" + fjbh_temp + "' and ddsj='" + ddsj_temp + "' and lksj='" + lksj_temp + "')");
B_Common.ExecuteSql("update Ffjzt set lksj='" + lksj + "',czsj='" + DateTime.Now.ToString() + "' where fjbh='" + fjbh_temp + "' and ddsj='" + ddsj_temp + "' and lksj='" + lksj_temp + "'");
}
}
}
}
DS_temp.Dispose();
M_Qskyd_mainrecord.yydh = yydh;
M_Qskyd_mainrecord.qymc = qymc;
M_Qskyd_mainrecord.lsbh = lsbh;
M_Qskyd_mainrecord.ddbh = ddbh;
M_Qskyd_mainrecord.hykh = hykh;
M_Qskyd_mainrecord.hyrx = hyrx;
M_Qskyd_mainrecord.krxm = krxm;
M_Qskyd_mainrecord.tlkr = tlkr;
M_Qskyd_mainrecord.krgj = krgj;
M_Qskyd_mainrecord.krmz = krmz;
M_Qskyd_mainrecord.yxzj = yxzj;
M_Qskyd_mainrecord.zjhm = zjhm;
M_Qskyd_mainrecord.krxb = krxb;
M_Qskyd_mainrecord.krsr = Convert.ToDateTime(krsr);
M_Qskyd_mainrecord.krdh = krdh;
if (M_Qskyd_mainrecord.ddyy != common_file.common_app.ydzx_flag)
{
M_Qskyd_mainrecord.xsy = xsy;
M_Qskyd_mainrecord.xyh = xyh;
M_Qskyd_mainrecord.xydw = xydw;
M_Qskyd_mainrecord.krly = krly;
}
//if(M_Qskyd_mainrecord.ddyy != common_file.common_app.ydzx_flage&&M_Qskyd_mainrecord.krly != common_file.common_app.krly_xydw_flage)
//{
// M_Qskyd_mainrecord.xsy = xsy;
// }
M_Qskyd_mainrecord.krsj = krsj;
M_Qskyd_mainrecord.krEmail = krEmail;
M_Qskyd_mainrecord.krdz = krdz;
M_Qskyd_mainrecord.krjg = krjg;
M_Qskyd_mainrecord.krdw = krdw;
M_Qskyd_mainrecord.krzy = krzy;
M_Qskyd_mainrecord.cxmd = cxmd;
M_Qskyd_mainrecord.qzrx = qzrx;
M_Qskyd_mainrecord.qzhm = qzhm;
M_Qskyd_mainrecord.zjyxq = Convert.ToDateTime(zjyxq);
M_Qskyd_mainrecord.tlyxq = Convert.ToDateTime(tlyxq);
M_Qskyd_mainrecord.tjrq = Convert.ToDateTime(tjrq);
M_Qskyd_mainrecord.lzka = lzka;
if (krly == "")
{
string krly_0 = get_hy(hykh);
if (krly_0 != "")
{
M_Qskyd_mainrecord.krly = krly_0;
}
}
M_Qskyd_mainrecord.ddrx = ddrx;
M_Qskyd_mainrecord.ddwz = ddwz;
M_Qskyd_mainrecord.zyzt = zyzt;
M_Qskyd_mainrecord.krrx = krrx;
string krrx_0 = get_htk(krxm, zjhm);
if (krrx_0 != "")
{
M_Qskyd_mainrecord.krrx = krrx_0;
}
M_Qskyd_mainrecord.kr_children = Convert.ToInt32(kr_children);
if (M_Qskyd_mainrecord.yddj != common_file.common_yddj.yddj_dj)
{
M_Qskyd_mainrecord.ddsj = Convert.ToDateTime(ddsj);
}
M_Qskyd_mainrecord.lzts = Convert.ToInt32(lzts);
M_Qskyd_mainrecord.lksj = Convert.ToDateTime(lksj);
M_Qskyd_mainrecord.qtyq = qtyq;
M_Qskyd_mainrecord.czy = czy;
M_Qskyd_mainrecord.czsj = Convert.ToDateTime(czsj);
M_Qskyd_mainrecord.cznr = cznr;
//M_Qskyd_mainrecord.sktt = sktt;
//M_Qskyd_mainrecord.yddj = yddj;
//M_Qskyd_mainrecord.main_sec = main_sec;
M_Qskyd_mainrecord.vip_type = vip_type;
M_Qskyd_mainrecord.tsyq = tsyq;
M_Qskyd_mainrecord.ddly = ddly;
M_Qskyd_mainrecord.hykh_bz = hykh_bz;
//common_file.common_Qskyd_mainrecord.PlInter(int.Parse(id), "修改");//删除前批量添加到备份表里
B_Qskyd_mainrecord_new.Pladd(int.Parse(id), common_file.common_app.chinese_edit, "", czy, czsj, "xg", "");
B_Qskyd_mainrecord.Update(M_Qskyd_mainrecord);
fjbh_temp = "";
string shlf_temp = "0";
bool shlf0 = common_file.common_fjzt.Islf(M_Qskyd_mainrecord.lsbh);
if (shlf0 == true)
{
shlf_temp = "1";
}
string shts_temp = "0";
bool shts0 = common_file.common_fjzt.Ists(M_Qskyd_mainrecord.lsbh);
if (shts0 == true)
{
shts_temp = "1";
}
string shvip_temp = "0";
bool shvip0 = common_file.common_fjzt.IsVIP(M_Qskyd_mainrecord.lsbh);
if (shvip0 == true)
{
shvip_temp = "1";
}
string fjbm_temp = "0";
bool fjbm0 = common_file.common_fjzt.Isbm(M_Qskyd_mainrecord.lsbh);
if (fjbm0 == true)
{
fjbm_temp = "1";
}
string krxm0 = M_Qskyd_mainrecord.krxm;
if (DS_temp != null && DS_temp.Tables[0].Rows.Count > 0)
{
fjbh_temp = DS_temp.Tables[0].Rows[0]["fjbh"].ToString();
if (yddj == common_file.common_yddj.yddj_dj)
{
B_Common.ExecuteSql("update Ffjzt set krxm='" + krxm0 + "',shlf='" + shlf_temp + "',shts='" + shts_temp + "',shvip='" + shvip_temp + "',fjbm='" + fjbm_temp + "',czsj='" + DateTime.Now.ToString() + "' where fjbh='" + fjbh_temp + "'");
}
else
if (yddj == common_file.common_yddj.yddj_yd)
{
B_Common.ExecuteSql("update Ffjzt set krxm='" + krxm0 + "',shlf='" + shlf_temp + "',shts='" + shts_temp + "',shvip='" + shvip_temp + "',fjbm='" + fjbm_temp + "',czsj='" + DateTime.Now.ToString() + "' where fjbh='" + fjbh_temp + "' and yd_ddsj='" + M_Qskyd_mainrecord.ddsj + "' and yd_lksj='" + M_Qskyd_mainrecord.lksj + "' and zyzt<>'" + common_file.common_fjzt.zzf + "'");
}
}
s = common_file.common_app.get_suc;
}
else if (add_edit_delete == common_file.common_app.get_delete)
{
s = delete_sz_xgft(id, "sc", cznr, qtyq, "", czy, czsj, xxzs);
//通过qtyq传递取消原因过来
}
return(s);
}
/// <summary>
/// 用来删除主单或退房时单据的删除和修改房态及备份相应记录
/// </summary>
/// <param name="id"></param>
/// <param name="czzt"></param>两个值,一个是删除“sc”，一个是结账"jz"
/// <param name="czbz"></param>主要是两个值，一个是“取消”，一个“未到”到common_yddj里去找
/// <param name="qxyy"></param>取消原因
/// <param name="jzbh"></param>
/// <param name="czy"></param>
/// <param name="czsj"></param>
/// <param name="xxzs"></param>
/// <returns></returns>
public string delete_sz_xgft(string id, string czzt, string czbz, string qxyy, string jzbh, string czy, string czsj, string xxzs)
{
int i_temp = 8;//用来M_Qskyd_mainrecord =NULL时判断
string s = common_file.common_app.get_failure;
BLL.Qskyd_mainrecord B_Qskyd_mainrecord = new Hotel_app.BLL.Qskyd_mainrecord();
Model.Qskyd_mainrecord M_Qskyd_mainrecord = new Hotel_app.Model.Qskyd_mainrecord();
BLL.Qskyd_mainrecord_new B_Qskyd_mainrecord_new = new Hotel_app.BLL.Qskyd_mainrecord_new();
BLL.Ffjzt B_Ffjzt = new Hotel_app.BLL.Ffjzt();
Model.Ffjzt M_Ffjzt = new Hotel_app.Model.Ffjzt();
BLL.Qskyd_fjrb B_Qskyd_fjrb = new Hotel_app.BLL.Qskyd_fjrb();
Model.Qskyd_fjrb M_Qskyd_fjrb = new Hotel_app.Model.Qskyd_fjrb();
BLL.Common B_Common = new Hotel_app.BLL.Common();
if (id != "")
{
DataSet DS_temp;
M_Qskyd_mainrecord = B_Qskyd_mainrecord.GetModel(int.Parse(id));
//判断预订的记录有两条房类时删除同一个主单避免出错
if (M_Qskyd_mainrecord == null)
{
i_temp = 9;
}
else
{
DS_temp = B_Qskyd_fjrb.GetList(" lsbh='" + M_Qskyd_mainrecord.lsbh + "'");
string fjbh_temp = "";
if (DS_temp != null && DS_temp.Tables[0].Rows.Count > 0)
{
//fjbh_temp = DS_temp.Tables[0].Rows[0]["fjbh"].ToString();
for (int k_0 = 0; k_0 < DS_temp.Tables[0].Rows.Count; k_0++)
{
if (DS_temp.Tables[0].Rows[k_0]["fjbh"].ToString() != "")
{
fjbh_temp = DS_temp.Tables[0].Rows[k_0]["fjbh"].ToString();
}
}
s = common_file.common_app.get_suc;
if (fjbh_temp != "")
{
DS_temp = B_Ffjzt.GetList(" fjbh='" + fjbh_temp + "'");
if (DS_temp != null && DS_temp.Tables[0].Rows.Count > 0)
{
M_Ffjzt = B_Ffjzt.GetModel(int.Parse(DS_temp.Tables[0].Rows[0]["id"].ToString()));
//修改房态,把在住房改成脏房后,再判断是否有两个主单共用一个房间如有再把它改成在住.
if (M_Qskyd_mainrecord.yddj == common_file.common_yddj.yddj_dj)
{
s = common_file.common_app.get_failure;
//改成脏房
Ffjzt.Fgj_z_yj_zzzf Fgj_z_yj_zzzf_new = new Hotel_app.Server.Ffjzt.Fgj_z_yj_zzzf();
s = Fgj_z_yj_zzzf_new.set_gj_zf_yj_zzzf_qxzz(M_Ffjzt.id.ToString(), M_Qskyd_mainrecord.yydh, M_Qskyd_mainrecord.qymc, M_Ffjzt.fjbh, "zf", czy, DateTime.Parse(czsj), xxzs);
//是否有两个主单共用一个房间如有再把它改成在住.
DS_temp = B_Qskyd_fjrb.GetList(" fjbh='" + fjbh_temp + "' and yddj='" + common_file.common_yddj.yddj_dj + "' and lsbh<>'" + M_Qskyd_mainrecord.lsbh + "'");
if (DS_temp != null && DS_temp.Tables[0].Rows.Count > 0)
{
s = common_file.common_app.get_failure;
Qyddj.Qskyd_fjrb_add_edit_delete Qskyd_fjrb_add_edit_delete_new = new Qskyd_fjrb_add_edit_delete();
M_Qskyd_fjrb = B_Qskyd_fjrb.GetModel(int.Parse(DS_temp.Tables[0].Rows[0]["id"].ToString()));
Qskyd_fjrb_add_edit_delete_new.add_fjbh_dj_fjzt(fjbh_temp, M_Qskyd_fjrb, DateTime.Parse(czsj), czy, xxzs);
//把入住房数改成1
B_Common.ExecuteSql("update Qskyd_fjrb set lzfs=1,czsj='" + DateTime.Now.ToString() + "',shsc=0 where lsbh='" + DS_temp.Tables[0].Rows[0]["lsbh"].ToString() + "'");
s = common_file.common_app.get_suc;
}
}
else
if (M_Qskyd_mainrecord.yddj == common_file.common_yddj.yddj_yd)
{
s = common_file.common_app.get_failure;
//清除预订
Qyddj.Qskyd_fjrb_add_edit_delete Qskyd_fjrb_add_edit_delete_new = new Qskyd_fjrb_add_edit_delete();
s = Qskyd_fjrb_add_edit_delete_new.clear_old_yd_fjzt(fjbh_temp, M_Qskyd_mainrecord.ddsj, M_Qskyd_mainrecord.lksj, DateTime.Parse(czsj), czy, xxzs);
//是否有两个主单共用一个房间如有再把它改成预订.
DS_temp = B_Qskyd_fjrb.GetList(" fjbh='" + fjbh_temp + "' and yddj='" + common_file.common_yddj.yddj_yd + "' and lsbh<>'" + M_Qskyd_mainrecord.lsbh + "' and ddsj>='" + DateTime.Now.Date.ToString() + "' and ddsj<'" + DateTime.Now.Date.AddDays(1) + "'");
if (DS_temp != null && DS_temp.Tables[0].Rows.Count > 0)
{
s = common_file.common_app.get_failure;
Qskyd_fjrb_add_edit_delete_new.add_fjbh_yd_fjzt(M_Qskyd_fjrb.lsbh, fjbh_temp, M_Qskyd_fjrb.sktt, DateTime.Parse(czsj), czy, xxzs);
//把入住房数改成1
B_Common.ExecuteSql("update Qskyd_fjrb set lzfs=1,czsj='" + DateTime.Now.ToString() + "',shsc=0 where lsbh='" + DS_temp.Tables[0].Rows[0]["lsbh"].ToString() + "'");
s = common_file.common_app.get_suc;
}
}
}
}
}
//DS_temp.Dispose();
if (s == common_file.common_app.get_suc)
{
s = common_file.common_app.get_failure;
//清除入住记录
int strid = int.Parse(id);
//common_file.common_Qskyd_mainrecord.PlInter(int.Parse(id), "删除");
B_Qskyd_mainrecord_new.Pladd(strid, czbz, qxyy, czy, czsj, czzt, jzbh);//删除前批量添加到备份表里
M_Qskyd_mainrecord = B_Qskyd_mainrecord.GetModel(strid);
if (M_Qskyd_mainrecord != null)
{
//为了避免触发器成批删除时只触发最后一条,删除两次
B_Common.ExecuteSql("delete from Qskyd_mainrecord where lsbh='" + M_Qskyd_mainrecord.lsbh + "' and main_sec='" + common_file.common_app.main_sec_main + "'");
B_Common.ExecuteSql("delete from Qskyd_mainrecord where lsbh='" + M_Qskyd_mainrecord.lsbh + "' and main_sec<>'" + common_file.common_app.main_sec_main + "'");
}
//if (B_Qskyd_mainrecord.Delete(strid) == true)
//{
s = common_file.common_app.get_suc;
//}
}
}
if (i_temp == 9)
{
s = common_file.common_app.get_suc;
}
}
return(s);
}
/// <summary>获得可用房
///
/// </summary>
/// <param name="DS_fjzt"></param>
/// <param name="yd_dj"></param>
/// <param name="ddsj_temp"></param>
/// <param name="lksj_temp"></param>
/// <param name="fjrb_temp"></param>
/// <param name="is_lksj"></param>//是否包含离开时间包含true就不要排除当日预离房，如果不包含false就排除当日预离房
///<param name="is_contain_wx"></param>//是否包含维修（就是说维修时还可排给预订房，但在维修房绝对不能排给登记）TRUE维修房可用，FALSE维修房不能用
public static void get_dataset_fjzt_canused(out DataSet DS_fjzt, string yd_dj, DateTime ddsj_temp, DateTime lksj_temp, string fjrb_temp, bool is_lksj, bool is_contain_wx)
{
BLL.Ffjzt B_Ffjzt = new Hotel_app.BLL.Ffjzt();
string select_strwhere = "(1=1) ";
string ddsj_temp_0 = ddsj_temp.ToShortDateString();
string lksj_temp_0 = lksj_temp.ToShortDateString() + " " + "23:59:59";
string fjrb_fjbh_select = ""; string fjrb_fjbh_select_qtf = ""; string fjrb_fjbh = "";
if (fjrb_temp.Trim() != "")
{
fjrb_fjbh = " and (fjrb='" + fjrb_temp + "')";
fjrb_fjbh_select = " and (fjrb='" + fjrb_temp + "' and Zyzt ='" + common_file.common_fjzt.wxf + " ')"; //用于维修房
fjrb_fjbh_select_qtf = " and (fjrb='" + fjrb_temp + "' and Zyzt='" + common_file.common_fjzt.qtf + "')"; //用于其它房（其它房不管是在预订还是在登记的时候都要排除掉)
}
string wx_select_condition = " and ((ddsj between '" + ddsj_temp_0 + "' and '" + lksj_temp_0 + "') or (ddsj<'" + ddsj_temp_0 + "' and lksj>'" + lksj_temp_0 + "')or (lksj between '" + ddsj_temp_0 + "' and '" + lksj_temp_0 + "'))";
if (is_lksj == false) //false 时离开时间也是不可用，但TRUE时离开那一天可用
{
if (is_contain_wx == false) //不可用的时候都加上这一条件
{
select_strwhere = " (fjbh not in(select fjbh from Fwx_other where (id>=0" + common_app.yydh_select + ")" + wx_select_condition + fjrb_fjbh_select + " )) and ";
select_strwhere += "(fjbh not in(select fjbh from Qskyd_fjrb where (id>=0" + common_app.yydh_select + ")" + wx_select_condition + fjrb_fjbh + " ))";
if (yd_dj == common_file.common_yddj.yddj_dj)
{
select_strwhere += "and (zyzt!='" + common_file.common_fjzt.zzf + "')";
}
}
else
{
if (yd_dj == common_file.common_yddj.yddj_dj)
{
select_strwhere = " (fjbh not in(select fjbh from Fwx_other where (id>=0" + common_app.yydh_select + ")" + wx_select_condition + fjrb_fjbh_select + " )) and ";
select_strwhere += "(fjbh not in(select fjbh from Qskyd_fjrb where (id>=0" + common_app.yydh_select + ")" + wx_select_condition + fjrb_fjbh + " ))";
select_strwhere += "and (zyzt<>'" + common_file.common_fjzt.zzf + "' and zyzt<>'" + common_file.common_fjzt.wxf + "' and zyzt<>'" + common_file.common_fjzt.qtf + "' and zybz<>'" + common_file.common_fjzt.lszy + "')";
}
else
{
select_strwhere += " and (fjbh not in(select fjbh from Qskyd_fjrb where (id>=0" + common_app.yydh_select + ")" + wx_select_condition + fjrb_fjbh + " ))";
}
}
select_strwhere += " and (fjbh not in(select fjbh from Fwx_other Where (id>=0" + common_app.yydh_select + ")" + wx_select_condition + fjrb_fjbh_select_qtf + "))";
if (fjrb_temp != "")
{
select_strwhere += " and (fjrb='" + fjrb_temp + "')";
}
select_strwhere += " order by zyzt , fjrb,fjbh";
DS_fjzt = B_Ffjzt.GetList(select_strwhere);
return;
}
else//if (is_lksj == false)//false 时离开时间也是不可用，但TRUE时离开那一天可用
{
string dj_select_condition = "";
//
//dj_select_condition = " and ((CONVERT(varchar(10),ddsj, 120) between '" + ddsj_temp_0 + "' and '" + lksj_temp_0 + "') or (CONVERT(varchar(10),ddsj, 120) <'" + ddsj_temp_0 + "' and CONVERT(varchar(10),lksj, 120)>'" + lksj_temp_0 + "') or (CONVERT(varchar(10),lksj, 120) between '" + ddsj_temp_0 + "' and '" + lksj_temp_0 + "'))";
string ddsj_cs = ddsj_temp.ToShortDateString();
string ddsj_js = ddsj_temp.ToShortDateString() + " " + "23:59:59";
string lksj_cs = lksj_temp.ToShortDateString();
string lksj_js = lksj_temp.ToShortDateString() + " " + "23:59:59";
if (ddsj_temp.ToShortDateString() != lksj_temp.ToShortDateString())
{
dj_select_condition = " and (((ddsj between '" + ddsj_temp_0 + "' and '" + lksj_temp_0 + "') or (ddsj<'" + ddsj_temp_0 + "' and lksj>'" + lksj_temp_0 + "') or (lksj between '" + ddsj_temp_0 + "' and '" + lksj_temp_0 + "')) and (lsbh not in (select lsbh from VIEW_Qfjrb_fs_tj where (ddsj between '" + lksj_cs + "' and '" + lksj_js + "' and lksj>='" + lksj_cs + "') or (lksj between '" + ddsj_cs + "' and '" + ddsj_js + "' and ddsj<='" + ddsj_js + "') )) )";
}
else
{
//dj_select_condition = " and (((ddsj between '" + ddsj_temp_0 + "' and '" + lksj_temp_0 + "') or (ddsj<'" + ddsj_temp_0 + "' and lksj>'" + lksj_temp_0 + "') or (lksj between '" + ddsj_temp_0 + "' and '" + lksj_temp_0 + "')) and (lsbh not in (select lsbh from VIEW_Qfjrb_fs_tj where ((ddsj between '" + lksj_cs + "' and '" + lksj_js + "' and lksj>='" + lksj_cs + "') or (lksj between '" + ddsj_cs + "' and '" + ddsj_js + "' and ddsj<='" + ddsj_js + "')) and (CONVERT(varchar(10),ddsj, 120)=CONVERT(varchar(10),lksj, 120)) )) )";
dj_select_condition = " and (((ddsj between '" + ddsj_temp_0 + "' and '" + lksj_temp_0 + "') or (ddsj<'" + ddsj_temp_0 + "' and lksj>'" + lksj_temp_0 + "') or (lksj between '" + ddsj_temp_0 + "' and '" + lksj_temp_0 + "')) and (lsbh not in (select lsbh from VIEW_Qfjrb_fs_tj where ((ddsj between '" + lksj_cs + "' and '" + lksj_js + "' and lksj>='" + lksj_cs + "') or (lksj between '" + ddsj_cs + "' and '" + ddsj_js + "' and ddsj<='" + ddsj_js + "')) )) )";
}
//是否排除维修房
if (is_contain_wx == false) //维修房不可用
{
select_strwhere = " (fjbh not in(select fjbh from Fwx_other where (id>=0" + common_app.yydh_select + ")" + wx_select_condition + fjrb_fjbh_select + " ))";
select_strwhere += " and (fjbh not in(select fjbh from Qskyd_fjrb where (id>=0" + common_app.yydh_select + ")" + dj_select_condition + fjrb_fjbh + " ))";
if (yd_dj == common_file.common_yddj.yddj_dj)
{
select_strwhere += "and (zyzt<>'" + common_file.common_fjzt.zzf + "')";
}
}
else
{
if (yd_dj == common_file.common_yddj.yddj_dj)
{
select_strwhere = " (fjbh not in(select fjbh from Fwx_other where (id>=0" + common_app.yydh_select + ")" + wx_select_condition + fjrb_fjbh_select + " ))";
select_strwhere += " and (fjbh not in(select fjbh from Qskyd_fjrb where (id>=0" + common_app.yydh_select + ")" + dj_select_condition + fjrb_fjbh + " ))";
select_strwhere += "and (zyzt<>'" + common_file.common_fjzt.zzf + "' and zyzt<>'" + common_file.common_fjzt.wxf + "' and zyzt<>'" + common_file.common_fjzt.qtf + "' and zybz<>'" + common_file.common_fjzt.lszy + "')";
}
else
{
select_strwhere += " and (fjbh not in(select fjbh from Qskyd_fjrb where (id>=0" + common_app.yydh_select + ")" + dj_select_condition + fjrb_fjbh + " ))";
}
}
select_strwhere += " and (fjbh not in(select fjbh from Fwx_other Where (id>=0" + common_app.yydh_select + ")" + wx_select_condition + fjrb_fjbh_select_qtf + "))";
if (fjrb_temp != "")
{
select_strwhere += " and (fjrb='" + fjrb_temp + "')";
}
select_strwhere += " order by zyzt, fjrb,fjbh";
DS_fjzt = B_Ffjzt.GetList(select_strwhere);
return;
}
}
public string set_wx_other(int id, string yydh, string qymc, string lsbh, string fjrb, string fjbh, DateTime ddsj, DateTime lksj, string bz, string zyzt, string czy, string czsj, bool is_top, bool is_select, string add_edit_delete, string xxzs)
{
string s = common_file.common_app.get_failure;
DateTime yd_ddsj0 = DateTime.Parse(common_file.common_app.cssj);
DateTime yd_lksj0 = DateTime.Parse(common_file.common_app.cssj);
BLL.Fwx_other B_Fwx_other = new Hotel_app.BLL.Fwx_other();
BLL.Qskyd_fjrb B_Qskyd_fjrb = new Hotel_app.BLL.Qskyd_fjrb();
BLL.Ffjzt B_Ffjzt = new Hotel_app.BLL.Ffjzt();
Model.Fwx_other M_Fwx_other = new Hotel_app.Model.Fwx_other();
Ffjzt.Ffjzt_add_edit Ffjzt_add_edit_new = new Hotel_app.Server.Ffjzt.Ffjzt_add_edit();
if (add_edit_delete == common_file.common_app.get_add)
{
s = common_file.common_app.get_failure;
M_Fwx_other.yydh = yydh; M_Fwx_other.qymc = qymc; M_Fwx_other.lsbh = lsbh;
M_Fwx_other.fjrb = fjrb; M_Fwx_other.fjbh = fjbh; M_Fwx_other.ddsj = ddsj;
M_Fwx_other.lksj = lksj; M_Fwx_other.bz = bz; M_Fwx_other.zyzt = zyzt;
M_Fwx_other.czy = czy; M_Fwx_other.czsj = DateTime.Now; M_Fwx_other.cznr = common_file.common_app.chinese_add;
M_Fwx_other.is_top = false;
M_Fwx_other.is_select = false;
if (B_Fwx_other.Add(M_Fwx_other) > 0)
{
s = common_file.common_app.get_suc;
if (ddsj >= DateTime.Now.Date && ddsj < DateTime.Now.Date.AddDays(1))
//当天维修才去修改房态
{
s = common_file.common_app.get_failure;
s = Ffjzt_add_edit_new.set_yd_ft(zyzt, fjbh, ddsj, lksj, czsj, "修改房态成" + zyzt, czy, xxzs);
s = common_file.common_app.get_suc;
}
}
}
else
if (add_edit_delete == common_file.common_app.get_edit)
{
s = common_file.common_app.get_failure;
M_Fwx_other = B_Fwx_other.GetModel(id);
//先修改原来如果有占用房态的房间要先清除掉
DateTime ddsj_temp = M_Fwx_other.ddsj;
DateTime lksj_temp = M_Fwx_other.lksj;
DataSet ds_temp0 = B_Ffjzt.GetList("zyzt='" + zyzt + "' and ddsj='" + ddsj_temp.ToString() + "' and lksj='" + lksj_temp.ToString() + "'");
if ((ddsj < DateTime.Now.Date || ddsj >= DateTime.Now.Date.AddDays(1)) && (ds_temp0.Tables[0].Rows.Count > 0))
{
s = Ffjzt_add_edit_new.set_yd_ft(common_file.common_fjzt.zf, fjbh, DateTime.Parse(common_file.common_app.cssj), DateTime.Parse(common_file.common_app.cssj), czsj, zyzt + "自动修改房态成" + common_file.common_fjzt.zf, czy, xxzs);
}
ds_temp0.Dispose();
M_Fwx_other.ddsj = ddsj;
M_Fwx_other.lksj = lksj; M_Fwx_other.bz = bz; M_Fwx_other.zyzt = zyzt;
M_Fwx_other.czy = czy; M_Fwx_other.czsj = DateTime.Now; M_Fwx_other.cznr = common_file.common_app.chinese_edit;
if (B_Fwx_other.Update(M_Fwx_other) == true)
{
s = common_file.common_app.get_suc;
if ((ddsj >= DateTime.Now.Date && ddsj < DateTime.Now.Date.AddDays(1)))
//不能限制当天维修才去修改房态,因为有可能离开时间延长或变短了!
{
s = common_file.common_app.get_failure;
s = Ffjzt_add_edit_new.set_yd_ft(zyzt, fjbh, ddsj, lksj, czsj, "修改房态成" + zyzt, czy, xxzs);
s = common_file.common_app.get_suc;
}
}
}
else
if (add_edit_delete == common_file.common_app.get_delete)
{
s = common_file.common_app.get_failure;
M_Fwx_other = B_Fwx_other.GetModel(id);
//先修改原来如果有占用房态的房间要先清除掉
DateTime ddsj_temp = M_Fwx_other.ddsj;
DateTime lksj_temp = M_Fwx_other.lksj;
DataSet ds_temp0 = B_Ffjzt.GetList("zyzt='" + zyzt + "' and fjbh='" + fjbh + "' and ddsj='" + ddsj_temp.ToString() + "' and lksj='" + lksj_temp.ToString() + "'");
if ((ds_temp0.Tables[0].Rows.Count > 0))
{
s = Ffjzt_add_edit_new.set_yd_ft(common_file.common_fjzt.zf, fjbh, DateTime.Parse(common_file.common_app.cssj), DateTime.Parse(common_file.common_app.cssj), czsj, zyzt + "自动修改房态成" + common_file.common_fjzt.zf, czy, xxzs);
}
ds_temp0.Dispose();
B_Fwx_other.Delete(id);
s = common_file.common_app.get_suc;
}
return(s);
}
private void b_save_Click(object sender, EventArgs e)
{
common_file.common_app.get_czsj();
if ((dT_ddsj_date.Value < DateTime.Today) && (judge_add_edit == common_file.common_app.get_add))
{
common_file.common_app.Message_box_show(common_file.common_app.message_title, "初始时间不能小于当天！");
}
else
{
if (DateTime.Parse(dT_lksj_date.Value.ToShortDateString() + " " + dT_lksj_time.Value.ToLongTimeString()) < DateTime.Parse(dT_ddsj_date.Value.ToShortDateString() + " " + dT_ddsj_time.Value.ToLongTimeString()))
{
common_file.common_app.Message_box_show(common_file.common_app.message_title, "结束时间不能小于操作时间！");
}
else
{
if (common_file.common_used_fjzt.get_dataset_usedfjzt(zyzt, Convert.ToDateTime(dT_ddsj_date.Value.ToShortDateString() + " 00:00:00"), Convert.ToDateTime(dT_lksj_date.Value.ToShortDateString() + " 23:59:59"), tB_fjrb.Text.Trim(), tB_fjbh.Text.Trim(), tB_fjbh.Text.Trim(), Fwx_other_id, common_file.common_app.is_contain_wx) == false)
{
string url = common_file.common_app.service_url + "Ffjzt/Ffjzt_app.asmx";
object[] args = new object[16];
if (Fwx_other_id == "")
{
args[0] = 0;
}
else
{
args[0] = int.Parse(Fwx_other_id);
}
args[1] = common_file.common_app.yydh;
args[2] = common_file.common_app.qymc;
args[3] = common_file.common_ddbh.ddbh("wxqt", "lfdate", "lfcounter", 3);
args[4] = tB_fjrb.Text.Trim().Replace("'", "//");
args[5] = tB_fjbh.Text.Trim().Replace("'", "//");
args[6] = DateTime.Parse(dT_ddsj_date.Value.ToShortDateString());
args[7] = DateTime.Parse(dT_lksj_date.Value.ToShortDateString() + " 23:59:59");
args[8] = tB_bz.Text.Trim().Replace("'", "//");
args[9] = zyzt;
args[10] = common_file.common_app.czy;
args[11] = DateTime.Now.ToString();
args[12] = false;
args[13] = false;
args[14] = judge_add_edit;
args[15] = common_file.common_app.xxzs;
Hotel_app.Server.Ffjzt.Fwx_other Fwx_other_services = new Hotel_app.Server.Ffjzt.Fwx_other();
string result = Fwx_other_services.set_wx_other(int.Parse(args[0].ToString()), args[1].ToString(), args[2].ToString(), args[3].ToString(), args[4].ToString(), args[5].ToString(), DateTime.Parse(args[6].ToString()), DateTime.Parse(args[7].ToString()), args[8].ToString(), args[9].ToString(), args[10].ToString(), args[11].ToString(), bool.Parse(args[12].ToString()), bool.Parse(args[13].ToString()), args[14].ToString(), args[15].ToString());
//object result = Hotel_app.我的替换DynamicWebServiceCall.InvokeWebService(url, "set_wx_other", args);
if (result == common_file.common_app.get_suc)
{
common_file.common_app.Message_box_show(common_file.common_app.message_title, "保存成功！");
if (Fwx_other_browse_temp_app != null)
{
Fwx_other_browse_temp_app.refresh_app();
}
BLL.Ffjzt B_Ffjzt = new Hotel_app.BLL.Ffjzt();
DataSet ds_temp_0 = B_Ffjzt.GetList("fjbh='" + tB_fjbh.Text + "'");
if (ds_temp_0 != null && ds_temp_0.Tables[0].Rows.Count > 0)
{
if (ds_temp_0.Tables[0].Rows[0]["zyzt"].ToString() == common_file.common_fjzt.wxf || ds_temp_0.Tables[0].Rows[0]["zyzt"].ToString() == common_file.common_fjzt.qtf)
{
if (Ffjzt.common_form.Ffjzt_pic_big_new != null)
{
if (Ffjzt.common_form.Ffjzt_pic_big_new.UC_room_pic_0_select != null)
{
common_file.common_room_state.room_state(Ffjzt.common_form.Ffjzt_pic_big_new.UC_room_pic_0_select, ds_temp_0, 0);
}
}
}
}
ds_temp_0.Dispose();
this.Close();
}
else
if (result.ToString() == common_file.common_app.get_failure)
{
common_file.common_app.Message_box_show(common_file.common_app.message_title, "操作失败！");
}
}
}
Cursor.Current = Cursors.Default;
}
}
/// <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);
}
/// <param name="zyzt"></param>//有三种状态,一种预订、一种登记、一种预订转登记
public string Qskyd_fjrb_add_edit_delete_app(string id, string yydh, string qymc, string lsbh, string krxm, string sktt, string yddj, string fjrb, string fjbh, DateTime ddsj, DateTime lksj, Decimal lzfs, string shqh, decimal fjjg, decimal sjfjjg, string yh, decimal yhbl, string bz, string czy, DateTime czsj, string cznr, string zyzt, string add_edit_delete, string xxzs, string fjbm, decimal jcje)
{
string s = common_file.common_app.get_failure;
BLL.Qskyd_fjrb B_Qskyd_fjrb = new Hotel_app.BLL.Qskyd_fjrb();
BLL.Common B_Common = new Hotel_app.BLL.Common();
BLL.Ffjzt B_Ffjzt = new Hotel_app.BLL.Ffjzt();
Model.Qskyd_fjrb M_Qskyd_fjrb = new Hotel_app.Model.Qskyd_fjrb();
Model.Ffjzt M_Ffjzt = new Hotel_app.Model.Ffjzt();
string old_fjbh = "";
string old_fjbm = "";
DataSet ds_temp = B_Ffjzt.GetList("fjbh='" + fjbh + "'");
string krxm0 = ""; string sktt0 = ""; string lsbh0 = "";
bool shlf0 = false; bool shts0 = false; bool shvip0 = false;
if (add_edit_delete == common_file.common_app.get_add)
{
M_Qskyd_fjrb.bz = bz;
M_Qskyd_fjrb.cznr = cznr;
M_Qskyd_fjrb.czsj = czsj;
M_Qskyd_fjrb.czy = czy;
M_Qskyd_fjrb.ddsj = ddsj;
M_Qskyd_fjrb.fjbh = fjbh;
M_Qskyd_fjrb.fjjg = fjjg;
M_Qskyd_fjrb.fjrb = fjrb;
M_Qskyd_fjrb.krxm = krxm;
M_Qskyd_fjrb.lksj = lksj;
M_Qskyd_fjrb.lsbh = lsbh;
M_Qskyd_fjrb.lzfs = lzfs;
M_Qskyd_fjrb.qymc = qymc;
M_Qskyd_fjrb.shqh = shqh;
M_Qskyd_fjrb.sjfjjg = sjfjjg;
M_Qskyd_fjrb.sktt = sktt;
M_Qskyd_fjrb.yddj = yddj;
M_Qskyd_fjrb.yh = yh;
M_Qskyd_fjrb.yhbl = yhbl;
M_Qskyd_fjrb.yydh = yydh;
M_Qskyd_fjrb.fjbm = fjbm;
M_Qskyd_fjrb.jcje = jcje;
int IsSuc = B_Qskyd_fjrb.Add(M_Qskyd_fjrb);
if (IsSuc > 0)
{
s = common_file.common_app.get_suc;
if (zyzt == common_file.common_yddj.yddj_dj)
{
if (fjbh != "")
{
s = add_fjbh_dj_fjzt(fjbh, M_Qskyd_fjrb, czsj, czy, xxzs);
}
}
else
if (zyzt == common_file.common_yddj.yddj_yd)
{
if (fjbh != "")
{
s = add_fjbh_yd_fjzt(lsbh, fjbh, sktt, czsj, czy, xxzs);
}
}
}
}
else
if (add_edit_delete == common_file.common_app.get_edit)
{
M_Qskyd_fjrb = B_Qskyd_fjrb.GetModel(int.Parse(id));
if (M_Qskyd_fjrb != null)
{
old_fjbh = M_Qskyd_fjrb.fjbh; //根据Id读取旧的房间编号old_fjbh
string old_fjjg = M_Qskyd_fjrb.fjjg.ToString();
string old_sjfjjg = M_Qskyd_fjrb.sjfjjg.ToString();
DateTime old_ddsj = M_Qskyd_fjrb.ddsj;
DateTime old_lksj = M_Qskyd_fjrb.lksj;
M_Qskyd_fjrb.fjrb = fjrb;
M_Qskyd_fjrb.fjbh = fjbh;
M_Qskyd_fjrb.lzfs = lzfs;
M_Qskyd_fjrb.shqh = shqh;
M_Qskyd_fjrb.fjjg = fjjg;
M_Qskyd_fjrb.sjfjjg = sjfjjg;
M_Qskyd_fjrb.yh = yh;
M_Qskyd_fjrb.yhbl = yhbl;
M_Qskyd_fjrb.bz = bz;
M_Qskyd_fjrb.czy = czy;
M_Qskyd_fjrb.czsj = czsj;
M_Qskyd_fjrb.cznr = cznr;
M_Qskyd_fjrb.fjbm = fjbm;
M_Qskyd_fjrb.jcje = jcje;
if (B_Qskyd_fjrb.Update(M_Qskyd_fjrb))
{
if (zyzt == common_file.common_yddj.yddj_dj) //如果yddj等于登记
{
if (old_fjbh != fjbh) //如果旧房间编号不等于新的房间编号说明换房了
{
s = common_file.common_app.get_failure;
if (fjbh != "") //先把新的房号的房态先修改进去
{
s = add_fjbh_dj_fjzt(fjbh, M_Qskyd_fjrb, czsj, czy, xxzs);
}
if (old_fjbh != "") //如果原来房间编号不为空读出相关客人信息，然后把这间房间改为脏房
{
s = clear_old_dj_fjzt(old_fjbh, czsj, czy, xxzs);
}
if (old_fjbh != "")
{
common_file.common_czjl.add_czjl(yydh, qymc, czy, "换房", "原来房号：" + old_fjbh, "换后房号：" + fjbh, czsj);
}
}
if (fjbm == common_file.common_app.fjbm_bm && fjbh != "") //修改房价保密的判断
{
B_Common.ExecuteSql("update Ffjzt set fjbm=1,czsj='" + DateTime.Now.ToString() + "' where fjbh='" + fjbh + "' and fjbm=0");
}
else
if (fjbm != common_file.common_app.fjbm_bm && fjbh != "")
{
B_Common.ExecuteSql("update Ffjzt set fjbm=0,czsj='" + DateTime.Now.ToString() + "' where fjbh='" + fjbh + "' and fjbm=1");
}
}
else
if (zyzt == common_file.common_yddj.yddj_yd) //如果yddj等于预订
{
if (old_fjbh != fjbh) //如果旧房间编号不等于新的房间编号说明换房了
{
if (old_fjbh != "") //如果原来房间编号不为空读出相关客人信息，然后把这间房间改为原来的状态
{
s = clear_old_yd_fjzt(old_fjbh, old_ddsj, old_lksj, czsj, czy, xxzs);
}
if (fjbh != "") //现在的房号不为空--预订
{
s = add_fjbh_yd_fjzt(lsbh, fjbh, sktt, czsj, czy, xxzs);
}
}
if (fjbm == common_file.common_app.fjbm_bm && fjbh != "") //修改房价保密的判断
{
B_Common.ExecuteSql("update Ffjzt set fjbm=1,czsj='" + DateTime.Now.ToString() + "' where fjbh='" + fjbh + "' and fjbm=0 and zyzt<>'" + common_file.common_fjzt.zzf + "' and yd_ddsj='" + M_Qskyd_fjrb.ddsj.ToString() + "' and yd_lksj='" + M_Qskyd_fjrb.lksj.ToString() + "'");
}
else
if (fjbm != common_file.common_app.fjbm_bm && fjbh != "")
{
B_Common.ExecuteSql("update Ffjzt set fjbm=0,czsj='" + DateTime.Now.ToString() + "' where fjbh='" + fjbh + "' and fjbm=1 and zyzt<>'" + common_file.common_fjzt.zzf + "' and yd_ddsj='" + M_Qskyd_fjrb.ddsj.ToString() + "' and yd_lksj='" + M_Qskyd_fjrb.lksj.ToString() + "'");
}
}
else
if (zyzt == common_file.common_yddj.yddj_ydzdj)
{
DataSet DS_temp_1 = B_Common.GetList("select * from Ffjzt", "fjbh='" + fjbh + "' and zyzt_second='" + common_file.common_fjzt.ydf + "' and yd_ddsj='" + M_Qskyd_fjrb.ddsj + "' and yd_lksj='" + M_Qskyd_fjrb.lksj + "'");
if (DS_temp_1 != null && DS_temp_1.Tables[0].Rows.Count >= 0)
{
clear_old_yd_fjzt(M_Qskyd_fjrb.fjbh, old_ddsj, old_lksj, czsj, czy, xxzs);
if (old_ddsj.ToShortDateString() != czsj.ToShortDateString())
{
if (DateTime.Parse(old_ddsj.ToShortDateString()) > DateTime.Parse(czsj.ToShortDateString()))
{
common_file.common_czjl.add_czjl(yydh, qymc, czy, zyzt, krxm + "_" + fjrb + "_" + fjbh + "_" + lsbh, "由" + old_ddsj.ToShortDateString() + "提前至" + czsj.ToShortDateString(), czsj);
}
else
if (DateTime.Parse(old_ddsj.ToShortDateString()) < DateTime.Parse(czsj.ToShortDateString()))
{
common_file.common_czjl.add_czjl(yydh, qymc, czy, zyzt, krxm + "_" + fjrb + "_" + fjbh + "_" + lsbh, "由" + old_ddsj.ToShortDateString() + "推迟至" + czsj.ToShortDateString(), czsj);
}
}
}
if (add_fjbh_dj_fjzt(fjbh, M_Qskyd_fjrb, czsj, czy, xxzs) == common_file.common_app.get_suc)
{
B_Common.ExecuteSql("update Ffjzt set ddsj='" + ddsj.ToString() + "' where fjbh='" + fjbh + "'");
}
}
if (M_Qskyd_fjrb.fjbh == "")
{
string s_0 = "update Qskyd_fjrb set fjjg='" + M_Qskyd_fjrb.fjjg.ToString() + "',sjfjjg='" + M_Qskyd_fjrb.sjfjjg.ToString() + "' , yh='" + M_Qskyd_fjrb.yh + "' , yhbl='" + M_Qskyd_fjrb.yhbl.ToString() + "',fjbm='" + M_Qskyd_fjrb.fjbm + "' where (fjrb='" + M_Qskyd_fjrb.fjrb + "' and fjbh<>'') and (fjjg='" + old_fjjg + "' and sjfjjg='" + old_sjfjjg + "') and (lsbh in(select lsbh from Qskyd_mainrecord where ddbh in(select ddbh from Qttyd_mainrecord where lsbh='" + M_Qskyd_fjrb.lsbh + "')))";
B_Common.ExecuteSql(s_0);
}
s = common_file.common_app.get_suc;
//以下对房态进行再次修改以保证房态会自动刷新
if (M_Qskyd_fjrb.yddj == common_file.common_yddj.yddj_dj)
{
B_Common.ExecuteSql("update Ffjzt set czsj='" + DateTime.Now.ToString() + "'");
}
else
if (M_Qskyd_fjrb.yddj == common_file.common_yddj.yddj_yd)
{
if (M_Qskyd_fjrb.ddsj > DateTime.Parse(DateTime.Now.ToShortDateString()) && M_Qskyd_fjrb.ddsj < DateTime.Parse(DateTime.Now.AddDays(1).ToShortDateString()))
{
B_Common.ExecuteSql("update Ffjzt set czsj='" + DateTime.Now.ToString() + "'");
}
}
}
}
}
else
if (add_edit_delete == common_file.common_app.get_delete)
{
if (id != "")
{
String s_0 = "insert into Qskyd_fjrb_temp(yydh,qymc,lsbh,krxm,sktt,yddj,fjrb,fjbh,ddsj,lksj,lzfs,shqh,fjjg,sjfjjg,yh,yhbl,bz,is_top,is_select,shsc,czy,czsj,cznr,sdcz,fjbm,jcje)";
s_0 = s_0 + "select yydh,qymc,lsbh,krxm,sktt,yddj,fjrb,fjbh,ddsj,lksj,lzfs,shqh,fjjg,sjfjjg,yh,yhbl,bz,is_top,is_select,shsc,'" + czy + "','" + czsj + "','" + cznr + "',sdcz,fjbm,jcje from Qskyd_fjrb where id='" + id + "'";
if (B_Common.ExecuteSql(s_0) > 0)
{
if (B_Qskyd_fjrb.Delete(int.Parse(id)) == true)
{
common_file.common_czjl.add_czjl(yydh, qymc, czy, "强制删除多排" + lzfs + fjrb, krxm, lsbh, czsj);
s = common_file.common_app.get_suc;
}
}
}
}
ds_temp.Dispose();
return(s);
}
