//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); }
public static void Download_Qskyd_mainrecord_lskr_cs() { 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(); DataSet DS_download = new DataSet(); object[] args = new object[2]; args[0] = yydh; args[1] = DS_download; object result = jdgl_res_head_app.DynamicWebServiceCall.InvokeWebService(url, " Qskyd_mainrecord_lskr_download_cs", args); if (result.ToString() == common_file.common_app.get_suc) { DS_download = (DataSet)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("@jzbh", SqlDbType.VarChar, 100), new SqlParameter("@lsbh", SqlDbType.VarChar, 100), new SqlParameter("@ddbh", SqlDbType.VarChar, 100), new SqlParameter("@is_top", SqlDbType.Bit, 1), new SqlParameter("@is_select", SqlDbType.Bit, 1), new SqlParameter("@hykh", SqlDbType.VarChar, 50), new SqlParameter("@hyrx", SqlDbType.VarChar, 50), new SqlParameter("@krxm", SqlDbType.VarChar, 50), new SqlParameter("@tlkr", SqlDbType.VarChar, 50), new SqlParameter("@krgj", SqlDbType.VarChar, 50), new SqlParameter("@krmz", SqlDbType.VarChar, 50), new SqlParameter("@yxzj", SqlDbType.VarChar, 50), new SqlParameter("@zjhm", SqlDbType.VarChar, 50), new SqlParameter("@krxb", SqlDbType.VarChar, 50), new SqlParameter("@krsr", SqlDbType.DateTime), new SqlParameter("@krdh", SqlDbType.VarChar, 50), new SqlParameter("@krsj", SqlDbType.VarChar, 50), new SqlParameter("@krEmail", SqlDbType.VarChar, 50), new SqlParameter("@krdz", SqlDbType.VarChar, 50), new SqlParameter("@krjg", SqlDbType.VarChar, 50), new SqlParameter("@krdw", SqlDbType.VarChar, 50), new SqlParameter("@krzy", SqlDbType.VarChar, 50), new SqlParameter("@cxmd", SqlDbType.VarChar, 50), new SqlParameter("@qzrx", SqlDbType.VarChar, 50), new SqlParameter("@qzhm", SqlDbType.VarChar, 50), new SqlParameter("@zjyxq", SqlDbType.DateTime), new SqlParameter("@tlyxq", SqlDbType.DateTime), new SqlParameter("@tjrq", SqlDbType.DateTime), new SqlParameter("@lzka", SqlDbType.VarChar, 50), new SqlParameter("@krly", SqlDbType.VarChar, 50), new SqlParameter("@xyh", SqlDbType.VarChar, 50), new SqlParameter("@xydw", SqlDbType.VarChar, 50), new SqlParameter("@xsy", SqlDbType.VarChar, 50), new SqlParameter("@ddrx", SqlDbType.VarChar, 50), new SqlParameter("@ddwz", SqlDbType.VarChar, 50), new SqlParameter("@zyzt", SqlDbType.VarChar, 50), new SqlParameter("@krrx", SqlDbType.VarChar, 50), new SqlParameter("@kr_children", SqlDbType.Int, 4), new SqlParameter("@ddsj", SqlDbType.DateTime), new SqlParameter("@ddyy", SqlDbType.VarChar, 200), new SqlParameter("@lzts", SqlDbType.Int, 4), new SqlParameter("@lksj", SqlDbType.DateTime), new SqlParameter("@qtyq", SqlDbType.VarChar, 800), new SqlParameter("@czy", SqlDbType.VarChar, 50), new SqlParameter("@czsj", SqlDbType.DateTime), new SqlParameter("@cznr", SqlDbType.VarChar, 50), new SqlParameter("@shsc", SqlDbType.Bit, 1), new SqlParameter("@sktt", SqlDbType.VarChar, 50), new SqlParameter("@yddj", SqlDbType.VarChar, 50), new SqlParameter("@ffshys", SqlDbType.Bit, 1), new SqlParameter("@ffzf", SqlDbType.Bit, 1), new SqlParameter("@main_sec", SqlDbType.VarChar, 50), new SqlParameter("@sdcz", SqlDbType.Bit, 1), new SqlParameter("@syzd", SqlDbType.VarChar, 50), new SqlParameter("@vip_type", SqlDbType.VarChar, 100), new SqlParameter("@tsyq", SqlDbType.VarChar, 800), new SqlParameter("@is_visible", SqlDbType.Bit, 1), new SqlParameter("@ddly", SqlDbType.VarChar, 50), new SqlParameter("@hykh_bz", SqlDbType.VarChar, 50), new SqlParameter("@DB_Option_Action_", SqlDbType.VarChar, 50) }; parameters[0].Value = dr["yydh"]; parameters[1].Value = dr["qymc"]; parameters[2].Value = dr["jzbh"]; parameters[3].Value = dr["lsbh"]; parameters[4].Value = dr["ddbh"]; parameters[5].Value = Convert.ToBoolean(dr["is_top"]); parameters[6].Value = Convert.ToBoolean(dr["is_select"]); parameters[7].Value = dr["hykh"]; parameters[8].Value = dr["hyrx"]; parameters[9].Value = dr["krxm"]; parameters[10].Value = dr["tlkr"]; parameters[11].Value = dr["krgj"]; parameters[12].Value = dr["krmz"]; parameters[13].Value = dr["yxzj"]; parameters[14].Value = dr["zjhm"]; parameters[15].Value = dr["krxb"]; parameters[16].Value = dr["krsr"]; parameters[17].Value = dr["krdh"]; parameters[18].Value = dr["krsj"]; parameters[19].Value = dr["krEmail"]; parameters[20].Value = dr["krdz"]; parameters[21].Value = dr["krjg"]; parameters[22].Value = dr["krdw"]; parameters[23].Value = dr["krzy"]; parameters[24].Value = dr["cxmd"]; parameters[25].Value = dr["qzrx"]; parameters[26].Value = dr["qzhm"]; parameters[27].Value = dr["zjyxq"]; parameters[28].Value = Convert.ToDateTime(dr["tlyxq"]); parameters[29].Value = Convert.ToDateTime(dr["tjrq"]); parameters[30].Value = dr["lzka"]; parameters[31].Value = dr["krly"]; parameters[32].Value = dr["xyh"]; parameters[33].Value = dr["xydw"]; parameters[34].Value = dr["xsy"]; parameters[35].Value = dr["ddrx"]; parameters[36].Value = dr["ddwz"]; parameters[37].Value = dr["zyzt"]; parameters[38].Value = dr["krrx"]; parameters[39].Value = Convert.ToInt32(dr["kr_children"]); parameters[40].Value = Convert.ToDateTime(dr["ddsj"]); parameters[41].Value = dr["ddyy"]; parameters[42].Value = Convert.ToInt32(dr["lzts"]); parameters[43].Value = Convert.ToDateTime(dr["lksj"]); parameters[44].Value = dr["qtyq"]; parameters[45].Value = dr["czy"]; parameters[46].Value = Convert.ToDateTime(dr["czsj"]); parameters[47].Value = dr["cznr"]; parameters[48].Value = true; parameters[49].Value = dr["sktt"]; parameters[50].Value = dr["yddj"]; parameters[51].Value = Convert.ToBoolean(dr["ffshys"]); parameters[52].Value = Convert.ToBoolean(dr["ffzf"]); parameters[53].Value = dr["main_sec"]; parameters[54].Value = true; parameters[55].Value = dr["syzd"]; parameters[56].Value = dr["vip_type"]; parameters[57].Value = dr["tsyq"]; parameters[58].Value = true; parameters[59].Value = dr["ddly"]; parameters[60].Value = dr["hykh_bz"]; parameters[61].Value = "Insert"; SqlHelper.ExecuteNonQuery(CommandType.StoredProcedure, "Qskyd_mainrecord_lskr_InsertUpdateDelete", parameters); } } }