//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); }
//上传Qskyd_fjrb_lskr public static void UpLoad_Qskyd_fjrb_lskr() { BLL.Qskyd_fjrb_lskr B_Qskyd_fjrb_lskr = new BLL.Qskyd_fjrb_lskr(); string strdat = DateTime.Now.ToString("yyyy-MM-dd"); DataSet DS_fjrb_lskr = B_Qskyd_fjrb_lskr.GetList(1000, "ID>=0 and shsc=0 and convert(varchar(10),czsj,120)<'" + strdat + "' and yydh='" + yydh + "'", "id"); if (DS_fjrb_lskr != null && DS_fjrb_lskr.Tables[0].Rows.Count > 0) { object[] args = new object[1]; args[0] = DS_fjrb_lskr; object result = jdgl_res_head_app.DynamicWebServiceCall.InvokeWebService(url, "Qskyd_fjrb_lskr_UploadDS", args); if (result.ToString() == common_file.common_app.get_suc) { Common_Shsc.Updatshsc(DS_fjrb_lskr, "Qskyd_fjrb_lskr");//上传后修改本地shsh=1 } } DS_fjrb_lskr.Dispose(); }
//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); }