//会员消费记录信息下载,供特定门店下载返回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); }