internal string FindNewBillNo(string billDate)
{
StoredProcParameter parameters = new StoredProcParameter();
parameters.AddParameter("VDATE", billDate);
parameters.AddParameter("VBILLNO", "00000000000000000000", DbType.String, ParameterDirection.Output);
ExecuteNonQuery("GENPALLETNO", parameters);
return parameters["VBILLNO"].ToString();
}
public DataSet GetData(string procName, StoredProcParameter param)
{
using (PersistentManager persistentManager = new PersistentManager())
{
SysSelectDialogDao dao = new SysSelectDialogDao();
return dao.ExecuteProcedure(procName, param);
}
}
public object ExecuteScalar(string procedureName, StoredProcParameter param)
{
DbCommand dbCommand = this.CreateCommand(procedureName);
if (this.transaction != null)
{
dbCommand.Transaction = this.transaction;
}
dbCommand.CommandType = CommandType.StoredProcedure;
this.SetParameter(dbCommand, param);
return(dbCommand.ExecuteScalar());
}
protected void ExecuteNonQuery(string procedureName, StoredProcParameter param)
{
try
{
this.InitPM();
this.persistentManager.ExecuteNonQuery(procedureName, param);
this.ReleasePM();
}
catch (Exception exception)
{
this.ReleasePM();
throw new Exception(exception.Message);
}
}
/// <summary>
/// 分配货位,返回 0:TaskID，1:货位
/// </summary>
/// <param name="strWhere"></param>
public string[] AssignCell(string strWhere, string ApplyStation)
{
string where = "1=1";
if (!string.IsNullOrEmpty(strWhere))
where = strWhere;
string strSQL = "SELECT * FROM WCS_TASK WHERE " + where;
DataTable dt = ExecuteQuery(strSQL).Tables[0];
if (dt.Rows.Count == 0)
{
throw new Exception("找不到相关的入库单号。");
}
string TaskID = dt.Rows[0]["TASK_ID"].ToString();
string billNo = dt.Rows[0]["BILL_NO"].ToString();
string ProductCode = dt.Rows[0]["PRODUCT_CODE"].ToString();
string VCell = "";
if (dt.Rows[0]["CELL_CODE"].ToString() == "")
{
StoredProcParameter parameters = new StoredProcParameter();
parameters.AddParameter("VBILLNO", billNo);
parameters.AddParameter("VPRODUCTCODE", ProductCode);
parameters.AddParameter("VCELL", "00000000", DbType.String, ParameterDirection.Output);
if (ApplyStation == "131")
ExecuteNonQuery("APPLYPALLETCELL", parameters);
else
ExecuteNonQuery("APPLYCELL", parameters);
VCell = parameters["VCELL"].ToString();
}
else
{
VCell = dt.Rows[0]["CELL_CODE"].ToString();
}
if (VCell == "")
{
throw new Exception("没有可分配的货位！");
}
strSQL = string.Format("UPDATE CMD_CELL SET IS_LOCK='1',BILL_NO='{1}' WHERE CELL_CODE='{0}'", VCell, billNo);
ExecuteNonQuery(strSQL);
strSQL = string.Format("UPDATE WCS_TASK SET CELL_CODE='{0}' WHERE {1}", VCell, where);
ExecuteNonQuery(strSQL);
string[] strValue = new string[2];
strValue[0] = TaskID;
strValue[1] = VCell;
return strValue;
}
protected void ExecuteNonQuery(string procedureName, StoredProcParameter param)
{
try
{
this.InitPM();
this.persistentManager.ExecuteNonQuery(procedureName, param);
this.ReleasePM();
}
catch (Exception exception)
{
this.ReleasePM();
throw new Exception(exception.Message);
}
}
public void ExecuteNonQuery(string procedureName, StoredProcParameter param)
{
DbCommand dbCommand = this.CreateCommand(procedureName);
dbCommand.CommandType = CommandType.StoredProcedure;
this.SetParameter(dbCommand, param);
if (this.transaction != null)
{
dbCommand.Transaction = this.transaction;
}
dbCommand.ExecuteNonQuery();
foreach (IDbDataParameter parameter in dbCommand.Parameters)
{
param.Parameters[parameter.ParameterName].ParameterValue = parameter.Value;
}
}
public DataSet ExecuteQuery(string procedureName, string tableName, StoredProcParameter param)
{
DataSet dataSet = new DataSet();
DbCommand dbCommand = this.CreateCommand(procedureName);
if (this.transaction != null)
{
dbCommand.Transaction = this.transaction;
}
dbCommand.CommandType = CommandType.StoredProcedure;
this.SetParameter(dbCommand, param);
DbDataAdapter adapter = this.CreateDataAdapter(dbCommand);
adapter.SelectCommand = dbCommand;
adapter.Fill(dataSet, tableName);
return(dataSet);
}
protected DataSet ExecuteQuery(string procedureName, string tableName, StoredProcParameter param)
{
DataSet set2;
try
{
this.InitPM();
DataSet set = this.persistentManager.ExecuteQuery(procedureName, tableName, param);
this.ReleasePM();
set2 = set;
}
catch (Exception exception)
{
this.ReleasePM();
throw new Exception(exception.Message);
}
return(set2);
}
protected IDataReader ExecuteReader(string procedureName, StoredProcParameter param)
{
IDataReader reader2;
try
{
this.InitPM();
IDataReader reader = this.persistentManager.ExecuteReader(procedureName, param);
this.ReleasePM();
reader2 = reader;
}
catch (Exception exception)
{
this.ReleasePM();
throw new Exception(exception.Message);
}
return(reader2);
}
protected object ExecuteScalar(string procedureName, StoredProcParameter param)
{
object obj3;
try
{
this.InitPM();
object obj2 = this.persistentManager.ExecuteScalar(procedureName, param);
this.ReleasePM();
obj3 = obj2;
}
catch (Exception exception)
{
this.ReleasePM();
throw new Exception(exception.Message);
}
return(obj3);
}
private void SetParameter(IDbCommand dbCommand, StoredProcParameter param)
{
if (param != null)
{
foreach (Parameter parameter in param.Parameters.Values)
{
IDbDataParameter parameter2 = dbCommand.CreateParameter();
parameter2.ParameterName = parameter.ParameterName;
parameter2.Value = parameter.ParameterValue;
parameter2.DbType = parameter.ParameterType;
parameter2.Direction = parameter.ParameterDirectioin;
if (dbCommand is System.Data.OracleClient.OracleCommand && parameter.ParameterDirectioin == ParameterDirection.Output && parameter.ParameterType == System.Data.DbType.String)
{
parameter2.Size = parameter.ParameterValue.ToString().Length;
}
dbCommand.Parameters.Add(parameter2);
}
}
}
/// <summary>
/// 空托盘组出库单
/// </summary>
/// <param name="TARGET_CODE"></param>
/// <returns></returns>
public string CreatePalletOutBillTask(string TARGET_CODE)
{
string strSQL = string.Format("SELECT * FROM WCS_TASK WHERE PRODUCT_CODE='0000' AND STATE IN (0,1) AND TASK_TYPE='12' AND TARGET_CODE='{0}'", TARGET_CODE);
DataTable dt = ExecuteQuery(strSQL).Tables[0];
if (dt.Rows.Count == 0)
{
StoredProcParameter parameters = new StoredProcParameter();
parameters.AddParameter("VCELL", "00000000", DbType.String, ParameterDirection.Output);
ExecuteNonQuery("APPLYPALLETOUTCELL", parameters);
string VCell = parameters["VCELL"].ToString();
//VCell=-1表示找不到可以出库的空托盘组
if (VCell != "-1")
{
string strBillNo = GetBillNo("POS");
strSQL = string.Format("INSERT INTO WMS_PALLET_MASTER (BILL_NO,BILL_DATE,BTYPE_CODE,WAREHOUSE_CODE,STATUS,STATE,OPERATER,OPERATE_DATE,TASKER,TASK_DATE)" +
"values ('{0}',SYSDATE,'012','001','1','3','000001',SYSDATE,'000001',SYSDATE)", strBillNo);
ExecuteNonQuery(strSQL);
strSQL = string.Format("INSERT INTO WMS_PALLET_DETAIL(BILL_NO,ITEM_NO,PRODUCT_CODE,QUANTITY,PACKAGES)" +
" VALUES('{0}',1,'0000',6,1)", strBillNo);
ExecuteNonQuery(strSQL);
strSQL = string.Format("INSERT INTO WMS_PRODUCT_STATE(BILL_NO,ITEM_NO,PRODUCT_CODE,WEIGHT,REAL_WEIGHT,PACKAGE_COUNT,IS_MIX,CELL_CODE)" + "VALUES('{0}',1,'0000',0,0,1,0,'{1}')", strBillNo, VCell);
ExecuteNonQuery(strSQL);
strSQL = string.Format("INSERT INTO WCS_TASK(TASK_ID,TASK_TYPE,TASK_LEVEL,BILL_NO,PRODUCT_CODE,REAL_WEIGHT,PRODUCT_BARCODE,PALLET_CODE,STATE,TASK_DATE,TASKER,PRODUCT_TYPE,IS_MIX,CELL_CODE,TARGET_CODE)" +
"SELECT STATE.BILL_NO||LPAD(ITEM_NO, 2, '0'),BTYPE.TASK_TYPE ,BTYPE.TASK_LEVEL,STATE.BILL_NO,PRODUCT_CODE,REAL_WEIGHT,PRODUCT_BARCODE,PALLET_CODE,'0',TASK_DATE,TASKER,2,IS_MIX,CELL_CODE,'{1}' FROM WMS_PRODUCT_STATE STATE " +
"LEFT JOIN WMS_PALLET_MASTER BILL ON STATE.BILL_NO=BILL.BILL_NO " +
"LEFT JOIN CMD_BILL_TYPE BTYPE ON BILL.BTYPE_CODE=BTYPE.BTYPE_CODE WHERE STATE.BILL_NO='{0}'", strBillNo, TARGET_CODE);
ExecuteNonQuery(strSQL);
return strBillNo + "01";
}
else
throw new Exception("没有找到可以出库的托盘货位。");
}
else
return dt.Rows[0]["TASK_ID"].ToString();
}
internal void ExecuteNonQuery(string procedureName, StoredProcParameter param)
{
this.dbAccess.ExecuteNonQuery(procedureName, param);
}
internal object ExecuteScalar(string procedureName, StoredProcParameter param)
{
return(this.dbAccess.ExecuteScalar(procedureName, param));
}
internal DataSet ExecuteQuery(string procedureName, string tableName, StoredProcParameter param)
{
return this.dbAccess.ExecuteQuery(procedureName, tableName, param);
}
internal void ExecuteNonQuery(string procedureName, StoredProcParameter param)
{
this.dbAccess.ExecuteNonQuery(procedureName, param);
}
protected IDataReader ExecuteReader(string procedureName, StoredProcParameter param)
{
IDataReader reader2;
try
{
this.InitPM();
IDataReader reader = this.persistentManager.ExecuteReader(procedureName, param);
this.ReleasePM();
reader2 = reader;
}
catch (Exception exception)
{
this.ReleasePM();
throw new Exception(exception.Message);
}
return reader2;
}
public object ExecuteScalar(string procedureName, StoredProcParameter param)
{
DbCommand dbCommand = this.CreateCommand(procedureName);
if (this.transaction != null)
{
dbCommand.Transaction = this.transaction;
}
dbCommand.CommandType = CommandType.StoredProcedure;
this.SetParameter(dbCommand, param);
return dbCommand.ExecuteScalar();
}
/// <summary>
/// 更新单号完成标志。
/// </summary>
/// <param name="BillNo"></param>
public void UpdateInBillMasterFinished(string BillNo,string isBill)
{
StoredProcParameter parameters = new StoredProcParameter();
parameters.AddParameter("VBILLNO", BillNo);
parameters.AddParameter("VISBILL", isBill);
ExecuteNonQuery("CONFIRMBILLFINSHED", parameters);
}
public string FindNewBillNo(string prefix, string billDate)
{
StoredProcParameter parameters = new StoredProcParameter();
parameters.AddParameter("PREFIX", prefix);
parameters.AddParameter("VDATE", billDate);
parameters.AddParameter("VBILLNO", "00000000000000000000", DbType.String, ParameterDirection.Output);
ExecuteNonQuery("GENBILLNO", parameters);
return parameters["VBILLNO"].ToString();
}
/// <summary>
/// 分配货位,返回 0:TaskID，1:任务号，2:货物到达入库站台的目的地址--平面号,3:堆垛机入库站台，4:货位，5:堆垛机编号
/// </summary>
/// <param name="strWhere"></param>
public string[] AssignNewCell(string strWhere, string CraneNo)
{
string[] strValue = new string[6];
string where = "1=1";
if (!string.IsNullOrEmpty(strWhere))
where = strWhere;
string strSQL = "SELECT * FROM WCS_TASK WHERE " + where;
DataTable dt = ExecuteQuery(strSQL).Tables[0];
if (dt.Rows.Count == 0)
{
throw new Exception("找不到相关的入库单号。");
}
string TaskID = dt.Rows[0]["TASK_ID"].ToString();
string billNo = dt.Rows[0]["BILL_NO"].ToString();
string ProductCode = dt.Rows[0]["PRODUCT_CODE"].ToString();
string VCell = "";
if (dt.Rows[0]["CELL_CODE"].ToString() != "")
{
VCell = dt.Rows[0]["CELL_CODE"].ToString();
CellDao cdao = new CellDao();
DataTable dtCell = cdao.GetCellInfo(VCell);
if (dtCell.Rows[0]["ERROR_FLAG"].ToString() == "1")
{
VCell = "";
}
}
if (VCell == "")
{
StoredProcParameter parameters = new StoredProcParameter();
parameters.AddParameter("VPRODUCTCODE",ProductCode);
parameters.AddParameter("VCRANENO", CraneNo);
parameters.AddParameter("VCELL", "00000000", DbType.String, ParameterDirection.Output);
ExecuteNonQuery("APPLYNEWCELL", parameters);
VCell = parameters["VCELL"].ToString();
}
if (VCell == "")
{
throw new Exception("没有可分配的货位！");
}
strSQL = string.Format("UPDATE CMD_CELL SET IS_LOCK='1',BILL_NO='{1}' WHERE CELL_CODE='{0}'", VCell, billNo);
ExecuteNonQuery(strSQL);
strSQL = string.Format("UPDATE WCS_TASK SET CELL_CODE='{0}' WHERE {1}", VCell, where);
ExecuteNonQuery(strSQL);
SysStationDao sysdao = new SysStationDao();
dt = sysdao.GetSationInfo(VCell, "11","3");
string TaskNo = InsertTaskDetail(TaskID);
strValue[0] = TaskID;
strValue[1] = TaskNo;
strValue[2] = dt.Rows[0]["STATION_NO"].ToString();
strValue[3] = dt.Rows[0]["CRANE_POSITION"].ToString();
strValue[4] = VCell;
strValue[5] = dt.Rows[0]["CRANE_NO"].ToString();
return strValue;
}
public DataSet ExecuteQuery(string procedureName, string tableName, StoredProcParameter param)
{
DataSet dataSet = new DataSet();
DbCommand dbCommand = this.CreateCommand(procedureName);
if (this.transaction != null)
{
dbCommand.Transaction = this.transaction;
}
dbCommand.CommandType = CommandType.StoredProcedure;
this.SetParameter(dbCommand, param);
DbDataAdapter adapter = this.CreateDataAdapter(dbCommand);
adapter.SelectCommand = dbCommand;
adapter.Fill(dataSet, tableName);
return dataSet;
}
public string TaskUrgentOutBill(string billNo)
{
StoredProcParameter parameters = new StoredProcParameter();
parameters.AddParameter("VBILLNO", billNo);
parameters.AddParameter("VRESULT", 0, DbType.Int32, ParameterDirection.Output);
ExecuteNonQuery("TASKURGENTOUT", parameters);
return parameters["VRESULT"].ToString();
}
protected DataSet ExecuteQuery(string procedureName, string tableName, StoredProcParameter param)
{
DataSet set2;
try
{
this.InitPM();
DataSet set = this.persistentManager.ExecuteQuery(procedureName, tableName, param);
this.ReleasePM();
set2 = set;
}
catch (Exception exception)
{
this.ReleasePM();
throw new Exception(exception.Message);
}
return set2;
}
internal DataSet ExecuteQuery(string procedureName, string tableName, StoredProcParameter param)
{
return(this.dbAccess.ExecuteQuery(procedureName, tableName, param));
}
/// <summary>
/// 更新单号完成标志。
/// </summary>
/// <param name="BillNo"></param>
public void UpdateOutBillMasterFinished(string BillNo)
{
StoredProcParameter parameters = new StoredProcParameter();
parameters.AddParameter("VBILLNO", BillNo);
ExecuteNonQuery("CONFIRMOUTBILLFINSHED", parameters);
}
internal IDataReader ExecuteReader(string procedureName, StoredProcParameter param)
{
return(this.dbAccess.ExecuteReader(procedureName, param));
}
internal IDataReader ExecuteReader(string procedureName, StoredProcParameter param)
{
return this.dbAccess.ExecuteReader(procedureName, param);
}
private void SetParameter(IDbCommand dbCommand, StoredProcParameter param)
{
if (param != null)
{
foreach (Parameter parameter in param.Parameters.Values)
{
IDbDataParameter parameter2 = dbCommand.CreateParameter();
parameter2.ParameterName = parameter.ParameterName;
parameter2.Value = parameter.ParameterValue;
parameter2.DbType = parameter.ParameterType;
parameter2.Direction = parameter.ParameterDirectioin;
if (dbCommand is System.Data.OracleClient.OracleCommand && parameter.ParameterDirectioin == ParameterDirection.Output && parameter.ParameterType == System.Data.DbType.String)
{
parameter2.Size = parameter.ParameterValue.ToString().Length;
}
dbCommand.Parameters.Add(parameter2);
}
}
}
internal object ExecuteScalar(string procedureName, StoredProcParameter param)
{
return this.dbAccess.ExecuteScalar(procedureName, param);
}
public void ExecuteNonQuery(string procedureName, StoredProcParameter param)
{
DbCommand dbCommand = this.CreateCommand(procedureName);
dbCommand.CommandType = CommandType.StoredProcedure;
this.SetParameter(dbCommand, param);
if (this.transaction != null)
{
dbCommand.Transaction = this.transaction;
}
dbCommand.ExecuteNonQuery();
foreach (IDbDataParameter parameter in dbCommand.Parameters)
{
param.Parameters[parameter.ParameterName].ParameterValue = parameter.Value;
}
}
protected object ExecuteScalar(string procedureName, StoredProcParameter param)
{
object obj3;
try
{
this.InitPM();
object obj2 = this.persistentManager.ExecuteScalar(procedureName, param);
this.ReleasePM();
obj3 = obj2;
}
catch (Exception exception)
{
this.ReleasePM();
throw new Exception(exception.Message);
}
return obj3;
}
