| | |
|---|
| | | { |
|---|
| | | List<object> columnNameList = new List<object>(); |
|---|
| | | |
|---|
| | | if (sWhere == null || sWhere.Equals("")) |
|---|
| | | { |
|---|
| | | ds = oCN.RunProcReturn("select * from h_v_Sb_EquipMentCollectionTechParam order by 閲囬泦鏃ユ湡 desc", "h_v_Sb_EquipMentCollectionTechParam"); |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | string sql1 = "select * from h_v_Sb_EquipMentCollectionTechParam where 1 = 1 "; |
|---|
| | | string sql = sql1 + sWhere + " order by 閲囬泦鏃ユ湡 "; |
|---|
| | | ds = oCN.RunProcReturn(sql, "h_v_Sb_EquipMentCollectionTechParam"); |
|---|
| | | } |
|---|
| | | Dictionary<object, object> dic = Newtonsoft.Json.JsonConvert.DeserializeObject<Dictionary<object, object>>(sWhere); |
|---|
| | | |
|---|
| | | string HEquipNumber = dic["HEquipNumber"].ToString();//璁惧缂栫爜 |
|---|
| | | string HTechParamName = dic["HTechParamName"].ToString();//宸ヨ壓浜ф暟 |
|---|
| | | string HDate = dic["HDate"].ToString();//閲囬泦鏃ユ湡 |
|---|
| | | string HDate1 = dic["HDate1"].ToString();//閲囬泦鏃ユ湡 |
|---|
| | | string HEquipType = dic["HEquipType"].ToString();//鏌ヨ绫诲瀷 |
|---|
| | | |
|---|
| | | ds = oCN.RunProcReturn("exec h_p_Sb_EquipMentCollectionTechParam '"+ HEquipNumber + "','"+ HTechParamName + "','"+ HDate + "','"+ HDate1 + "','"+ HEquipType + "'", "h_p_Sb_EquipMentCollectionTechParam"); |
|---|
| | | |
|---|
| | | //娣诲姞鍒楀悕 |
|---|
| | | foreach (DataColumn col in ds.Tables[0].Columns) |
|---|
