You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
1163 lines
37 KiB
1163 lines
37 KiB
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Data;
|
|
using System.Reflection;
|
|
|
|
namespace SiaSun.LMS.Implement
|
|
{
|
|
public class PlanBase : S_BaseService, SiaSun.LMS.Interface.I_PlanService
|
|
{
|
|
public PlanBase()
|
|
{
|
|
}
|
|
|
|
/// <summary>
|
|
/// 计划创建
|
|
/// </summary>
|
|
/// <param name="mPLAN_MAIN">计划模型</param>
|
|
/// <param name="lsPLAN_LIST">计划列表</param>
|
|
/// <param name="sResult">返回结果</param>
|
|
/// <returns></returns>
|
|
public bool PlanCreate(SiaSun.LMS.Model.PLAN_MAIN mPLAN_MAIN,
|
|
DataTable dtPLAN_LIST,
|
|
out int PLAN_ID,
|
|
out string sResult)
|
|
{
|
|
bool bResult = true;
|
|
|
|
sResult = string.Empty;
|
|
|
|
PLAN_ID = 0;
|
|
|
|
try
|
|
{
|
|
this._P_Base_House.BeginTransaction();
|
|
|
|
if (null != this._P_PLAN_MAIN.GetModel(mPLAN_MAIN.PLAN_ID))
|
|
{
|
|
if (mPLAN_MAIN.PLAN_STATUS.Equals(SiaSun.LMS.Enum.PLAN_STATUS.Complete.ToString()))
|
|
{
|
|
bResult = false;
|
|
|
|
sResult = string.Format("{0}单号已经完成 不能编辑!", mPLAN_MAIN.PLAN_CODE);
|
|
|
|
this._P_Base_House.RollBackTransaction();
|
|
|
|
return bResult;
|
|
}
|
|
|
|
IList<SiaSun.LMS.Model.RECORD_MAIN> lsRECORD_MAIN = this._P_RECORD_MAIN.GetListPlanCode(mPLAN_MAIN.PLAN_CODE);
|
|
|
|
if (lsRECORD_MAIN.Count > 0)
|
|
{
|
|
bResult = false;
|
|
|
|
sResult = string.Format("此计划已经存在出入库记录 不能编辑");
|
|
|
|
this._P_Base_House.RollBackTransaction();
|
|
|
|
return bResult;
|
|
}
|
|
|
|
this._P_PLAN_MAIN.Update(mPLAN_MAIN);
|
|
}
|
|
else
|
|
{
|
|
if (!string.IsNullOrEmpty(mPLAN_MAIN.PLAN_CODE) && null != this._P_PLAN_MAIN.GetModelPlanCode(mPLAN_MAIN.PLAN_CODE))
|
|
{
|
|
bResult = false;
|
|
|
|
sResult = string.Format("{0}单号已经存在!", mPLAN_MAIN.PLAN_CODE);
|
|
|
|
this._P_Base_House.RollBackTransaction();
|
|
|
|
return bResult;
|
|
}
|
|
|
|
this._P_PLAN_MAIN.Add(mPLAN_MAIN);
|
|
}
|
|
|
|
|
|
foreach (DataRow drPLAN_LIST in dtPLAN_LIST.Rows)
|
|
{
|
|
|
|
if (drPLAN_LIST.RowState != DataRowState.Deleted)
|
|
{
|
|
drPLAN_LIST["PLAN_ID"] = mPLAN_MAIN.PLAN_ID;
|
|
}
|
|
}
|
|
|
|
this.Save(dtPLAN_LIST, "PLAN_LIST");
|
|
|
|
mPLAN_MAIN.PLAN_CODE = "LK" + mPLAN_MAIN.PLAN_ID.ToString();
|
|
|
|
this._P_PLAN_MAIN.Update(mPLAN_MAIN);
|
|
this._P_Base_House.CommitTransaction();
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
bResult = false;
|
|
|
|
sResult = ex.Message;
|
|
|
|
this._P_Base_House.RollBackTransaction();
|
|
}
|
|
|
|
PLAN_ID = mPLAN_MAIN.PLAN_ID;
|
|
|
|
return bResult;
|
|
}
|
|
|
|
|
|
|
|
/// <summary>创建
|
|
/// 创建
|
|
/// </summary>
|
|
/// <param name="mPLAN_MAIN">计划模型</param>
|
|
/// <param name="lsPLAN_LIST">计划列表</param>
|
|
/// <param name="sResult">返回结果</param>
|
|
/// <returns></returns>
|
|
public bool PlanCreate(SiaSun.LMS.Model.PLAN_MAIN mPLAN_MAIN,
|
|
IList<SiaSun.LMS.Model.PLAN_LIST> lsPLAN_LIST,
|
|
out int PLAN_ID,
|
|
out string sResult)
|
|
{
|
|
bool bResult = true;
|
|
|
|
sResult = string.Empty;
|
|
|
|
PLAN_ID = 0;
|
|
|
|
try
|
|
{
|
|
this._P_Base_House.BeginTransaction();
|
|
|
|
if (null != this._P_PLAN_MAIN.GetModel(mPLAN_MAIN.PLAN_ID))
|
|
{
|
|
if (mPLAN_MAIN.PLAN_STATUS.Equals(SiaSun.LMS.Enum.PLAN_STATUS.Complete.ToString()))
|
|
{
|
|
bResult = false;
|
|
|
|
sResult = string.Format("{0}单号已经完成 不能编辑!", mPLAN_MAIN.PLAN_CODE);
|
|
|
|
return bResult;
|
|
}
|
|
|
|
this._P_PLAN_MAIN.Update(mPLAN_MAIN);
|
|
}
|
|
else
|
|
{
|
|
if (null != this._P_PLAN_MAIN.GetModelPlanCode(mPLAN_MAIN.PLAN_CODE))
|
|
{
|
|
bResult = false;
|
|
|
|
sResult = string.Format("{0}单号已经存在!", mPLAN_MAIN.PLAN_CODE);
|
|
|
|
return bResult;
|
|
}
|
|
|
|
this._P_PLAN_MAIN.Add(mPLAN_MAIN);
|
|
}
|
|
|
|
foreach (SiaSun.LMS.Model.PLAN_LIST mPLAN_LIST in lsPLAN_LIST)
|
|
{
|
|
bResult = this._S_GoodsService.GoodsPropertyCheck(mPLAN_LIST.GOODS_ID, mPLAN_LIST, out sResult);
|
|
|
|
if (!bResult)
|
|
{
|
|
sResult = string.Format("属性校验错误: {0}", sResult);
|
|
|
|
return bResult;
|
|
}
|
|
|
|
if (mPLAN_LIST.PLAN_ID.Equals(0))
|
|
{
|
|
mPLAN_LIST.PLAN_ID = mPLAN_MAIN.PLAN_ID;
|
|
this._P_PLAN_LIST.Add(mPLAN_LIST);
|
|
}
|
|
else
|
|
{
|
|
this._P_PLAN_LIST.Update(mPLAN_LIST);
|
|
}
|
|
}
|
|
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
bResult = false;
|
|
|
|
sResult = ex.Message;
|
|
|
|
this._P_Base_House.RollBackTransaction();
|
|
}
|
|
finally
|
|
{
|
|
if (bResult)
|
|
{
|
|
this._P_Base_House.CommitTransaction();
|
|
}
|
|
else
|
|
{
|
|
this._P_Base_House.RollBackTransaction();
|
|
}
|
|
}
|
|
|
|
PLAN_ID = mPLAN_MAIN.PLAN_ID;
|
|
|
|
return bResult;
|
|
}
|
|
|
|
|
|
public bool PlanImport(SiaSun.LMS.Model.PLAN_MAIN mPLAN_MAIN,
|
|
IList<SiaSun.LMS.Model.PLAN_LIST> lsPLAN_LIST,
|
|
out int PLAN_ID,
|
|
out string sResult)
|
|
{
|
|
bool bResult = true;
|
|
|
|
sResult = string.Empty;
|
|
|
|
PLAN_ID = 0;
|
|
|
|
//try
|
|
//{
|
|
// this._P_Base_House.BeginTransaction();
|
|
|
|
// if (null != this._P_PLAN_MAIN.GetModel(mPLAN_MAIN.PLAN_ID))
|
|
// {
|
|
// if (mPLAN_MAIN.PLAN_STATUS.Equals(SiaSun.LMS.Enum.PLAN_STATUS.Complete.ToString()))
|
|
// {
|
|
// bResult = false;
|
|
|
|
// sResult = string.Format("{0}单号已经完成 不能编辑!", mPLAN_MAIN.PLAN_CODE);
|
|
|
|
// return bResult;
|
|
// }
|
|
|
|
// this._P_PLAN_MAIN.Update(mPLAN_MAIN);
|
|
// }
|
|
// else
|
|
// {
|
|
// if (null != this._P_PLAN_MAIN.GetModel(mPLAN_MAIN.PLAN_CODE))
|
|
// {
|
|
// bResult = false;
|
|
|
|
// sResult = string.Format("{0}单号已经存在!", mPLAN_MAIN.PLAN_CODE);
|
|
|
|
// return bResult;
|
|
// }
|
|
|
|
// this._P_PLAN_MAIN.Add(mPLAN_MAIN);
|
|
|
|
// mPLAN_RELATE.PLAN_ID = mPLAN_MAIN.PLAN_ID;
|
|
|
|
// this._P_PLAN_RELATE.Add(mPLAN_RELATE);
|
|
// }
|
|
|
|
// foreach (SiaSun.LMS.Model.PLAN_LIST mPLAN_LIST in lsPLAN_LIST)
|
|
// {
|
|
// bResult = this._S_Goods.GoodsPropertyCheck(mPLAN_LIST.GOODS_ID, mPLAN_LIST, out sResult);
|
|
|
|
// if (!bResult)
|
|
// {
|
|
// sResult = string.Format("属性校验错误: {0}", sResult);
|
|
|
|
// return bResult;
|
|
// }
|
|
|
|
// if (mPLAN_LIST.PLAN_ID.Equals(0))
|
|
// {
|
|
// mPLAN_LIST.PLAN_ID = mPLAN_MAIN.PLAN_ID;
|
|
// this._P_PLAN_LIST.Add(mPLAN_LIST);
|
|
// }
|
|
// else
|
|
// {
|
|
// this._P_PLAN_LIST.Update(mPLAN_LIST);
|
|
// }
|
|
// }
|
|
|
|
//}
|
|
//catch (Exception ex)
|
|
//{
|
|
// bResult = false;
|
|
|
|
// sResult = ex.Message;
|
|
//}
|
|
//finally
|
|
//{
|
|
// if (bResult)
|
|
// {
|
|
// this._P_Base_House.CommitTransaction();
|
|
// }
|
|
// else
|
|
// {
|
|
// this._P_Base_House.RollBackTransaction();
|
|
// }
|
|
//}
|
|
|
|
//PLAN_ID = mPLAN_MAIN.PLAN_ID;
|
|
|
|
return bResult;
|
|
}
|
|
|
|
|
|
/// <summary>取消
|
|
/// 取消
|
|
/// </summary>
|
|
/// <param name="PLAN_ID">计划编号</param>
|
|
/// <param name="sResult">返回结果</param>
|
|
/// <returns></returns>
|
|
public bool PlanCancel(int PLAN_ID,
|
|
out string sResult)
|
|
{
|
|
bool bResult = true;
|
|
|
|
sResult = string.Empty;
|
|
|
|
try
|
|
{
|
|
SiaSun.LMS.Model.PLAN_MAIN mPLAN_MAIN = this._P_PLAN_MAIN.GetModel(PLAN_ID);
|
|
|
|
if (null == mPLAN_MAIN)
|
|
{
|
|
bResult = false;
|
|
|
|
sResult = string.Format("未找到计划{0}", PLAN_ID.ToString());
|
|
|
|
return bResult;
|
|
}
|
|
|
|
if (mPLAN_MAIN.PLAN_FLAG == "1")
|
|
{
|
|
bResult = false;
|
|
|
|
sResult = string.Format("导入计划{0}不能删除", PLAN_ID.ToString());
|
|
|
|
return bResult;
|
|
}
|
|
|
|
IList<SiaSun.LMS.Model.MANAGE_MAIN> lsMANAGE_MAIN = this._P_MANAGE_MAIN.GetListPlanID(PLAN_ID);
|
|
|
|
if (lsMANAGE_MAIN.Count > 0)
|
|
{
|
|
bResult = false;
|
|
|
|
sResult = string.Format("此计划存在任务。不能删除");
|
|
|
|
return bResult;
|
|
}
|
|
|
|
IList<SiaSun.LMS.Model.RECORD_MAIN> lsRECORD_MAIN = this._P_RECORD_MAIN.GetListPlanCode(mPLAN_MAIN.PLAN_CODE);
|
|
|
|
if (lsRECORD_MAIN.Count > 0)
|
|
{
|
|
bResult = false;
|
|
|
|
sResult = string.Format("此计划已经存在出入库记录。不能删除");
|
|
|
|
return bResult;
|
|
}
|
|
|
|
|
|
this._P_Base_House.BeginTransaction();
|
|
|
|
this._P_PLAN_LIST.DeletePlanID(PLAN_ID);
|
|
|
|
this._P_PLAN_MAIN.Delete(PLAN_ID);
|
|
|
|
this._P_Base_House.CommitTransaction();
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
bResult = false;
|
|
|
|
sResult = ex.Message;
|
|
|
|
this._P_Base_House.RollBackTransaction();
|
|
}
|
|
|
|
return bResult;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 检验计划是否可以完成
|
|
/// </summary>
|
|
/// <param name="PLAN_ID">计划编号</param>
|
|
/// <param name="sResult">返回结果</param>
|
|
/// <returns></returns>
|
|
public bool PlanCheckComplete(int PLAN_ID,
|
|
out string sResult)
|
|
{
|
|
bool bResult = true;
|
|
|
|
sResult = string.Empty;
|
|
|
|
SiaSun.LMS.Model.PLAN_MAIN mPLAN_MAIN = this._P_PLAN_MAIN.GetModel(PLAN_ID);
|
|
|
|
if (null == mPLAN_MAIN)
|
|
{
|
|
bResult = false;
|
|
|
|
sResult = string.Format("未找到计划{0}", PLAN_ID.ToString());
|
|
|
|
return bResult;
|
|
}
|
|
|
|
IList<SiaSun.LMS.Model.PLAN_LIST> lsPLAN_LIST = this._P_PLAN_LIST.GetListNoComplete(PLAN_ID);
|
|
|
|
|
|
if (lsPLAN_LIST.Count!=0)
|
|
{
|
|
bResult = false;
|
|
}
|
|
|
|
return bResult;
|
|
}
|
|
|
|
/// <summary>完成
|
|
/// 完成
|
|
/// </summary>
|
|
/// <param name="PLAN_ID">计划编号</param>
|
|
/// <param name="sResult">返回结果</param>
|
|
/// <returns></returns>
|
|
public bool PlanComplete(int PLAN_ID,
|
|
out string sResult)
|
|
{
|
|
return this.PlanComplete(PLAN_ID, true, out sResult);
|
|
}
|
|
|
|
|
|
/// <summary>完成-支持事务
|
|
/// 完成-支持事务
|
|
/// </summary>
|
|
/// <param name="PLAN_ID">计划编号</param>
|
|
/// <param name="sResult">返回结果</param>
|
|
/// <returns></returns>
|
|
public bool PlanComplete(int PLAN_ID,
|
|
bool bTrans,
|
|
out string sResult)
|
|
{
|
|
bool bResult = true;
|
|
|
|
sResult = string.Empty;
|
|
|
|
SiaSun.LMS.Model.PLAN_MAIN mPLAN_MAIN = this._P_PLAN_MAIN.GetModel(PLAN_ID);
|
|
|
|
if (null == mPLAN_MAIN)
|
|
{
|
|
bResult = false;
|
|
|
|
sResult = string.Format("未找到计划{0}", PLAN_ID.ToString());
|
|
|
|
return bResult;
|
|
}
|
|
|
|
try
|
|
{
|
|
this._P_Base_House.BeginTransaction(bTrans);
|
|
|
|
mPLAN_MAIN.PLAN_END_TIME = SiaSun.LMS.Common.StringUtil.GetDateTime();
|
|
|
|
mPLAN_MAIN.PLAN_STATUS = SiaSun.LMS.Enum.PLAN_STATUS.Complete.ToString();
|
|
|
|
this._P_PLAN_MAIN.Update(mPLAN_MAIN);
|
|
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
bResult = false;
|
|
|
|
sResult = ex.Message;
|
|
}
|
|
finally
|
|
{
|
|
if (bResult)
|
|
{
|
|
this._P_Base_House.CommitTransaction(bTrans);
|
|
}
|
|
else
|
|
{
|
|
this._P_Base_House.RollBackTransaction(bTrans);
|
|
}
|
|
}
|
|
|
|
return bResult;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 计划执行
|
|
/// </summary>
|
|
/// <param name="PLAN_ID">计划编号</param>
|
|
/// <param name="sResult">返回结果</param>
|
|
/// <returns></returns>
|
|
public bool PlanExecute(int PLAN_ID,
|
|
out string sResult)
|
|
{
|
|
bool bResult = true;
|
|
|
|
sResult = string.Empty;
|
|
|
|
SiaSun.LMS.Model.PLAN_MAIN mPLAN_MAIN = this._P_PLAN_MAIN.GetModel(PLAN_ID);
|
|
|
|
if (null == mPLAN_MAIN)
|
|
{
|
|
bResult = false;
|
|
|
|
sResult = string.Format("未找到计划{0}", PLAN_ID);
|
|
|
|
return bResult;
|
|
}
|
|
try
|
|
{
|
|
this._P_Base_House.BeginTransaction();
|
|
|
|
if( string.IsNullOrEmpty(mPLAN_MAIN.PLAN_BEGIN_TIME))
|
|
mPLAN_MAIN.PLAN_BEGIN_TIME = SiaSun.LMS.Common.StringUtil.GetDateTime();
|
|
|
|
mPLAN_MAIN.PLAN_STATUS = SiaSun.LMS.Enum.PLAN_STATUS.Executing.ToString();
|
|
|
|
this._P_PLAN_MAIN.Update(mPLAN_MAIN);
|
|
|
|
|
|
this._P_Base_House.CommitTransaction();
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
bResult = false;
|
|
|
|
sResult = ex.Message;
|
|
|
|
this._P_Base_House.RollBackTransaction();
|
|
}
|
|
|
|
return bResult;
|
|
}
|
|
|
|
/// <summary>计划执行默认动作
|
|
/// 计划执行默认动作
|
|
/// </summary>
|
|
/// <param name="PLAN_ID">计划编号</param>
|
|
/// <param name="sResult">返回结果</param>
|
|
/// <returns></returns>
|
|
public bool PlanExcuteDefault(int PLAN_ID, out string sResult)
|
|
{
|
|
bool bResult = true;
|
|
|
|
sResult = string.Empty;
|
|
|
|
string ACTION_EVENT = string.Empty;
|
|
|
|
SiaSun.LMS.Model.PLAN_MAIN mPLAN_MAIN = this._P_PLAN_MAIN.GetModel(PLAN_ID);
|
|
|
|
DataTable dtPlan = this.GetList(string.Format("SELECT * FROM V_PLAN WHERE PLAN_ID = {0}", PLAN_ID));
|
|
|
|
DataTable dtACTION = this._S_FlowService.PlanGetAction(PLAN_ID.ToString(), "1");
|
|
|
|
if (dtACTION.Rows.Count.Equals(0))
|
|
{
|
|
return bResult;
|
|
}
|
|
|
|
foreach (DataRow drPlan in dtPlan.Rows)
|
|
{
|
|
foreach (DataRow drACTION in dtACTION.Rows)
|
|
{
|
|
IList<SiaSun.LMS.Model.FLOW_PARA> lsFLOW_PARA = this._S_FlowService.FlowGetParameters("FLOW_PLAN");
|
|
|
|
string[] aFLOW_PARA = new string[lsFLOW_PARA.Count];
|
|
|
|
int i = 0;
|
|
|
|
foreach (SiaSun.LMS.Model.FLOW_PARA mFLOW_PARA in lsFLOW_PARA)
|
|
{
|
|
aFLOW_PARA[i] = drPlan[mFLOW_PARA.FLOW_PARA_CODE].ToString();
|
|
|
|
i++;
|
|
}
|
|
|
|
SiaSun.LMS.Model.PLAN_ACTION_EXCUTE mPLAN_ACTION_EXCUTE = new SiaSun.LMS.Model.PLAN_ACTION_EXCUTE();
|
|
|
|
mPLAN_ACTION_EXCUTE.PLAN_ID = Convert.ToInt32(drPlan["PLAN_ID"]);
|
|
|
|
mPLAN_ACTION_EXCUTE.ACTION_EVENT = string.Format(drACTION["FLOW_ACTION_EVENT"].ToString(), aFLOW_PARA);
|
|
|
|
bResult = this._S_FlowService.EventExecute(mPLAN_ACTION_EXCUTE.ACTION_EVENT, out sResult);
|
|
}
|
|
}
|
|
|
|
if (bResult)
|
|
{
|
|
mPLAN_MAIN.PLAN_BEGIN_TIME = SiaSun.LMS.Common.StringUtil.GetDateTime();
|
|
|
|
bResult = this.PlanExcuteDefault(PLAN_ID, out sResult);
|
|
}
|
|
|
|
return bResult;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 计划暂停
|
|
/// </summary>
|
|
/// <param name="PLAN_ID">计划编号</param>
|
|
/// <param name="sResult">返回结果</param>
|
|
/// <returns></returns>
|
|
public bool PlanPause(int PLAN_ID, out string sResult)
|
|
{
|
|
bool bResult = true;
|
|
|
|
sResult = string.Empty;
|
|
|
|
SiaSun.LMS.Model.PLAN_MAIN mPLAN_MAIN = this._P_PLAN_MAIN.GetModel(PLAN_ID);
|
|
|
|
if (null == mPLAN_MAIN)
|
|
{
|
|
bResult = false;
|
|
|
|
sResult = string.Format("未找到计划{0}", PLAN_ID);
|
|
|
|
return bResult;
|
|
}
|
|
|
|
try
|
|
{
|
|
this._P_Base_House.BeginTransaction();
|
|
|
|
mPLAN_MAIN.PLAN_STATUS = SiaSun.LMS.Enum.PLAN_STATUS.Waiting.ToString();
|
|
|
|
this._P_PLAN_MAIN.Update(mPLAN_MAIN);
|
|
|
|
this._P_Base_House.CommitTransaction();
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
bResult = false;
|
|
|
|
sResult = ex.Message;
|
|
|
|
this._P_Base_House.RollBackTransaction();
|
|
}
|
|
|
|
return bResult;
|
|
}
|
|
|
|
|
|
//====================
|
|
|
|
public bool Invoke(string sPlanType, string sMethod, object[] inParams, out string sResult)
|
|
{
|
|
bool bResult = true;
|
|
|
|
sResult = string.Empty;
|
|
|
|
string sClassFullName = string.Format("SiaSun.LMS.Implement.{0}", sPlanType);
|
|
|
|
List<object> oPara = inParams.ToList<object>();
|
|
|
|
oPara.Add(sResult);
|
|
|
|
Type t = this.GetType();
|
|
|
|
Assembly complierAssembly = t.Assembly;
|
|
|
|
object complierInstance = complierAssembly.CreateInstance(sClassFullName);
|
|
|
|
Type type = complierInstance.GetType();
|
|
|
|
object[] obj = oPara.ToArray();
|
|
|
|
object oResult = null;
|
|
|
|
//创建反射的所有公用方法
|
|
MethodInfo[] lsMethodInfo = type.GetMethods();
|
|
|
|
foreach (MethodInfo methodInfo in lsMethodInfo)
|
|
{
|
|
if (methodInfo.Name.Equals(sMethod) && oPara.Count.Equals(methodInfo.GetParameters().Length))
|
|
{
|
|
oResult = methodInfo.Invoke(complierInstance, obj);
|
|
|
|
break;
|
|
}
|
|
}
|
|
|
|
bResult = Convert.ToBoolean(oResult);
|
|
|
|
sResult = obj[oPara.Count - 1].ToString();
|
|
|
|
return bResult;
|
|
}
|
|
|
|
|
|
public bool Invoke(string sPlanType, string sMethod, object[] inParams, out object[] outParams)
|
|
{
|
|
bool bResult = true;
|
|
|
|
string sClassFullName = string.Format("SiaSun.LMS.Implement.{0}", sPlanType);
|
|
|
|
List<object> oPara = inParams.ToList<object>();
|
|
|
|
Type t = this.GetType();
|
|
|
|
Assembly complierAssembly = t.Assembly;
|
|
|
|
object complierInstance = complierAssembly.CreateInstance(sClassFullName);
|
|
|
|
Type type = complierInstance.GetType();
|
|
|
|
outParams = oPara.ToArray();
|
|
|
|
object oResult = null;
|
|
|
|
//创建反射的所有公用方法
|
|
MethodInfo[] lsMethodInfo = type.GetMethods();
|
|
|
|
foreach (MethodInfo methodInfo in lsMethodInfo)
|
|
{
|
|
if (methodInfo.Name.Equals(sMethod) && oPara.Count.Equals(methodInfo.GetParameters().Length))
|
|
{
|
|
oResult = methodInfo.Invoke(complierInstance, outParams);
|
|
|
|
break;
|
|
}
|
|
}
|
|
|
|
bResult = Convert.ToBoolean(oResult);
|
|
|
|
return bResult;
|
|
}
|
|
|
|
|
|
#region ------PLAN_TYPE
|
|
|
|
|
|
/// <summary>
|
|
/// 获得所有列表
|
|
/// </summary>
|
|
public DataTable PlanTypeGetData()
|
|
{
|
|
return this.GetList("");
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
/// 获得PLAN_TYPE模型
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public SiaSun.LMS.Model.PLAN_TYPE PlanTypeGetModel(string PLAN_TYPE_CODE)
|
|
{
|
|
return this._P_PLAN_TYPE.GetModel(1);
|
|
}
|
|
|
|
#endregion
|
|
|
|
#region ------PLAN_MAIN
|
|
|
|
/// <summary>
|
|
/// 获得PLAN模型
|
|
/// </summary>
|
|
public SiaSun.LMS.Model.PLAN_MAIN PlanGetModel(int PLAN_ID)
|
|
{
|
|
return this._P_PLAN_MAIN.GetModel(PLAN_ID);
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
/// 获得PLAN模型
|
|
/// </summary>
|
|
public SiaSun.LMS.Model.PLAN_DETAIL PlanDetailGetModel(int PLAN_DETAIL_ID)
|
|
{
|
|
return this._P_PLAN_DETAIL.GetModel(PLAN_DETAIL_ID);
|
|
}
|
|
|
|
|
|
#endregion
|
|
|
|
#region -------PLAN_LIST
|
|
|
|
/// <summary>
|
|
/// 获得PLANLIST模型
|
|
/// </summary>
|
|
public SiaSun.LMS.Model.PLAN_LIST PlanListGetModel(int PLAN_LIST_ID)
|
|
{
|
|
return this._P_PLAN_LIST.GetModel(PLAN_LIST_ID);
|
|
}
|
|
|
|
#endregion
|
|
|
|
public bool PlanDownLoad(int PLAN_ID, out string sResult)
|
|
{
|
|
bool bResult = true;
|
|
|
|
sResult = string.Empty;
|
|
|
|
//Model.PLAN_MAIN mPLAN_MAIN = this._P_PLAN_MAIN.GetModel(PLAN_ID);
|
|
|
|
//bResult = mPLAN_MAIN != null;
|
|
|
|
//if (!bResult)
|
|
//{
|
|
// sResult = string.Format("未找到计划{0}", PLAN_ID.ToString());
|
|
|
|
// return bResult;
|
|
//}
|
|
|
|
//IList<SiaSun.LMS.Model.PLAN_LIST> lsPLAN_LIST = this._P_PLAN_LIST.GetListPlanID(PLAN_ID);
|
|
|
|
//List<int> lsEND_CELL_ID = new List<int>();
|
|
|
|
//Model.WH_CELL mWH_CELL_END = null;
|
|
|
|
//IList<SiaSun.LMS.Model.WH_CELL> lsEND_CELL = null;
|
|
|
|
//bResult = !string.IsNullOrEmpty(mPLAN_MAIN.PLAN_INOUT_STATION);
|
|
|
|
//if (!bResult)
|
|
//{
|
|
// sResult = string.Format("传入站台为空-任务号为{0}", mPLAN_MAIN.PLAN_CODE);
|
|
|
|
// return bResult;
|
|
//}
|
|
|
|
//mWH_CELL_END = this._P_WH_CELL.GetModel(mPLAN_MAIN.PLAN_INOUT_STATION);
|
|
|
|
//bResult = null != mWH_CELL_END;
|
|
|
|
//if (!bResult)
|
|
//{
|
|
// sResult = string.Format("未找到站台{0}-任务号为{1}", mPLAN_MAIN.PLAN_INOUT_STATION, mPLAN_MAIN.PLAN_CODE);
|
|
|
|
// return bResult;
|
|
//}
|
|
|
|
//if (!mWH_CELL_END.LANE_WAY.Equals(0))
|
|
//{
|
|
// lsEND_CELL = this._P_WH_CELL.GetList_LANEWAY(mWH_CELL_END.LANE_WAY);
|
|
//}
|
|
|
|
//if (lsEND_CELL != null && lsEND_CELL.Count > 0)
|
|
//{
|
|
// foreach (WH_CELL mWH_CELL in lsEND_CELL)
|
|
// {
|
|
// lsEND_CELL_ID.Add(mWH_CELL.CELL_ID);
|
|
// }
|
|
|
|
// lsEND_CELL_ID.Remove(mWH_CELL_END.CELL_ID);
|
|
|
|
// lsEND_CELL_ID.Insert(0, mWH_CELL_END.CELL_ID);
|
|
//}
|
|
//else
|
|
//{
|
|
// lsEND_CELL_ID.Add(mWH_CELL_END.CELL_ID);
|
|
//}
|
|
|
|
//try
|
|
//{
|
|
// this._P_Base_House.BeginTransaction();
|
|
|
|
// foreach (Model.PLAN_LIST mPLAN_LIST in lsPLAN_LIST)
|
|
// {
|
|
|
|
// bResult = this.PlanListDownLoad( mPLAN_LIST.PLAN_LIST_ID, out sResult);
|
|
|
|
// if (!bResult)
|
|
// {
|
|
// return bResult;
|
|
// }
|
|
// }
|
|
|
|
// //更新计划状态
|
|
// mPLAN_MAIN.PLAN_STATUS = Enum.PLAN_STATUS.Executing.ToString();
|
|
|
|
// this._P_PLAN_MAIN.Update(mPLAN_MAIN);
|
|
//}
|
|
//catch (Exception ex)
|
|
//{
|
|
// bResult = false;
|
|
|
|
// sResult = ex.ToString();
|
|
//}
|
|
//finally
|
|
//{
|
|
// if (bResult)
|
|
// {
|
|
// this._P_Base_House.CommitTransaction();
|
|
// }
|
|
// else
|
|
// {
|
|
// this._P_Base_House.RollBackTransaction();
|
|
// }
|
|
//}
|
|
|
|
return bResult;
|
|
}
|
|
|
|
|
|
public bool PlanListDownLoad(Model.SYS_USER mSYS_USER, int PLAN_LIST_ID, int END_CELL_ID, bool bTrans, out string sResult)
|
|
{
|
|
bool bResult = true;
|
|
|
|
sResult = string.Empty;
|
|
|
|
string sMsg = string.Empty;
|
|
|
|
SiaSun.LMS.Model.PLAN_LIST mPLAN_LIST = this._P_PLAN_LIST.GetModel(PLAN_LIST_ID);
|
|
|
|
SiaSun.LMS.Model.PLAN_MAIN mPLAN_MAIN = this._P_PLAN_MAIN.GetModel(mPLAN_LIST.PLAN_ID);
|
|
|
|
SiaSun.LMS.Model.PLAN_TYPE mPLAN_TYPE = this._P_PLAN_TYPE.GetModelPlanTypeCode(mPLAN_MAIN.PLAN_TYPE_CODE);
|
|
|
|
int iSTART_CELL_ID = 0;
|
|
|
|
string STOCK_BARCODE = string.Empty;
|
|
|
|
decimal MANAGE_ORDERED_QUANTITY = 0;
|
|
|
|
System.Data.DataTable dtLANEWAY = null;
|
|
|
|
bResult = this._S_CellService.LaneWayGetList(END_CELL_ID, mPLAN_LIST.GOODS_ID, string.Empty, out dtLANEWAY, out sResult);
|
|
|
|
if (!bResult)
|
|
{
|
|
return bResult;
|
|
}
|
|
|
|
int iSumQuantity = 0;
|
|
|
|
foreach (DataRow drLANEWAY in dtLANEWAY.Rows)
|
|
{
|
|
iSumQuantity += Convert.ToInt32(drLANEWAY["LANEWAY_QUANTITY"]);
|
|
}
|
|
|
|
bResult = iSumQuantity >= Convert.ToInt32(mPLAN_LIST.PLAN_LIST_QUANTITY) - Convert.ToInt32(mPLAN_LIST.PLAN_LIST_ORDERED_QUANTITY);
|
|
|
|
if (!bResult)
|
|
{
|
|
sResult = string.Format("计划执行失败。计划出库数量为{1},当前可用库存为{0},", iSumQuantity, mPLAN_LIST.PLAN_LIST_QUANTITY.ToString());
|
|
|
|
return bResult;
|
|
}
|
|
|
|
try
|
|
{
|
|
this._P_Base_House.BeginTransaction(bTrans);
|
|
|
|
while (mPLAN_LIST.PLAN_LIST_QUANTITY > mPLAN_LIST.PLAN_LIST_ORDERED_QUANTITY)
|
|
{
|
|
|
|
decimal MANAGE_LIST_QUANTITY = mPLAN_LIST.PLAN_LIST_QUANTITY - mPLAN_LIST.PLAN_LIST_ORDERED_QUANTITY;
|
|
|
|
//判断计划是否已经全部下达
|
|
if (MANAGE_LIST_QUANTITY <= 0)
|
|
{
|
|
break;
|
|
}
|
|
|
|
DataView dvLANEWAY = dtLANEWAY.DefaultView;
|
|
|
|
dvLANEWAY.RowFilter = "LANEWAY_QUANTITY > 0";
|
|
|
|
dvLANEWAY.Sort = "MANAGE_QUANTITY asc,LANEWAY_QUANTITY desc";
|
|
|
|
bResult = dvLANEWAY.Count > 0;
|
|
|
|
if (!bResult)
|
|
{
|
|
sResult = "满足条件的库存数量不足，注意自动校表线只能出满垛（24只）";
|
|
|
|
this._P_Base_House.RollBackTransaction(bTrans);
|
|
|
|
return bResult;
|
|
}
|
|
|
|
int iLANEWAY = Convert.ToInt32(dvLANEWAY[0]["LANE_WAY"]);
|
|
|
|
bResult = this._S_CellService.CellOutAllocate(iLANEWAY, END_CELL_ID, mPLAN_LIST.GOODS_ID, string.Empty, MANAGE_LIST_QUANTITY, out iSTART_CELL_ID, out STOCK_BARCODE, out MANAGE_ORDERED_QUANTITY, out sResult);
|
|
|
|
if (!bResult)
|
|
{
|
|
dvLANEWAY[0]["LANEWAY_QUANTITY"] = 0;
|
|
|
|
break;
|
|
|
|
}
|
|
|
|
bResult = new SiaSun.LMS.Implement.ManageBase().ManageCreate(mSYS_USER, PLAN_LIST_ID, mPLAN_TYPE.MANAGE_TYPE_CODE, STOCK_BARCODE, iSTART_CELL_ID, END_CELL_ID, false, true, false, out sResult);
|
|
|
|
if (!bResult)
|
|
{
|
|
sResult += sMsg;
|
|
|
|
this._P_Base_House.RollBackTransaction(bTrans);
|
|
|
|
return bResult;
|
|
}
|
|
|
|
decimal dLANEWAY_QUANTITY_SUB = Convert.ToDecimal(dvLANEWAY[0].Row["LANEWAY_QUANTITY"]) - MANAGE_ORDERED_QUANTITY;
|
|
|
|
dvLANEWAY[0].Row["LANEWAY_QUANTITY"] = dLANEWAY_QUANTITY_SUB;
|
|
|
|
if (dLANEWAY_QUANTITY_SUB > 0)
|
|
{
|
|
dvLANEWAY[0].Row["MANAGE_QUANTITY"] = Convert.ToDecimal(dvLANEWAY[0].Row["MANAGE_QUANTITY"]) + 1;
|
|
}
|
|
|
|
mPLAN_LIST = this._P_PLAN_LIST.GetModel(PLAN_LIST_ID);
|
|
|
|
}
|
|
|
|
this._P_Base_House.CommitTransaction(bTrans);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
this._P_Base_House.RollBackTransaction(bTrans);
|
|
|
|
bResult = false;
|
|
|
|
sResult = ex.Message;
|
|
}
|
|
|
|
return bResult;
|
|
}
|
|
|
|
|
|
public bool PlanDetailDownLoad(int PLAN_ID, out string sResult)
|
|
{
|
|
bool bResult = true;
|
|
|
|
sResult = string.Empty;
|
|
|
|
return bResult;
|
|
}
|
|
|
|
|
|
#region ------根据筛选条件选择出库
|
|
|
|
///// <summary>
|
|
///// 根据出库规则，库存，创建出库任务
|
|
///// </summary>
|
|
//public bool CreateOutTask_Rule(SYS_USER mUSER, int PLAN_ID, string PLAN_TYPE_CODE, decimal SumQuantity, string BoxNo_Start, string BoxNo_End, string Where, out string strResult)
|
|
//{
|
|
// bool boolResult = true;
|
|
// strResult = null;
|
|
// string strWhere = null;
|
|
|
|
// //校验参数是否合法
|
|
// if (SumQuantity < 0 && (string.IsNullOrEmpty(BoxNo_Start) || string.IsNullOrEmpty(BoxNo_End)))
|
|
// {
|
|
// boolResult = false;
|
|
// strResult = string.Format("请检查传入参数是否合法！");
|
|
// return boolResult;
|
|
// }
|
|
|
|
// //判断出库规则
|
|
// if (!string.IsNullOrEmpty(BoxNo_Start) && !string.IsNullOrEmpty(BoxNo_End))
|
|
// {
|
|
// strWhere = string.Format("{0} AND (BOX_NO BETWEEN '{1}' AND '{2}')", string.IsNullOrEmpty(Where) ? "1=1" : Where, BoxNo_Start, BoxNo_End);
|
|
// }
|
|
// else
|
|
// {
|
|
// strWhere = string.Format("{0}", string.IsNullOrEmpty(Where) ? "1=1" : Where);
|
|
// }
|
|
// try
|
|
// {
|
|
// //获得满足条件的库存
|
|
// using (DataTable tableStorageList = this.GetTable(string.Format("SELECT * FROM V_STORAGE_LIST WHERE {0}", strWhere)))
|
|
// {
|
|
// if (tableStorageList.Rows.Count <= 0)
|
|
// {
|
|
// boolResult = false;
|
|
// strResult = string.Format("库存不存在，请检查库存！");
|
|
// return boolResult;
|
|
// }
|
|
// decimal delSum = 0;
|
|
// List<string> listStockBarCode = new List<string>();
|
|
|
|
// //获得数组
|
|
// DataRow[] arStorageList = tableStorageList.Rows.Cast<DataRow>().ToArray();
|
|
// //按照箱序号、生产日期排序并分组
|
|
// var groupStock = from ar in arStorageList orderby ar["BATCH_NO"].ToString(), ar["BOX_NO"] group ar by ar["STOCK_BARCODE"].ToString() into a select a;
|
|
// //遍历所有托盘，对比数量
|
|
// foreach (var stock in groupStock)
|
|
// {
|
|
// //计算数量
|
|
// if (SumQuantity <= 0 || (SumQuantity > 0 && delSum <= SumQuantity))
|
|
// {
|
|
// //获得托盘条码
|
|
// string strStockBarCode = stock.Key;
|
|
// //获得该托盘内物料总数
|
|
// var queryStock = from ar in arStorageList where ar["STOCK_BARCODE"].ToString() == strStockBarCode select ar;
|
|
// delSum += queryStock.Sum(r => Convert.ToDecimal(r["STORAGE_LIST_QUANTITY"]));
|
|
// //加入列表
|
|
// listStockBarCode.Add(strStockBarCode);
|
|
// }
|
|
// }
|
|
|
|
// //将所有托盘出库
|
|
// boolResult = this.CreateOutTask_List(mUSER, PLAN_ID, PLAN_TYPE_CODE, listStockBarCode, out strResult);
|
|
// }
|
|
// }
|
|
// catch (Exception ex)
|
|
// {
|
|
// boolResult = false;
|
|
// strResult = ex.Message;
|
|
// }
|
|
// return boolResult;
|
|
//}
|
|
|
|
///// <summary>
|
|
///// 创建出库任务
|
|
///// </summary>
|
|
//public bool CreateOutTask_List(SYS_USER mUSER, int PLAN_ID, string PLAN_TYPE_CODE, List<string> StockBarCodeList, out string strResult)
|
|
//{
|
|
// bool boolResult = true;
|
|
// strResult = null;
|
|
|
|
// //获得库区列表
|
|
// IList<WH_AREA> listWH_AREA = this._P_WH_AREA.GetList();
|
|
// //获得目标库区
|
|
// int intEndAreaID = listWH_AREA.First(r => r.AREA_TYPE == Enum.AREA_TYPE.XuNiKu.ToString()).AREA_ID;
|
|
|
|
// //遍历所有托盘
|
|
// foreach (string strStockBarCode in StockBarCodeList)
|
|
// {
|
|
// //获得库存
|
|
// STORAGE_MAIN mSTORAGE_MAIN = this._P_STORAGE_MAIN.GetModel_STOCK_BARCODE(strStockBarCode);
|
|
// if (mSTORAGE_MAIN != null)
|
|
// {
|
|
// //获得库存位置
|
|
// WH_CELL mWH_CELL_Start = this._P_WH_CELL.GetModel(mSTORAGE_MAIN.CELL_ID);
|
|
// if (mWH_CELL_Start != null)
|
|
// {
|
|
// //获得组盘实例
|
|
// Model.Stack mStack = this._S_StorageService.GetStack_CellID_Storage(PLAN_ID, mWH_CELL_Start.CELL_ID);
|
|
// //任务参数
|
|
// ManageCreateParam mParam = new ManageCreateParam(true,
|
|
// mUSER,
|
|
// PLAN_ID,
|
|
// null,
|
|
// 0,
|
|
// PLAN_TYPE_CODE,
|
|
// null,
|
|
// mWH_CELL_Start.AREA_ID,
|
|
// mWH_CELL_Start.CELL_ID,
|
|
// intEndAreaID,
|
|
// 0,
|
|
// mStack);
|
|
// //创建出库任务
|
|
// int intManageID = 0;
|
|
// boolResult = this._S_TaskService.MANAGE_Create_Task(mParam, out intManageID, out strResult);
|
|
// }
|
|
// }
|
|
// }
|
|
|
|
// return boolResult;
|
|
//}
|
|
|
|
#endregion
|
|
|
|
|
|
|
|
}
|
|
}
|