//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); }
//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); }
public static void Download_Qskyd_lskr_delete() { 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(); string csdatatime = "1800-01-01"; string jsdatatime = "1800-01-01"; DataSet DS_download = new DataSet(); object[] args = new object[4]; args[0] = yydh; args[1] = csdatatime; args[2] = jsdatatime; args[3] = DS_download; object result = jdgl_res_head_app.DynamicWebServiceCall.InvokeWebService(url, "Qskyd_lskr_delete_download", args); jsdatatime = (String)args[2]; if (result.ToString() == common_file.common_app.get_suc) { DS_download = (DataSet)args[3]; //下载好后把值传给本地数据库 jsdatatime = (String)args[2]; //读取结束时间 csdatatime = (String)args[1]; //读取初始时间 foreach (DataRow dr in DS_download.Tables[0].Rows) { string hykh_service = dr["lsbh"].ToString(); SqlParameter[] parameters = { new SqlParameter("@yydh", SqlDbType.VarChar, 50), new SqlParameter("@qymc", SqlDbType.VarChar, 50), new SqlParameter("@lsbh", SqlDbType.VarChar, 100), new SqlParameter("@shsc", SqlDbType.Bit, 1), new SqlParameter("@czsj", SqlDbType.DateTime), new SqlParameter("@DB_Option_Action_", SqlDbType.VarChar, 50) }; parameters[0].Value = dr["yydh"]; parameters[1].Value = dr["qymc"]; parameters[2].Value = dr["lsbh"]; parameters[3].Value = true; parameters[4].Value = Convert.ToDateTime(dr["czsj"]); parameters[5].Value = "Insert"; SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "Qskyd_lskr_delete_InsertUpdateDelete", parameters); } //下载完后删除门店lsbh相同的信息这个写在添加的触发器 } common_file.Common_lskr.DownLoadUpdate(jsdatatime); //用于下载成功后修改远程服务下载时间 }