/// <summary>
/// 更新单号完成标志。
/// </summary>
/// <param name="BillNo"></param>
public void UpdateOutBillMasterFinished(string BillNo)
{
StoredProcParameter parameters = new StoredProcParameter();
parameters.AddParameter("VBILLNO", BillNo);
ExecuteNonQuery("CONFIRMOUTBILLFINSHED", parameters);
}
public DataSet GetData(string procName, StoredProcParameter param)
{
using (PersistentManager persistentManager = new PersistentManager())
{
SysSelectDialogDao dao = new SysSelectDialogDao();
return(dao.ExecuteProcedure(procName, param));
}
}
/// <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);
}
/// <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);
}
public void ResetUserParameter(int UserID)
{
StoredProcParameter param = new StoredProcParameter();
param.Names.Add("UserID");
param.Values.Add(UserID.ToString());
param.Types.Add(DbType.String);
ExecuteNonQuery("sys_UserSysInfoReset", param);
}
public void ExecBalance(string wh_code, DateTime settleDate, string type)
{
using (PersistentManager persistentManager = new PersistentManager())
{
BalanceDao dao = new BalanceDao();
StoredProcParameter para = new StoredProcParameter();
para.AddParameter("wh_code", wh_code, DbType.String);
para.AddParameter("day", settleDate, DbType.Date);
para.AddParameter("type", type, DbType.String);
dao.ExecProc("cp_DailyBalance", para);
}
}
public bool UpdateSystemParameter(string procName, StoredProcParameter param)
{
bool flag = false;
using (PersistentManager persistentManager = new PersistentManager())
{
SysSystemParameterDao paraDao = new SysSystemParameterDao();
paraDao.ExecuteProcedure(procName, param);
flag = true;
}
return(flag);
}
/// <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());
}
}
public void ExecuteProcedure(string procName, StoredProcParameter param)
{
ExecuteNonQuery(procName, param);
}
public void ExecProc(string procName, StoredProcParameter para)
{
ExecuteNonQuery(procName, para);
}
public void SaveData()
{
//个人显示设置,WUQH添加
Session["sys_PageCount"] = this.txtSys_PageCount.Text;
Session["grid_ColumnTitleFont"] = this.txtGrid_ColumnTitleFont.Text;
Session["grid_ContentFont"] = this.txtGrid_ContentFont.Text;
Session["grid_ColumnTextAlign"] = this.ddlGrid_ColumnTextAlign.SelectedValue;
Session["grid_ContentTextAlign"] = this.ddlGrid_ContentTextAlign.SelectedValue;
Session["grid_NumberColumnAlign"] = this.ddlGrid_NumberColumnAlign.SelectedValue;
Session["grid_MoneyColumnAlign"] = this.ddlGrid_MoneyColumnAlign.SelectedValue;
Session["grid_SelectMode"] = this.ddlGrid_SelectMode.SelectedValue;
Session["grid_OddRowColor"] = this.ddlGrid_DisplayRowColor.SelectedValue;
Session["grid_EvenRowColor"] = this.ddlGrid_DisplayRowColorEven.SelectedValue;
Session["grid_IsRefreshBeforeAdd"] = this.ddlGrid_IsRefreshBeforeAdd.SelectedValue;
Session["grid_IsRefreshBeforeUpdate"] = this.ddlGrid_IsRefreshBeforeUpdate.SelectedValue;
Session["grid_IsRefreshBeforeDelete"] = this.ddlGrid_IsRefreshBeforeDelete.SelectedValue;
Session["sys_PrintForm"] = this.ddlPrintForm.SelectedValue;
Session["pager_ShowPageIndex"] = this.ddl_ShowPageIndex.SelectedValue;
StoredProcParameter param = new StoredProcParameter();
param.Names.Add("UserID");
param.Names.Add("sys_PageCount");
param.Names.Add("grid_ColumnTitleFont");
param.Names.Add("grid_ContentFont");
param.Names.Add("grid_ColumnTextAlign");
param.Names.Add("grid_ContentTextAlign");
param.Names.Add("grid_NumberColumnAlign");
param.Names.Add("grid_MoneyColumnAlign");
param.Names.Add("grid_SelectMode");
param.Names.Add("grid_OddRowColor");
param.Names.Add("grid_EvenRowColor");
param.Names.Add("grid_IsRefreshBeforeAdd");
param.Names.Add("grid_IsRefreshBeforeUpdate");
param.Names.Add("grid_IsRefreshBeforeDelete");
param.Names.Add("sys_PrintForm");
param.Names.Add("pager_ShowPageIndex");
param.Values.Add(Session["UserID"].ToString());
param.Values.Add(this.txtSys_PageCount.Text);
param.Values.Add(this.txtGrid_ColumnTitleFont.Text);
param.Values.Add(this.txtGrid_ContentFont.Text);
param.Values.Add(this.ddlGrid_ColumnTextAlign.SelectedValue);
param.Values.Add(this.ddlGrid_ContentTextAlign.SelectedValue);
param.Values.Add(this.ddlGrid_NumberColumnAlign.SelectedValue);
param.Values.Add(this.ddlGrid_MoneyColumnAlign.SelectedValue);
param.Values.Add(this.ddlGrid_SelectMode.SelectedValue);
param.Values.Add(this.ddlGrid_DisplayRowColor.SelectedValue);
param.Values.Add(this.ddlGrid_DisplayRowColorEven.SelectedValue);
param.Values.Add(this.ddlGrid_IsRefreshBeforeAdd.SelectedValue);
param.Values.Add(this.ddlGrid_IsRefreshBeforeUpdate.SelectedValue);
param.Values.Add(this.ddlGrid_IsRefreshBeforeDelete.SelectedValue);
param.Values.Add(this.ddlPrintForm.SelectedValue);
param.Values.Add(this.ddl_ShowPageIndex.SelectedValue);
for (int i = 0; i < 16; i++)
{
param.Types.Add(DbType.String);
}
bool bSaveSucess = false;
try
{
objParam.UpdateSystemParameter("sys_UserSysInfoAddNew", param);
bSaveSucess = true;
}
catch (SqlException e)
{
Session["ModuleName"] = " 系统信息参数设置";
Session["FunctionName"] = "ControlsDataBind";
Session["ExceptionalType"] = e.GetType().FullName;
Session["ExceptionalDescription"] = e.Message;
Response.Redirect("~/Common/MistakesPage.aspx");
}
if (bSaveSucess)
{
JScript.Instance.ShowMessage(this, "保存成功！");
}
else
{
JScript.Instance.ShowMessage(this, "保存失败！");
}
if (Session["IsUseGlobalParameter"].ToString() == "1")
{
DoubleLineColor = Session["grid_EvenRowColor"].ToString(); //DoubleLineColor = dc.GetFieldValue("sys_SystemParameter", "ParameterValue", "ParameterName", "grid_EvenRowColor");
SingleLineColor = Session["grid_OddRowColor"].ToString(); //SingleLineColor = dc.GetFieldValue("sys_SystemParameter", "ParameterValue", "ParameterName", "grid_OddRowColor");
}
else
{
DoubleLineColor = "";
SingleLineColor = "";
}
for (int i = 0; i < 4; i++)
{
HeadFont[i] = this.txtGrid_ColumnTitleFont.Text.Split(',')[i];
TableFont[i] = this.txtGrid_ContentFont.Text.Split(',')[i];
}
if (HeadFont[3] == "加粗")
{
HeadFont[3] = "bold";
}
if (TableFont[3] == "加粗")
{
TableFont[3] = "bolder";
}
}
public DataSet ExecuteProcedure(string procName, StoredProcParameter param)
{
return(ExecuteQuery(procName, param));
}
/// <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);
}
