public void delete_all_trash(string yydh, string qymc, string czy, DateTime czsj, string xxzs)
{
BLL.Common B_Common = new Hotel_app.BLL.Common();
string sql_ss = "";
//sql_ss = "backup database Hotel_data to disk='D:\\1.bak'";
//B_Common.ExecuteSql(sql_ss);
string sql_s = "delete from BBfx_jzmx";
B_Common.ExecuteSql(sql_s);
sql_s = "delete from BBfx_jzmx_bak";
B_Common.ExecuteSql(sql_s);
sql_s = "delete from Ssyxfmx_bb_ls";
B_Common.ExecuteSql(sql_s);
sql_s = "delete from BQ_syxfmx_ls";
B_Common.ExecuteSql(sql_s);
sql_s = "delete from BS_jzmx_ls";
B_Common.ExecuteSql(sql_s);
sql_s = "delete from BS_jzmx_bak_ls";
B_Common.ExecuteSql(sql_s);
sql_s = "delete from Qskyd_fjrb_temp where fjbh is null";
B_Common.ExecuteSql(sql_s);
sql_s = "delete from Qskyd_mainrecord_temp where krxm is null";
B_Common.ExecuteSql(sql_s);
//清除一百天后的操作记录
sql_s = "delete from YHczjl where czsj<'" + czsj.AddDays(-100).ToShortDateString() + "'";
B_Common.ExecuteSql(sql_s);
DataSet DS_temp = B_Common.GetList("select * from Qskyd_mainrecord", " yddj='" + common_file.common_yddj.yddj_yd + "' and main_sec='" + common_file.common_app.main_sec_main + "' and ddsj<'" + DateTime.Now.ToShortDateString() + "' and (sktt='" + common_file.common_sktt.sktt_sk + "' or sktt='" + common_file.common_sktt.sktt_cz + "' or sktt='" + common_file.common_sktt.sktt_zd + "')");
if (DS_temp != null && DS_temp.Tables[0].Rows.Count > 0)
{
string[] id_arg = new string[DS_temp.Tables[0].Rows.Count];
for (int i_0 = 0; i_0 < DS_temp.Tables[0].Rows.Count; i_0++)
{
id_arg[i_0] = DS_temp.Tables[0].Rows[i_0]["id"].ToString();
}
Qyddj.Qyddj_add_edit_delete Qyddj_add_edit_delete_new = new Qyddj.Qyddj_add_edit_delete();
Qyddj_add_edit_delete_new.delete_sk_multi(id_arg, "sc", common_file.common_yddj.yddj_wd, "预订未到被取消", "", czy, czsj.ToString(), xxzs);
}
DS_temp = B_Common.GetList("select * from Qttyd_mainrecord", " yddj='" + common_file.common_yddj.yddj_yd + "' and ddsj<'" + DateTime.Now.ToShortDateString() + "'");
if (DS_temp != null && DS_temp.Tables[0].Rows.Count > 0)
{
for (int i_0 = 0; i_0 < DS_temp.Tables[0].Rows.Count; i_0++)
{
DataSet DS_temp_0 = B_Common.GetList("select * from Qskyd_mainrecord", "ddbh='" + DS_temp.Tables[0].Rows[i_0]["ddbh"].ToString() + "' and yydh='" + DS_temp.Tables[0].Rows[i_0]["yydh"].ToString() + "' and yddj='" + common_file.common_yddj.yddj_dj + "'");
if (DS_temp_0 != null && DS_temp_0.Tables[0].Rows.Count > 0)
{
}
else
{
Qyddj.Qttyd_add_edit_delete Qttyd_add_edit_delete_new = new Qyddj.Qttyd_add_edit_delete();
Qttyd_add_edit_delete_new.Qttyd_add_edit_delete_app(DS_temp.Tables[0].Rows[i_0]["id"].ToString(), "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "预订未到被取消", "", "", "", czy, common_file.common_yddj.yddj_wd, czsj.ToString(), "", "", common_file.common_app.get_delete, xxzs, "");
}
DS_temp_0.Clear();
DS_temp_0.Dispose();
}
}
//离开时间续住
DateTime dt_temp = czsj;
DS_temp = B_Common.GetList("select * from Qttyd_mainrecord", " yddj='" + common_file.common_yddj.yddj_dj + "' ");
if (DS_temp != null && DS_temp.Tables[0].Rows.Count > 0)
{
for (int i_0 = 0; i_0 < DS_temp.Tables[0].Rows.Count; i_0++)
{
if (DS_temp.Tables[0].Rows[i_0]["lksj"].ToString() != "")
{
if (DateTime.Parse(DateTime.Parse(DS_temp.Tables[0].Rows[i_0]["lksj"].ToString()).ToShortDateString()) < DateTime.Parse(czsj.ToShortDateString()))
{
dt_temp = DateTime.Parse(czsj.ToShortDateString() + " " + DateTime.Parse(DS_temp.Tables[0].Rows[i_0]["lksj"].ToString()).ToShortTimeString());
//dt_temp = dt_temp.AddDays(1);
B_Common.ExecuteSql("update Qttyd_mainrecord set lksj='" + dt_temp.ToString() + "' where lsbh='" + DS_temp.Tables[0].Rows[i_0]["lsbh"].ToString() + "'");
}
}
}
}
DS_temp = B_Common.GetList("select * from View_Qskzd", " yddj='" + common_file.common_yddj.yddj_dj + "' and main_sec='" + common_file.common_app.main_sec_main + "' ");
if (DS_temp != null && DS_temp.Tables[0].Rows.Count > 0)
{
dt_temp = czsj;
for (int i_0 = 0; i_0 < DS_temp.Tables[0].Rows.Count; i_0++)
{
if (DS_temp.Tables[0].Rows[i_0]["lksj"].ToString() != "")
{
if (DateTime.Parse(DateTime.Parse(DS_temp.Tables[0].Rows[i_0]["lksj"].ToString()).ToShortDateString()) < DateTime.Parse(czsj.ToShortDateString()))
{
dt_temp = DateTime.Parse(czsj.ToShortDateString() + " " + DateTime.Parse(DS_temp.Tables[0].Rows[i_0]["lksj"].ToString()).ToShortTimeString());
//dt_temp = dt_temp.AddDays(1);
B_Common.ExecuteSql("update Qskyd_mainrecord set lksj='" + dt_temp.ToString() + "' where lsbh='" + DS_temp.Tables[0].Rows[i_0]["lsbh"].ToString() + "'");
B_Common.ExecuteSql("update Ffjzt set lksj='" + dt_temp.ToString() + "',czsj='" + DateTime.Now.ToString() + "' where lsbh='" + DS_temp.Tables[0].Rows[i_0]["lsbh"].ToString() + "'");
}
}
}
}
DS_temp.Clear();
DS_temp.Dispose();
sql_s = "delete from Q_sfz_temp where czsj<'" + DateTime.Now.ToShortDateString() + "'";
B_Common.ExecuteSql(sql_s);
//sql_s = "DUMP TRANSACTION hotel_data WITH NO_LOG";
//B_Common.ExecuteSql(sql_s);
}
