PMMachine.cs 3.1 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374
  1. using Cksoft.Unity;
  2. using System;
  3. namespace DllEapEntity.PM
  4. {
  5. [Table("pmmachine")]
  6. public class PMMachine:BaseEntity
  7. {
  8. ////自动产生代码开始&&此行不能删除
  9. #region 自动产生代码
  10. public PMMachine()
  11. {
  12. base.EntityStatusID = 1;
  13. }
  14. [ColDetail(10,"ID",1,1,100,1,"a.ID","",1,1)]
  15. [Key]
  16. [Identity]
  17. public int ID { get; set; }
  18. [ColDetail(20,"主档ID",1,1,100,1,"a.MacID","",1,1)]
  19. public int MacID { get; set; }
  20. [ColDetail(30,"上级ID",1,1,100,1,"a.PMID","",1,1)]
  21. public int PMID { get; set; }
  22. [ColDetail(40,"开始时间",1,1,100,1,"a.StartTime","",1,1)]
  23. public DateTime StartTime { get; set; }
  24. [ColDetail(50,"备注",1,1,100,1,"a.Remark","",1,1)]
  25. public string Remark { get; set; }
  26. [ColDetail(60,"录入人代码",1,1,100,1,"a.RecCode","",1,1)]
  27. public string RecCode { get; set; }
  28. [ColDetail(70,"录入日期",1,1,100,1,"a.RecTime","",1,1)]
  29. public DateTime RecTime { get; set; }
  30. [ColDetail(80,"修改 人代码",1,1,100,1,"a.ModCode","",1,1)]
  31. public string ModCode { get; set; }
  32. [ColDetail(90,"修改时间",1,1,100,1,"a.ModTime","",1,1)]
  33. public DateTime ModTime { get; set; }
  34. [ColDetail(100,"机台代码",1,0,100,1,"b.FCode","",1,1)]
  35. public string MacCode { get; set; }
  36. [ColDetail(110,"机台名称",1,0,100,1,"b.FName","",1,1)]
  37. public string MacFName { get; set; }
  38. [ColDetail(120,"方案代码",1,0,100,1,"c.FCode","",1,1)]
  39. public string PMCode { get; set; }
  40. [ColDetail(130,"方案名称",1,0,100,1,"c.FName","",1,1)]
  41. public string PMName { get; set; }
  42. [ColDetail(140,"录入人",1,0,100,1,"d.FName","",1,1)]
  43. public string RecName { get; set; }
  44. [ColDetail(150,"修改人",1,0,100,1,"e.FName","",1,1)]
  45. public string ModName { get; set; }
  46. public override string GetSelectSql()
  47. {
  48. return string.Format($"select { GetQueryColSql()} from { GetQueryTabSql()}");
  49. }
  50. public override string GetQueryColSql()
  51. {
  52. string sqlstr = "a.ID ID,a.MacID MacID,a.PMID PMID,a.StartTime StartTime,a.Remark Remark,a.RecCode RecCode,a.RecTime RecTime,a.ModCode ModCode,a.ModTime ModTime";
  53. sqlstr += ",b.FCode MacCode,b.FName MacFName,c.FCode PMCode,c.FName PMName,d.FName RecName,e.FName ModName,0 EntityStatusID";
  54. return sqlstr;
  55. }
  56. public override string GetQueryTabSql()
  57. {
  58. string sqlstr=" pmmachine a ";
  59. sqlstr+=" left outer join machine b on a.MacID =b.id";
  60. sqlstr+=" left outer join pmschema c on a.PMID =c.id";
  61. sqlstr+=" left outer join staff d on a.RecCode =d.FCode";
  62. sqlstr+=" left outer join staff e on a.ModCode =e.FCode";
  63. return sqlstr;
  64. }
  65. public override string GetQuerySortSql()
  66. {
  67. return "";
  68. }
  69. #endregion
  70. ////自动产生代码结束&&此行不能删除
  71. }
  72. }