/// <summary> /// 加入仪器共享数据列表 /// </summary> /// <param name="instrument_num"></param> /// <param name="instrument_phone"></param> /// <returns></returns> public ActionResult AddInstrumentShareListData(AddInstrument addinst) { string responseText = ""; responseText = orderbll.addInstrumentShareListData(addinst); return(Content(responseText)); }
/// <summary> /// 加入仪器共享数据列表 /// </summary> /// <param name="instrument_num"></param> /// <param name="instrument_phone"></param> /// <returns></returns> public string addInstrumentShareListData(AddInstrument addinst) { string responseText = ""; responseText = orderdal.addInstrumentShareListData(addinst); return(responseText); }
public async void AddNewInstrument() { Value = true; var connection = await apiService.CheckConnection(); if (!connection.IsSuccess) { await Application.Current.MainPage.DisplayAlert( Languages.Warning, Languages.CheckConnection, Languages.Ok); return; } if (string.IsNullOrEmpty(Name) || string.IsNullOrEmpty(Description)) { Value = true; return; } if (SelectedType.Key == null) { await Application.Current.MainPage.DisplayAlert("Error", "Please Select Type", "ok"); return; } var _instrument = new AddInstrument { active = Active, name = Name, description = Description, type = SelectedType.Key }; var cookie = Settings.Cookie; //.Split(11, 33) var res = cookie.Substring(11, 32); var response = await apiService.Save <AddInstrument>( "https://portalesp.smart-path.it", "/Portalesp", "/instrument/save", res, _instrument); if (!response.IsSuccess) { await Application.Current.MainPage.DisplayAlert("Error", response.Message, "ok"); return; } Value = false; MessagingCenter.Send((App)Application.Current, "OnSaved"); DependencyService.Get <INotification>().CreateNotification("PortalSP", "Instrument Added"); await App.Current.MainPage.Navigation.PopPopupAsync(true); }
/// <summary> /// 加入仪器共享数据列表 /// </summary> /// <param name="instrument_num"></param> /// <param name="instrument_phone"></param> /// <returns></returns> public string addInstrumentShareListData(AddInstrument instshare) { string responseText = ""; string Select_Sql = ""; //条件语句 int count = 0; //条件查询到的记录数 int start = 0; //起始查询条数 int last = 0; //最终查询条数 int pagecount = 0; //总页数 int pagesize = 0; int nowpage = 0; if (instshare.Pagesize == "" || instshare.Pagesize == null) { pagesize = 10; } else { pagesize = Convert.ToInt32(instshare.Pagesize); } if (instshare.Nowpage == "" || instshare.Nowpage == null) { nowpage = 1; } else { nowpage = Convert.ToInt32(instshare.Nowpage); } if (instshare.Instrument_id != "" && instshare.Instrument_id != null) { Select_Sql += string.Format(" and (INSTRUMENT_ID = '{0}')", instshare.Instrument_id); } if (instshare.User_phone != "" && instshare.User_phone != null) { Select_Sql += string.Format(" and (USER_TEL = '{0}')", instshare.User_phone); } if (instshare.Regtime_start != "" && instshare.Regtime_start != null) { Select_Sql += string.Format(" and to_char(to_date(ADD_TIME,'yyyy-MM-dd HH24:mi:ss'),'yyyy-MM-dd') >='{0}'", instshare.Regtime_start); } if (instshare.Regtime_end != "" && instshare.Regtime_end != null) { Select_Sql += string.Format(" and to_char(to_date(ADD_TIME,'yyyy-MM-dd HH24:mi:ss'),'yyyy-MM-dd') <='{0}'", instshare.Regtime_end); } //if (order.Order_status != "00" && order.Order_status != "" && order.Order_status != null) //{ // Select_Sql += string.Format(" and (IS_RECEIVED = '{0}')", order.Order_status); //} string sql0 = "select count(*) from GXIS_ADD_VIEW where 1=1 and DEL_FLAG='0' " + Select_Sql; DataTable dt0 = OracleHelper.GetTable(sql0, null); count = Convert.ToInt32(dt0.Rows[0][0]); //得到了全部的记录数 if (count % pagesize == 0) //计算得到全部页数 { pagecount = count / pagesize; } else { pagecount = count / pagesize + 1; } if (count == 0) { start = 0; } else { start = (nowpage - 1) * pagesize + 1; //计算该显示记录的行数范围; } if (start <= count) { if (count - start >= pagesize) //start起始 last结束 { last = start + pagesize - 1; } else { last = count; } } string sql = string.Format("select * from(select a.*,rownum row_num from (select * from GXIS_ADD_VIEW where 1=1 and DEL_FLAG='0' {0} order by INSTRUMENT_ID asc) a) b where b.row_num between {1} and {2}", Select_Sql, start, last); DataTable dt = OracleHelper.GetTable(sql, null); responseText = JsonHelper.getRecordJson(dt); responseText = "{\"msg\":\"success\",\"count\":" + count.ToString() + ",\"servers\":[" + responseText + "]}"; return(responseText); }