| | |
|---|
| | | SQLHelper.ExecuteQuery(sql2); |
|---|
| | | |
|---|
| | | } |
|---|
| | | |
|---|
| | | public string[] YzxImgVerify(string id) |
|---|
| | | { |
|---|
| | | string[] msgStr = new string[2]; |
|---|
| | | |
|---|
| | | OracleSQLHelper SQLHelper = new(); |
|---|
| | | //修改结果 |
|---|
| | | var sql2 = string.Format(@"select A.ITEMNAME from ( select 888||min(id) id,ITEMNAME from MES_IQC_CONSISTENCY_CK where pid='"+ id + "' group by ITEMNAME) A " + |
|---|
| | | "left join MES_QS_IMAGE b on a.id=b.fid where B.id is null order by ITEMNAME"); |
|---|
| | | DataTable db= SQLHelper.ExecuteQuery(sql2); |
|---|
| | | if (db.Rows.Count > 0) |
|---|
| | | { |
|---|
| | | msgStr[1] = "元器件："; |
|---|
| | | for (int i = 0; i < db.Rows.Count; i++) |
|---|
| | | { |
|---|
| | | msgStr[1] += db.Rows[i]["ITEMNAME"]+ ","; |
|---|
| | | } |
|---|
| | | msgStr[1] += "未完成图片上传，请上传！"; |
|---|
| | | msgStr[0] = "1"; |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | msgStr[0] = "0"; |
|---|
| | | msgStr[1] = "ok"; |
|---|
| | | } |
|---|
| | | |
|---|
| | | return msgStr; |
|---|
| | | } |
|---|
| | | |
|---|
| | | public int UpdateQSItemDetail(MesQaItemsDetectDetail12 detail) |
|---|
| | | { |
|---|
| | | var withOracle = SqlSugarHelper.UseTransactionWithOracle(db => |
|---|
