public IList <MM_LOTS_NAMEPLATE> QueryNamePlate(string saporderid)
{
string assyRule = sM_CONFIG_KEYBO.GetConfigKey("DepartAssy").sValue;
POM_TEMP_ERP_ORDER erpOrderModel = new POM_TEMP_ERP_ORDER();
erpOrderModel.SapOrderID = saporderid;
IList <POM_TEMP_ERP_ORDER> chkList = orderBO.GetEntities(erpOrderModel);
if (chkList.Count != 0)
{
if (!assyRule.Contains(chkList[0].DepartID))
{
return(null);
}
}
MM_LOTS_NAMEPLATE namePlateModel = new MM_LOTS_NAMEPLATE();
namePlateModel.SapOrderID = saporderid;
IList <MM_LOTS_NAMEPLATE> namePlateList = namePlateBO.GetMMEntites(namePlateModel);
return(namePlateList);
}
public string CreateNamePlate(POM_TEMP_ERP_ORDER param)
{
try
{
if (param == null)
{
return("请选择ERP工单");
}
//1.查询数量是否超过限定数量
IList <MM_LOTS_NAMEPLATE> entities = namePlateBO.GetEntities(param);
if (entities.Count >= param.Quantity)
{
return("局号已经足够，不允许生成局号");
}
string namePlatePro = param.Attribute05 + param.Attribute06; //前置值+后置值
string PlateStart = param.Attribute05; //前置值
string PlateEnd = param.Attribute06; //后置值
string serialNumber = param.Attribute04; //流水号
int status = 0;
if (param.Attribute07 == "流水号前置")
{
status = 1;
}
else if (param.Attribute07 == "流水号后置")
{
status = 2;
}
if (status == 0 || PlateStart == "" || PlateEnd == "" || serialNumber == "")
{
return("接收信息不全（前置、后置、流水号、类型都不允许为空），请重新操作");
}
//2.调存储过程，修改规则
string sqlRule = @" DECLARE @return_value int,
@Message nvarchar(255)
EXEC @return_value = [dbo].[CP_BARCOCODE_NAMEPLATE_CONFIG]
@Status = {0},
@PartStart = N'{1}',
@PartEnd = N'{2}',
@Serial = N'{3}',
@Message = @Message OUTPUT
SELECT @Message as N'@Message'" ;
sqlRule = string.Format(sqlRule, status, PlateStart, PlateEnd, serialNumber);
DataTable message = co_BSC_BO.GetDataTableBySql(sqlRule);
if (message.Rows[0][0].ToString() != "")
{
return(message.Rows[0][0].ToString());
}
//3.生成局号插入表中
IList <string> Code;
Code = pom_ORDER_EXTBO.CreateNameplate((int)param.Quantity, PlateStart, PlateEnd, param.Attribute07);
DateTime dtLot = SSGlobalConfig.Now;
//保存到表MM_LOTS_NAMEPLATE
List <MM_LOTS_NAMEPLATE> list = new List <MM_LOTS_NAMEPLATE>();
for (int i = 0; i < Code.Count; i++)
{
MM_LOTS_NAMEPLATE entity = new MM_LOTS_NAMEPLATE();
entity.NamePlate = Code[i];
entity.Sequence = i + 1;
entity.SapOrderID = param.SapOrderID;
entity.CreatedBy = param.Attribute08;
entity.CreatedOn = dtLot;
entity.UpdatedBy = param.Attribute08;
entity.UpdatedOn = entity.CreatedOn;
//namePlateBO.Insert(entity);
list.Add(entity);
}
if (list == null || list.Count == 0)
{
//do nothing
}
else
{
co_BSC_BO.ExcuteSqlTranction(list, "MM_LOTS_NAMEPLATE"); //批量插入
}
//修改POM_TEMP_ERP_ORDER状态
param.IsGenerated = true;
orderBO.UpdateSome(param);
return("生成流水号成功");
}
catch (Exception ex)
{
return(ex.Message.ToString());
}
}
