//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); //用于下载成功后修改远程服务下载时间
}
//上传Qskyd_lskr_delete
public static void UpLoad_Qskyd_lskr_delete()
{
BLL.Qskyd_lskr_delete B_Qskyd_lskr_delete = new BLL.Qskyd_lskr_delete();
string strdat = DateTime.Now.ToString("yyyy-MM-dd");
DataSet DS_Qskyd_lskr_delete = B_Qskyd_lskr_delete.GetList(200, "ID>=0 and shsc=0 and convert(varchar(10),czsj,120)<'" + strdat + "' and yydh='" + yydh + "'", "id");
if (DS_Qskyd_lskr_delete != null && DS_Qskyd_lskr_delete.Tables[0].Rows.Count > 0)
{
object[] args = new object[1];
args[0] = DS_Qskyd_lskr_delete;
object result = jdgl_res_head_app.DynamicWebServiceCall.InvokeWebService(url, "Qskyd_lskr_delete_UploadDS", args);
if (result.ToString() == common_file.common_app.get_suc)
{
Common_Shsc.Updatshsc(DS_Qskyd_lskr_delete, "Qskyd_lskr_delete");//上传后修改本地shsh=1
}
}
DS_Qskyd_lskr_delete.Dispose();
}
