//Qskyd_fjrb_lskr信息下载，供特定门店下载返回dataset
public DataSet Qskyd_mainrecord_lskr_download_DS(string yydh)
{
BLL.Qskyd_mainrecord_lskr B_Qskyd_mainrecord_lskr = new BLL.Qskyd_mainrecord_lskr();
Model.Qskyd_mainrecord_lskr M_Qskyd_mainrecord_lskr = new Model.Qskyd_mainrecord_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_mainrecord_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_mainrecord_lskr = B_Qskyd_mainrecord_lskr.GetList(2000, "yydh<>'" + yydh + "' and czsj>='" + cstime + "' and czsj<'" + jstime + "'", "id");
}
else
{
LogHelper.WriteLog("中心服务器表Lskr_sc_xz_sj里没有配置yydh为:" + yydh + "的门店初始下载的记录信息,请先配置信息");
DS_Qskyd_mainrecord_lskr = null;
}
}
return(DS_Qskyd_mainrecord_lskr);
}
//Qskyd_fjrb_lskr信息下载，供特定门店下载返回dataset
public DataSet Qskyd_mainrecord_lskr_download_DS(string yydh)
{
BLL.Qskyd_mainrecord_lskr B_Qskyd_mainrecord_lskr = new BLL.Qskyd_mainrecord_lskr();
Model.Qskyd_mainrecord_lskr M_Qskyd_mainrecord_lskr = new Model.Qskyd_mainrecord_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_mainrecord_lskr = new DataSet();
DS_Qskyd_mainrecord_lskr = B_Qskyd_mainrecord_lskr.GetList(2000, "yydh<>'" + yydh + "' and czsj>='" + cstime + "' and czsj<'" + jstime + "'", "id");
return(DS_Qskyd_mainrecord_lskr);
}
//上传Qskyd_mainrecord_lskr
public static void UpLoad_Qskyd_mainrecord_lskr()
{
BLL.Qskyd_mainrecord_lskr B_Qskyd_mainrecord_lskr = new BLL.Qskyd_mainrecord_lskr();
string strdat = DateTime.Now.ToString("yyyy-MM-dd");
DataSet DS_Qskyd_mainrecord_lskr = B_Qskyd_mainrecord_lskr.GetList(1000, "ID>=0 and shsc=0 and convert(varchar(10),czsj,120)<'" + strdat + "' and yydh='" + yydh + "'", "id");
if (DS_Qskyd_mainrecord_lskr != null && DS_Qskyd_mainrecord_lskr.Tables[0].Rows.Count > 0)
{
object[] args = new object[1];
args[0] = DS_Qskyd_mainrecord_lskr;
object result = jdgl_res_head_app.DynamicWebServiceCall.InvokeWebService(url, "Qskyd_mainrecord_lskr_UploadDS", args);
if (result.ToString() == common_file.common_app.get_suc)
{
Common_Shsc.Updatshsc(DS_Qskyd_mainrecord_lskr, "Qskyd_mainrecord_lskr");//上传后修改本地shsh=1
}
else
{
common_file.Common.WriteLog("现在时间" + strdat, "上传历史客人成功但是修改本地shsc=1时出错");
}
}
DS_Qskyd_mainrecord_lskr.Dispose();
}