You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

300 lines
8.9 KiB
Plaintext

This file contains ambiguous Unicode characters!

This file contains ambiguous Unicode characters that may be confused with others in your current locale. If your use case is intentional and legitimate, you can safely ignore this warning. Use the Escape button to highlight these characters.

using System;
using System.Collections.Generic;
using System.Data;
using System.Text;
using BP.WF.Data;
using BP.En;
namespace BP.MES
{
/// <summary>
/// 箱体订单 Attr
/// </summary>
public class ND1RptAttr : NDXRptBaseAttr
{
#region 基本属性
/// <summary>
/// 箱体名称
/// </summary>
public const string XiangTiMingCheng = "XiangTiMingCheng";
/// <summary>
/// 订单号
/// </summary>
public const string DingDanHao = "DingDanHao";
/// <summary>
/// 项目名称
/// </summary>
public const string PrjName = "PrjName";
/// <summary>
/// 期限限定
/// </summary>
public const string QiXianXianDing = "QiXianXianDing";
/// <summary>
/// 紧急程度
/// </summary>
public const string JJCD = "JJCD";
public const string JJCDText = "JJCDText";
/// <summary>
/// 图纸编号
/// </summary>
public const string TuZhiBianHao = "TuZhiBianHao";
/// <summary>
/// 图纸制图人
/// </summary>
public const string TuZhiZhiTuRen = "TuZhiZhiTuRen";
/// <summary>
/// 装配负责人
/// </summary>
public const string ZhuangPeiFuZeRen = "ZhuangPeiFuZeRen";
/// <summary>
/// 检测负责人
/// </summary>
public const string JianCeFuZeRen = "JianCeFuZeRen";
/// <summary>
/// 封装人
/// </summary>
public const string FengZhuangRen = "FengZhuangRen";
/// <summary>
/// 客户信息
/// </summary>
public const string KeHuMingCheng = "KeHuMingCheng";
#endregion
}
/// <summary>
/// 箱体订单
/// </summary>
public class ND1Rpt : NDXRptBase
{
#region 属性
/// <summary>
/// 请假人部门名称
/// </summary>
public string TuZhiBianHao
{
get
{
return this.GetValStringByKey(ND1RptAttr.TuZhiBianHao);
}
set
{
this.SetValByKey(ND1RptAttr.TuZhiBianHao, value);
}
}
public string DingDanHao
{
get
{
return this.GetValStringByKey(ND1RptAttr.DingDanHao);
}
set
{
this.SetValByKey(ND1RptAttr.TuZhiBianHao, DingDanHao);
}
}
public string PrjName
{
get
{
return this.GetValStringByKey(ND1RptAttr.PrjName);
}
set
{
this.SetValByKey(ND1RptAttr.PrjName, value);
}
}
public string XiangTiMingCheng
{
get
{
return this.GetValStringByKey(ND1RptAttr.XiangTiMingCheng);
}
set
{
this.SetValByKey(ND1RptAttr.XiangTiMingCheng, value);
}
}
/// <summary>
/// 请假人编号
/// </summary>
public string TuZhiZhiTuRen
{
get
{
return this.GetValStringByKey(ND1RptAttr.TuZhiZhiTuRen);
}
set
{
this.SetValByKey(ND1RptAttr.TuZhiZhiTuRen, value);
}
}
/// <summary>
/// 请假人名称
/// </summary>
public string ZhuangPeiFuZeRen
{
get
{
return this.GetValStringByKey(ND1RptAttr.ZhuangPeiFuZeRen);
}
set
{
this.SetValByKey(ND1RptAttr.ZhuangPeiFuZeRen, value);
}
}
/// <summary>
/// 请假人部门编号
/// </summary>
public int JJCD
{
get
{
return this.GetValIntByKey(ND1RptAttr.JJCD);
}
set
{
this.SetValByKey(ND1RptAttr.JJCD, value);
}
}
/// <summary>
/// 总经理意见
/// </summary>
public string JJCDText
{
get
{
return this.GetValRefTextByKey(ND1RptAttr.JJCD);
}
}
/// <summary>
/// 人力资源意见
/// </summary>
#endregion
#region 构造函数
/// <summary>
/// 请假
/// </summary>
public ND1Rpt()
{
}
/// <summary>
/// 请假
/// </summary>
/// <param name="workid">工作ID</param>
public ND1Rpt(Int64 workid)
{
this.OID = workid;
this.Retrieve();
}
/// <summary>
/// 重写基类方法
/// </summary>
public override Map EnMap
{
get
{
if (this._enMap != null)
return this._enMap;
Map map = new Map("ND1Rpt", "箱体订单");
#region 流程的基本字段
map.AddTBIntPKOID();
map.AddTBString(ND1RptAttr.Title, null, "标题", false, true, 0, 500, 10);
map.AddTBString(ND1RptAttr.BillNo, null, "编号", false, true, 0, 50, 10);
// map.AddDDLSysEnum(ND1RptAttr.WFState, 0, "状态", false, true, "WFState");
//map.AddTBInt(ND1RptAttr.FID, 0, "FID", false, true);
//map.AddTBInt(ND1RptAttr.FlowDaySpan, 0, "跨度", false, true);
// map.AddTBString(ND1RptAttr.KeHuMingCheng, null, "客户名称", false, true, 0, 50, 10);
map.AddTBString(ND1RptAttr.DingDanHao, null, "订单号", true, true, 0, 50, 10);
map.AddTBString(ND1RptAttr.PrjName, null, "项目名称", true, true, 0, 50, 10);
map.AddTBString(ND1RptAttr.KeHuMingCheng, null, "客户名称", false, true, 0, 50, 10);
map.AddTBString(ND1RptAttr.QiXianXianDing, null, "期限限定", true, true, 0, 50, 10);
map.AddDDLSysEnum(ND1RptAttr.JJCD, 0, "紧急程度", true, true, ND1RptAttr.JJCD, "@0=低@1=中@2=高");
map.AddTBString(ND1RptAttr.TuZhiBianHao, null, "图纸编号", true, true, 0, 50, 10);
map.AddTBString(ND1RptAttr.TuZhiZhiTuRen, null, "图纸制图人", true, true, 0, 50, 10);
map.AddTBString(ND1RptAttr.XiangTiMingCheng, null, "箱体名称", true, true, 0, 50, 10);
//map.AddTBString(ND1RptAttr.ZhuangPeiFuZeRen, null, "装配负责人", true, true, 0, 50, 10);
//map.AddTBString(ND1RptAttr.JianCeFuZeRen, null, "检测负责人", true, true, 0, 50, 10);
//map.AddTBString(ND1RptAttr.FengZhuangRen, null, "封装人", true, true, 0, 50, 10);
map.AddTBInt(ND1RptAttr.PWorkID, 0, "父流程ID", true, true);
// map.AddTBString(ND1RptAttr.FaHuoRen, null, "发货人", false, true, 0, 100, 10);
#endregion 流程的基本字段
this._enMap = map;
return this._enMap;
}
}
#endregion
/// <summary>
/// 检查是否可以发送.
/// </summary>
/// <returns></returns>
public string Work_CheckIsOverAndSend()
{
BP.WF.GenerWorkFlow gwf = new WF.GenerWorkFlow(this.OID);
if (gwf.FK_Node != 102)
return "";
//获得重做与未完成的数据量: 如果是02则让其发送下去. 0=未检查, 2=重做的.
string sql = "SELECT count(OID) as Num FROM ND101Dtl1 WHERE RefPK = '" + this.OID + "' AND WorkSta in(0,2) ";
var val = BP.DA.DBAccess.RunSQLReturnValInt(sql);
if (val != 0)
return "";
//开始执行发送.
string msg = BP.WF.Dev2Interface.Node_SendWork("001", this.OID, 103, null).ToMsgOfText();
// string msg = BP.WF.Dev2Interface.Flow_ReSend(this.OID, 103, "zhoupeng", "运动到").ToMsgOfText();
return msg;
}
}
/// <summary>
/// 箱体订单s
/// </summary>
public class ND1Rpts : NDXRptBases
{
public string MyReWork_Init()
{
//2 重做
string sql = "SELECT OID, Title, WorkSta, Worker,count(OID) as Num FROM V_WorkDtl WHERE Worker = '" + BP.Web.WebUser.No + "' AND WorkSta=2 GROUP BY Title,WorkSta,Worker,OID ";
DataTable dt = BP.DA.DBAccess.RunSQLReturnTable(sql);
return BP.Tools.Json.ToJson(dt);
}
#region 方法
/// <summary>
/// 得到它的 Entity
/// </summary>
public override Entity GetNewEntity
{
get
{
return new ND1Rpt();
}
}
/// <summary>
/// 请假s
/// </summary>
public ND1Rpts() { }
#endregion
}
}