/// <summary>
/// 删除时批量添加 到Qskyd_mainrecord_temp表
/// </summary>
/// //public static string Pladd(string lsbh_old, string lsbh_new, string ddbh_new, string czy, string czsj)
public static string Pladd(string yydh, string qymc, string lsbh_old, string lsbh_new, string ddbh_new, string czy, string czsj, string krxm, string sktt)
{
string s = common_app.get_failure;
BLL.Common B_common = new Hotel_app.BLL.Common();
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Qskyd_mainrecord(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,zyzt,krrx,kr_children,ddsj,lzts,lksj,qtyq,czy,czsj,cznr,shsc,sktt,yddj,ffshys,main_sec,sdcz,syzd,vip_type,tsyq,ddly)");
strSql.Append(" select yydh,qymc,'" + lsbh_new + "','" + ddbh_new + "',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,zyzt,krrx,kr_children,ddsj,lzts,lksj,qtyq,'" + czy + "','" + czsj + "','" + common_app.chinese_add + "','" + "0" + "',sktt,yddj,'" + "0" + "','" + common_app.main_sec_main + "',sdcz,syzd,vip_type,tsyq,ddly from Qskyd_mainrecord");
strSql.Append(" where lsbh='" + lsbh_old + "'");
string krxm0 = ""; string sktt0 = "";
DataSet DS_temp = B_common.GetList("select sktt,krxm from Qskyd_mainrecord", " lsbh='" + lsbh_old + "'");
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();
}
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_new, krxm0, sktt0, "", czy);
if (B_common.ExecuteSql(strSql.ToString()) > 0)
{
s = 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);
}
