//房态修改时要判断这些值是否要重新加载
public void set_fj_value(out string krxm0, out string sktt0, out string lsbh0, out string zyzt_second0, out DateTime yd_ddsj0, out DateTime yd_lksj0, out bool shlf0, out bool shts0, out bool shvip0, out bool fjbm0, string sel_condition)
{
DataSet ds_temp;
BLL.Qskyd_fjrb B_Qskyd_fjrb = new Hotel_app.BLL.Qskyd_fjrb();
krxm0 = ""; sktt0 = ""; lsbh0 = "";
zyzt_second0 = "";
yd_ddsj0 = DateTime.Parse(common_file.common_app.cssj);
yd_lksj0 = DateTime.Parse(common_file.common_app.cssj);
shlf0 = false; shts0 = false; shvip0 = false; fjbm0 = false;
ds_temp = B_Qskyd_fjrb.GetList(sel_condition);
if (ds_temp != null && ds_temp.Tables[0].Rows.Count > 0)
{
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();
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);
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());
}
ds_temp.Dispose();
}
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);
}
//通过原来的主单信息来新增一条另外的主单，返回真假（mainRecord)
//lsbh为原来的主单的
//lsbh_news为新生成的那条的
//通过房间类型得到房间价格
//private decimal Get_JGByFjrb(string fjrb)
//{
// decimal fjjg = 0;
// BLL.Ffjrb B_Ffjrb = new Hotel_app.BLL.Ffjrb();
// Model.Ffjrb M_Ffjrb = new Hotel_app.Model.Ffjrb();
// if (B_Ffjrb.GetModelList("fjrb='" + fjrb + "'")[0].sjjg != null)
// {
// return B_Ffjrb.GetModelList("fjrb='" + fjrb + "'")[0].sjjg;
// }
// else
// {
// return 0;
// }
//}
//得到fjrb,lsbh,lzfs=1&&fjbh=""时的Qskyd_fjrb的模
private Model.Qskyd_fjrb GetModel(string fjrb, string lsbh)
{
BLL.Qskyd_fjrb B_Qsky_fjrb = new Hotel_app.BLL.Qskyd_fjrb();
if (B_Qsky_fjrb.GetModelList("lsbh='" + lsbh + "' and fjrb='" + fjrb + "'").Count > 0)
{
return(B_Qsky_fjrb.GetModelList("lsbh='" + lsbh + "' and fjrb='" + fjrb + "'")[0]);
}
else
{
return(null);
}
}
//通过房间类型的ID获取主单ID
public static int GetMainRecordIDByFjrbID(string id)
{
int result = 0;
string lsbh = "";
BLL.Qskyd_fjrb B_Qskyd_fjrb = new Hotel_app.BLL.Qskyd_fjrb();
BLL.Qskyd_mainrecord B_Qskyd_mainrecord = new Hotel_app.BLL.Qskyd_mainrecord();
if (B_Qskyd_fjrb.GetModel(int.Parse(id)) != null)
{
lsbh = B_Qskyd_fjrb.GetModel(int.Parse(id)).lsbh;
}
if (B_Qskyd_mainrecord.GetModelList("lsbh='" + lsbh + "'").Count > 0)
{
result = B_Qskyd_mainrecord.GetModelList("lsbh='" + lsbh + "'")[0].id;
}
return(result);
}
public static bool Isbm(string lsbh)//房价是否保密
{
bool sflf = false;
BLL.Qskyd_fjrb B_Qskyd_fjrb = new Hotel_app.BLL.Qskyd_fjrb();
DataSet ds = B_Qskyd_fjrb.GetList("lsbh='" + lsbh + "' and fjbm='" + common_app.fjbm_bm + "'");
if (ds.Tables[0].Rows.Count > 0)
{
sflf = true;
}
else
{
sflf = false;
}
return(sflf);
}
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);
}
///房号，房态来返回图标的名称
///
public static string GetIco(string fjbh, string fjrb)
{
string icoName = "a-4.ico";//默认显示哪个
if (!fjbh.Equals("") && !fjrb.Equals(""))
{
BLL.Qskyd_fjrb B_Qskyd_fjrb = new Hotel_app.BLL.Qskyd_fjrb();
List <Model.Qskyd_fjrb> list = B_Qskyd_fjrb.GetModelList(" id>=0 and fjbh='" + fjbh + "' and yddj='" + common_yddj.yddj_dj + "' ");
if (list.Count > 0)
{
if (list[0].sktt.Equals(common_sktt.sktt_sk))
{
icoName = ""; return(icoName);;
}
;
if (list[0].sktt.Equals(common_sktt.sktt_cz))
{
icoName = "house.ico"; return(icoName);
}
;
if (list[0].sktt.Equals(common_sktt.sktt_zd))
{
icoName = "c-4.ico"; return(icoName);
}
;
if (list[0].sktt.Equals(common_sktt.sktt_tt))
{
icoName = "tuanti.ico"; return(icoName);
}
;
if (list[0].sktt.Equals(common_sktt.sktt_hy))
{
icoName = "a-11.ico"; return(icoName);
}
;
}
}
return(icoName);
}
/// <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 New_skyd_dl_record(string id, string old_lsbh, string czy, string czsj, string xxzs)
{
string s = common_file.common_app.get_failure;
if (id != "")
{
BLL.Common B_Common = new Hotel_app.BLL.Common();
string new_lsbh = common_file.common_ddbh.ddbh("skdjN", "skdjdate", "skdjcounter", 6);
int krzs = 0;
DataSet DS_temp = B_Common.GetList("select count(*) as sl from Qskyd_mainrecord", "lsbh='" + old_lsbh + "'");
if (DS_temp != null && DS_temp.Tables[0].Rows.Count > 0)
{
krzs = int.Parse(DS_temp.Tables[0].Rows[0]["sl"].ToString());
if (krzs > 2)
{
krzs = 2;
}
}
if (krzs > 1)
{
string insert_s = "";
decimal[] fjjg = new decimal[krzs]; decimal[] sjfjjg = new decimal[krzs];
BLL.Qskyd_fjrb B_Qskyd_fjrb = new Hotel_app.BLL.Qskyd_fjrb();
Model.Qskyd_fjrb M_Qskyd_fjrb = new Hotel_app.Model.Qskyd_fjrb();
Model.Qskyd_fjrb M_Qskyd_fjrb_temp = new Hotel_app.Model.Qskyd_fjrb();
DS_temp = B_Common.GetList("select id from Qskyd_fjrb", "lsbh='" + old_lsbh + "'");
if (DS_temp != null && DS_temp.Tables[0].Rows.Count > 0)
{
string id_0 = DS_temp.Tables[0].Rows[0]["id"].ToString();
M_Qskyd_fjrb = B_Qskyd_fjrb.GetModel(int.Parse(id_0));
if (M_Qskyd_fjrb != null)
{
decimal fjjg_temp = 0; decimal sjfjjg_temp = 0;
for (int i_0 = 0; i_0 < krzs; i_0++)
{
if (i_0 < (krzs - 1))
{
fjjg[i_0] = decimal.Parse(common_file.common_sswl.Round_sswl(double.Parse(Convert.ToString(M_Qskyd_fjrb.fjjg / krzs)), common_file.common_sswl.sswl_ws, common_file.common_sswl.selectMode_sel).ToString());
fjjg_temp = fjjg_temp + fjjg[i_0];
sjfjjg[i_0] = decimal.Parse(common_file.common_sswl.Round_sswl(double.Parse(Convert.ToString(M_Qskyd_fjrb.sjfjjg / krzs)), common_file.common_sswl.sswl_ws, common_file.common_sswl.selectMode_sel).ToString());
sjfjjg_temp = sjfjjg_temp + fjjg[i_0];
}
}
fjjg[krzs - 1] = M_Qskyd_fjrb.fjjg - fjjg_temp;
sjfjjg[krzs - 1] = M_Qskyd_fjrb.sjfjjg - sjfjjg_temp;
insert_s = "insert into Qskyd_fjrb (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)";
insert_s = insert_s + " select yydh,qymc,'" + new_lsbh + "',krxm,sktt,yddj,fjrb,fjbh,ddsj,lksj,0,shqh,'" + fjjg[krzs - 1].ToString() + "','" + sjfjjg[krzs - 1].ToString() + "',yh,yhbl,bz,0,0,0,'" + czy + "','" + czsj + "','" + common_file.common_app.chinese_add + "',sdcz,fjbm from Qskyd_fjrb where lsbh='" + old_lsbh + "'";
B_Common.ExecuteSql(insert_s);
//增加配套费用
Q_ff_xyxf Q_ff_xyxf_new = new Q_ff_xyxf();
Q_ff_xyxf_new.Qyddj_otherfee_add(M_Qskyd_fjrb.yydh, M_Qskyd_fjrb.qymc, new_lsbh, M_Qskyd_fjrb.krxm, M_Qskyd_fjrb.sktt, "", czy);
B_Common.ExecuteSql("update Qskyd_fjrb set fjjg='" + fjjg[0] + "',sjfjjg='" + sjfjjg[0] + "' where lsbh='" + old_lsbh + "'");
insert_s = "insert into Szwzd(yydh,qymc,lsbh,krxm,sktt,yddj,fjbh,fkje,xfje,main_sec,is_top,is_select)";
insert_s = insert_s + " select yydh,qymc,'" + new_lsbh + "',krxm,sktt,yddj,fjbh,0,0,'" + common_file.common_app.main_sec_sec + "',0,0 from Szwzd where lsbh='" + old_lsbh + "'";
B_Common.ExecuteSql(insert_s);
B_Common.ExecuteSql("update Qskyd_mainrecord set main_sec='" + common_file.common_app.main_sec_main + "',lsbh='" + new_lsbh + "' where id='" + id + "'");
common_file.common_czjl.add_czjl(M_Qskyd_fjrb.yydh, M_Qskyd_fjrb.qymc, czy, "自成主单", "旧" + old_lsbh + "/新" + new_lsbh, M_Qskyd_fjrb.fjbh, DateTime.Parse(czsj));
s = common_file.common_app.get_suc;
}
}
}
DS_temp.Dispose();
}
return(s);
}
private void timer_GetYdzxData_Tick(object sender, EventArgs e)
{
DataSet ds_0 = null;
DataSet ds_1 = null;
BLL.Common B_common = new Hotel_app.BLL.Common();
ds_0 = B_common.GetList(" select * from View_Qskzd", " id>=0 and ddyy='" + common_file.common_app.ydzx_flag + "' and yddj='" + common_file.common_yddj.yddj_yd + "' and shsc=1 ");
ds_1 = B_common.GetList(" select * from View_Qttzd", " id>=0 and ddyy='" + common_file.common_app.ydzx_flag + "' and yddj='" + common_file.common_yddj.yddj_yd + "' and shsc=1 ");
string url = common_app.service_url;
string clinetAppVersion = "";
//弹出预订中心的订单
if ((ds_0 != null && ds_0.Tables[0].Rows.Count > 0) || (ds_1 != null && ds_1.Tables[0].Rows.Count > 0))
{
fmain_new mainhelper = new fmain_new();
Qyddj.Q_ydzx_noticeBar taskbarNotifier = new Hotel_app.Qyddj.Q_ydzx_noticeBar();
string path = Application.StartupPath;
string fileName = path + "\\image\\" + "skin2.bmp";
string fileName1 = path + "\\image\\" + "close2.bmp";
taskbarNotifier.SetBackgroundBitmap(fileName, Color.FromArgb(255, 0, 255));
taskbarNotifier.SetCloseBitmap(fileName1, Color.FromArgb(255, 0, 255), new Point(300, 74));
taskbarNotifier.TitleRectangle = new Rectangle(123, 80, 176, 16);
taskbarNotifier.ContentRectangle = new Rectangle(116, 97, 197, 22);
taskbarNotifier.TitleClick += new EventHandler(mainhelper.TitleClick);
taskbarNotifier.ContentClick += new EventHandler(mainhelper.ContentClick);
taskbarNotifier.CloseClick += new EventHandler(mainhelper.CloseClick);
taskbarNotifier.CloseClickable = true; // checkBoxCloseClickable.Checked;
taskbarNotifier.TitleClickable = true; // checkBoxTitleClickable.Checked;
taskbarNotifier.ContentClickable = true; // checkBoxContentClickable.Checked;
taskbarNotifier.EnableSelectionRectangle = true; // checkBoxSelectionRectangle.Checked;
taskbarNotifier.KeepVisibleOnMousOver = true; // checkBoxKeepVisibleOnMouseOver.Checked; // Added Rev 002
taskbarNotifier.ReShowOnMouseOver = true; // checkBoxReShowOnMouseOver.Checked; // Added Rev 002
taskbarNotifier.Show("网站订单提醒", "你有新的订单信息，点击查看详细", 10000, 10000, 0);
}
//查询新版本
clinetAppVersion = System.Diagnostics.FileVersionInfo.GetVersionInfo(Application.StartupPath + "\\hotel_app.exe").ProductVersion;
url += "update.asmx";
object[] args = new object[2];
args[0] = common_file.common_app.yydh;
args[1] = clinetAppVersion;
object result = Hotel_app.DynamicWebServiceCall.InvokeWebService(url, "GetUpdate", args);
if (result != null && result.ToString() != "")
{
fmain_new mainhelper = new fmain_new();
//mainhelper.Fmain = this;
Qyddj.Q_ydzx_noticeBar taskbarNotifier = new Hotel_app.Qyddj.Q_ydzx_noticeBar();
string path = Application.StartupPath;
string fileName = path + "\\image\\" + "skin.bmp";
string fileName1 = path + "\\image\\" + "close2.bmp";
taskbarNotifier.SetBackgroundBitmap(fileName, Color.FromArgb(255, 0, 255));
taskbarNotifier.SetCloseBitmap(fileName1, Color.FromArgb(255, 0, 255), new Point(300, 74));
taskbarNotifier.TitleRectangle = new Rectangle(123, 80, 176, 16);
taskbarNotifier.ContentRectangle = new Rectangle(116, 97, 197, 22);
taskbarNotifier.TitleClick += new EventHandler(mainhelper.TitleClick);
taskbarNotifier.ContentClick += new EventHandler(mainhelper.ContentClick_GetNewVersion);
taskbarNotifier.CloseClick += new EventHandler(mainhelper.CloseClick);
taskbarNotifier.CloseClickable = true; // checkBoxCloseClickable.Checked;
taskbarNotifier.TitleClickable = true; // checkBoxTitleClickable.Checked;
taskbarNotifier.ContentClickable = true; // checkBoxContentClickable.Checked;
taskbarNotifier.EnableSelectionRectangle = true; // checkBoxSelectionRectangle.Checked;
taskbarNotifier.KeepVisibleOnMousOver = true; // checkBoxKeepVisibleOnMouseOver.Checked; // Added Rev 002
taskbarNotifier.ReShowOnMouseOver = true; // checkBoxReShowOnMouseOver.Checked; // Added Rev 002
taskbarNotifier.Show("版本检查", "有新的版本产生，点击更新", 10000, 10000, 0);
}
//检查钟点房
BLL.Qskyd_fjrb bll = new Hotel_app.BLL.Qskyd_fjrb();
List <Model.Qskyd_fjrb> lists = bll.GetModelList(" yydh='" + common_file.common_app.yydh + "' and yddj='" + common_file.common_yddj.yddj_dj + "' and sktt='" + common_file.common_sktt.sktt_zd + "' and lksj<'" + DateTime.Now + "' ");
if (lists != null && lists.Count > 0)
{
StringBuilder sb = new StringBuilder();
sb.Append("以下钟点房超时,请确认加收钟点房费:");
foreach (var item in lists)
{
sb.Append("[房号:" + item.fjbh + "]" + "\r\t");
}
fmain_new mainhelper = new fmain_new();
Qyddj.Q_ydzx_noticeBar taskbarNotifier = new Hotel_app.Qyddj.Q_ydzx_noticeBar();
string path = Application.StartupPath;
string fileName = path + "\\image\\" + "skin2.bmp";
string fileName1 = path + "\\image\\" + "close2.bmp";
taskbarNotifier.SetBackgroundBitmap(fileName, Color.FromArgb(255, 0, 255));
taskbarNotifier.SetCloseBitmap(fileName1, Color.FromArgb(255, 0, 255), new Point(300, 74));
taskbarNotifier.TitleRectangle = new Rectangle(123, 80, 176, 16);
taskbarNotifier.ContentRectangle = new Rectangle(116, 97, 197, 22);
taskbarNotifier.TitleClick += new EventHandler(mainhelper.TitleClick);
//taskbarNotifier.ContentClick += new EventHandler(mainhelper.ContentClick_GetNewVersion);
taskbarNotifier.CloseClick += new EventHandler(mainhelper.CloseClick);
taskbarNotifier.CloseClickable = true; // checkBoxCloseClickable.Checked;
taskbarNotifier.TitleClickable = true; // checkBoxTitleClickable.Checked;
taskbarNotifier.ContentClickable = true; // checkBoxContentClickable.Checked;
taskbarNotifier.EnableSelectionRectangle = true; // checkBoxSelectionRectangle.Checked;
taskbarNotifier.KeepVisibleOnMousOver = true; // checkBoxKeepVisibleOnMouseOver.Checked; // Added Rev 002
taskbarNotifier.ReShowOnMouseOver = true; // checkBoxReShowOnMouseOver.Checked; // Added Rev 002
taskbarNotifier.Show("钟点房超时提醒", sb.ToString(), 10000, 10000, 0);
}
}
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);
}
public void InitalApp(string _lsbh, string _sk_tt)
{
dg_tfinfo.AutoGenerateColumns = false;
lsbh = _lsbh;
sk_tt = _sk_tt;
//否则,明细去相应主单的bak里面找
ds = B_sjzzd.GetList(" yydh='" + common_file.common_app.yydh + "' and lsbh='" + lsbh + "'");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
if (sk_tt == "sk")
{
BLL.Qskyd_fjrb_bak B_Qskyd_fjrb_bak = new Hotel_app.BLL.Qskyd_fjrb_bak();
ds_temp = B_Qskyd_fjrb_bak.GetList(" lsbh='" + lsbh + "' and yydh='" + common_file.common_app.yydh + "'");
if (ds_temp != null && ds_temp.Tables[0].Rows.Count > 0)
{
objsource.DataSource = ds_temp.Tables[0];
dg_tfinfo.DataSource = objsource;
}
}
if (sk_tt == "tt")
{
BLL.Qttyd_mainrecord_bak B_Qttyd_mainrecord_bak = new Hotel_app.BLL.Qttyd_mainrecord_bak();
ds_temp = B_Qttyd_mainrecord_bak.GetList(" lsbh='" + lsbh + "' and yydh='" + common_file.common_app.yydh + "'");
if (ds_temp != null && ds.Tables[0].Rows.Count > 0)
{
string ddbh = ds_temp.Tables[0].Rows[0]["ddbh"].ToString();
ds_temp = B_common.GetList(" select * from Qskyd_fjrb_bak ", " id>=0 and yydh='" + common_file.common_app.yydh + "' and fjbh!='' and lsbh in (select lsbh from Qskyd_mainrecord_bak where id>=0 and yydh='" + common_file.common_app.yydh + "' and ddbh='" + ddbh + "')");
if (ds_temp != null && ds_temp.Tables[0].Rows.Count > 0)
{
objsource.DataSource = ds_temp.Tables[0];
dg_tfinfo.DataSource = objsource;
}
}
}
}
else//如果当前的lshb在sjzzd里面找不到,就说明是在住或者预定的类型
{
if (sk_tt == "sk")
{
BLL.Qskyd_fjrb B_Qskyd_fjrb = new Hotel_app.BLL.Qskyd_fjrb();
ds_temp = B_Qskyd_fjrb.GetList(" lsbh='" + lsbh + "' and yydh='" + common_file.common_app.yydh + "'");
if (ds_temp != null && ds_temp.Tables[0].Rows.Count > 0)
{
objsource.DataSource = ds_temp.Tables[0];
dg_tfinfo.DataSource = objsource;
}
}
if (sk_tt == "tt")
{
BLL.Qttyd_mainrecord B_Qttyd_mainrecord = new Hotel_app.BLL.Qttyd_mainrecord();
ds_temp = B_Qttyd_mainrecord.GetList(" lsbh='" + lsbh + "' and yydh='" + common_file.common_app.yydh + "'");
if (ds_temp != null && ds.Tables[0].Rows.Count > 0)
{
string ddbh = ds_temp.Tables[0].Rows[0]["ddbh"].ToString();
BLL.Qskyd_fjrb B_Qskyd_fjrb = new Hotel_app.BLL.Qskyd_fjrb();
ds_temp = B_Qskyd_fjrb.GetList(" ddbh='" + ddbh + "' and yydh='" + common_file.common_app.yydh + "'");
if (ds_temp != null && ds_temp.Tables[0].Rows.Count > 0)
{
objsource.DataSource = ds_temp.Tables[0];
dg_tfinfo.DataSource = objsource;
}
}
}
}
}
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);
}
/// <summary>
/// 处理团体排房
/// </summary>
/// <param name="tt_id">团体房间类别表的ID</param>
/// <param name="fjrb"></param>
/// <param name="fjjg"></param>
/// <param name="shqh"></param>
/// <param name="yh"></param>
/// <param name="yhbl"></param>
/// <param name="bz"></param>
/// <returns></returns>
public string tt_pf(string tt_id, string lsbh, string fjrb, string fjbh, string fjjg, string shqh, string yh, string bz, string czy, string xxzs)
{
string s = common_file.common_app.get_failure;
string lsbh_new = "";
string krxm_temp = "";
int id_temp = 0;
DateTime czsj = DateTime.Now;
Hotel_app.Model.Qskyd_fjrb M_Qskyd_fjrb;
Hotel_app.BLL.Qskyd_fjrb B_Qskyd_fjrb = new Hotel_app.BLL.Qskyd_fjrb();
Hotel_app.Model.Qttyd_mainrecord M_Qttyd_mainrecord;
Hotel_app.BLL.Qttyd_mainrecord B_Qttyd_mainrecord = new Hotel_app.BLL.Qttyd_mainrecord();
Qskyd_fjrb_add_edit_delete Qskyd_fjrb_add_edit_delete_new = new Qskyd_fjrb_add_edit_delete();
//获取公共信息
M_Qttyd_mainrecord = B_Qttyd_mainrecord.GetModelList("lsbh='" + lsbh + "'")[0];
//生成新的临时编号
if (M_Qttyd_mainrecord.yddj == common_file.common_yddj.yddj_dj)
{
lsbh_new = common_file.common_ddbh.ddbh("skdj", "skdjdate", "skdjcounter", 6);
}
else
if (M_Qttyd_mainrecord.yddj == common_file.common_yddj.yddj_yd)
{
lsbh_new = common_file.common_ddbh.ddbh("skyd", "skyddate", "skydcounter", 6);
}
//生成客人的临时姓名(团体名称+房间编号)
krxm_temp = M_Qttyd_mainrecord.krxm + fjbh;
s = common_file_server.Common_pl_Qskyd_mainRecord_add.TT_plAdd(lsbh, lsbh_new, krxm_temp, czy, czsj.ToString(), xxzs);//根据lsbh读起主单信息，添加一条有房号的记录。
//增加配置费用
Q_ff_xyxf Q_ff_xyxf_new = new Q_ff_xyxf();
Q_ff_xyxf_new.Qyddj_otherfee_add(M_Qttyd_mainrecord.yydh, M_Qttyd_mainrecord.qymc, M_Qttyd_mainrecord.lsbh, "", M_Qttyd_mainrecord.sktt, "", czy);
if (s == common_file.common_app.get_suc)//增加成功
{
s = common_file.common_app.get_failure;
#region 修改成员主单的房间类别表的信息
M_Qskyd_fjrb = B_Qskyd_fjrb.GetModelList("lsbh='" + lsbh_new + "'")[0];
id_temp = M_Qskyd_fjrb.id;
M_Qskyd_fjrb.fjbh = fjbh;
M_Qskyd_fjrb.fjrb = fjrb;
M_Qskyd_fjrb.shqh = shqh;
M_Qskyd_fjrb.fjjg = decimal.Parse(fjjg);
M_Qskyd_fjrb.yh = yh;
M_Qskyd_fjrb.yhbl = Get_yhblByYh(yh);
M_Qskyd_fjrb.bz = bz;
M_Qskyd_fjrb.lzfs = 1;
M_Qskyd_fjrb.id = id_temp;
//新增的成员主单修改成功后,更新lzfs(这里调用Qskyd_fjrb_add_edit_delete这个类的方法，注意里面有修改房态的部分)
//if (B_Qskyd_fjrb.Update(M_Qskyd_fjrb))
if (Qskyd_fjrb_add_edit_delete_new.Qskyd_fjrb_add_edit_delete_app(id_temp.ToString(), M_Qskyd_fjrb.yydh, M_Qskyd_fjrb.qymc, lsbh_new, GetStringValue(M_Qskyd_fjrb.krxm), common_file.common_sktt.sktt_tt, GetStringValue(M_Qskyd_fjrb.yddj), fjrb, fjbh, M_Qskyd_fjrb.ddsj, M_Qskyd_fjrb.lksj, decimal.Parse("1"), shqh, decimal.Parse(fjjg), decimal.Parse(fjjg), yh, Get_yhblByYh(yh), bz, czy, DateTime.Now, "新增", GetStringValue(M_Qskyd_fjrb.yddj), common_file.common_app.get_edit, common_file.common_app.xxzs, M_Qskyd_fjrb.fjbm, M_Qskyd_fjrb.jcje) == common_file.common_app.get_suc)
{
M_Qskyd_fjrb = B_Qskyd_fjrb.GetModel(int.Parse(tt_id));
M_Qskyd_fjrb.lzfs -= 1;
M_Qskyd_fjrb.id = int.Parse(tt_id);
if (B_Qskyd_fjrb.Update(M_Qskyd_fjrb))
{
s = common_file.common_app.get_suc;
}
}
#endregion
}
return(s);
}
public string Qskyd_fjrb_add_edit_delete_app_1(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_temp = new Hotel_app.BLL.Qskyd_fjrb();
Model.Qskyd_fjrb M_Qskyd_fjrb = new Hotel_app.Model.Qskyd_fjrb();
Ffjzt.Flfsz_add_edit Flfsz_add_edit_new = new Hotel_app.Server.Ffjzt.Flfsz_add_edit();
BLL.Common B_Common = new Hotel_app.BLL.Common();
DataSet ds = new DataSet();
int id_temp = 0; int id_temp2 = 0;
int j_temp = 1;
string lsbh_News = "";
string ddbh_News = "";
string lfbh_News = ""; int i_1 = 0;
string old_fjbh = "";
BLL.Flfsz B_flfsz = new Hotel_app.BLL.Flfsz();
Model.Flfsz M_flfsz = new Hotel_app.Model.Flfsz();
//if (sktt == common_file.common_sktt.sktt_sk || sktt == common_file.common_sktt.sktt_cz)
{
#region 预订新增房间类型
//1.新增有房号的主单
//2.修改新增主单里的房类信息把fjbh加进去并把lzfs设为1.
//3.设置联房，要先去查看原来的临时编号有没有存在联房，有就不再重新生成联房编号，直接修改。
//4.修改fjrb表，把没有房号的LZFS扣除1同时加到联房里，再修改现有主单里的房类信息
if (add_edit_delete == common_file.common_app.get_add)
{
if (yddj == common_file.common_yddj.yddj_yd)
{
if (lzfs > 1 && fjbh != "")
{
//新增客人主单
ds = B_Qskyd_mainrecord.GetList("lsbh='" + lsbh + "'");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
M_Qskyd_mainrecord = B_Qskyd_mainrecord.GetModel(Convert.ToInt32(ds.Tables[0].Rows[0]["id"].ToString()));
lsbh_News = common_file.common_ddbh.ddbh("skyd", "skyddate", "skydcounter", 6);
ddbh_News = common_file.common_ddbh.ddbh("skyd", "skyddate", "skydcounter", 6);
s = common_file_server.Common_pl_Qskyd_mainRecord_add.Pladd(yydh, qymc, lsbh, lsbh_News, ddbh_News, czy, czsj.ToString(), "", "");//根据lsbh读起主单信息，添加一条有房号的记录。
if (s == common_file.common_app.get_suc)
{
s = common_file.common_app.get_failure;
//修改新增主单里的房类信息把fjbh加进去并把lzfs设为1.
ds = B_temp.GetList("lsbh='" + lsbh_News + "'");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
Model.Qskyd_fjrb M_temp = B_temp.GetModel(Convert.ToInt32(ds.Tables[0].Rows[0]["id"]));
M_temp.fjbh = fjbh;
M_temp.fjrb = fjrb;
M_temp.fjjg = fjjg;
M_temp.sjfjjg = sjfjjg;
M_temp.yh = yh;
M_temp.yhbl = yhbl;
M_temp.shqh = shqh;
M_temp.bz = bz;
M_temp.lzfs = 1;
M_temp.fjbm = fjbm;
M_temp.jcje = jcje;
if (B_temp.Update(M_temp))
{
Qskyd_fjrb_add_edit_delete_new.add_fjbh_yd_fjzt(M_temp.lsbh, M_temp.fjbh, M_temp.sktt, czsj, czy, xxzs);
#region 当前主单以前没有联房过()
if (B_flfsz.GetModelList("lsbh='" + lsbh + "'").Count == 0)
{
//生成新的联房编号
lfbh_News = common_file.common_ddbh.ddbh("lf", "lfdate", "lfcounter", 6);
s = Flfsz_add_edit_new.Flfsz_add_edit_delete("", yydh, qymc, lfbh_News, lsbh_News, fjbh, krxm, sktt, yddj, czy, czsj.ToString(), common_file.common_app.shlz, common_file.common_app.get_add, xxzs);
if (s == common_file.common_app.get_suc)
{
//主单增加到联房，增加新的一条无房号的记录到fjrb表
lzfs = lzfs - 1;
if (Qskyd_fjrb_add_edit_delete_new.Qskyd_fjrb_add_edit_delete_app(id.ToString(), yydh, qymc, lsbh, krxm, sktt, yddj, fjrb, "", ddsj, lksj, lzfs, shqh, fjjg, sjfjjg, yh, yhbl, bz, czy, DateTime.Now, cznr, zyzt, common_file.common_app.get_add, xxzs, fjbm, jcje) == common_file.common_app.get_suc)
{
//新增临时编号到联房里面
string fjbh_0 = "";
DataSet DS_temp = B_Common.GetList("select fjbh from Qskyd_fjrb", "lsbh='" + lsbh + "' and fjbh<>''");
if (DS_temp != null && DS_temp.Tables[0].Rows.Count > 0)
{
fjbh_0 = DS_temp.Tables[0].Rows[0]["fjbh"].ToString();
}
s = Flfsz_add_edit_new.Flfsz_add_edit_delete("", yydh, qymc, lfbh_News, lsbh, fjbh_0, krxm, sktt, yddj, czy, czsj.ToString(), common_file.common_app.shlz, common_file.common_app.get_add, xxzs);
//M_flfsz.yydh = yydh;
//M_flfsz.qymc = qymc;
//M_flfsz.lsbh = lsbh;
//M_flfsz.fjbh = "";
//M_flfsz.lfbh = lfbh_News;
//M_flfsz.krxm = krxm;
//M_flfsz.sktt = sktt;
//M_flfsz.yddj = yddj;
//M_flfsz.czy = czy;
//M_flfsz.czsj = czsj;
//if (B_flfsz.Add(M_flfsz) > 0)
//{
// s = common_file.common_app.get_suc;
//}
//else
//{
// return s;
//}
}
else
{
return(s);
}
}
else
{
return(s);
}
}
#endregion
#region 当前主单有联房过
else
{
//直接把新增的一条加到联房表，fjbh不存在的一条不管
lfbh_News = B_flfsz.GetModelList("lsbh='" + lsbh + "'")[0].lfbh;
s = Flfsz_add_edit_new.Flfsz_add_edit_delete("", yydh, qymc, lfbh_News, lsbh_News, fjbh, krxm, sktt, yddj, czy, czsj.ToString(), common_file.common_app.shlz, common_file.common_app.get_add, xxzs);
if (s == common_file.common_app.get_suc)
{
//主单增加到联房，增加新的一条无房号的记录到fjrb表
lzfs = lzfs - 1;
if (Qskyd_fjrb_add_edit_delete_new.Qskyd_fjrb_add_edit_delete_app(id.ToString(), yydh, qymc, lsbh, krxm, sktt, yddj, fjrb, "", ddsj, lksj, lzfs, shqh, fjjg, sjfjjg, yh, yhbl, bz, czy, DateTime.Now, cznr, zyzt, common_file.common_app.get_add, xxzs, fjbm, jcje) == common_file.common_app.get_suc)
{
s = common_file.common_app.get_suc;
}
else
{
return(s);
}
}
else
{
return(s);
}
}
#endregion
}
else
{
return(s);
}
}
}
else
{
return(s);
}
}
}//if (lzfs > 1 && fjbh != "")
else
{
j_temp = 1;
//如果原来已经有等一条已经排房的记录，新的（增加修改记录）房型一样且如果仍为1时的情况
if (B_temp.GetModelList("lsbh='" + lsbh + "' and fjrb='" + fjrb + "' and fjbh<>'' ").Count > 0)
{
j_temp = 3;
}
if (j_temp != 3)
{
//如果原来已经有等一条已经排房的记录，新的（增加修改记录）房型如果不一样且如果仍为1时的情况
#region 判断当前的临时编号对应的lzfs是否为1，并在fjrb表有多条记录的时候
if (B_temp.GetModelList("lsbh='" + lsbh + "' and fjrb<>'" + fjrb + "' and fjrb<>'' ").Count > 0)
{
j_temp = 3;
}
#endregion
#region 只有一条记录的时候,直接修改fjrb,并加到联房表
else
{
if (Qskyd_fjrb_add_edit_delete_new.Qskyd_fjrb_add_edit_delete_app(id.ToString(), yydh, qymc, lsbh, krxm, sktt, yddj, fjrb, fjbh, ddsj, lksj, lzfs, shqh, fjjg, sjfjjg, yh, yhbl, bz, czy, czsj, cznr, zyzt, add_edit_delete, xxzs, fjbm, jcje) == common_file.common_app.get_suc)
{
s = common_file.common_app.get_suc;
}
else
{
return(s);
}
}
}
if (j_temp == 3)//输入房数为1时的判断，且原来有记录的情况
{
if (fjbh != "")
{
//找到当前房间类型为1，而且还没有排房号的那条记录
//M_Qskyd_fjrb = B_temp.GetModelList("lsbh='" + lsbh + "' and fjrb='" + fjrb + "' and lzfs=1 and fjbh=''")[0];
//得到主单的信息：
lsbh_News = common_file.common_ddbh.ddbh("skyd", "skyddate", "skydcounter", 6);
ddbh_News = common_file.common_ddbh.ddbh("skyd", "skyddate", "skydcounter", 6);
//通过当前的主单信息新增一条新的记录
if (common_file_server.Common_pl_Qskyd_mainRecord_add.Pladd(yydh, qymc, lsbh, lsbh_News, ddbh_News, czy, czsj.ToString(), "", "") == common_file.common_app.get_suc)
{
#region //修改fjrb表里当前生成这条记录的房间信息
id_temp2 = GetModel("", lsbh_News).id;
if (Qskyd_fjrb_add_edit_delete_new.Qskyd_fjrb_add_edit_delete_app(id_temp2.ToString(), yydh, qymc, lsbh_News, krxm, sktt, yddj, fjrb, fjbh, ddsj, lksj, lzfs, shqh, fjjg, sjfjjg, yh, yhbl, bz, czy, czsj, "自动新增", zyzt, common_file.common_app.get_edit, xxzs, fjbm, jcje) == common_file.common_app.get_suc)
{
if (lf_GetResult(lsbh, qymc, lsbh_News, yydh, fjbh, krxm, sktt, yddj, czy, czsj, xxzs))
{
s = common_file.common_app.get_suc;
}
}
#endregion
}
}
else
{
if (Qskyd_fjrb_add_edit_delete_new.Qskyd_fjrb_add_edit_delete_app(id.ToString(), yydh, qymc, lsbh, krxm, sktt, yddj, fjrb, fjbh, ddsj, lksj, lzfs, shqh, fjjg, sjfjjg, yh, yhbl, bz, czy, czsj, cznr, zyzt, add_edit_delete, xxzs, fjbm, jcje) == common_file.common_app.get_suc)
{
s = common_file.common_app.get_suc;
}
else
{
return(s);
}
}
}
#endregion
}
}
}
#endregion
#region 预订修改房间类型
else
if (add_edit_delete == common_file.common_app.get_edit)
{
if (yddj == common_file.common_yddj.yddj_yd)
{
#region 新增主单lzfs > 1 && fjbh != ""
if (lzfs > 1 && fjbh != "")
{
//新增主单
//修改新增主单里的房类信息
//设置联房，要先去查看原来的临时编号有没有存在联房，有就不再重新生成联房编号
//把没有房号的LZFS扣除1同里加到联房里，再修改现有主单里的房类信息
ds = B_Qskyd_mainrecord.GetList("lsbh='" + lsbh + "'");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
M_Qskyd_mainrecord = B_Qskyd_mainrecord.GetModel(Convert.ToInt32(ds.Tables[0].Rows[0]["id"].ToString()));
lsbh_News = common_file.common_ddbh.ddbh("skyd", "skyddate", "skydcounter", 6);
ddbh_News = common_file.common_ddbh.ddbh("skyd", "skyddate", "skydcounter", 6);
s = common_file_server.Common_pl_Qskyd_mainRecord_add.Pladd(yydh, qymc, lsbh, lsbh_News, ddbh_News, czy, czsj.ToString(), "", "");
if (s == common_file.common_app.get_suc)
{
s = common_file.common_app.get_failure;
//修改新增主单里的房类信息把fjbh加进去
ds = B_temp.GetList("lsbh='" + lsbh_News + "'");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
//修改新增主单的Qskyd_fjrb表的fjbh并加到联房
Model.Qskyd_fjrb M_temp = B_temp.GetModel(Convert.ToInt32(ds.Tables[0].Rows[0]["id"]));
M_temp.fjbh = fjbh;
M_temp.fjrb = fjrb;
M_temp.fjjg = fjjg;
M_temp.sjfjjg = sjfjjg;
M_temp.yh = yh;
M_temp.yhbl = yhbl;
M_temp.shqh = shqh;
M_temp.bz = bz;
M_temp.lzfs = 1;
M_temp.fjbm = fjbm;
M_temp.jcje = jcje;
//M_temp.id=Convert.ToInt32(ds.Tables[0].Rows[0]["id"]);
#region //以前没有联房的处理节
if (B_flfsz.GetModelList("lsbh='" + lsbh + "'").Count == 0) //以前没有联房
{
lfbh_News = common_file.common_ddbh.ddbh("lf", "lfdate", "lfcounter", 6); //
s = Flfsz_add_edit_new.Flfsz_add_edit_delete("", yydh, qymc, lfbh_News, lsbh_News, fjbh, krxm, sktt, yddj, czy, czsj.ToString(), common_file.common_app.shlz, common_file.common_app.get_add, xxzs);
//增加到联房,修改新增的主单fjrb表里的fjbh并把lzfs-1；并增加到联房)
if (B_temp.Update(M_temp) && s == common_file.common_app.get_suc)
{
Qskyd_fjrb_add_edit_delete_new.add_fjbh_yd_fjzt(M_temp.lsbh, M_temp.fjbh, M_temp.sktt, czsj, czy, xxzs);
ds = B_temp.GetList("lsbh='" + lsbh + "' and fjrb='' and id='" + id.ToString() + "'");
i_1 = 5;
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
i_1 = 6;
}
else
{
i_1 = 5;
ds = B_temp.GetList("lsbh='" + lsbh + "' and fjrb<>'' and id='" + id.ToString() + "'");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["fjrb"].ToString() == fjrb)
{
i_1 = 5;
}
else
{
i_1 = 7;
}
}
}
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
id_temp = Convert.ToInt32(ds.Tables[0].Rows[0]["id"]);
M_Qskyd_fjrb = B_temp.GetModel(id_temp);
}
if (i_1 == 5 || i_1 == 6 || i_1 == 7)
{
M_Qskyd_fjrb.lzfs = lzfs - 1;
M_Qskyd_fjrb.czy = czy;
M_Qskyd_fjrb.czsj = DateTime.Now;
M_Qskyd_fjrb.cznr = common_file.common_app.get_edit;
if (i_1 == 6 || i_1 == 7)
{
M_Qskyd_fjrb.fjrb = fjrb;
if (i_1 == 6)
{
M_Qskyd_fjrb.shqh = shqh;
M_Qskyd_fjrb.fjjg = fjjg; //decimal.Parse(common_file.common_get_fjjg.get_fjjg(fjrb));
M_Qskyd_fjrb.sjfjjg = sjfjjg;
M_Qskyd_fjrb.yh = yh;
M_Qskyd_fjrb.yhbl = yhbl;
M_Qskyd_fjrb.bz = bz;
M_Qskyd_fjrb.fjbm = fjbm;
M_Qskyd_fjrb.bz = bz;
}
}
}
if (B_temp.Update(M_Qskyd_fjrb)) //无房间编号的房类主单也加到联房表里面
{
s = Flfsz_add_edit_new.Flfsz_add_edit_delete("", yydh, qymc, lfbh_News, lsbh, "", krxm, sktt, yddj, czy, czsj.ToString(), common_file.common_app.shlz, common_file.common_app.get_add, xxzs);
}
else
{
return(s);
}
}
else
{
return(s);
}
}
#endregion
#region 以前有联房
else
{
//读出联房信息
lfbh_News = B_flfsz.GetModelList("lsbh='" + lsbh + "'")[0].lfbh;
//将新增主单加到联房表里面 同时 修改新增的一条fjrb表里面的信息
M_Qskyd_fjrb = B_temp.GetModelList("lsbh='" + lsbh_News + "'")[0];
//相同信息
M_Qskyd_fjrb.fjrb = fjrb;
M_Qskyd_fjrb.fjbh = fjbh;
M_Qskyd_fjrb.cznr = common_file.common_app.get_edit;
M_Qskyd_fjrb.czsj = DateTime.Now;
M_Qskyd_fjrb.lzfs = 1;
M_Qskyd_fjrb.fjjg = fjjg;
M_Qskyd_fjrb.yh = yh;
M_Qskyd_fjrb.yhbl = yhbl;
M_Qskyd_fjrb.shqh = shqh;
M_Qskyd_fjrb.bz = bz;
M_Qskyd_fjrb.fjbm = fjbm;
M_Qskyd_fjrb.jcje = jcje;
s = Flfsz_add_edit_new.Flfsz_add_edit_delete("", yydh, qymc, lfbh_News, lsbh_News, fjbh, krxm, sktt, yddj, czy, czsj.ToString(), common_file.common_app.shlz, common_file.common_app.get_add, xxzs);
if (s == common_file.common_app.get_suc && B_temp.Update(M_Qskyd_fjrb))
{
Qskyd_fjrb_add_edit_delete_new.add_fjbh_yd_fjzt(M_Qskyd_fjrb.lsbh, M_Qskyd_fjrb.fjbh, M_Qskyd_fjrb.sktt, czsj, czy, xxzs);
//修改原来的fjrb表的信息
//M_Qskyd_fjrb = B_temp.GetModelList("lsbh='" + lsbh + "' and fjrb='" + fjrb + "'")[0];
M_Qskyd_fjrb = B_temp.GetModel(int.Parse(id));
M_Qskyd_fjrb.id = int.Parse(id);
M_Qskyd_fjrb.lzfs = lzfs - 1;
M_Qskyd_fjrb.fjrb = fjrb;
M_Qskyd_fjrb.fjjg = fjjg;
M_Qskyd_fjrb.sjfjjg = sjfjjg;
M_Qskyd_fjrb.yh = yh;
M_Qskyd_fjrb.yhbl = yhbl;
M_Qskyd_fjrb.shqh = shqh;
M_Qskyd_fjrb.bz = bz;
M_Qskyd_fjrb.fjbm = fjbm;
M_Qskyd_fjrb.jcje = jcje;
if (B_temp.Update(M_Qskyd_fjrb))
{
s = common_file.common_app.get_suc;
}
else
{
return(s);
}
}
else
{
return(s);
}
}
#endregion
}
}
else
{
return(s);
}
}
}
#endregion
else
{
#region 判断当前的临时编号对应的lzfs是否为1，并在fjrb表有多条记录的时候
DataSet DS_temp_1;
DS_temp_1 = B_temp.GetList("id='" + id + "'");
if (DS_temp_1 != null && DS_temp_1.Tables[0].Rows.Count > 0)
{
old_fjbh = DS_temp_1.Tables[0].Rows[0]["fjbh"].ToString();
}
j_temp = 1;
//如果原来已经有等一条已经排房的记录，新的（增加修改记录）房型一样且如果仍为1时的情况
if (B_temp.GetModelList("lsbh='" + lsbh + "' and fjrb='" + fjrb + "' and fjbh<>'' ").Count > 0)
{
j_temp = 3;
}
if (j_temp != 3)
{
if (B_temp.GetModelList("lsbh='" + lsbh + "' and fjrb<>'" + fjrb + "' and fjrb<>'' ").Count > 0)
{
j_temp = 3;
if (old_fjbh == "" && fjbh != "")
{
if (B_temp.GetModelList("lsbh='" + lsbh + "' and fjrb<>'" + fjrb + "' and fjrb<>'' and fjbh='' ").Count > 0)
{
j_temp = 1;
}
}
}
#endregion
#region 只有一条记录的时候,直接修改fjrb,并加到联房表
else
{
if (Qskyd_fjrb_add_edit_delete_new.Qskyd_fjrb_add_edit_delete_app(id.ToString(), yydh, qymc, lsbh, krxm, sktt, yddj, fjrb, fjbh, ddsj, lksj, lzfs, shqh, fjjg, sjfjjg, yh, yhbl, bz, czy, czsj, cznr, zyzt, add_edit_delete, xxzs, fjbm, jcje) == common_file.common_app.get_suc)
{
s = common_file.common_app.get_suc;
}
else
{
return(s);
}
}
#endregion
}
if (old_fjbh != "")
{
j_temp = 1;
}
if (j_temp == 3)
{
if (fjbh != "")
{
//找到当前房间类型为1，而且还没有排房号的那条记录
//M_Qskyd_fjrb = B_temp.GetModelList("lsbh='" + lsbh + "' and fjrb='" + fjrb + "' and lzfs=1 and fjbh=''")[0];
//得到主单的信息：
lsbh_News = common_file.common_ddbh.ddbh("skyd", "skyddate", "skydcounter", 6);
ddbh_News = common_file.common_ddbh.ddbh("skyd", "skyddate", "skydcounter", 6);
//通过当前的主单信息新增一条新的记录
if (common_file_server.Common_pl_Qskyd_mainRecord_add.Pladd(yydh, qymc, lsbh, lsbh_News, ddbh_News, czy, czsj.ToString(), "", "") == common_file.common_app.get_suc)
{
#region //修改fjrb表里当前生成这条记录的房间信息
id_temp2 = GetModel("", lsbh_News).id;
if (Qskyd_fjrb_add_edit_delete_new.Qskyd_fjrb_add_edit_delete_app(id_temp2.ToString(), yydh, qymc, lsbh_News, krxm, sktt, yddj, fjrb, fjbh, ddsj, lksj, lzfs, shqh, fjjg, sjfjjg, yh, yhbl, bz, czy, czsj, "自动新增", zyzt, common_file.common_app.get_edit, xxzs, fjbm, jcje) == common_file.common_app.get_suc)
{
//修改成功后，把当前原来fjrb表里面对应的那条记录删除
if (GetModel(fjrb, lsbh) != null)
{
id_temp2 = int.Parse(id);
if (B_temp.Delete(id_temp2))
{
//删除对应记录成功后，把新生成的记录加到联房里
#region 判断当前的lsbh在不在在联房表里面，然后做相应处理
if (lf_GetResult(lsbh, qymc, lsbh_News, yydh, fjbh, krxm, sktt, yddj, czy, czsj, xxzs))
{
s = common_file.common_app.get_suc;
}
#endregion
}
}
}
#endregion
}
}
else
{
if (Qskyd_fjrb_add_edit_delete_new.Qskyd_fjrb_add_edit_delete_app(id.ToString(), yydh, qymc, lsbh, krxm, sktt, yddj, fjrb, fjbh, ddsj, lksj, lzfs, shqh, fjjg, sjfjjg, yh, yhbl, bz, czy, czsj, cznr, zyzt, add_edit_delete, xxzs, fjbm, jcje) == common_file.common_app.get_suc)
{
s = common_file.common_app.get_suc;
}
else
{
return(s);
}
}
}
else
{
if (Qskyd_fjrb_add_edit_delete_new.Qskyd_fjrb_add_edit_delete_app(id.ToString(), yydh, qymc, lsbh, krxm, sktt, yddj, fjrb, fjbh, ddsj, lksj, lzfs, shqh, fjjg, sjfjjg, yh, yhbl, bz, czy, czsj, cznr, zyzt, add_edit_delete, xxzs, fjbm, jcje) == common_file.common_app.get_suc)
{
s = common_file.common_app.get_suc;
}
}
}
} //if (yddj == common_file.common_yddj.yddj_yd)
else
if (yddj == common_file.common_yddj.yddj_dj)
{
if (Qskyd_fjrb_add_edit_delete_new.Qskyd_fjrb_add_edit_delete_app(id.ToString(), yydh, qymc, lsbh, krxm, sktt, yddj, fjrb, fjbh, ddsj, lksj, lzfs, shqh, fjjg, sjfjjg, yh, yhbl, bz, czy, czsj, cznr, zyzt, add_edit_delete, xxzs, fjbm, jcje) == common_file.common_app.get_suc)
{
s = common_file.common_app.get_suc;
}
else
{
return(s);
}
} //if (yddj == common_file.common_yddj.yddj_dj)
}
#endregion
#region hy类型的时候
else
if (sktt == common_file.common_sktt.sktt_tt || sktt == common_file.common_sktt.sktt_hy)
{
if (add_edit_delete == common_file.common_app.get_add)
{
if (yddj == common_file.common_yddj.yddj_yd)
{
//1.新增主单
//2.修改房类Qskyd_Fjrb表，把fjbh写进，lzfs设为1.
//3.修改没有带房号的临时编号lzfs减1
}
}
else
if (add_edit_delete == common_file.common_app.get_edit)
{
}
}
#endregion
}
ds.Dispose();
return(s);
}
//团体多间排房
/// <summary>
///
/// </summary>
/// <param name="tt_id"></param>
/// <param name="lsbh"></param>
/// <param name="fjrb"></param>
/// <param name="strs_fjbh">fjbh的列表</param>
/// <param name="fjjg"></param>
/// <param name="shqh"></param>
/// <param name="yh"></param>
/// <param name="bz"></param>
/// <param name="czy"></param>
/// <returns></returns>
public string tt_pf_multi(string tt_id, string lsbh, string fjrb, string[] strs_fjbh, string fjjg, string shqh, string yh, string bz, string czy, string czsj, string cznr, string xxzs)
{
string s = common_file.common_app.get_failure;
string lsbh_new = "";
string krxm_temp = "";
int id_temp = 0;
Hotel_app.Model.Qskyd_fjrb M_Qskyd_fjrb;
Hotel_app.BLL.Qskyd_fjrb B_Qskyd_fjrb = new Hotel_app.BLL.Qskyd_fjrb();
Hotel_app.Model.Qttyd_mainrecord M_Qttyd_mainrecord;
Hotel_app.BLL.Qttyd_mainrecord B_Qttyd_mainrecord = new Hotel_app.BLL.Qttyd_mainrecord();
Qskyd_fjrb_add_edit_delete Qskyd_fjrb_add_edit_delete_new = new Qskyd_fjrb_add_edit_delete();
Ffjzt.Flfsz_add_edit Flfsz_add_edit_new = new Hotel_app.Server.Ffjzt.Flfsz_add_edit();
BLL.Common B_Common = new Hotel_app.BLL.Common();
DataSet DS_temp = B_Common.GetList("select id from Xqyxx", "id>=0");
//获取公共信息
M_Qttyd_mainrecord = B_Qttyd_mainrecord.GetModelList("lsbh='" + lsbh + "'")[0];
string lfbh_news = ""; int judge_get_lfbh = 2;
foreach (string fjbh in strs_fjbh)
{
if (fjbh != null && fjbh.Trim() != "")
{
//生成新的临时编号
if (M_Qttyd_mainrecord.yddj == common_file.common_yddj.yddj_dj)
{
lsbh_new = common_file.common_ddbh.ddbh("skdj", "skdjdate", "skdjcounter", 6);
}
else
if (M_Qttyd_mainrecord.yddj == common_file.common_yddj.yddj_yd)
{
lsbh_new = common_file.common_ddbh.ddbh("skyd", "skyddate", "skydcounter", 6);
}
//生成客人的临时姓名(团体名称+房间编号)
krxm_temp = M_Qttyd_mainrecord.krxm + "_" + fjbh;
s = common_file_server.Common_pl_Qskyd_mainRecord_add.TT_plAdd(lsbh, lsbh_new, krxm_temp, czy, czsj.ToString(), xxzs);//根据lsbh读起主单信息，添加一条有房号的记录。
//增加配置费用
Q_ff_xyxf Q_ff_xyxf_new = new Q_ff_xyxf();
//Q_ff_xyxf_new.Qyddj_otherfee_add(M_Qttyd_mainrecord.yydh, M_Qttyd_mainrecord.qymc, lsbh_new, "", M_Qttyd_mainrecord.sktt, "", czy);
Q_ff_xyxf_new.Qyddj_otherfee_add(M_Qttyd_mainrecord.yydh, M_Qttyd_mainrecord.qymc, lsbh_new, krxm_temp, M_Qttyd_mainrecord.sktt, "", czy); //把名称加进去
if (s == common_file.common_app.get_suc) //增加成功
{
s = common_file.common_app.get_failure;
#region 修改成员主单的房间类别表的信息
M_Qskyd_fjrb = B_Qskyd_fjrb.GetModelList("lsbh='" + lsbh_new + "'")[0];
id_temp = M_Qskyd_fjrb.id;
M_Qskyd_fjrb.fjbh = fjbh;
M_Qskyd_fjrb.fjrb = fjrb;
M_Qskyd_fjrb.shqh = shqh;
M_Qskyd_fjrb.fjjg = decimal.Parse(fjjg);
M_Qskyd_fjrb.yh = yh;
M_Qskyd_fjrb.yhbl = Get_yhblByYh(yh);
M_Qskyd_fjrb.bz = bz;
M_Qskyd_fjrb.lzfs = 1;
M_Qskyd_fjrb.id = id_temp;
DS_temp = B_Common.GetList("select * from Qskyd_fjrb", "id='" + tt_id + "'");
if (DS_temp != null && DS_temp.Tables[0].Rows.Count > 0)
{
M_Qskyd_fjrb.fjbm = DS_temp.Tables[0].Rows[0]["fjbm"].ToString();
}
//新增的成员主单修改成功后,更新lzfs(这里调用Qskyd_fjrb_add_edit_delete这个类的方法，注意里面有修改房态的部分)
//if (B_Qskyd_fjrb.Update(M_Qskyd_fjrb))
if (Qskyd_fjrb_add_edit_delete_new.Qskyd_fjrb_add_edit_delete_app(id_temp.ToString(), M_Qskyd_fjrb.yydh, M_Qskyd_fjrb.qymc, lsbh_new, GetStringValue(M_Qskyd_fjrb.krxm), common_file.common_sktt.sktt_tt, GetStringValue(M_Qskyd_fjrb.yddj), fjrb, fjbh, M_Qskyd_fjrb.ddsj, M_Qskyd_fjrb.lksj, decimal.Parse("1"), shqh, decimal.Parse(fjjg), decimal.Parse(fjjg), yh, Get_yhblByYh(yh), bz, czy, DateTime.Now, "新增", GetStringValue(M_Qskyd_fjrb.yddj), common_file.common_app.get_edit, common_file.common_app.xxzs, M_Qskyd_fjrb.fjbm, M_Qskyd_fjrb.jcje) == common_file.common_app.get_suc)
{
M_Qskyd_fjrb = B_Qskyd_fjrb.GetModel(int.Parse(tt_id));
M_Qskyd_fjrb.lzfs -= 1;
M_Qskyd_fjrb.id = int.Parse(tt_id);
if (B_Qskyd_fjrb.Update(M_Qskyd_fjrb))
{
//if (judge_get_lfbh != 3)
//{
// DS_temp = B_Common.GetList("select lfbh from Flfsz", "lsbh in(select lsbh from Qskyd_mainrecord where ddbh='" + M_Qttyd_mainrecord.ddbh + "')");
// if (DS_temp != null && DS_temp.Tables[0].Rows.Count > 0)
// {
// lfbh_news = DS_temp.Tables[0].Rows[0]["lfbh"].ToString();
// judge_get_lfbh = 3;
// }
// else
// {
// lfbh_news = common_file.common_ddbh.ddbh("lf", "lfdate", "lfcounter", 6);
// judge_get_lfbh = 3;
// }
//}
//s = Flfsz_add_edit_new.Flfsz_add_edit_delete("", M_Qskyd_fjrb.yydh, M_Qskyd_fjrb.qymc, lfbh_news, lsbh_new, fjbh, M_Qskyd_fjrb.krxm, M_Qskyd_fjrb.sktt, M_Qskyd_fjrb.yddj, czy, czsj.ToString(), false, common_file.common_app.get_add, xxzs);
s = common_file.common_app.get_suc;
}
}
#endregion
}
}
}
DS_temp.Dispose();
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);
}
