/// <summary>
/// 检测输送机任务完成(查找改巷到-1的 指令改为0)
/// </summary>
public bool ActivateOrderInfo(string line, string stn, string tuid, out string outString)
{
bool r = false;
outString = "";
var db = new DBAccess_MySql("MySql");
try
{
db.StartTran();
DataTable dt = GetCMD_NoSend(db, line, stn, tuid, out outString);
if (dt == null)
{
return(false);
}
for (int i = 0; i < dt.Rows.Count; i++)
{
var dr = dt.Rows[i];
string sql = string.Format(ConfigurationManager.AppSettings["SQL_ActiveCMD"].Replace('\n', ' '), dr["order_id"].ToString());
var dbr = db.ExecSql(sql, out outString);
r = dbr == DBExeResult.Successed;
}
db.CommitTran();
return(r);
}
catch (Exception ex)
{
r = false;
db.RollBack();
}
return(r);
}
/// <summary>
/// 创建库存
/// </summary>
/// <param name="outString"></param>
/// <returns></returns>
public bool CreateStock(DBAccess_MySql db, string houseNumber, BarcodeInfo info, out string outString)
{
outString = "";
string sql = string.Format(ConfigurationManager.AppSettings["SQL_CreateStock"].Replace('\n', ' '), houseNumber, info.ProductCode, info.BatchNo, info.UnitQty, info.VendorCode, info.PacketSeqNo, info.Barcode);
var rlt = db.ExecSql(sql, out outString);
return(rlt == DBExeResult.Successed);
}
/// <summary>
/// 取消分配
/// </summary>
/// <param name="houseNumber"></param>
/// <param name="outString"></param>
/// <returns></returns>
public bool CancelAllocationLoc(DBAccess_MySql db, string houseNumber, out string outString)
{
outString = "";
//取消预定
string sql = string.Format(ConfigurationManager.AppSettings["SQL_UnBookingLoc"].Replace('\n', ' '), houseNumber);
var rlt = db.ExecSql(sql, out outString);
return(rlt == DBExeResult.Successed);
}
public bool CreateOrderInfo_Out_T(DBAccess_MySql db, string barcode, string FromLoc, string ToLoc, out string outString)
{
outString = "";
string sql = ConfigurationManager.AppSettings["SQL_CreateOrder_Out_T"].Replace('\n', ' ');
sql = string.Format(sql, FromLoc, ToLoc, barcode);
var rlt = db.ExecSql(sql, out outString);
return(rlt == DBExeResult.Successed);
}
private void button1_Click(object sender, EventArgs e)
{
DataTable dt;
var db = new DBAccess_MySql("MySql");
string outString = "";
sql = "SELECT * FROM user_info WHERE user_code = '" + tb_userName.Text + "' AND pass_word = '" + tb_userPassword.Text + "'";
var rlt = db.QuerySQL_ToTable(sql, out dt, out outString);
if (dt.Rows.Count == 1)
{
int i = dt.Rows.Count;
FRM_CC fc = new FRM_CC();
this.Visible = false;
fc.Show();
}
else
{
int i = dt.Rows.Count;
MessageBox.Show("请检查用户名和密码是否正确！");
}
sql = "SELECT use_pl_new_pallet FROM user_info WHERE user_code = '" + tb_userName.Text + "'";
var rlt1 = db.QuerySQL_ToTable(sql, out dt, out outString);
try
{
DataRow dr = dt.Rows[0];
string s = dr[0].ToString();
sql = "UPDATE config_unit SET table_name = '" + tb_userName.Text + "',unit_name = '" + s + "'";
db.ExecSql(sql, out outString);
}
catch
{
}
}
/// <summary>
/// 分配货位
/// </summary>
/// <param name="barcode"></param>
/// <param name="outString"></param>
/// <returns></returns>
public bool AllocationLoc(DBAccess_MySql db, string barcode, out string Loc, out string outString)
{
Loc = "";
BarcodeInfo bi = new BarcodeInfo(barcode);
outString = "";
//找到空格位最少的巷道
//找到该巷道货位 按 层，列，排 升序排序的 的一个货位
//预定货位-将状态设置为入库预定I
//返货预定储位
DataTable dt = GetAllocationLoc(db, out outString);
if (dt == null || dt.Rows.Count <= 0)
{
return(false);
}
Loc = dt.Rows[0]["house_number"].ToString();
string sql = ConfigurationManager.AppSettings["SQL_BookingLoc"].Replace('\n', ' ');
sql = string.Format(sql, Loc);
var rlt = db.ExecSql(sql, out outString);
return(rlt == DBExeResult.Successed);
}
/// <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);
}
}