| | |
|---|
| | | { |
|---|
| | | string sql = @"SELECT A.id, ISNULL(C.createtime,'1990-01-01') as createtime, ISNULL(C.updatetime,'1990-01-01') as updatetime, A.code AS placecode, A.status, |
|---|
| | | A.islock, A.isexecute, B.name as placetypename, B.remark as placetyperemark, D.name, D.code AS materialcode, D.description, D.typeremark, D.typename, |
|---|
| | | ISNULL(D.status,0) AS materialstatus, A.id as placeid, ISNULL(C.materialid,0) as materialid, D.remark, A.layer, A.col, A.row, A.typeid as placetypeid |
|---|
| | | ISNULL(D.status,0) AS materialstatus, A.id as placeid, ISNULL(C.materialid,0) as materialid, D.remark, A.layer, A.col, A.row, A.typeid as placetypeid, |
|---|
| | | D.thick, D.wide, D.length,D.IssueProjectNo,D.ProcurementProjectNo,D.SerialNo,D.ClassificationSociety,D.CuttingType,D.Version |
|---|
| | | FROM dbo.BASEPlace AS A LEFT OUTER JOIN |
|---|
| | | dbo.BASEPlaceType AS B ON A.typeid = B.id LEFT OUTER JOIN |
|---|
| | | dbo.BASEPlaceMaterial as C on A.id=C.placeid LEFT OUTER JOIN |
|---|
