//结帐,记帐,挂帐处理过程
public string GetJzResult(string lsbh, string jzbh, string czzt, string sk_tt, string czy, string czsj, string hykh, string xfje, string phoneNo, string yydh)
{
string s = common_app.get_failure;
//记帐，挂帐，结帐的处理节
if (czzt == common_file.common_jzzt.czzt_sz)//算帐
{
strSql = new StringBuilder();
strSql.Append("delete from Syjcz where id>0 " + common_app.yydh_select + " and lsbh='" + lsbh + "'");
B_common.ExecuteSql(strSql.ToString());
strSql = new StringBuilder();
strSql.Append("delete from Szwmx where id>0 " + common_file.common_app.yydh_select + " and lsbh='" + lsbh + "'");
B_common.ExecuteSql(strSql.ToString());
}
//更新Ssyxfmx里的Jzbh
B_common.ExecuteSql("update Ssyxfmx set jzbh='" + jzbh + "' where lsbh='" + lsbh + "'");
if (czzt == common_jzzt.czzt_gz || czzt == common_jzzt.czzt_jz || czzt == common_file.common_jzzt.czzt_sz)
{
//清除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里面的数据了
{
//调用修改房态的方法(第五步)
if (sk_tt == "sk")
{
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//是团体
{
M_Qttyd_mainrecord = B_Qttyd_mainrecord.GetModelList("ID>0 " + common_app.yydh_select + " AND lsbh='" + lsbh + "'")[0];
string tt_id = M_Qttyd_mainrecord.id.ToString();
//要成批更新团体所有成员的房态，并删除成员主单
string ddbh_temp = M_Qttyd_mainrecord.ddbh;
if (Qttyd_add_edit_delete_new.delete_sz_ttyd(tt_id, "jz", common_file.common_jzzt.czzt_sz, "", jzbh, czy, czsj, xxzs) == common_file.common_app.get_suc)
{
s = common_file.common_app.get_suc;
}
}
//结帐成功后,更新会员的积分(挂-结，记-结，部分结，结帐都要加积分
//会员卡号,当前记录的lsbh，
if ((czzt == common_jzzt.czzt_sz) || (czzt == common_jzzt.czzt_jz) || (czzt == common_jzzt.czzt_gz) || (czzt == common_jzzt.czzt_bfsz))
{
string zjf = "0"; bool shsj = false; string hyrx_now = "";//银卡
string dfjf = "0";
string lsbh_df = common_file.common_ddbh.ddbh("df", "lsbhdfdate", "lsbhdfcounter", 6);
string qymc = "";
if (!yydh.Equals(""))
{
DataSet ds000 = B_common.GetList(" select * from Xqyxx ", " id>=0 and yydh='" + yydh + "' ");
if (ds000 != null && ds000.Tables[0].Rows.Count > 0)
{
qymc = ds000.Tables[0].Rows[0]["qymc"].ToString();
}
}
IncHYScore(jzbh, lsbh, sk_tt, hykh, xfje, ref zjf, ref shsj);
//发送会员消费短信
Hhygl.Hhygl_verifyCode Hhygl_verifyCode_new = new Hotel_app.Server.Hhygl.Hhygl_verifyCode();
Hhygl_verifyCode_new.Hhygl_SendMsm(phoneNo, zjf, yydh, qymc, common_hyAction.hy_Action_hytf, czsj, "", "", "", hykh, xfje, xxzs);
BLL.Hhygl B_Hhygl_new = new Hotel_app.BLL.Hhygl();
DataSet ds111 = B_Hhygl_new.GetList(" hykh_bz='" + hykh + "' and id>=0 and hykh_bz!='' ");
if (ds111 != null && ds111.Tables[0].Rows.Count > 0)
{
hyrx_now = ds111.Tables[0].Rows[0]["hykh_bz"].ToString();
}
//升级需要的积分数
BLL.Hhyjb B_Hhyjb_new = new Hotel_app.BLL.Hhyjb();
DataSet ds222 = B_Hhyjb_new.GetList(" hyrx='" + common_app.hykh_rx + "' and id>=0 and qymc='" + qymc + "' ");
if (ds222 != null && ds222.Tables[0].Rows.Count > 0)
{
dfjf = ds222.Tables[0].Rows[0]["hykh_bz"].ToString();
}
if (!hyrx_now.Equals("") && hyrx_now.Equals(common_app.hykh_rx))
{
//发送短信(判断当前的会员类型),是银卡才自动升级
if (shsj)//自动发送升级短信
{
Hhygl_verifyCode_new.Hhygl_SendMsm(phoneNo, zjf, yydh, qymc, common_hyAction.hy_Action_hytf, czsj, "", "", "", hykh, xfje, xxzs);
//调用升级会员的方法，扣除升级积分
Hhygl.Hhyjf_df Hhyjf_dr_new = new Hotel_app.Server.Hhygl.Hhyjf_df();
Hhyjf_dr_new.Hhyjfdf_add_edit("", yydh, qymc, "", hykh, "", dfjf, "升级金卡", "1", lsbh_df, hykh, common_app.chinese_add, xxzs);
}
}
}
}
}
return(s);
}
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);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Hotel_app.Model.Qskyd_mainrecord model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Qskyd_mainrecord(");
strSql.Append("yydh,qymc,lsbh,ddbh,is_top,is_select,hykh,hyrx,krxm,tlkr,krgj,krmz,yxzj,zjhm,krxb,krsr,krdh,krsj,krEmail,krdz,krjg,krdw,krzy,cxmd,qzrx,qzhm,zjyxq,tlyxq,tjrq,lzka,krly,xyh,xydw,xsy,ddrx,ddwz,ddyy,zyzt,krrx,kr_children,ddsj,lzts,lksj,qtyq,czy,czsj,cznr,shsc,sktt,yddj,ffshys,ffzf,main_sec,sdcz,syzd,vip_type,tsyq,ddly,hykh_bz)");
strSql.Append(" values (");
strSql.Append("@yydh,@qymc,@lsbh,@ddbh,@is_top,@is_select,@hykh,@hyrx,@krxm,@tlkr,@krgj,@krmz,@yxzj,@zjhm,@krxb,@krsr,@krdh,@krsj,@krEmail,@krdz,@krjg,@krdw,@krzy,@cxmd,@qzrx,@qzhm,@zjyxq,@tlyxq,@tjrq,@lzka,@krly,@xyh,@xydw,@xsy,@ddrx,@ddwz,@ddyy,@zyzt,@krrx,@kr_children,@ddsj,@lzts,@lksj,@qtyq,@czy,@czsj,@cznr,@shsc,@sktt,@yddj,@ffshys,@ffzf,@main_sec,@sdcz,@syzd,@vip_type,@tsyq,@ddly,@hykh_bz)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@yydh", SqlDbType.VarChar, 50),
new SqlParameter("@qymc", SqlDbType.VarChar, 50),
new SqlParameter("@lsbh", SqlDbType.VarChar, 50),
new SqlParameter("@ddbh", SqlDbType.VarChar, 50),
new SqlParameter("@is_top", SqlDbType.Bit, 1),
new SqlParameter("@is_select", SqlDbType.Bit, 1),
new SqlParameter("@hykh", SqlDbType.VarChar, 50),
new SqlParameter("@hyrx", SqlDbType.VarChar, 50),
new SqlParameter("@krxm", SqlDbType.VarChar, 50),
new SqlParameter("@tlkr", SqlDbType.VarChar, 50),
new SqlParameter("@krgj", SqlDbType.VarChar, 50),
new SqlParameter("@krmz", SqlDbType.VarChar, 50),
new SqlParameter("@yxzj", SqlDbType.VarChar, 50),
new SqlParameter("@zjhm", SqlDbType.VarChar, 50),
new SqlParameter("@krxb", SqlDbType.VarChar, 50),
new SqlParameter("@krsr", SqlDbType.DateTime),
new SqlParameter("@krdh", SqlDbType.VarChar, 50),
new SqlParameter("@krsj", SqlDbType.VarChar, 50),
new SqlParameter("@krEmail", SqlDbType.VarChar, 50),
new SqlParameter("@krdz", SqlDbType.VarChar, 500),
new SqlParameter("@krjg", SqlDbType.VarChar, 500),
new SqlParameter("@krdw", SqlDbType.VarChar, 500),
new SqlParameter("@krzy", SqlDbType.VarChar, 50),
new SqlParameter("@cxmd", SqlDbType.VarChar, 500),
new SqlParameter("@qzrx", SqlDbType.VarChar, 50),
new SqlParameter("@qzhm", SqlDbType.VarChar, 50),
new SqlParameter("@zjyxq", SqlDbType.DateTime),
new SqlParameter("@tlyxq", SqlDbType.DateTime),
new SqlParameter("@tjrq", SqlDbType.DateTime),
new SqlParameter("@lzka", SqlDbType.VarChar, 50),
new SqlParameter("@krly", SqlDbType.VarChar, 50),
new SqlParameter("@xyh", SqlDbType.VarChar, 50),
new SqlParameter("@xydw", SqlDbType.VarChar, 500),
new SqlParameter("@xsy", SqlDbType.VarChar, 50),
new SqlParameter("@ddrx", SqlDbType.VarChar, 50),
new SqlParameter("@ddwz", SqlDbType.VarChar, 50),
new SqlParameter("@ddyy", SqlDbType.VarChar, 200),
new SqlParameter("@zyzt", SqlDbType.VarChar, 50),
new SqlParameter("@krrx", SqlDbType.VarChar, 50),
new SqlParameter("@kr_children", SqlDbType.Int, 4),
new SqlParameter("@ddsj", SqlDbType.DateTime),
new SqlParameter("@lzts", SqlDbType.Int, 4),
new SqlParameter("@lksj", SqlDbType.DateTime),
new SqlParameter("@qtyq", SqlDbType.VarChar, 800),
new SqlParameter("@czy", SqlDbType.VarChar, 50),
new SqlParameter("@czsj", SqlDbType.DateTime),
new SqlParameter("@cznr", SqlDbType.VarChar, 50),
new SqlParameter("@shsc", SqlDbType.Bit, 1),
new SqlParameter("@sktt", SqlDbType.VarChar, 50),
new SqlParameter("@yddj", SqlDbType.VarChar, 50),
new SqlParameter("@ffshys", SqlDbType.Bit, 1),
new SqlParameter("@ffzf", SqlDbType.Bit, 1),
new SqlParameter("@main_sec", SqlDbType.VarChar, 50),
new SqlParameter("@sdcz", SqlDbType.Bit, 1),
new SqlParameter("@syzd", SqlDbType.VarChar, 50),
new SqlParameter("@vip_type", SqlDbType.VarChar, 100),
new SqlParameter("@tsyq", SqlDbType.VarChar, 800),
new SqlParameter("@ddly", SqlDbType.VarChar, 50),
new SqlParameter("@hykh_bz", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.yydh;
parameters[1].Value = model.qymc;
parameters[2].Value = model.lsbh;
parameters[3].Value = model.ddbh;
parameters[4].Value = model.is_top;
parameters[5].Value = model.is_select;
parameters[6].Value = model.hykh;
parameters[7].Value = model.hyrx;
parameters[8].Value = model.krxm;
parameters[9].Value = model.tlkr;
parameters[10].Value = model.krgj;
parameters[11].Value = model.krmz;
parameters[12].Value = model.yxzj;
parameters[13].Value = model.zjhm;
parameters[14].Value = model.krxb;
parameters[15].Value = model.krsr;
parameters[16].Value = model.krdh;
parameters[17].Value = model.krsj;
parameters[18].Value = model.krEmail;
parameters[19].Value = model.krdz;
parameters[20].Value = model.krjg;
parameters[21].Value = model.krdw;
parameters[22].Value = model.krzy;
parameters[23].Value = model.cxmd;
parameters[24].Value = model.qzrx;
parameters[25].Value = model.qzhm;
parameters[26].Value = model.zjyxq;
parameters[27].Value = model.tlyxq;
parameters[28].Value = model.tjrq;
parameters[29].Value = model.lzka;
parameters[30].Value = model.krly;
parameters[31].Value = model.xyh;
parameters[32].Value = model.xydw;
parameters[33].Value = model.xsy;
parameters[34].Value = model.ddrx;
parameters[35].Value = model.ddwz;
parameters[36].Value = model.ddyy;
parameters[37].Value = model.zyzt;
parameters[38].Value = model.krrx;
parameters[39].Value = model.kr_children;
parameters[40].Value = model.ddsj;
parameters[41].Value = model.lzts;
parameters[42].Value = model.lksj;
parameters[43].Value = model.qtyq;
parameters[44].Value = model.czy;
parameters[45].Value = model.czsj;
parameters[46].Value = model.cznr;
parameters[47].Value = model.shsc;
parameters[48].Value = model.sktt;
parameters[49].Value = model.yddj;
parameters[50].Value = model.ffshys;
parameters[51].Value = model.ffzf;
parameters[52].Value = model.main_sec;
parameters[53].Value = model.sdcz;
parameters[54].Value = model.syzd;
parameters[55].Value = model.vip_type;
parameters[56].Value = model.tsyq;
parameters[57].Value = model.ddly;
parameters[58].Value = model.hykh_bz;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
//平帐时用到的方法
public string Sjzmx_pz(string id, string yydh, string qymc, string id_app, string jzbh, string lsbh, string krxm, string fjrb, string fjbh, string sktt,
string xfrq, string xfsj, string czy, string xfdr, string xfrb, string xfxm, string xfbz, string xfzy, string xfje, string yh, string sjxfje, string xfsl,
string czy_bc, string czzt, string czsj, string syzd, string add_edit_delete, string xxzs, string fkfs)
{
string s = common_file.common_app.get_failure;
string xyh_temp = "";
string jzzt = "";
BLL.Sjzmx B_Sjzmx = new Hotel_app.BLL.Sjzmx();
Model.Sjzmx M_Sjzmx = new Hotel_app.Model.Sjzmx();
if (xxzs == common_file.common_app.xxzs_xxvalue)
{
}
if (xxzs == common_file.common_app.xxzs_zsvalue)
{
}
if (add_edit_delete == common_file.common_app.get_add)
{
//id,yydh,qymc,id_app,jzbh,,lsbh,krxm,fjrb,fjbh,sktt,
//xfrq,xfsj,czy,xfdr,xfrb,xfxm,xfbz,xfzy
//xfje,yh,sjxfje,xfsl,czy_bc,czzt,czsj,syzd,fkfs,add,xxzs,fkfs
M_Sjzmx.yydh = yydh;
M_Sjzmx.qymc = qymc;
M_Sjzmx.id_app = id_app;
M_Sjzmx.jzbh = jzbh;
M_Sjzmx.lsbh = lsbh;
M_Sjzmx.krxm = krxm;
M_Sjzmx.fjrb = fjrb;
M_Sjzmx.fjbh = fjbh;
M_Sjzmx.sktt = sktt;
M_Sjzmx.xfrq = Convert.ToDateTime(xfrq);
M_Sjzmx.xfsj = Convert.ToDateTime(xfsj);
M_Sjzmx.czy = czy;
M_Sjzmx.xfdr = xfdr;
M_Sjzmx.xfrb = xfrb;
M_Sjzmx.xfxm = xfxm;
M_Sjzmx.xfbz = xfbz;
M_Sjzmx.xfzy = xfzy;
M_Sjzmx.xfje = Convert.ToDecimal(xfje);
M_Sjzmx.yh = yh;
M_Sjzmx.sjxfje = Convert.ToDecimal(sjxfje);
M_Sjzmx.xfsl = Convert.ToDecimal(xfsl);
M_Sjzmx.czy_bc = czy_bc;
M_Sjzmx.czzt = czzt;
M_Sjzmx.czsj = Convert.ToDateTime(czsj);
M_Sjzmx.syzd = syzd;
M_Sjzmx.fkfs = fkfs;
if (czzt == common_jzzt.czzt_sz)//结帐(结帐是直接从主单里面读）
{
if (sktt == "sk")
{
M_Qskyd_mainrecord = B_Qskyd_mainrecord.GetModelList("id>0 and yydh='" + yydh + "' and lsbh='" + lsbh + "'")[0];
xyh_temp = M_Qskyd_mainrecord.xyh;//直接读出协议号
jzzt = M_Qskyd_mainrecord.krxm;
}
if (sktt == "tt")
{
{
M_Qttyd_mainrecord = B_Qttyd_mainrecord.GetModelList("id>0 and yydh='" + yydh + "' and lsbh='" + lsbh + "'")[0];
xyh_temp = M_Qttyd_mainrecord.xyh;//直接读出协议号
jzzt = M_Qttyd_mainrecord.krxm;
}
}
}
else if (czzt == common_jzzt.czzt_gz || czzt == common_jzzt.czzt_jz)
{
object obj = DbHelperSQL.GetSingle("SELECT xyh from Sjzzd where id>0 and yydh='" + yydh + "' and jzbh='" + jzbh + "'");
if (obj != null)
{
xyh_temp = obj.ToString();
}
else
{
xyh_temp = "";
}
obj = DbHelperSQL.GetSingle("SELECT jzzt from Sjzzd where id>0 and yydh='" + yydh + "' and jzbh='" + jzbh + "'");
if (obj != null)
{
jzzt = obj.ToString();
}
else
{
jzzt = "";
}
}
M_Sjzmx.xyh = xyh_temp;
M_Sjzmx.jzzt = jzzt;
if (B_Sjzmx.Add(M_Sjzmx) > 0)
{
if (czzt == common_jzzt.czzt_gz || czzt == common_jzzt.czzt_jz)//写入付款方式设置
{
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,id_app)");
strSql.Append(" select yydh,qymc,jzbh,'" + jzzt + "',lsbh,fjbh,krxm,fkfs,xfdr,xfrb,xfxm,-xfje,-sjxfje,xfrq,xfsj,xfrq,xfsj,czy,'" + czy_bc + "','" + syzd + "',id_app from sjzmx");
strSql.Append(" where yydh='" + yydh + "' and id_app='" + id_app + "'");
B_common.ExecuteSql(strSql.ToString());
}
s = common_file.common_app.get_suc;
}
}
if (add_edit_delete == common_file.common_app.get_delete)
{
if (id != "")
{
B_Sjzmx.Delete(Convert.ToInt32(id));
s = common_file.common_app.get_suc;
}
}
return(s);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Hotel_app.Model.Qskyd_mainrecord GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,yydh,qymc,lsbh,ddbh,is_top,is_select,hykh,hyrx,krxm,tlkr,krgj,krmz,yxzj,zjhm,krxb,krsr,krdh,krsj,krEmail,krdz,krjg,krdw,krzy,cxmd,qzrx,qzhm,zjyxq,tlyxq,tjrq,lzka,krly,xyh,xydw,xsy,ddrx,ddwz,ddyy,zyzt,krrx,kr_children,ddsj,lzts,lksj,qtyq,czy,czsj,cznr,shsc,sktt,yddj,ffshys,ffzf,main_sec,sdcz,syzd,vip_type,tsyq,ddly,hykh_bz from Qskyd_mainrecord ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Hotel_app.Model.Qskyd_mainrecord model = new Hotel_app.Model.Qskyd_mainrecord();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
if (ds.Tables[0].Rows[0]["yydh"] != null && ds.Tables[0].Rows[0]["yydh"].ToString() != "")
{
model.yydh = ds.Tables[0].Rows[0]["yydh"].ToString();
}
if (ds.Tables[0].Rows[0]["qymc"] != null && ds.Tables[0].Rows[0]["qymc"].ToString() != "")
{
model.qymc = ds.Tables[0].Rows[0]["qymc"].ToString();
}
if (ds.Tables[0].Rows[0]["lsbh"] != null && ds.Tables[0].Rows[0]["lsbh"].ToString() != "")
{
model.lsbh = ds.Tables[0].Rows[0]["lsbh"].ToString();
}
if (ds.Tables[0].Rows[0]["ddbh"] != null && ds.Tables[0].Rows[0]["ddbh"].ToString() != "")
{
model.ddbh = ds.Tables[0].Rows[0]["ddbh"].ToString();
}
if (ds.Tables[0].Rows[0]["is_top"] != null && ds.Tables[0].Rows[0]["is_top"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["is_top"].ToString() == "1") || (ds.Tables[0].Rows[0]["is_top"].ToString().ToLower() == "true"))
{
model.is_top = true;
}
else
{
model.is_top = false;
}
}
if (ds.Tables[0].Rows[0]["is_select"] != null && ds.Tables[0].Rows[0]["is_select"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["is_select"].ToString() == "1") || (ds.Tables[0].Rows[0]["is_select"].ToString().ToLower() == "true"))
{
model.is_select = true;
}
else
{
model.is_select = false;
}
}
if (ds.Tables[0].Rows[0]["hykh"] != null && ds.Tables[0].Rows[0]["hykh"].ToString() != "")
{
model.hykh = ds.Tables[0].Rows[0]["hykh"].ToString();
}
if (ds.Tables[0].Rows[0]["hyrx"] != null && ds.Tables[0].Rows[0]["hyrx"].ToString() != "")
{
model.hyrx = ds.Tables[0].Rows[0]["hyrx"].ToString();
}
if (ds.Tables[0].Rows[0]["krxm"] != null && ds.Tables[0].Rows[0]["krxm"].ToString() != "")
{
model.krxm = ds.Tables[0].Rows[0]["krxm"].ToString();
}
if (ds.Tables[0].Rows[0]["tlkr"] != null && ds.Tables[0].Rows[0]["tlkr"].ToString() != "")
{
model.tlkr = ds.Tables[0].Rows[0]["tlkr"].ToString();
}
if (ds.Tables[0].Rows[0]["krgj"] != null && ds.Tables[0].Rows[0]["krgj"].ToString() != "")
{
model.krgj = ds.Tables[0].Rows[0]["krgj"].ToString();
}
if (ds.Tables[0].Rows[0]["krmz"] != null && ds.Tables[0].Rows[0]["krmz"].ToString() != "")
{
model.krmz = ds.Tables[0].Rows[0]["krmz"].ToString();
}
if (ds.Tables[0].Rows[0]["yxzj"] != null && ds.Tables[0].Rows[0]["yxzj"].ToString() != "")
{
model.yxzj = ds.Tables[0].Rows[0]["yxzj"].ToString();
}
if (ds.Tables[0].Rows[0]["zjhm"] != null && ds.Tables[0].Rows[0]["zjhm"].ToString() != "")
{
model.zjhm = ds.Tables[0].Rows[0]["zjhm"].ToString();
}
if (ds.Tables[0].Rows[0]["krxb"] != null && ds.Tables[0].Rows[0]["krxb"].ToString() != "")
{
model.krxb = ds.Tables[0].Rows[0]["krxb"].ToString();
}
if (ds.Tables[0].Rows[0]["krsr"] != null && ds.Tables[0].Rows[0]["krsr"].ToString() != "")
{
model.krsr = DateTime.Parse(ds.Tables[0].Rows[0]["krsr"].ToString());
}
if (ds.Tables[0].Rows[0]["krdh"] != null && ds.Tables[0].Rows[0]["krdh"].ToString() != "")
{
model.krdh = ds.Tables[0].Rows[0]["krdh"].ToString();
}
if (ds.Tables[0].Rows[0]["krsj"] != null && ds.Tables[0].Rows[0]["krsj"].ToString() != "")
{
model.krsj = ds.Tables[0].Rows[0]["krsj"].ToString();
}
if (ds.Tables[0].Rows[0]["krEmail"] != null && ds.Tables[0].Rows[0]["krEmail"].ToString() != "")
{
model.krEmail = ds.Tables[0].Rows[0]["krEmail"].ToString();
}
if (ds.Tables[0].Rows[0]["krdz"] != null && ds.Tables[0].Rows[0]["krdz"].ToString() != "")
{
model.krdz = ds.Tables[0].Rows[0]["krdz"].ToString();
}
if (ds.Tables[0].Rows[0]["krjg"] != null && ds.Tables[0].Rows[0]["krjg"].ToString() != "")
{
model.krjg = ds.Tables[0].Rows[0]["krjg"].ToString();
}
if (ds.Tables[0].Rows[0]["krdw"] != null && ds.Tables[0].Rows[0]["krdw"].ToString() != "")
{
model.krdw = ds.Tables[0].Rows[0]["krdw"].ToString();
}
if (ds.Tables[0].Rows[0]["krzy"] != null && ds.Tables[0].Rows[0]["krzy"].ToString() != "")
{
model.krzy = ds.Tables[0].Rows[0]["krzy"].ToString();
}
if (ds.Tables[0].Rows[0]["cxmd"] != null && ds.Tables[0].Rows[0]["cxmd"].ToString() != "")
{
model.cxmd = ds.Tables[0].Rows[0]["cxmd"].ToString();
}
if (ds.Tables[0].Rows[0]["qzrx"] != null && ds.Tables[0].Rows[0]["qzrx"].ToString() != "")
{
model.qzrx = ds.Tables[0].Rows[0]["qzrx"].ToString();
}
if (ds.Tables[0].Rows[0]["qzhm"] != null && ds.Tables[0].Rows[0]["qzhm"].ToString() != "")
{
model.qzhm = ds.Tables[0].Rows[0]["qzhm"].ToString();
}
if (ds.Tables[0].Rows[0]["zjyxq"] != null && ds.Tables[0].Rows[0]["zjyxq"].ToString() != "")
{
model.zjyxq = DateTime.Parse(ds.Tables[0].Rows[0]["zjyxq"].ToString());
}
if (ds.Tables[0].Rows[0]["tlyxq"] != null && ds.Tables[0].Rows[0]["tlyxq"].ToString() != "")
{
model.tlyxq = DateTime.Parse(ds.Tables[0].Rows[0]["tlyxq"].ToString());
}
if (ds.Tables[0].Rows[0]["tjrq"] != null && ds.Tables[0].Rows[0]["tjrq"].ToString() != "")
{
model.tjrq = DateTime.Parse(ds.Tables[0].Rows[0]["tjrq"].ToString());
}
if (ds.Tables[0].Rows[0]["lzka"] != null && ds.Tables[0].Rows[0]["lzka"].ToString() != "")
{
model.lzka = ds.Tables[0].Rows[0]["lzka"].ToString();
}
if (ds.Tables[0].Rows[0]["krly"] != null && ds.Tables[0].Rows[0]["krly"].ToString() != "")
{
model.krly = ds.Tables[0].Rows[0]["krly"].ToString();
}
if (ds.Tables[0].Rows[0]["xyh"] != null && ds.Tables[0].Rows[0]["xyh"].ToString() != "")
{
model.xyh = ds.Tables[0].Rows[0]["xyh"].ToString();
}
if (ds.Tables[0].Rows[0]["xydw"] != null && ds.Tables[0].Rows[0]["xydw"].ToString() != "")
{
model.xydw = ds.Tables[0].Rows[0]["xydw"].ToString();
}
if (ds.Tables[0].Rows[0]["xsy"] != null && ds.Tables[0].Rows[0]["xsy"].ToString() != "")
{
model.xsy = ds.Tables[0].Rows[0]["xsy"].ToString();
}
if (ds.Tables[0].Rows[0]["ddrx"] != null && ds.Tables[0].Rows[0]["ddrx"].ToString() != "")
{
model.ddrx = ds.Tables[0].Rows[0]["ddrx"].ToString();
}
if (ds.Tables[0].Rows[0]["ddwz"] != null && ds.Tables[0].Rows[0]["ddwz"].ToString() != "")
{
model.ddwz = ds.Tables[0].Rows[0]["ddwz"].ToString();
}
if (ds.Tables[0].Rows[0]["ddyy"] != null && ds.Tables[0].Rows[0]["ddyy"].ToString() != "")
{
model.ddyy = ds.Tables[0].Rows[0]["ddyy"].ToString();
}
if (ds.Tables[0].Rows[0]["zyzt"] != null && ds.Tables[0].Rows[0]["zyzt"].ToString() != "")
{
model.zyzt = ds.Tables[0].Rows[0]["zyzt"].ToString();
}
if (ds.Tables[0].Rows[0]["krrx"] != null && ds.Tables[0].Rows[0]["krrx"].ToString() != "")
{
model.krrx = ds.Tables[0].Rows[0]["krrx"].ToString();
}
if (ds.Tables[0].Rows[0]["kr_children"] != null && ds.Tables[0].Rows[0]["kr_children"].ToString() != "")
{
model.kr_children = int.Parse(ds.Tables[0].Rows[0]["kr_children"].ToString());
}
if (ds.Tables[0].Rows[0]["ddsj"] != null && ds.Tables[0].Rows[0]["ddsj"].ToString() != "")
{
model.ddsj = DateTime.Parse(ds.Tables[0].Rows[0]["ddsj"].ToString());
}
if (ds.Tables[0].Rows[0]["lzts"] != null && ds.Tables[0].Rows[0]["lzts"].ToString() != "")
{
model.lzts = int.Parse(ds.Tables[0].Rows[0]["lzts"].ToString());
}
if (ds.Tables[0].Rows[0]["lksj"] != null && ds.Tables[0].Rows[0]["lksj"].ToString() != "")
{
model.lksj = DateTime.Parse(ds.Tables[0].Rows[0]["lksj"].ToString());
}
if (ds.Tables[0].Rows[0]["qtyq"] != null && ds.Tables[0].Rows[0]["qtyq"].ToString() != "")
{
model.qtyq = ds.Tables[0].Rows[0]["qtyq"].ToString();
}
if (ds.Tables[0].Rows[0]["czy"] != null && ds.Tables[0].Rows[0]["czy"].ToString() != "")
{
model.czy = ds.Tables[0].Rows[0]["czy"].ToString();
}
if (ds.Tables[0].Rows[0]["czsj"] != null && ds.Tables[0].Rows[0]["czsj"].ToString() != "")
{
model.czsj = DateTime.Parse(ds.Tables[0].Rows[0]["czsj"].ToString());
}
if (ds.Tables[0].Rows[0]["cznr"] != null && ds.Tables[0].Rows[0]["cznr"].ToString() != "")
{
model.cznr = ds.Tables[0].Rows[0]["cznr"].ToString();
}
if (ds.Tables[0].Rows[0]["shsc"] != null && ds.Tables[0].Rows[0]["shsc"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["shsc"].ToString() == "1") || (ds.Tables[0].Rows[0]["shsc"].ToString().ToLower() == "true"))
{
model.shsc = true;
}
else
{
model.shsc = false;
}
}
if (ds.Tables[0].Rows[0]["sktt"] != null && ds.Tables[0].Rows[0]["sktt"].ToString() != "")
{
model.sktt = ds.Tables[0].Rows[0]["sktt"].ToString();
}
if (ds.Tables[0].Rows[0]["yddj"] != null && ds.Tables[0].Rows[0]["yddj"].ToString() != "")
{
model.yddj = ds.Tables[0].Rows[0]["yddj"].ToString();
}
if (ds.Tables[0].Rows[0]["ffshys"] != null && ds.Tables[0].Rows[0]["ffshys"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["ffshys"].ToString() == "1") || (ds.Tables[0].Rows[0]["ffshys"].ToString().ToLower() == "true"))
{
model.ffshys = true;
}
else
{
model.ffshys = false;
}
}
if (ds.Tables[0].Rows[0]["ffzf"] != null && ds.Tables[0].Rows[0]["ffzf"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["ffzf"].ToString() == "1") || (ds.Tables[0].Rows[0]["ffzf"].ToString().ToLower() == "true"))
{
model.ffzf = true;
}
else
{
model.ffzf = false;
}
}
if (ds.Tables[0].Rows[0]["main_sec"] != null && ds.Tables[0].Rows[0]["main_sec"].ToString() != "")
{
model.main_sec = ds.Tables[0].Rows[0]["main_sec"].ToString();
}
if (ds.Tables[0].Rows[0]["sdcz"] != null && ds.Tables[0].Rows[0]["sdcz"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["sdcz"].ToString() == "1") || (ds.Tables[0].Rows[0]["sdcz"].ToString().ToLower() == "true"))
{
model.sdcz = true;
}
else
{
model.sdcz = false;
}
}
if (ds.Tables[0].Rows[0]["syzd"] != null && ds.Tables[0].Rows[0]["syzd"].ToString() != "")
{
model.syzd = ds.Tables[0].Rows[0]["syzd"].ToString();
}
if (ds.Tables[0].Rows[0]["vip_type"] != null && ds.Tables[0].Rows[0]["vip_type"].ToString() != "")
{
model.vip_type = ds.Tables[0].Rows[0]["vip_type"].ToString();
}
if (ds.Tables[0].Rows[0]["tsyq"] != null && ds.Tables[0].Rows[0]["tsyq"].ToString() != "")
{
model.tsyq = ds.Tables[0].Rows[0]["tsyq"].ToString();
}
if (ds.Tables[0].Rows[0]["ddly"] != null && ds.Tables[0].Rows[0]["ddly"].ToString() != "")
{
model.ddly = ds.Tables[0].Rows[0]["ddly"].ToString();
}
if (ds.Tables[0].Rows[0]["hykh_bz"] != null && ds.Tables[0].Rows[0]["hykh_bz"].ToString() != "")
{
model.hykh_bz = ds.Tables[0].Rows[0]["hykh_bz"].ToString();
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Hotel_app.Model.Qskyd_mainrecord model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Qskyd_mainrecord set ");
strSql.Append("yydh=@yydh,");
strSql.Append("qymc=@qymc,");
strSql.Append("lsbh=@lsbh,");
strSql.Append("ddbh=@ddbh,");
strSql.Append("is_top=@is_top,");
strSql.Append("is_select=@is_select,");
strSql.Append("hykh=@hykh,");
strSql.Append("hyrx=@hyrx,");
strSql.Append("krxm=@krxm,");
strSql.Append("tlkr=@tlkr,");
strSql.Append("krgj=@krgj,");
strSql.Append("krmz=@krmz,");
strSql.Append("yxzj=@yxzj,");
strSql.Append("zjhm=@zjhm,");
strSql.Append("krxb=@krxb,");
strSql.Append("krsr=@krsr,");
strSql.Append("krdh=@krdh,");
strSql.Append("krsj=@krsj,");
strSql.Append("krEmail=@krEmail,");
strSql.Append("krdz=@krdz,");
strSql.Append("krjg=@krjg,");
strSql.Append("krdw=@krdw,");
strSql.Append("krzy=@krzy,");
strSql.Append("cxmd=@cxmd,");
strSql.Append("qzrx=@qzrx,");
strSql.Append("qzhm=@qzhm,");
strSql.Append("zjyxq=@zjyxq,");
strSql.Append("tlyxq=@tlyxq,");
strSql.Append("tjrq=@tjrq,");
strSql.Append("lzka=@lzka,");
strSql.Append("krly=@krly,");
strSql.Append("xyh=@xyh,");
strSql.Append("xydw=@xydw,");
strSql.Append("xsy=@xsy,");
strSql.Append("ddrx=@ddrx,");
strSql.Append("ddwz=@ddwz,");
strSql.Append("ddyy=@ddyy,");
strSql.Append("zyzt=@zyzt,");
strSql.Append("krrx=@krrx,");
strSql.Append("kr_children=@kr_children,");
strSql.Append("ddsj=@ddsj,");
strSql.Append("lzts=@lzts,");
strSql.Append("lksj=@lksj,");
strSql.Append("qtyq=@qtyq,");
strSql.Append("czy=@czy,");
strSql.Append("czsj=@czsj,");
strSql.Append("cznr=@cznr,");
strSql.Append("shsc=@shsc,");
strSql.Append("sktt=@sktt,");
strSql.Append("yddj=@yddj,");
strSql.Append("ffshys=@ffshys,");
strSql.Append("ffzf=@ffzf,");
strSql.Append("main_sec=@main_sec,");
strSql.Append("sdcz=@sdcz,");
strSql.Append("syzd=@syzd,");
strSql.Append("vip_type=@vip_type,");
strSql.Append("tsyq=@tsyq,");
strSql.Append("ddly=@ddly,");
strSql.Append("hykh_bz=@hykh_bz");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@yydh", SqlDbType.VarChar, 50),
new SqlParameter("@qymc", SqlDbType.VarChar, 50),
new SqlParameter("@lsbh", SqlDbType.VarChar, 50),
new SqlParameter("@ddbh", SqlDbType.VarChar, 50),
new SqlParameter("@is_top", SqlDbType.Bit, 1),
new SqlParameter("@is_select", SqlDbType.Bit, 1),
new SqlParameter("@hykh", SqlDbType.VarChar, 50),
new SqlParameter("@hyrx", SqlDbType.VarChar, 50),
new SqlParameter("@krxm", SqlDbType.VarChar, 50),
new SqlParameter("@tlkr", SqlDbType.VarChar, 50),
new SqlParameter("@krgj", SqlDbType.VarChar, 50),
new SqlParameter("@krmz", SqlDbType.VarChar, 50),
new SqlParameter("@yxzj", SqlDbType.VarChar, 50),
new SqlParameter("@zjhm", SqlDbType.VarChar, 50),
new SqlParameter("@krxb", SqlDbType.VarChar, 50),
new SqlParameter("@krsr", SqlDbType.DateTime),
new SqlParameter("@krdh", SqlDbType.VarChar, 50),
new SqlParameter("@krsj", SqlDbType.VarChar, 50),
new SqlParameter("@krEmail", SqlDbType.VarChar, 50),
new SqlParameter("@krdz", SqlDbType.VarChar, 500),
new SqlParameter("@krjg", SqlDbType.VarChar, 500),
new SqlParameter("@krdw", SqlDbType.VarChar, 500),
new SqlParameter("@krzy", SqlDbType.VarChar, 50),
new SqlParameter("@cxmd", SqlDbType.VarChar, 500),
new SqlParameter("@qzrx", SqlDbType.VarChar, 50),
new SqlParameter("@qzhm", SqlDbType.VarChar, 50),
new SqlParameter("@zjyxq", SqlDbType.DateTime),
new SqlParameter("@tlyxq", SqlDbType.DateTime),
new SqlParameter("@tjrq", SqlDbType.DateTime),
new SqlParameter("@lzka", SqlDbType.VarChar, 50),
new SqlParameter("@krly", SqlDbType.VarChar, 50),
new SqlParameter("@xyh", SqlDbType.VarChar, 50),
new SqlParameter("@xydw", SqlDbType.VarChar, 500),
new SqlParameter("@xsy", SqlDbType.VarChar, 50),
new SqlParameter("@ddrx", SqlDbType.VarChar, 50),
new SqlParameter("@ddwz", SqlDbType.VarChar, 50),
new SqlParameter("@ddyy", SqlDbType.VarChar, 200),
new SqlParameter("@zyzt", SqlDbType.VarChar, 50),
new SqlParameter("@krrx", SqlDbType.VarChar, 50),
new SqlParameter("@kr_children", SqlDbType.Int, 4),
new SqlParameter("@ddsj", SqlDbType.DateTime),
new SqlParameter("@lzts", SqlDbType.Int, 4),
new SqlParameter("@lksj", SqlDbType.DateTime),
new SqlParameter("@qtyq", SqlDbType.VarChar, 800),
new SqlParameter("@czy", SqlDbType.VarChar, 50),
new SqlParameter("@czsj", SqlDbType.DateTime),
new SqlParameter("@cznr", SqlDbType.VarChar, 50),
new SqlParameter("@shsc", SqlDbType.Bit, 1),
new SqlParameter("@sktt", SqlDbType.VarChar, 50),
new SqlParameter("@yddj", SqlDbType.VarChar, 50),
new SqlParameter("@ffshys", SqlDbType.Bit, 1),
new SqlParameter("@ffzf", SqlDbType.Bit, 1),
new SqlParameter("@main_sec", SqlDbType.VarChar, 50),
new SqlParameter("@sdcz", SqlDbType.Bit, 1),
new SqlParameter("@syzd", SqlDbType.VarChar, 50),
new SqlParameter("@vip_type", SqlDbType.VarChar, 100),
new SqlParameter("@tsyq", SqlDbType.VarChar, 800),
new SqlParameter("@ddly", SqlDbType.VarChar, 50),
new SqlParameter("@hykh_bz", SqlDbType.VarChar, 50),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.yydh;
parameters[1].Value = model.qymc;
parameters[2].Value = model.lsbh;
parameters[3].Value = model.ddbh;
parameters[4].Value = model.is_top;
parameters[5].Value = model.is_select;
parameters[6].Value = model.hykh;
parameters[7].Value = model.hyrx;
parameters[8].Value = model.krxm;
parameters[9].Value = model.tlkr;
parameters[10].Value = model.krgj;
parameters[11].Value = model.krmz;
parameters[12].Value = model.yxzj;
parameters[13].Value = model.zjhm;
parameters[14].Value = model.krxb;
parameters[15].Value = model.krsr;
parameters[16].Value = model.krdh;
parameters[17].Value = model.krsj;
parameters[18].Value = model.krEmail;
parameters[19].Value = model.krdz;
parameters[20].Value = model.krjg;
parameters[21].Value = model.krdw;
parameters[22].Value = model.krzy;
parameters[23].Value = model.cxmd;
parameters[24].Value = model.qzrx;
parameters[25].Value = model.qzhm;
parameters[26].Value = model.zjyxq;
parameters[27].Value = model.tlyxq;
parameters[28].Value = model.tjrq;
parameters[29].Value = model.lzka;
parameters[30].Value = model.krly;
parameters[31].Value = model.xyh;
parameters[32].Value = model.xydw;
parameters[33].Value = model.xsy;
parameters[34].Value = model.ddrx;
parameters[35].Value = model.ddwz;
parameters[36].Value = model.ddyy;
parameters[37].Value = model.zyzt;
parameters[38].Value = model.krrx;
parameters[39].Value = model.kr_children;
parameters[40].Value = model.ddsj;
parameters[41].Value = model.lzts;
parameters[42].Value = model.lksj;
parameters[43].Value = model.qtyq;
parameters[44].Value = model.czy;
parameters[45].Value = model.czsj;
parameters[46].Value = model.cznr;
parameters[47].Value = model.shsc;
parameters[48].Value = model.sktt;
parameters[49].Value = model.yddj;
parameters[50].Value = model.ffshys;
parameters[51].Value = model.ffzf;
parameters[52].Value = model.main_sec;
parameters[53].Value = model.sdcz;
parameters[54].Value = model.syzd;
parameters[55].Value = model.vip_type;
parameters[56].Value = model.tsyq;
parameters[57].Value = model.ddly;
parameters[58].Value = model.hykh_bz;
parameters[59].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
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 string GetJzResult(string lsbh, string jzbh, string yydh, string jzzt, string syzd, string czy_bc, string czzt, string sk_tt, string czy, string czsj, string hhykh_bz, string phoneNo, string czy_GUID)
{
string s = common_app.get_failure;
//记帐，挂帐，结帐的处理节
if (czzt == common_file.common_jzzt.czzt_sz)//算帐
{
strSql = new StringBuilder();
strSql.Append(" insert into Sfkfssz(yydh,qymc,is_top,is_select,jzbh,jzzt,lsbh,fjbh,krxm,fkfs,xfdr,xfrb,xfxm,xfje,sjxfje,xfrq,xfsj,czrq,czsj,czy,czy_bc,syzd,id_app)");
strSql.Append(" select yydh,qymc,0,0,jzbh,'" + jzzt + "',lsbh,fjbh,krxm,fkfs,xfdr,xfrb,xfxm,-xfje,-sjxfje,xfrq,xfsj,'" + DateTime.Parse(czsj).ToShortDateString() + "','" + czsj + "','" + czy + "','" + czy_bc + "','" + syzd + "',id_app from Szw_temp where jzbh='" + jzbh + "' and xfdr='" + common_app.fkdr + "'");
B_common.ExecuteSql(strSql.ToString());
strSql = new StringBuilder();
strSql.Append("delete from Syjcz where id>0 " + common_app.yydh_select + " and id_app in (select id_app from Szw_temp where czy_temp='" + czy_GUID + "')");
B_common.ExecuteSql(strSql.ToString());
strSql = new StringBuilder();
strSql.Append("delete from Szwmx where id>=0 " + common_file.common_app.yydh_select + " and jzbh<>'' and jzbh='" + jzbh + "'");
B_common.ExecuteSql(strSql.ToString());
}
if (czzt == common_jzzt.czzt_gz || czzt == common_jzzt.czzt_jz || czzt == common_file.common_jzzt.czzt_sz)
{
//调用修改房态的方法(第五步)
if (sk_tt == "sk")
{
//DataSet ds_temp0 = B_common.GetList(" select distinct lsbh from Szw_temp", " czy='" + czy + "' and yydh='" + yydh + "'");
DataSet ds_temp0 = B_common.GetList(" select * from Flfsz ", " id>=0 and yydh='" + common_file.common_app.yydh + "' and lfbh in (select lfbh from Flfsz where lsbh='" + lsbh + "' and yydh='" + common_file.common_app.yydh + "' and shlz='1' ) and shlz=1 ");
// B_common.GetList("select distinct lsbh from Flfsz", " lfbh in (select lfbh From Flfsz where lsbh='" + lsbh + "' ) and shlz=1 and yydh='" + yydh + "'");
if (ds_temp0 != null && ds_temp0.Tables[0].Rows.Count > 0)
{
}
else
{
ds_temp0 = B_common.GetList("select distinct lsbh from Qskyd_mainrecord", " lsbh='" + lsbh + "' and yydh='" + yydh + "'");
}
if (ds_temp0 != null && ds_temp0.Tables[0].Rows.Count > 0)
{
s = common_app.get_failure;
for (int j = 0; j < ds_temp0.Tables[0].Rows.Count; j++)
{
string lsbh_0 = ds_temp0.Tables[0].Rows[j]["lsbh"].ToString();
M_Qskyd_mainrecord = B_Qskyd_mainrecord.GetModelList("id>0 " + common_app.yydh_select + " and lsbh='" + lsbh_0 + "'")[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)
if (Qyddj_add_edit_delete_new.delete_sz_xgft(id, "jz", czzt, "", jzbh, czy, czsj, xxzs) == common_app.get_suc)
{
s = common_app.get_suc;
}
}
}
else
{
//M_Qskyd_mainrecord = B_Qskyd_mainrecord.GetModelList("id>0 " + common_app.yydh_select + " and lsbh='" + lsbh + "'")[0];
DataSet ds_1 = B_common.GetList(" select * from Qskyd_mainrecord ", "id>0 " + common_app.yydh_select + " and lsbh='" + lsbh + "' and main_sec='" + common_file.common_app.main_sec_main + "'");
//M_Qskyd_mainrecord = B_Qskyd_mainrecord.GetModelList("id>0 " + common_app.yydh_select + " and lsbh='" + lsbh + "'")[0];
if (ds_1 != null && ds_1.Tables[0].Rows.Count > 0)
{//M_Qskyd_mainrecord.id.ToString();
//删除主单记录（这里有包含主单记录删除时的备份
id = ds_1.Tables[0].Rows[0]["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)
if (Qyddj_add_edit_delete_new.delete_sz_xgft(id, "jz", czzt, "", jzbh, czy, czsj, xxzs) == common_app.get_suc)
{
s = common_app.get_suc;
}
}
}
}
else//是团体
{
DataSet ds_1 = B_common.GetList(" select * from Qttyd_mainrecord ", "id>0 " + common_app.yydh_select + " and lsbh='" + lsbh + "' ");
if (ds_1 != null && ds_1.Tables[0].Rows.Count > 0)
{
//M_Qttyd_mainrecord = B_Qttyd_mainrecord.GetModelList("ID>0 " + common_app.yydh_select + " AND LSBH='" + lsbh + "'")[0];
string tt_id = ds_1.Tables[0].Rows[0]["id"].ToString();// M_Qttyd_mainrecord.id.ToString();
//要成批更新团体所有成员的房态，并删除成员主单
//string ddbh_temp = M_Qttyd_mainrecord.ddbh;
// if (Qttyd_add_edit_delete_new.delete_sz_ttyd(tt_id, "jz", common_file.common_jzzt.czzt_sz, "", jzbh, czy, czsj, xxzs) == common_file.common_app.get_suc)
if (Qttyd_add_edit_delete_new.delete_sz_ttyd(tt_id, "jz", czzt, "", jzbh, czy, czsj, xxzs) == common_file.common_app.get_suc)
{
s = common_file.common_app.get_suc;
}
}
}
if (s == common_app.get_suc)
{
//备份到Szw_temp_bak，清除Szw_temp，并且更新bak表里面的tfsj为当前的操作时间
strSql = new StringBuilder();
strSql.Append(" insert into Szw_temp_bak(yydh,qymc,is_top,is_select,id_app,jzbh,lsbh,krxm,fjrb,fjbh,sktt,xfrq,xfsj,czy,xfdr,xfrb,xfxm,xfbz,xfzy,fkfs,jjje,xfje,yh,sjxfje,xfsl,shsc,mxbh,czsj,czy_temp)");
strSql.Append(" select yydh,qymc,is_top,is_select,id_app,jzbh,lsbh,krxm,fjrb,fjbh,sktt,xfrq,xfsj,czy,xfdr,xfrb,xfxm,xfbz,xfzy,fkfs,jjje,xfje,yh,sjxfje,xfsl,shsc,mxbh,czsj,czy_temp from Szw_temp");
strSql.Append(" where czy_temp='" + czy_GUID + "' and xfxm!='" + common_app.dj_pzsk + "'");
B_common.ExecuteSql(strSql.ToString());
strSql = new StringBuilder();
strSql.Append("delete from Szw_temp where id>0 and czy_temp='" + czy_GUID + "'");
if (B_common.ExecuteSql(strSql.ToString()) >= 0) //清除Szw_temp里面的数据了
//修改备份表的tfsj
{
if (sk_tt == "sk")
{
B_common.ExecuteSql(" update Qskyd_mainrecord_bak set czsj='" + czsj + "' where jzbh='" + jzbh + "'");
B_common.ExecuteSql(" update Qskyd_mainrecord_lskr set czsj='" + czsj + "' where jzbh='" + jzbh + "'");
//B_common.ExecuteSql(" update Qskyd_mainrecord_temp set lksj='" + czsj + "' where lsbh='" + lsbh + "'");
}
}
if (sk_tt == "tt")
{
string bak_ddbh_temp = DbHelperSQL.GetSingle(" Select ddbh from Qttyd_mainrecord_bak where lsbh='" + lsbh + "' and jzbh='" + jzbh + "'").ToString();
string bak_jzbh_temp = DbHelperSQL.GetSingle(" select jzbh from Qttyd_mainrecord_bak where lsbh='" + lsbh + "' and jzbh='" + jzbh + "'").ToString();
B_common.ExecuteSql(" update Qttyd_mainrecord_bak set czsj='" + czsj + "' where lsbh='" + lsbh + "' and jzbh='" + jzbh + "'");
B_common.ExecuteSql(" update Qskyd_mainrecord_bak set czsj='" + czsj + "' where ddbh='" + bak_ddbh_temp + "' and jzbh='" + bak_jzbh_temp + "'");
B_common.ExecuteSql(" update Qskyd_mainrecord_lskr set czsj='" + czsj + "' where ddbh='" + bak_ddbh_temp + "' and jzbh='" + bak_jzbh_temp + "'");
B_common.ExecuteSql(" update Qskyd_mainrecord_temp set czsj='" + czsj + "' where ddbh='" + bak_ddbh_temp + "'");
}
}
//结帐成功后,更新会员的积分(挂-结，记-结，部分结，结帐都要加积分
DataSet ds_temp_2;
if (sk_tt == "sk")
{
ds_temp_2 = B_common.GetList("select jzbh,lsbh,hykh,hykh_bz,krsj,xyh,xydw from Qskyd_mainrecord_bak", " id>=0 and jzbh='" + jzbh + "'");
if (ds_temp_2 != null && ds_temp_2.Tables[0].Rows.Count > 0)
{
for (int i_0 = 0; i_0 < ds_temp_2.Tables[0].Rows.Count; i_0++)
{
//有用到的时候才启用
//IncHYScore(ds_temp_2.Tables[0].Rows[i_0]["jzbh"].ToString(), ds_temp_2.Tables[0].Rows[i_0]["lsbh"].ToString(), sk_tt, ds_temp_2.Tables[0].Rows[i_0]["hykh_bz"].ToString(), yydh, qymc,ds_temp_2.Tables[0].Rows[i_0]["krsj"].ToString() , czsj);
}
}
}
else
if (sk_tt == "tt")
{
}
}
return(s);
}
