protected void ScanSearch(string type)
{
string sql = "";
if (type == "SHOW")
{
sql = "SELECT A.*,f_getunitname(A.UNIT) UNITNAME FROM DAT_CK_EXT A WHERE A.BILLNO = '{0}' ORDER BY A.GDSEQ,A.INSTIME DESC";
}
else
{
sql = "SELECT A.*,f_getunitname(A.UNIT) UNITNAME FROM DAT_CK_EXT A WHERE A.BILLNO = '{0}' ORDER BY A.INSTIME DESC";
}
DataTable dtScan = DbHelperOra.Query(string.Format(sql, docSEQNO.Text)).Tables[0];
//PubFunc.GridRowAdd(GridSacn, dtScan);
GridSacn.DataSource = dtScan;
GridSacn.DataBind();
//对状态进行判断
if (docFLAG.SelectedValue == "Y")
{
zsmScan.Enabled = false;
zsmDelete.Enabled = false;
}
else
{
zsmScan.Enabled = true;
zsmDelete.Enabled = true;
}
zsmScan.Text = String.Empty;
zsmScan.Focus();
}
protected void ScanSearch(string type)
{
string sql = "";
if (type == "SHOW")
{
sql = "SELECT A.*,f_getunitname(A.UNIT) UNITNAME FROM DAT_CK_EXT A WHERE A.BILLNO = '{0}' ORDER BY A.GDSEQ,A.INSTIME DESC";
}
else
{
sql = "SELECT A.*,f_getunitname(A.UNIT) UNITNAME FROM DAT_CK_EXT A WHERE A.BILLNO = '{0}' ORDER BY A.INSTIME DESC";
}
DataTable dtScan = DbHelperOra.Query(string.Format(sql, docSEQNO.Text)).Tables[0];
GridSacn.DataSource = dtScan;
GridSacn.DataBind();
}
protected void ScanSearch(string type)
{
string sql = "";
if (type == "SHOW")
{
sql = "SELECT A.*,f_getunitname(A.UNIT) UNITNAME FROM DAT_CK_EXT A WHERE A.BILLNO = '{0}' ORDER BY A.GDSEQ,A.INSTIME DESC";
}
else
{
if (type == "SJSHOW")
{
GoodsType.Text = "试剂";
sql = @"select B.GDSEQ,
B.GDNAME,
B.GDSPEC,
f_getunitname(b.unit) UNITNAME,
'1' BZHL,
A.PH,
'1' BZSL,
A.GDBARCODE ONECODE
from DAT_BARCODE_SJ A, DOC_GOODS B
WHERE A.GDSEQ = B.GDSEQ and a.rkseqno='{0}'
order by onecode";
}
else
{
sql = "SELECT A.*,f_getunitname(A.UNIT) UNITNAME FROM DAT_CK_EXT A WHERE A.BILLNO = '{0}' ORDER BY A.INSTIME DESC";
}
}
DataTable dtScan = DbHelperOra.Query(string.Format(sql, docSEQNO.Text)).Tables[0];
//PubFunc.GridRowAdd(GridSacn, dtScan);
GridSacn.DataSource = dtScan;
GridSacn.DataBind();
zsmScan.Text = String.Empty;
zsmScan.Focus();
}