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

9 months ago
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
}
}