/// <summary>
/// 判断重复指令
/// </summary>
/// <returns></returns>
public bool IsRepeatPallet(string barcode, out string outString)
{
outString = "";
var db = new DBAccess_MySql("MySql");
try
{
string sql = string.Format(ConfigurationManager.AppSettings["SQL_IsRepeatPallet"].Replace('\n', ' '), barcode);
var obj = db.QuerySQL_GetValue(sql, out outString);
return(obj != null);
}
catch (Exception ex)
{
outString = ex.Message;
return(false);
}
}
/// <summary>
/// 指定位置出库（用于紧急出库）
/// </summary>
/// <param name="HouseNumber"></param>
/// <param name="outString"></param>
/// <returns></returns>
public bool OutStore_AssignLoction(string HouseNumber, int j, out string outString)
{
bool r = false;
outString = "";
var db = new DBAccess_MySql("MySql");
DBAccess_MySql dby = new DBAccess_MySql();
try
{
//查找出HouseNumber内所有库存，更新其库存计划出库量（参考WMS-Client的里的出库相关业务的“确认”按钮内的代码）
string sql = string.Format(ConfigurationManager.AppSettings["SQL_AssignGoods"].Replace('\n', ' '), HouseNumber);
dby = db.ReturnSQL_String(sql, out outString);
try
{
string a = null;
string b = null;
string c = null;
int d = 0;
string e = null;
while (dby.rec.Read())
{
a = dby.rec.GetString(0);
b = dby.rec.GetString(1);
c = dby.rec.GetString(2);
d = dby.rec.GetInt32(3);
e = dby.rec.GetString(4);
}
dby.connMysql.Close();
dby.rec.Close();
if (a != "")
{
string sql1 = string.Format(ConfigurationManager.AppSettings["SQL_UpdateGoods"].Replace('\n', ' '), d, a, b);
var rlt1 = db.ExecSql(sql1, out outString);
//改变库位状态
string sql2 = string.Format(ConfigurationManager.AppSettings["SQL_OutStateGoods"].Replace('\n', ' '), a);
var rlt2 = db.ExecSql(sql2, out outString);
//改变储位状态
string sql3 = string.Format(ConfigurationManager.AppSettings["SQL_OutDataGoods"].Replace('\n', ' '), a, b);
var rlt3 = db.ExecSql(sql3, out outString);
//判断是不是全部物品出库,如果是全部都出库了,那么是出库命令2.否则是减料出库3
string sql4 = string.Format(ConfigurationManager.AppSettings["SQL_OutSelectNull"].Replace('\n', ' '), a);
var obj4 = db.QuerySQL_GetValue(sql4, out outString);
if (obj4 == null)
{
//创建出库指令(order_info)
int i = int.Parse(a.Substring(1, 1));
string sql5 = string.Format(ConfigurationManager.AppSettings["SQL_AddOutOrder"].Replace('\n', ' '), a, i, e, j);
var rlt5 = db.ExecSql(sql5, out outString);
}
else
{
}
}
}
catch (Exception ex)
{
}
finally
{
}
return(!r);
}
catch (Exception ex)
{
outString = ex.Message;
return(r);
}
}