protected static object RenderLeaveType(string fieldXClass, object value)
{
using (IYZDbProvider provider = YZDbProviderManager.DefaultProvider)
{
using (IDbConnection cn = provider.OpenConnection())
{
using (IDbCommand cmd = cn.CreateCommand())
{
IDbDataParameter pmTypeCode = provider.CreateParameter("TypeCode", value, true);
cmd.CommandText = String.Format("select * from YZMDLeavingType WHERE TypeCode={0}", pmTypeCode.ParameterName);
cmd.Parameters.Add(pmTypeCode);
using (YZReader reader = new YZReader(cmd.ExecuteReader()))
{
if (reader.Read())
{
return(reader.ReadString("Name"));
}
else
{
return(value);
}
}
}
}
}
}
public virtual object GetBarcodeInfo(HttpContext context)
{
YZRequest request = new YZRequest(context);
string barcode = request.GetString("barcode", null);
string format = request.GetString("format", null);
using (IYZDbProvider provider = YZDbProviderManager.DefaultProvider)
{
using (IDbConnection cn = provider.OpenConnection())
{
using (IDbCommand cmd = cn.CreateCommand())
{
IDbDataParameter paramBarcode = provider.CreateParameter("Barcode", barcode, true);
IDbDataParameter paramFormat = provider.CreateParameter("Format", format, true);
cmd.CommandText = String.Format("SELECT * FROM YZMDProduct WHERE Barcode={0} AND Format={1}",
paramBarcode.ParameterName,
paramFormat.ParameterName);
cmd.Parameters.Add(paramBarcode);
cmd.Parameters.Add(paramFormat);
using (YZReader reader = new YZReader(cmd.ExecuteReader()))
{
DataTable table = reader.LoadTable();
if (table.Rows.Count >= 1)
{
JToken rv = JToken.FromObject(table);
return((rv as JArray)[0]);
}
else
{
return(new JObject());
}
}
}
}
}
}
