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;
Qskyd_fjrb_add_edit_delete Qskyd_fjrb_add_edit_delete_new = new Qskyd_fjrb_add_edit_delete();
s = Qskyd_fjrb_add_edit_delete_new.Qskyd_fjrb_add_edit_delete_app(id, 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);
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);
}
/// <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);
}
/// <summary>
/// //团体备份还原
/// </summary>
/// <param name="yydh"></param>
/// <param name="qymc"></param>
/// <param name="lsbh"></param>
/// <param name="input_cznr"></param>
/// <param name="czy"></param>
/// <param name="czsj"></param>
/// <param name="xxzs"></param>
/// <returns></returns>
public string ttbak_cx(string yydh, string qymc, string jzbh, string czy, DateTime czsj, string xxzs)
{
string s = common_file.common_app.get_failure;
BLL.Common B_Common = new Hotel_app.BLL.Common();
string insert_s = "";
string delete_s = "";
//string czzy_0 = "";
//string czbz_0 = "";
string cznr_0 = "账务撤销";
DataSet DS_temp = B_Common.GetList("select * from Qttyd_mainrecord_bak", " jzbh='" + jzbh + "'");
if (DS_temp != null && DS_temp.Tables[0].Rows.Count > 0)
{
//czzy_0 = DS_temp.Tables[0].Rows[0]["krxm"].ToString() + "/" + DS_temp.Tables[0].Rows[0]["lsbh"].ToString();
//czbz_0 = DS_temp.Tables[0].Rows[0]["ddsj"].ToString() + "/" + DS_temp.Tables[0].Rows[0]["lksj"].ToString();
DataSet DS_temp_0 = B_Common.GetList("select * from Qskyd_mainrecord_bak", " jzbh='" + jzbh + "' and ddbh='" + DS_temp.Tables[0].Rows[0]["ddbh"].ToString() + "'");
if (DS_temp_0 != null && DS_temp_0.Tables[0].Rows.Count > 0)
{
for (int j_0 = 0; j_0 < DS_temp_0.Tables[0].Rows.Count; j_0++)
{
skbak_cx(yydh, qymc, jzbh, DS_temp.Tables[0].Rows[0]["lsbh"].ToString(), czy, czsj, xxzs);
}
}
DS_temp_0.Dispose();
}
insert_s = "insert into Qttyd_mainrecord (yydh,qymc,lsbh,ddbh,is_top,is_select,krxm,krbh,krgj,krdh,krsj,krEmail,ydrxm,krdz,krly,xyh,xydw,xsy,ddrx,ddwz,ddyy,zyzt,ddsj,lzts,lksj,qtyq,czy,czsj,cznr,shsc,sktt,yddj,ffshys,sdcz,syzd,tsyq,ddly)";
insert_s = insert_s + " select yydh,qymc,lsbh,ddbh,is_top,is_select,krxm,krbh,krgj,krdh,krsj,krEmail,ydrxm,krdz,krly,xyh,xydw,xsy,ddrx,ddwz,ddyy,zyzt,ddsj,lzts,lksj,qtyq,'" + czy + "','" + czsj + "','" + cznr_0 + "',shsc,sktt,yddj,ffshys,sdcz,syzd,tsyq,ddly from Qttyd_mainrecord_bak where jzbh='" + jzbh + "'";
B_Common.ExecuteSql(insert_s);
delete_s = "delete from Qttyd_mainrecord_bak where jzbh='" + jzbh + "'";
B_Common.ExecuteSql(delete_s);
DS_temp = B_Common.GetList("select * from Qskyd_fjrb_bak", " jzbh='" + jzbh + "'");
if (DS_temp != null && DS_temp.Tables[0].Rows.Count > 0)
{
Qskyd_fjrb_add_edit_delete Qskyd_fjrb_add_edd_delete_new = new Qskyd_fjrb_add_edit_delete();
int i = 1;
for (int j_0 = 0; j_0 < DS_temp.Tables[0].Rows.Count; j_0++)
{
if (i == 2)
{
Qskyd_fjrb_add_edd_delete_new.Qskyd_fjrb_add_edit_delete_app("", yydh, qymc, DS_temp.Tables[0].Rows[j_0]["lsbh"].ToString(), DS_temp.Tables[0].Rows[j_0]["krxm"].ToString(), DS_temp.Tables[0].Rows[j_0]["sktt"].ToString(), DS_temp.Tables[0].Rows[j_0]["yddj"].ToString(), DS_temp.Tables[0].Rows[j_0]["fjrb"].ToString(), DS_temp.Tables[0].Rows[j_0]["fjbh"].ToString(), DateTime.Parse(DS_temp.Tables[0].Rows[j_0]["ddsj"].ToString()), DateTime.Parse(DS_temp.Tables[0].Rows[j_0]["lksj"].ToString()), Decimal.Parse(DS_temp.Tables[0].Rows[j_0]["lzfs"].ToString()), DS_temp.Tables[0].Rows[j_0]["shqh"].ToString(), decimal.Parse(DS_temp.Tables[0].Rows[j_0]["fjjg"].ToString()), decimal.Parse(DS_temp.Tables[0].Rows[j_0]["sjfjjg"].ToString()), DS_temp.Tables[0].Rows[j_0]["yh"].ToString(), decimal.Parse(DS_temp.Tables[0].Rows[j_0]["yhbl"].ToString()), DS_temp.Tables[0].Rows[j_0]["bz"].ToString(), czy, czsj, cznr_0, DS_temp.Tables[0].Rows[j_0]["yddj"].ToString(), common_file.common_app.get_add, xxzs, DS_temp.Tables[0].Rows[j_0]["fjbm"].ToString(), decimal.Parse(DS_temp.Tables[0].Rows[j_0]["jcje"].ToString()));
}
else
if (i == 1)
{
DataSet DS_temp_0 = B_Common.GetList("select * from Qskyd_fjrb", " lsbh='" + DS_temp.Tables[0].Rows[j_0]["lsbh"].ToString() + "'");
if (DS_temp_0 != null && DS_temp_0.Tables[0].Rows.Count > 0)
{
Qskyd_fjrb_add_edd_delete_new.Qskyd_fjrb_add_edit_delete_app(DS_temp_0.Tables[0].Rows[0]["id"].ToString(), yydh, qymc, DS_temp.Tables[0].Rows[j_0]["lsbh"].ToString(), DS_temp.Tables[0].Rows[j_0]["krxm"].ToString(), DS_temp.Tables[0].Rows[j_0]["sktt"].ToString(), DS_temp.Tables[0].Rows[j_0]["yddj"].ToString(), DS_temp.Tables[0].Rows[j_0]["fjrb"].ToString(), DS_temp.Tables[0].Rows[j_0]["fjbh"].ToString(), DateTime.Parse(DS_temp.Tables[0].Rows[j_0]["ddsj"].ToString()), DateTime.Parse(DS_temp.Tables[0].Rows[j_0]["lksj"].ToString()), Decimal.Parse(DS_temp.Tables[0].Rows[j_0]["lzfs"].ToString()), DS_temp.Tables[0].Rows[j_0]["shqh"].ToString(), decimal.Parse(DS_temp.Tables[0].Rows[j_0]["fjjg"].ToString()), decimal.Parse(DS_temp.Tables[0].Rows[j_0]["sjfjjg"].ToString()), DS_temp.Tables[0].Rows[j_0]["yh"].ToString(), decimal.Parse(DS_temp.Tables[0].Rows[j_0]["yhbl"].ToString()), DS_temp.Tables[0].Rows[j_0]["bz"].ToString(), czy, czsj, cznr_0, DS_temp.Tables[0].Rows[j_0]["yddj"].ToString(), common_file.common_app.get_edit, xxzs, DS_temp.Tables[0].Rows[j_0]["fjbm"].ToString(), decimal.Parse(DS_temp.Tables[0].Rows[j_0]["jcje"].ToString()));
i = 2;
}
else
{
i = 2;
}
DS_temp_0.Clear();
DS_temp_0.Dispose();
}
}
}
delete_s = "delete from Qskyd_fjrb_bak where jzbh='" + jzbh + "'";
B_Common.ExecuteSql(delete_s);
DS_temp = B_Common.GetList("select * from Szwzd_bak", " jzbh='" + jzbh + "'");
if (DS_temp != null && DS_temp.Tables[0].Rows.Count > 0)
{
B_Common.ExecuteSql("update Szwzd set fkje='" + DS_temp.Tables[0].Rows[0]["fkje"].ToString() + "',xfje='" + DS_temp.Tables[0].Rows[0]["xfje"].ToString() + "' where lsbh='" + DS_temp.Tables[0].Rows[0]["lsbh"].ToString() + "'");
}
else
{
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,lsbh,krxm,sktt,yddj,fjbh,fkje,xfje,main_sec,is_top,is_select from Szwzd_bak ";
insert_s = insert_s + " where jzbh='" + jzbh + "'";
B_Common.ExecuteSql(insert_s);
}
DS_temp.Clear();
DS_temp.Dispose();
delete_s = "delete from Szwzd_bak where jzbh='" + jzbh + "'";
B_Common.ExecuteSql(delete_s);
insert_s = "insert into Qyddj_otherfee (yydh,qymc,lsbh,krxm,fjbh,sktt,fyrx,xfdr,xfrb,xfsl,xfxm,jjje,xfje,shsc,czy,cznr,czsj,sdcz,is_top,is_select,mxbh)";
insert_s = insert_s + " select yydh,qymc,lsbh,krxm,fjbh,sktt,fyrx,xfdr,xfrb,xfsl,xfxm,jjje,xfje,shsc,'" + czy + "','" + cznr_0 + "','" + czsj + "',sdcz,is_top,is_select,mxbh from Qyddj_otherfee_bak";
insert_s = insert_s + " where jzbh='" + jzbh + "'";
B_Common.ExecuteSql(insert_s);
delete_s = "delete from Qyddj_otherfee_bak where jzbh='" + jzbh + "'";
B_Common.ExecuteSql(delete_s);
//common_file.common_czjl.add_czjl(yydh, qymc, czy, cznr_0, czzy_0, czbz_0, czsj);
s = common_file.common_app.get_suc;
return(s);
}
public string sk_ydzdj(string lsbh, string czy, string cznr, DateTime czsj, string xxzs)
{
string s = common_file.common_app.get_failure;
string yydh = "";
string qymc = "";
string krxm = "";
string fjrb = "";
string fjbh = "";
DateTime yd_ddsj = DateTime.Parse(common_file.common_app.cssj);
DateTime yd_lksj = DateTime.Parse(common_file.common_app.cssj);
BLL.Common B_Common = new Hotel_app.BLL.Common();
DataSet DS_temp_2 = B_Common.GetList("select * from Qskyd_fjrb", "lsbh='" + lsbh + "' and fjbh<>'' and yddj='" + common_file.common_yddj.yddj_yd + "'");
if (DS_temp_2 != null && DS_temp_2.Tables[0].Rows.Count > 0)
{
yydh = DS_temp_2.Tables[0].Rows[0]["yydh"].ToString();
qymc = DS_temp_2.Tables[0].Rows[0]["qymc"].ToString();
krxm = DS_temp_2.Tables[0].Rows[0]["krxm"].ToString();
fjrb = DS_temp_2.Tables[0].Rows[0]["fjrb"].ToString();
fjbh = DS_temp_2.Tables[0].Rows[0]["fjbh"].ToString();
yd_ddsj = DateTime.Parse(DS_temp_2.Tables[0].Rows[0]["ddsj"].ToString());
yd_lksj = DateTime.Parse(DS_temp_2.Tables[0].Rows[0]["lksj"].ToString());
Qskyd_fjrb_add_edit_delete Qskyd_fjrb_add_edit_delete_new = new Qskyd_fjrb_add_edit_delete();
s = Qskyd_fjrb_add_edit_delete_new.Qskyd_fjrb_add_edit_delete_app(DS_temp_2.Tables[0].Rows[0]["id"].ToString(), DS_temp_2.Tables[0].Rows[0]["yydh"].ToString(), DS_temp_2.Tables[0].Rows[0]["qymc"].ToString(), lsbh, DS_temp_2.Tables[0].Rows[0]["krxm"].ToString(), "", DS_temp_2.Tables[0].Rows[0]["yddj"].ToString(), DS_temp_2.Tables[0].Rows[0]["fjrb"].ToString(), DS_temp_2.Tables[0].Rows[0]["fjbh"].ToString(), czsj, DateTime.Parse(DS_temp_2.Tables[0].Rows[0]["lksj"].ToString()), decimal.Parse(DS_temp_2.Tables[0].Rows[0]["lzfs"].ToString()), DS_temp_2.Tables[0].Rows[0]["shqh"].ToString(), decimal.Parse(DS_temp_2.Tables[0].Rows[0]["fjjg"].ToString()), decimal.Parse(DS_temp_2.Tables[0].Rows[0]["sjfjjg"].ToString()), DS_temp_2.Tables[0].Rows[0]["yh"].ToString(), decimal.Parse(DS_temp_2.Tables[0].Rows[0]["yhbl"].ToString()), DS_temp_2.Tables[0].Rows[0]["bz"].ToString(), czy, czsj, cznr, common_file.common_yddj.yddj_ydzdj, common_file.common_app.get_edit, xxzs, DS_temp_2.Tables[0].Rows[0]["fjbm"].ToString(), decimal.Parse(DS_temp_2.Tables[0].Rows[0]["jcje"].ToString()));
}
DS_temp_2.Dispose();
if (s == common_file.common_app.get_suc)
{
s = common_file.common_app.get_failure;
if (B_Common.ExecuteSql("update Qskyd_mainrecord set ddsj='" + czsj + "',yddj='" + common_file.common_yddj.yddj_dj + "' where lsbh='" + lsbh + "'") > 0)
{
if (fjbh != "")
{
B_Common.ExecuteSql("update Ffjzt set zyzt_second='',yd_ddsj='" + common_file.common_app.cssj + "',yd_lksj='" + common_file.common_app.cssj + "' where fjbh='" + fjbh + "' and zyzt_second='" + common_file.common_yddj.yddj_yd + "' and yd_ddsj='" + yd_ddsj.ToString() + "' and yd_lksj='" + yd_lksj.ToString() + "'");
}
s = common_file.common_app.get_suc;
}
}
if (s == common_file.common_app.get_suc)
{
//在这里判断是否是从预定中心来的单子
DataSet ds_ydzx = B_Common.GetList(" select * from View_Qskzd ", " id>=0 and yydh='" + yydh + "' and ddyy='" + common_file_server.common_app.ydzx_flage + "' and lsbh='" + lsbh + "' and main_sec='" + common_file.common_app.main_sec_main + "' and shsc=0 ");
if (ds_ydzx != null && ds_ydzx.Tables[0].Rows.Count > 0)
{
Hotel_app.Server.Qyddj.Q_ff_xyxf Q_ff_xyxf_new = new Hotel_app.Server.Qyddj.Q_ff_xyxf();
Q_ff_xyxf_new.Qyddj_otherfee_add(yydh, qymc, lsbh, ds_ydzx.Tables[0].Rows[0]["krxm"].ToString(), ds_ydzx.Tables[0].Rows[0]["sktt"].ToString(), "", czy);
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(" insert into Qyqskyd_ydzlzmx(yydh, qymc, lsbh, fjrb, fjbh, sjjg, ddsj, lksj, ddrq, lkrq, lzrx, lzfs, shsc, scsj )");
sb.Append(" select yydh,qymc,lsbh,fjrb,fjbh,sjfjjg,ddsj,lksj,ddsj,lksj,1,lzfs,0,'" + czsj + "' from View_Qskzd where lsbh='" + lsbh + "' and yydh='" + yydh + "' and main_sec='" + common_file.common_app.main_sec_main + "' ");
B_Common.ExecuteSql(sb.ToString());
}
if (yydh != "")
{
common_file.common_czjl.add_czjl(yydh, qymc, czy, common_file.common_yddj.yddj_ydzdj, krxm + "_" + fjrb + "_" + fjbh, lsbh, czsj);
}
}
return(s);
}
