//会员消费记录信息下载，供特定门店下载返回dataset
public DataSet DSHhyjfxfjl_download(string yydh, out int rows, out string csdatatime, out string jsdatatime)
{
BLL.Hhyjf_xfjl B_Hhyjf_xfjl = new BLL.Hhyjf_xfjl();
Model.Hhyjf_xfjl M_Hhyjf_xfjl = new Model.Hhyjf_xfjl();
Model.Hhy_sc_xz_sj M_Hhyscsj = new Model.Hhy_sc_xz_sj();
BLL.Hhy_sc_xz_sj B_Hhyscsj = new BLL.Hhy_sc_xz_sj();
//查询出上次上传时间
DateTime cstime = Convert.ToDateTime("1800-01-01");
if (yydh != "" && yydh != null)
{
M_Hhyscsj = B_Hhyscsj.GetModelList("yydh='" + yydh + "'")[0];
cstime = M_Hhyscsj.hy_scsj;
}
string jstime = DateTime.Now.ToString();
DataSet DS_Hhyjf_xfjl = new DataSet();
rows = 0;
jsdatatime = jstime;
csdatatime = cstime.ToString();
DS_Hhyjf_xfjl = B_Hhyjf_xfjl.GetList("yydh<>'" + yydh + "' and scsj>='" + cstime + "' and scsj<'" + jstime + "'");
if (DS_Hhyjf_xfjl != null)
{
rows = DS_Hhyjf_xfjl.Tables[0].Rows.Count;
jsdatatime = jstime;
csdatatime = cstime.ToString();
//status = true;
//msg = "查询成功";
}
return(DS_Hhyjf_xfjl);
}
/// <summary>
/// 本地有修改过的会员记录修改时间
/// </summary>
/// <returns></returns>
public static string GetScsj()
{
Model.Hhy_sc_xz_sj M_Hhyscsj = new Model.Hhy_sc_xz_sj();
BLL.Hhy_sc_xz_sj B_Hhyscsj = new BLL.Hhy_sc_xz_sj();
//查询出上次上传时间
DateTime cstime = Convert.ToDateTime("1800-01-01");
M_Hhyscsj = B_Hhyscsj.GetModelList("1=1")[0];
if (M_Hhyscsj != null)
{
cstime = M_Hhyscsj.hy_scsj;
}
return(cstime.ToString());
}
//会员信息下载，供特定门店下载返回dataset
public DataSet DSHhygl_download(string yydh, out int rows, out string csdatatime, out string jsdatatime)
{
BLL.Web_Hhygl B_Hhygl = new BLL.Web_Hhygl();
Model.Web_Hhygl M_Hhygl = new Model.Web_Hhygl();
Model.Hhy_sc_xz_sj M_Hhyscsj = new Model.Hhy_sc_xz_sj();
BLL.Hhy_sc_xz_sj B_Hhyscsj = new BLL.Hhy_sc_xz_sj();
//查询出上次上传时间
DateTime cstime = Convert.ToDateTime("1800-01-01");
if (yydh != "" && yydh != null)
{
M_Hhyscsj = B_Hhyscsj.GetModelList("yydh='" + yydh + "'")[0];
cstime = M_Hhyscsj.hy_scsj;
}
string jstime = DateTime.Now.ToString();
string strxgsj = DateTime.Now.Date.ToString("yyyy-MM-dd");
DataSet DS_Hhygl = new DataSet();
rows = 0;
jsdatatime = jstime;
csdatatime = cstime.ToString();
//status = false;
//msg = "没有查到要下载的数据信息或者远程服务器出错";
DS_Hhygl = B_Hhygl.GetList("(yydh<>'" + yydh + "' and scsj>='" + cstime + "' and scsj<'" + jstime + "') or (shxg=1 and convert(varchar(10),xgsj,120)>='" + strxgsj + "')");
if (DS_Hhygl != null)
{
rows = DS_Hhygl.Tables[0].Rows.Count;
jsdatatime = jstime;
csdatatime = cstime.ToString();
//status = true;
//msg = "查询成功";
}
return(DS_Hhygl);
}
//奖品奖励信息下载，供特定门店下载返回dataset
public DataSet DSHhyjfjp_download(string yydh, out int rows, out string csdatatime, out string jsdatatime)
{
BLL.Hhyjf_jp B_Hhyjf_jp = new BLL.Hhyjf_jp();
Model.Hhyjf_jp M_Hhyjf_jp = new Model.Hhyjf_jp();
Model.Hhy_sc_xz_sj M_Hhyscsj = new Model.Hhy_sc_xz_sj();
BLL.Hhy_sc_xz_sj B_Hhyscsj = new BLL.Hhy_sc_xz_sj();
//查询出上次上传时间
DateTime cstime = Convert.ToDateTime("1800-01-01");
if (yydh != "" && yydh != null)
{
M_Hhyscsj = B_Hhyscsj.GetModelList("yydh='" + yydh + "'")[0];
cstime = M_Hhyscsj.hy_scsj;
}
string jstime = DateTime.Now.ToString();
DataSet DS_Hhyjf_jp = new DataSet();
rows = 0;
jsdatatime = jstime;
csdatatime = cstime.ToString();
//status = false;
//msg = "没有查到要下载的数据信息或者远程服务器出错";
DS_Hhyjf_jp = B_Hhyjf_jp.GetList(200, "yydh='" + yydh + "'", "id");
if (DS_Hhyjf_jp != null)
{
rows = DS_Hhyjf_jp.Tables[0].Rows.Count;
jsdatatime = jstime;
csdatatime = cstime.ToString();
//status = true;
//msg = "查询成功";
}
return(DS_Hhyjf_jp);
}
