public static bool Ists(string lsbh)//是否特殊要求及回头客或黑名单,只要其中一个不为空就要为TRUE
{
bool shts = false;
//Model.Flfsz M_flfsz = new Hotel_service.Model.Flfsz();
BLL.Qskyd_mainrecord B_Qskyd_mainrecord = new Hotel_app.BLL.Qskyd_mainrecord();
DataSet ds = B_Qskyd_mainrecord.GetList("(lsbh='" + lsbh + "') and (tsyq<>'' or krrx='" + common_app.krrx_htk + "' or krrx='" + common_app.krrx_hmd + "')");
if (ds.Tables[0].Rows.Count > 0)
{
shts = true;
}
else
{
shts = false;
}
return(shts);
}
public static bool IsVIP(string lsbh)//是否VIP或会员，只要其中一个不要空就要为TRUE
{
bool shvip = false;
//Model.Qskyd_mainrecord M_Qskyd_mainrecord = new Hotel_service.Model.Qskyd_mainrecord();
BLL.Qskyd_mainrecord B_Qskyd_mainrecord = new Hotel_app.BLL.Qskyd_mainrecord();
DataSet ds = B_Qskyd_mainrecord.GetList("(lsbh='" + lsbh + "') and ((hykh<>'' and hyrx<>'') or (vip_type<>''))");
if (ds.Tables[0].Rows.Count > 0)
{
shvip = true;
}
else
{
shvip = false;
}
return(shvip);
}
public string Qttyd_add_edit_delete_app(string id, string yydh, string qymc, string lsbh, string ddbh, string krxm, string krbh, string yddj, string sktt, string krgj, string krdz, string krly, string xyh, string xydw, string xsy, string krdh, string krsj, string kremail, string ydrxm, string ddsj, string lzts, string lksj, string qtyq, string ddrx, string ddwz, string zyzt, string czy, string cznr, string czsj, string syzd, string tsyq, string add_edit_delete, string xxzs, string ddly)
{
string s = common_file.common_app.get_failure;
Model.Qttyd_mainrecord M_Qttyd_mainrecord = new Hotel_app.Model.Qttyd_mainrecord();
BLL.Qttyd_mainrecord B_Qttyd_mainrecord = new Hotel_app.BLL.Qttyd_mainrecord();
//DataSet Ds_temp;
if (add_edit_delete == common_file.common_app.get_add)
{
M_Qttyd_mainrecord.cznr = cznr;
M_Qttyd_mainrecord.czsj = Convert.ToDateTime(czsj);
M_Qttyd_mainrecord.czy = czy;
M_Qttyd_mainrecord.ddbh = ddbh;
M_Qttyd_mainrecord.ddrx = ddrx;
M_Qttyd_mainrecord.ddsj = Convert.ToDateTime(ddsj);
M_Qttyd_mainrecord.ddwz = ddwz;
M_Qttyd_mainrecord.krbh = krbh;
M_Qttyd_mainrecord.krdh = krdh;
M_Qttyd_mainrecord.krdz = krdz;
M_Qttyd_mainrecord.krEmail = kremail;
M_Qttyd_mainrecord.krgj = krgj;
M_Qttyd_mainrecord.krly = krly;
M_Qttyd_mainrecord.krsj = krsj;
M_Qttyd_mainrecord.krxm = krxm;
M_Qttyd_mainrecord.lksj = Convert.ToDateTime(lksj);
M_Qttyd_mainrecord.lsbh = lsbh;
M_Qttyd_mainrecord.lzts = Convert.ToInt32(lzts);
M_Qttyd_mainrecord.qtyq = qtyq;
M_Qttyd_mainrecord.qymc = qymc;
M_Qttyd_mainrecord.sktt = sktt;
M_Qttyd_mainrecord.syzd = syzd;
M_Qttyd_mainrecord.tsyq = tsyq;
M_Qttyd_mainrecord.xsy = xsy;
M_Qttyd_mainrecord.xydw = xydw;
M_Qttyd_mainrecord.xyh = xyh;
M_Qttyd_mainrecord.yddj = yddj;
M_Qttyd_mainrecord.ydrxm = ydrxm;
M_Qttyd_mainrecord.yydh = yydh;
M_Qttyd_mainrecord.zyzt = zyzt;
M_Qttyd_mainrecord.ddly = ddly;
int IsAdd = B_Qttyd_mainrecord.Add(M_Qttyd_mainrecord);
if (IsAdd > 0)
{
s = common_file.common_app.get_suc;
}
}
else if (add_edit_delete == common_file.common_app.get_edit)
{
M_Qttyd_mainrecord = B_Qttyd_mainrecord.GetModel(int.Parse(id));
if (M_Qttyd_mainrecord != null)
{
DateTime ddsj_temp = M_Qttyd_mainrecord.ddsj;
DateTime lksj_temp = M_Qttyd_mainrecord.lksj;
M_Qttyd_mainrecord.id = int.Parse(id);
M_Qttyd_mainrecord.cznr = cznr;
M_Qttyd_mainrecord.czsj = Convert.ToDateTime(czsj);
M_Qttyd_mainrecord.czy = czy;
M_Qttyd_mainrecord.ddbh = ddbh;
M_Qttyd_mainrecord.ddrx = ddrx;
M_Qttyd_mainrecord.ddsj = Convert.ToDateTime(ddsj);
M_Qttyd_mainrecord.ddwz = ddwz;
M_Qttyd_mainrecord.krbh = krbh;
M_Qttyd_mainrecord.krdh = krdh;
M_Qttyd_mainrecord.krdz = krdz;
M_Qttyd_mainrecord.krEmail = kremail;
M_Qttyd_mainrecord.krgj = krgj;
M_Qttyd_mainrecord.krsj = krsj;
M_Qttyd_mainrecord.krxm = krxm;
M_Qttyd_mainrecord.lksj = Convert.ToDateTime(lksj);
M_Qttyd_mainrecord.lsbh = lsbh;
M_Qttyd_mainrecord.lzts = Convert.ToInt32(lzts);
M_Qttyd_mainrecord.qtyq = qtyq;
M_Qttyd_mainrecord.qymc = qymc;
M_Qttyd_mainrecord.sktt = sktt;
M_Qttyd_mainrecord.syzd = syzd;
M_Qttyd_mainrecord.tsyq = tsyq;
M_Qttyd_mainrecord.yddj = yddj;
M_Qttyd_mainrecord.ydrxm = ydrxm;
M_Qttyd_mainrecord.yydh = yydh;
M_Qttyd_mainrecord.zyzt = zyzt;
M_Qttyd_mainrecord.ddly = ddly;
if (M_Qttyd_mainrecord.ddyy != common_file_server.common_app.ydzx_flage)
{
M_Qttyd_mainrecord.xsy = xsy;
M_Qttyd_mainrecord.xydw = xydw;
M_Qttyd_mainrecord.krly = krly;
M_Qttyd_mainrecord.xyh = xyh;
}
//if (M_Qttyd_mainrecord.ddyy != common_file.common_app.ydzx_flage&&M_Qttyd_mainrecord.krly != common_file.common_app.krly_xydw_flage)
//{
// M_Qttyd_mainrecord.xsy = xsy;
// }
if (ddsj_temp != M_Qttyd_mainrecord.ddsj || lksj_temp != M_Qttyd_mainrecord.lksj)
{
DataSet ds_temp_0;
BLL.Qskyd_mainrecord B_Qskyd_mainrecord = new Hotel_app.BLL.Qskyd_mainrecord();
ds_temp_0 = B_Qskyd_mainrecord.GetList("ddbh='" + M_Qttyd_mainrecord.ddbh + "'");
if (ds_temp_0 != null && ds_temp_0.Tables[0].Rows.Count > 0)
{
Model.Qskyd_mainrecord M_Qskyd_mainrecord = new Hotel_app.Model.Qskyd_mainrecord();
for (int i_temp_0 = 0; i_temp_0 < ds_temp_0.Tables[0].Rows.Count; i_temp_0++)
{
M_Qskyd_mainrecord = B_Qskyd_mainrecord.GetModel(int.Parse(ds_temp_0.Tables[0].Rows[i_temp_0]["id"].ToString()));
if (M_Qskyd_mainrecord != null)
{
Qyddj.Qyddj_add_edit_delete Qyddj_add_edit_delete_new = new Qyddj_add_edit_delete();
Qyddj_add_edit_delete_new.Qskdj_add_edit_delete(M_Qskyd_mainrecord.id.ToString(), M_Qskyd_mainrecord.yydh,
M_Qskyd_mainrecord.qymc, M_Qskyd_mainrecord.lsbh,
M_Qskyd_mainrecord.ddbh, M_Qskyd_mainrecord.hykh,
M_Qskyd_mainrecord.hyrx, M_Qskyd_mainrecord.krxm, M_Qskyd_mainrecord.tlkr, M_Qskyd_mainrecord.krgj,
M_Qskyd_mainrecord.krmz, M_Qskyd_mainrecord.yxzj, M_Qskyd_mainrecord.zjhm, M_Qskyd_mainrecord.krxb,
M_Qskyd_mainrecord.krsr.ToString(), M_Qskyd_mainrecord.krdh, M_Qskyd_mainrecord.krsj, M_Qskyd_mainrecord.krEmail,
M_Qskyd_mainrecord.krdz, M_Qskyd_mainrecord.krjg, M_Qskyd_mainrecord.krdw, M_Qskyd_mainrecord.krzy,
M_Qskyd_mainrecord.cxmd, M_Qskyd_mainrecord.qzrx, M_Qskyd_mainrecord.qzhm, M_Qskyd_mainrecord.zjyxq.ToString(),
M_Qskyd_mainrecord.tlyxq.ToString(), M_Qskyd_mainrecord.tjrq.ToString(), M_Qskyd_mainrecord.lzka, M_Qskyd_mainrecord.krly,
M_Qttyd_mainrecord.xyh, M_Qttyd_mainrecord.xydw, M_Qttyd_mainrecord.xsy, M_Qttyd_mainrecord.ddrx,
M_Qttyd_mainrecord.ddwz, M_Qttyd_mainrecord.zyzt, M_Qskyd_mainrecord.krrx, M_Qskyd_mainrecord.kr_children.ToString(),
M_Qttyd_mainrecord.ddsj.ToString(), M_Qttyd_mainrecord.lzts.ToString(), M_Qttyd_mainrecord.lksj.ToString(), M_Qskyd_mainrecord.qtyq, czy,
czsj, cznr, M_Qttyd_mainrecord.sktt, M_Qttyd_mainrecord.yddj,
M_Qskyd_mainrecord.main_sec, M_Qskyd_mainrecord.yddj,
M_Qttyd_mainrecord.syzd, M_Qskyd_mainrecord.vip_type, M_Qskyd_mainrecord.tsyq, add_edit_delete, xxzs, M_Qttyd_mainrecord.ddly, M_Qskyd_mainrecord.hykh_bz);
}
}
}
ds_temp_0.Dispose();
}
if (B_Qttyd_mainrecord.Update(M_Qttyd_mainrecord))
{
s = common_file.common_app.get_suc;
}
}
}
else if (add_edit_delete == common_file.common_app.get_delete)
{
if (id != "")
{
s = delete_sz_ttyd(id, "sc", cznr, qtyq, "", czy, czsj, xxzs);
}
}
return(s);
}
