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();
}
