Advertisement
Guest User

Untitled

a guest
Apr 16th, 2014
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.17 KB | None | 0 0
  1. var list =
  2. (from spcdata_tb in _dbContext.SPCDATA_TB
  3. from wh_master_tb in _dbContext.WH_MASTER_TB
  4. where spcdata_tb.FACTORY_CODE == factoryCode
  5. && spcdata_tb.LINE_CODE == lineCode
  6. && spcdata_tb.MODEL_NO == modelNumber
  7. && spcdata_tb.FACTORY_CODE == wh_master_tb.WH_CODE
  8. && spcdata_tb.LINE_CODE == wh_master_tb.LINE_CODE
  9. select new SPCMeasureData()
  10. {
  11. operDateString = spcdata_tb.DATA_WDATE,
  12. operTimeString = spcdata_tb.DATA_WTIME,
  13. inputTimeString = spcdata_tb.DATA_ITIME,
  14. modelNumString = spcdata_tb.MODEL_NO,
  15. DataList[0] = spcdata_tb.DATA1,
  16. DataList[1] = spcdata_tb.DATA2,
  17. DataList[2] = spcdata-tb.DATA3
  18. });
  19.  
  20. public class SPCMeasureData
  21. {
  22. public DateTime operDateString { get; set; }
  23. public TimeSpan? operTimeString { get; set; }
  24. public TimeSpan? inputTimeString { get; set; }
  25. public string modelNumString { get; set; }
  26. public string modelNameString { get; set; }
  27. public string lotNumString { get; set; }
  28. public int dataSeqString { get; set; }
  29. public string factoryCodeString { get; set; }
  30. public string factoryNameString { get; set; }
  31. public string lineCodeString { get; set; }
  32. public string lineNameString { get; set; }
  33. public string cusNameString { get; set; }
  34. public string equipNumString { get; set; }
  35. public float?[] dataList = new float?[30];
  36.  
  37. public float?[] DataList
  38. {
  39. get { return dataList; }
  40. set { dataList = value; }
  41. }
  42. }
  43.  
  44. public class OtherClass
  45. {
  46. public string Prop1 { get; set; }
  47. }
  48.  
  49. public class MainClass
  50. {
  51. public OtherClass ComplexProperty { get; set; }
  52. public float?[] ArrayFloatProperty { get; set; }
  53. public List<string> CollectionProperty { get; set; }
  54. }
  55.  
  56. var mainObj = new MainClass
  57. {
  58. ArrayFloatProperty = new float? [] {0f, 2f, 3f},
  59. ComplexProperty = new OtherClass { Prop1 = "string property" },
  60. CollectionProperty = new List<string> { "str1", "str2", "str3" }
  61. };
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement