/// <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); }