| | |
| | | //æ·»å åå |
| | | for (int i = 0; i < ExcelDs.Tables[0].Columns.Count; i++) |
| | | { |
| | | tb2.Columns.Add(ExcelDs.Tables[0].Rows[0][i].ToString()); |
| | | if (!tb2.Columns.Contains(ExcelDs.Tables[0].Rows[0][i].ToString())) |
| | | { |
| | | tb2.Columns.Add(ExcelDs.Tables[0].Rows[0][i].ToString()); |
| | | } |
| | | } |
| | | //模æ¿ç¼ºå°å ä½éè¦ä»æ°æ®åºä¸æ¥è¯¢åºæ¥æ¾ç¤ºå¨é¡µé¢çåæ®µ |
| | | tb2.Columns.Add("hmainid", typeof(Int32)); |
| | |
| | | |
| | | |
| | | var ds = oCN.RunProcReturn($@"select * from Gy_Source where HName= '{HSourceName}'", "Gy_Source"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "çäº§èµæºåç§°æè¯¯ï¼ç³»ç»æªæ¥è¯¢å°å¯¹åºæ°æ®!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | HSourceID = ds.Tables[0].Rows[0]["HItemID"].ToString(); |
| | | |
| | | string sql = $"select * from Sc_WorkBillSortBillMain where HMainSourceInterID={HMainSourceInterID}" + |