| | |
|---|
| | | string sql = string.Format(@"select b.HDotCheckItemID HDotCheckItemID,c.HNumber HDotCheckCode,b.HDotCheckItem,b.HDotCheckPart,b.HClaim, |
|---|
| | | b.HManagerID,e.HNumber HManagerCode,e.HName HManagerName,b.HRemark from Sb_EquipDotCheckRuleBillMain a |
|---|
| | | left join Sb_EquipDotCheckRuleBillSub b on a.HInterID=b.HInterID |
|---|
| | | left join Gy_QCCheckItem c on c.HItemID=b.HDotCheckItemID |
|---|
| | | left join Gy_DotCheck c on c.HItemID=b.HDotCheckItemID |
|---|
| | | left join Gy_Employee e on e.HItemID=b.HManagerID |
|---|
| | | where a.HInterID=" + HDotCheckRuleInterID); |
|---|
| | | ds = oCN.RunProcReturn(sql, "Sb_EquipDotCheckRuleBillMain"); |
|---|
| | |
|---|
| | | /// <returns></returns> |
|---|
| | | [Route("Web/GetHSourceBillType")] |
|---|
| | | [HttpGet] |
|---|
| | | public object GetHSourceBillType(string HName) |
|---|
| | | public object GetHSourceBillType(string HName,int Num) |
|---|
| | | { |
|---|
| | | try |
|---|
| | | { |
|---|
| | | ClsCN oCn = new ClsCN(); |
|---|
| | | DataSet oDs = new DataSet(); |
|---|
| | | //========== |
|---|
| | | oDs = oCn.RunProcReturn("select * from Xt_BillSourceSet where HName='"+HName+"'", "Xt_BillSourceSet"); |
|---|
| | | //有的单子源单分为红蓝单 0代表蓝单 1代表红单 |
|---|
| | | if (Num==0) |
|---|
| | | { //源单为蓝单 |
|---|
| | | oDs = oCn.RunProcReturn("select * from Xt_BillSourceSet where HName='" + HName + "' HRedBlueFlag ='"+ Num+"' ", "Xt_BillSourceSet"); |
|---|
| | | } |
|---|
| | | else if (Num==1) |
|---|
| | | { //源单为红单 |
|---|
| | | oDs = oCn.RunProcReturn("select * from Xt_BillSourceSet where HName='" + HName + "' HRedBlueFlag ='" + Num + "' ", "Xt_BillSourceSet"); |
|---|
| | | } |
|---|
| | | else if(Num==2) |
|---|
| | | { //不分红蓝单 |
|---|
| | | oDs = oCn.RunProcReturn("select * from Xt_BillSourceSet where HName='" + HName + "'", "Xt_BillSourceSet"); |
|---|
| | | } |
|---|
| | | |
|---|
| | | objjson.code = "1"; |
|---|
| | | objjson.count = 1; |
|---|
| | | objjson.Message = "获取成功！"; |
|---|
