Example #1
0
        //Qskyd_fjrb_lskr信息下载,供特定门店下载返回dataset
        public DataSet Qskyd_lskr_delete_download_DS(string yydh, out string csdatatime, out string jsdatatime)
        {
            BLL.Qskyd_lskr_delete   B_Qskyd_lskr_delete = new BLL.Qskyd_lskr_delete();
            Model.Qskyd_lskr_delete M_Qskyd_lskr_delete = new Model.Qskyd_lskr_delete();
            Model.Lskr_sc_xz_sj     M_Lskrscsj          = new Model.Lskr_sc_xz_sj();
            BLL.Lskr_sc_xz_sj       B_Lskrscsj          = new BLL.Lskr_sc_xz_sj();

            //查询出上次上传时间
            DateTime cstime = Convert.ToDateTime("1800-01-01");

            if (yydh != "" && yydh != null)
            {
                M_Lskrscsj = B_Lskrscsj.GetModelList("yydh='" + yydh + "'")[0];
                cstime     = M_Lskrscsj.scsj;
            }
            string  jstime = DateTime.Now.ToString();
            DataSet DS_Qskyd_lskr_delete = new DataSet();

            jsdatatime = jstime;
            csdatatime = cstime.ToString();

            DS_Qskyd_lskr_delete = B_Qskyd_lskr_delete.GetList(1000, "yydh<>'" + yydh + "' and czsj>='" + cstime + "' and czsj<'" + jstime + "'", "id");
            jsdatatime           = jstime;
            csdatatime           = cstime.ToString();

            return(DS_Qskyd_lskr_delete);
        }
Example #2
0
        //Qskyd_fjrb_lskr信息下载,供特定门店下载返回dataset
        public DataSet Qskyd_lskr_delete_download_DS(string yydh, out string csdatatime, out string jsdatatime)
        {
            BLL.Qskyd_lskr_delete   B_Qskyd_lskr_delete = new BLL.Qskyd_lskr_delete();
            Model.Qskyd_lskr_delete M_Qskyd_lskr_delete = new Model.Qskyd_lskr_delete();
            Model.Lskr_sc_xz_sj     M_Lskrscsj          = new Model.Lskr_sc_xz_sj();
            BLL.Lskr_sc_xz_sj       B_Lskrscsj          = new BLL.Lskr_sc_xz_sj();
            string  jstime = DateTime.Now.ToString();
            DataSet DS_Qskyd_lskr_delete = new DataSet();

            csdatatime = jsdatatime = string.Empty;
            //查询出上次上传时间
            DateTime cstime = Convert.ToDateTime("1800-01-01");

            if (yydh != "" && yydh != null)
            {
                List <Model.Lskr_sc_xz_sj> listlskr = B_Lskrscsj.GetModelList("yydh='" + yydh + "'");
                if (listlskr.Count > 0)
                {
                    M_Lskrscsj           = listlskr[0];
                    cstime               = M_Lskrscsj.scsj;
                    jsdatatime           = jstime;
                    csdatatime           = cstime.ToString();
                    DS_Qskyd_lskr_delete = B_Qskyd_lskr_delete.GetList(1000, "yydh<>'" + yydh + "' and czsj>='" + cstime + "' and czsj<'" + jstime + "'", "id");
                }
            }
            else
            {
                LogHelper.WriteLog("中心服务器表Lskr_sc_xz_sj里没有配置yydh为:" + yydh + "的门店初始下载的记录信息,请先配置信息");
                DS_Qskyd_lskr_delete = null;
            }
            return(DS_Qskyd_lskr_delete);
        }
Example #3
0
        //Qskyd_fjrb_lskr信息下载,供特定门店下载返回dataset
        public DataSet Qskyd_fjrb_lskr_download_Ds(string yydh)
        {
            BLL.Qskyd_fjrb_lskr   B_Qskyd_fjrb_lskr = new BLL.Qskyd_fjrb_lskr();
            Model.Qskyd_fjrb_lskr M_Qskyd_fjrb_lskr = new Model.Qskyd_fjrb_lskr();
            Model.Lskr_sc_xz_sj   M_Lskrscsj        = new Model.Lskr_sc_xz_sj();
            BLL.Lskr_sc_xz_sj     B_Lskrscsj        = new BLL.Lskr_sc_xz_sj();
            string  jstime             = DateTime.Now.ToString();
            DataSet DS_Qskyd_fjrb_lskr = new DataSet();

            //查询出上次上传时间
            DateTime cstime = Convert.ToDateTime("1800-01-01");

            if (yydh != "" && yydh != null)
            {
                List <Model.Lskr_sc_xz_sj> listlskr = B_Lskrscsj.GetModelList("yydh='" + yydh + "'");
                if (listlskr.Count > 0)
                {
                    M_Lskrscsj         = listlskr[0];
                    cstime             = M_Lskrscsj.scsj;
                    DS_Qskyd_fjrb_lskr = B_Qskyd_fjrb_lskr.GetList(2000, "yydh<>'" + yydh + "' and czsj>='" + cstime + "' and czsj<'" + jstime + "'", "id");
                }
                else
                {
                    LogHelper.WriteLog("中心服务器表Lskr_sc_xz_sj里没有配置yydh为:" + yydh + "的门店初始下载的记录信息,请先配置信息");
                    DS_Qskyd_fjrb_lskr = null;
                }
            }
            return(DS_Qskyd_fjrb_lskr);
        }
Example #4
0
        //Qskyd_fjrb_lskr信息下载,供特定门店下载返回dataset
        public DataSet Qskyd_fjrb_lskr_download_Ds(string yydh)
        {
            BLL.Qskyd_fjrb_lskr   B_Qskyd_fjrb_lskr = new BLL.Qskyd_fjrb_lskr();
            Model.Qskyd_fjrb_lskr M_Qskyd_fjrb_lskr = new Model.Qskyd_fjrb_lskr();
            Model.Lskr_sc_xz_sj   M_Lskrscsj        = new Model.Lskr_sc_xz_sj();
            BLL.Lskr_sc_xz_sj     B_Lskrscsj        = new BLL.Lskr_sc_xz_sj();

            //查询出上次上传时间
            DateTime cstime = Convert.ToDateTime("1800-01-01");

            if (yydh != "" && yydh != null)
            {
                M_Lskrscsj = B_Lskrscsj.GetModelList("yydh='" + yydh + "'")[0];
                cstime     = M_Lskrscsj.scsj;
            }
            string  jstime             = DateTime.Now.ToString();
            DataSet DS_Qskyd_fjrb_lskr = new DataSet();

            DS_Qskyd_fjrb_lskr = B_Qskyd_fjrb_lskr.GetList(2000, "yydh<>'" + yydh + "' and czsj>='" + cstime + "' and czsj<'" + jstime + "'", "id");
            return(DS_Qskyd_fjrb_lskr);
        }