private DataTable gridPic_path1(string lsno) { DataTable picpathDT = new DataTable(); try { String[] paramSup1 = new String[1] { lsno }; JObject result = ApiClientService.query("LICENSE_TPICTURE", paramSup1); if ("success".Equals(result.Value <String>("result"))) { JArray ja = result.Value <JArray>("data"); String serJa = JsonConvert.SerializeObject(ja); picpathDT = JsonConvert.DeserializeObject <DataTable>(serJa); } else { String reason = result.Value <String>("reason"); Exception ex = new Exception(reason); throw ex; } } catch (Exception ex) { Alert.Show(ex.Message, "获取图片路径时报错", MessageBoxIcon.Error); } return(picpathDT); }
private DataTable getDGSupplier1() { DataTable dt = new DataTable(); try { //String[] paramSup = new String[7] { tbxSEQNO.Text, lstLICENSEID.Text, llstFLAG.SelectedValue, lstLICENSETYPE.SelectedValue, "", lstLRRQ1.SelectedDate.ToString(), lstLRRQ2.SelectedDate.ToString() }; //String[] paramSup1 = new String[2] { docSearch.Text, docFLAG.SelectedValue }; JObject result = ApiClientService.query("SUP_LICENSE_SUPD", docSearch.Text); if ("success".Equals(result.Value <String>("result"))) { JArray ja = result.Value <JArray>("data"); String serJa = JsonConvert.SerializeObject(ja); dt = JsonConvert.DeserializeObject <DataTable>(serJa); } else { String reason = result.Value <String>("reason"); Exception ex = new Exception(reason); throw ex; } } catch (Exception ex) { Alert.Show(ex.Message, "获取供应商信息时报错", MessageBoxIcon.Error); } return(dt); }
private DataTable getDGSupplier() { DataTable dt = new DataTable(); DateTime newDate = new DateTime(); try { String tgbSearchText = ""; if (!String.IsNullOrWhiteSpace(tgbSearch.Text)) { tgbSearchText = tgbSearch.Text; } JObject result = ApiClientService.query("DOC_SUPPLIER_DG", newDate.ToString("yyyy/MM/dd HH:mm:ss"), tgbSearchText); if ("success".Equals(result.Value <String>("result"))) { JArray ja = result.Value <JArray>("data"); String serJa = JsonConvert.SerializeObject(ja); dt = JsonConvert.DeserializeObject <DataTable>(serJa); hfdGridSupplier.Text = serJa; } else { String reason = result.Value <String>("reason"); Exception ex = new Exception(reason); throw ex; } } catch (Exception ex) { Alert.Show(ex.Message, "获取供应商信息时报错", MessageBoxIcon.Error); } return(dt); }
private void SearchTwo() { //从数据平台取得数据 DataTable dt = new DataTable(); try { JObject result = ApiClientService.query("DOC_GOODS_All", (GridGoods.PageIndex * GridGoods.PageSize).ToString(), ((GridGoods.PageIndex + 1) * GridGoods.PageSize).ToString(), ddlGoodsState.SelectedValue.Trim(), trbSearch.Text.Trim()); if ("success".Equals(result.Value <String>("result"))) { String serJa = JsonConvert.SerializeObject(result.Value <JArray>("data")); dt = JsonConvert.DeserializeObject <DataTable>(serJa); GridGoods.RecordCount = Convert.ToInt32((dt.Rows[0]["TOTAL"] ?? "0")); GridGoods.DataSource = dt; GridGoods.DataBind(); } else { String reason = result.Value <String>("reason"); Exception ex = new Exception(reason); throw ex; } } catch (Exception ex) { Alert.Show(ex.Message + ex.StackTrace, "获取商品信息时超时,请重新再试!", MessageBoxIcon.Error); } // string Stearch = ""; // if (!PubFunc.StrIsEmpty(trbSearch.Text)) // { // Stearch += string.Format(" AND (A.GDSEQ LIKE '%{0}%' OR A.GDNAME LIKE '%{0}%' OR A.BAR3 LIKE '%{0}%')", trbSearch.Text); // } // Stearch += " ORDER BY GDSEQ"; // int total = 0; // string mysql = @"SELECT A.*,DECODE(A.FLAG,'Y','正常','未下传') FLAGNAME,C.NAME UNITNAME,B.name PRODUCERNAME // FROM DOC_GOODS A,DOC_PRODUCER B,DOC_GOODSUNIT C // WHERE A.UNIT = C.CODE(+) AND A.PRODUCER = B.code(+) "; // DataTable dtData = PubFunc.DbGetPage(GridGoods.PageIndex, GridGoods.PageSize, mysql + Stearch, ref total); // GridGoods.RecordCount = total; // GridGoods.DataSource = dtData; // GridGoods.DataBind(); }