public static string GetUri()
{
var cmd = new SqlCommand("select top 1 cValue from BSetting where cName=@cName");
cmd.Parameters.AddWithValue("@cName", "WYI");
var wf = new WmsFunction(BaseStructure.WmsCon);
UriString=wf.ReturnFirstSingle(cmd);
return UriString;
}
public static string GetBoxWeight(string cBoxNumber)
{
using (var cmd = new SqlCommand(@"select isnull(iWeight,0) from SS_Box where cBoxNumber=@cBoxNumber"))
{
cmd.Parameters.AddWithValue("@cBoxNumber", cBoxNumber);
var wf = new WmsFunction(BaseStructure.WmsCon);
return(wf.ReturnFirstSingle(cmd));
}
}
public static string GetPrintLog(string cGuid)
{
using (var cmd = new SqlCommand(@"select dAddTime from BLogPrint WHERE cGuid=@cGuid"))
{
cmd.Parameters.AddWithValue("@cGuid", cGuid);
var wf = new WmsFunction(BaseStructure.WmsCon);
return(wf.ReturnFirstSingle(cmd));
}
}
/// <summary>
///
/// </summary>
/// <param name="cKey"></param>
/// <returns></returns>
public static string GetMenuClass(string cKey)
{
using (var cmd = new SqlCommand(@"select cClass from BFunction WHERE cFunction=@cFunction"))
{
cmd.Parameters.AddWithValue("@cFunction", cKey);
var wf = new WmsFunction(BaseStructure.WmsCon);
return(wf.ReturnFirstSingle(cmd));
}
}
/// <summary>
///
/// </summary>
/// <param name="cKey"></param>
/// <returns></returns>
public static string GetMenuClass(string cKey)
{
using (var cmd = new SqlCommand(@"select cClass from BFunction WHERE cFunction=@cFunction"))
{
cmd.Parameters.AddWithValue("@cFunction", cKey);
var wf = new WmsFunction(BaseStructure.WmsCon);
return wf.ReturnFirstSingle(cmd);
}
}
public static string GetBarCodeBySerialNumber(string cSerialNumber)
{
using (var logCmd = new SqlCommand(@"GetBarCodeBySerialNumber"))
{
logCmd.CommandType = CommandType.StoredProcedure;
logCmd.Parameters.AddWithValue("@cSerialNumber", cSerialNumber);
var wf = new WmsFunction(BaseStructure.WmsCon);
return(wf.ReturnFirstSingle(logCmd));
}
}
public static string GetUri()
{
var cmd = new SqlCommand("select top 1 cValue from BSetting where cName=@cName");
cmd.Parameters.AddWithValue("@cName", "WYI");
var wf = new WmsFunction(BaseStructure.WmsCon);
UriString = wf.ReturnFirstSingle(cmd);
return(UriString);
}