/// <summary>
/// This is the main constructor for the search cell.
/// </summary>
/// <param name="oMinCellPoint">This is the min world point of this cell.</param>
/// <param name="oMaxCellPoint">This is the max world point of this cell.</param>
/// <param name="nGridX">This is the x index of the grid that this cell is positioned at.</param>
/// <param name="nGridY">This is the y index of the grid that this cell is positioned at.</param>
/// <param name="nGridZ">This is the z index of the grid that this cell is positioned at.</param>
/// <param name="oGrid">This is the grid this cell belongs to.</param>
public SearchCell(Vector3 oMinCellPoint, Vector3 oMaxCellPoint, int nGridX, int nGridY, int nGridZ, SearchGrid oGrid)
{
//set initial variables
m_oMinCellPoint = oMinCellPoint;
m_oMaxCellPoint = oMaxCellPoint;
m_oCenterCellPoint = (m_oMinCellPoint + m_oMaxCellPoint) * 0.5f;
m_nGridX = nGridX;
m_nGridY = nGridY;
m_nGridZ = nGridZ;
//clear adjacency
for (int x = 0; x < 3; x++)
{
for (int y = 0; y < 3; y++)
{
for (int z = 0; z < 3; z++)
{
m_aoAdjacentCells[x, y, z] = null;
}
}
}
m_aoAdjacentCells[1, 1, 1] = this;
//set grids
m_oGrid = oGrid;
}
private void SearchGrid_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
// Click Grid
try
{
if (SearchGrid.GetFocusedRowCellValue("id") != null)
{
String _id = SearchGrid.GetFocusedRowCellValue("id").ToString().Trim();
String _name = SearchGrid.GetFocusedRowCellValue("name").ToString().Trim();
if (_id != "" && _name != "")
{
Select_EntityName = _name;
Select_EntityID = _id;
_lookup.LogicalName = _Entity;
_lookup.Name = _name;
_lookup.Id = new Guid(_id);
this.Close();
}
}
}
catch (Exception ex)
{
MessageBox.Show("btnAccept_Click: " + ex.Message, rm.GetString("ErrorNotification"), MessageBoxButton.OK, MessageBoxImage.Error);
}
}
protected void Page_Load(object sender, EventArgs e)
{
var searchTerm = Request.QueryString["q"];
SearchTerm.Text = searchTerm;
var result = new List <ProductModel>();
ProductModel Products = new ProductModel();
Products.Searched = Request.QueryString["q"];
var sqlString = "SELECT * FROM Product";
var connString = WebConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
using (var conn = new SqlConnection(connString))
{
var command = new SqlCommand(sqlString, conn);
command.Connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Products.ProductKey = reader.GetInt32(0).ToString();
Products.ProductAlternateKey = reader.GetString(1);
Products.ProductName = reader.GetString(5);
Products.StockLevel = reader.GetInt16(9);
}
result.Add(Products);
}
}
SearchGrid.DataSource = result.Where(p => p.ProductName.IndexOf(searchTerm, StringComparison.OrdinalIgnoreCase) >= 0);
SearchGrid.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//NEED SOME DATA TO TEST THE RESULT
Values = new List <TestObject>();
Values.Add(new TestObject()
{
Q = "test 1", C = true, E = true, R = true
});
Values.Add(new TestObject()
{
Q = "test 1", C = true, E = false, R = true
});
Values.Add(new TestObject()
{
Q = "test 1", C = true, E = true, R = false
});
Values.Add(new TestObject()
{
Q = "test 1", C = false, E = true, R = true
});
//BIND TO THE GRID
SearchGrid.DataSource = Values;
SearchGrid.DataBind();
}
}
public async Task <ActionResult> Get([FromQuery] SearchGrid searchGrid)
{
var identity = HttpContext.User.Identity as ClaimsIdentity;
var ids = identity.Claims.FirstOrDefault(d => d.Type.Contains("nameidentifier"))?.Value;
var list = await _staffService.GetUsersAll(searchGrid);
return(Ok(list));
}
public void GridCellOfPoint_Expected(double left, double bottom, double gridSizeX, double gridSizeY, int cellCountX, int cellCountY, double queryPointX, double queryPointY, int expectedCellX, int expectedCellY)
{
var grid = new SearchGrid <string>(left, bottom, gridSizeX, gridSizeY, cellCountX, cellCountY);
var resultCell = grid.GetGridCellOfPoint(queryPointX, queryPointY);
Assert.Equal(expectedCellX, resultCell[0]);
Assert.Equal(expectedCellY, resultCell[1]);
}
private void Search()
{
lblText.Visible = true;
using (SqlConnection connection = DbHelper.GetConnection())
{
SqlCommand com = new SqlCommand("Search", connection)
{
CommandType = CommandType.StoredProcedure
};
if (ddlCar.SelectedIndex != 0)
{
com.Parameters.AddWithValue("@carid", ddlCar.SelectedValue);
}
if (ddlCompany.SelectedIndex != 0)
{
com.Parameters.AddWithValue("@carid", ddlCompany.SelectedValue);
}
if (ddlColorType.SelectedIndex != 0)
{
com.Parameters.AddWithValue("@typeid", ddlColorType.SelectedValue);
}
if (!string.IsNullOrEmpty(txtCode.Text.Trim()))
{
var code = DbHelper.PersianToEnglish(txtCode.Text.Trim());
com.Parameters.AddWithValue("@code", code);
}
if (!string.IsNullOrEmpty(txtColorDesc1.Text.Trim()))
{
com.Parameters.AddWithValue("@desc1", txtColorDesc1.Text.Trim());
}
if (!string.IsNullOrEmpty(txtColorDesc2.Text.Trim()))
{
com.Parameters.AddWithValue("@desc2", txtColorDesc2.Text.Trim());
}
if (!string.IsNullOrEmpty(txtUsage.Text.Trim()))
{
com.Parameters.AddWithValue("@usage", txtUsage.Text.Trim());
}
if (!string.IsNullOrEmpty(DatePicker1.Text))
{
com.Parameters.AddWithValue("@date", DatePicker1.Date);
}
SqlDataAdapter da = new SqlDataAdapter(com);
DataTable dt = new DataTable();
try
{
da.Fill(dt);
SearchGrid.DataSource = dt.Rows.Count > 0 ? dt : null;
lblCount.Text = dt.Rows.Count.ToString();
SearchGrid.DataBind();
}
catch (Exception ex)
{
lblMessage.Text = "خطا" + ex.Message;
}
}
}
/// <summary>
/// F9 リボン 登録
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public override void OnF9Key(object sender, KeyEventArgs e)
{
if (SearchResult == null)
{
return;
}
try
{
SearchGrid.CommitEdit(DataGridEditingUnit.Row, true);
if (!isDataGridValidation())
{
return;
}
if (!base.CheckAllValidation())
{
this.ErrorMessage = "入力内容に誤りがあります。";
MessageBox.Show("入力内容に誤りがあります。");
SetFocusToTopControl();
return;
}
// データなしの場合は処理しない
if (SearchResult.Rows.Count == 0 && DeletedItem.Rows.Count == 0)
{
this.ErrorMessage = "登録対象のデータが存在しません。";
MessageBox.Show("登録対象のデータが存在しません。");
SetFocusToTopControl();
return;
}
var yesno = MessageBox.Show("入力内容を登録しますか？", "登録確認", MessageBoxButton.YesNo, MessageBoxImage.Question, MessageBoxResult.Yes);
if (yesno == MessageBoxResult.Yes)
{
// REMARKS:DataTableを引数にしてもサービス側で
// 受け取れなかったのでDataSetとして引き渡す
DataSet ds = new DataSet();
SearchResult.TableName = "updTbl";
DeletedItem.TableName = "delTbl";
ds.Tables.Add(SearchResult);
ds.Tables.Add(DeletedItem);
base.SendRequest(
new CommunicationObject(
MessageType.UpdateData,
M10_TOKUHIN_Update,
new object[] {
ds,
ccfg.ユーザID
}));
}
}
catch (Exception)
{
return;
}
}
/// <summary>
/// This is the called when the script/object is disabled.
/// </summary>
public void OnDisable()
{
//remove this object from the grid.
if (SearchCell != null &&
SearchGrid.Instance != null)
{
SearchGrid.RemoveObject(this);
}
}
public void OnSceneGUI()
{
SearchGrid grid = target as SearchGrid;
if (grid == null)
{
return;
}
//draw width lines
for (int y = 0; y <= grid.GridHeight; y++)
{
for (int z = 0; z <= grid.GridDepth; z++)
{
Handles.DrawLine(grid.MinWorldPoint +
new Vector3(0.0f,
grid.CellSize * (float)y,
grid.CellSize * (float)z),
grid.MinWorldPoint +
new Vector3(grid.WorldSize.x,
grid.CellSize * (float)y,
grid.CellSize * (float)z));
}
}
//draw height lines
for (int x = 0; x <= grid.GridWidth; x++)
{
for (int z = 0; z <= grid.GridDepth; z++)
{
Handles.DrawLine(grid.MinWorldPoint +
new Vector3(grid.CellSize * (float)x,
0.0f,
grid.CellSize * (float)z),
grid.MinWorldPoint +
new Vector3(grid.CellSize * (float)x,
grid.WorldSize.y,
grid.CellSize * (float)z));
}
}
//draw depth lines
for (int x = 0; x <= grid.GridWidth; x++)
{
for (int y = 0; y <= grid.GridHeight; y++)
{
Handles.DrawLine(grid.MinWorldPoint +
new Vector3(grid.CellSize * (float)x,
grid.CellSize * (float)y,
0.0f),
grid.MinWorldPoint +
new Vector3(grid.CellSize * (float)x,
grid.CellSize * (float)y,
grid.WorldSize.z));
}
}
}
/// <summary>
/// 行の追加処理をおこなう
/// </summary>
private void addDataGridRow()
{
if (SearchResult == null)
{
return;
}
// グリッドにフォーカスを設定
SearchGrid.Focus();
DataRow row = SearchResult.NewRow();
if (!string.IsNullOrEmpty(this.TOKUISAKI.Text1))
{
// 得意先で検索されている場合
row["得意先コード"] = this.TOKUISAKI.Text1;
row["枝番"] = this.TOKUISAKI.Text2;
row["得意先名１"] = this.TOKUISAKI.Label2Text;
}
row["論理削除"] = false;
if (SendFormId == (int)SEND_FORM.取引先マスタ || SendFormId == (int)SEND_FORM.メニュー)
{
// 品番検索を開く
if (ShowProductDialogForm(row))
{
SearchResult.Rows.Add(row);
// 行追加後は追加行を選択させる
int insIdx = SearchResult.Rows.Count - 1;
SetCurrentCell(SearchGrid, insIdx, 2);
}
}
else if (SendFormId == (int)SEND_FORM.品番マスタ)
{
SCHM01_TOK tokForm = new SCHM01_TOK();
tokForm.TwinTextBox = new Framework.Windows.Controls.UcLabelTwinTextBox();
tokForm.TwinTextBox.LinkItem = "0,3"; // 得意先・相殺
if (tokForm.ShowDialog(this) ?? false)
{
row["品番コード"] = ProductNumber;
row["品番名称"] = this.HINBAN.Text2;
row["得意先コード"] = tokForm.TwinTextBox.Text1;
row["枝番"] = tokForm.TwinTextBox.Text2;
row["得意先名１"] = tokForm.TwinTextBox.Text3;
SearchResult.Rows.Add(row);
// 行追加後は追加行を選択させる
int insIdx = SearchResult.Rows.Count - 1;
SetCurrentCell(SearchGrid, insIdx, 2);
}
}
}
public OsmMapMatcher Clone()
{
OsmMapMatcher result = new OsmMapMatcher();
result.Graph = Graph;
result.SearchGrid = SearchGrid.Clone();
result.State = MapMatchState.InitialState();
result.Parameters = Parameters;
return(result);
}
// Constructor
public AsyncPathRequest(SearchGrid grid, Index start, Index end, PathRequestDelegate callback)
{
this.grid = grid;
this.start = start;
this.end = end;
this.callback = callback;
// Create a time stamp
timeStamp = DateTime.UtcNow.Ticks;
}
protected void Page_Load(object sender, EventArgs e)
{
var searchTerm = Request.QueryString["q"];
SearchTerm.Text = searchTerm;
var products = new Product().GetSampleProductList();
SearchGrid.DataSource = products.Where(p => p.Name.IndexOf(searchTerm, StringComparison.OrdinalIgnoreCase) >= 0);
SearchGrid.DataBind();
}
public AsyncPathRequest(SearchGrid grid, Index start, Index end, DiagonalMode diagonal, Action <Path, PathRequestStatus> callback)
{
this.grid = grid;
this.start = start;
this.end = end;
this.diagonal = diagonal;
this.callback = callback;
// Create a time stamp
timeStamp = DateTime.UtcNow.Ticks;
}
private void SearchGrid_OnGotFocus(object sender, RoutedEventArgs e)
{
if (e.OriginalSource is DataGridCell cell && cell.Column is DataGridCheckBoxColumn)
{
SearchGrid.BeginEdit();
if (cell.Content is CheckBox chkBox)
{
chkBox.IsChecked = !chkBox.IsChecked;
}
}
}
private List <DirectedRoad> GetNearbyRoads(Coord query, double radiusInMeters)
{
if (SearchGrid != null)
{
return(SearchGrid.GetNearbyValues(query, radiusInMeters));
}
else
{
int i;
return(Graph.Roads.Where(x => query.SnapToPolyline(x.Geometry, out i).HaversineDistance(query).DistanceInMeters < radiusInMeters).ToList());
}
}
public void FetchDataAll()
{
SearchGrid search = new SearchGrid();
search.sord = "asc";
search.sidx = "name";
search.page = 1;
IndexController controller = new IndexController();
JsonResult beerJsonResult = controller.FetchData(search) as JsonResult;
Assert.IsNotNull(beerJsonResult.Data, "JsonResult returned from action method.");
}
private void Search()
{
using (SqlConnection connection = DbHelper.GetConnection())
{
SqlCommand com = new SqlCommand("Search", connection)
{
CommandType = CommandType.StoredProcedure
};
if (ddlCar.SelectedIndex != 0)
{
com.Parameters.AddWithValue("@carid", ddlCar.SelectedValue);
}
if (ddlCompany.SelectedIndex != 0)
{
com.Parameters.AddWithValue("@carid", ddlCompany.SelectedValue);
}
if (ddlColorType.SelectedIndex != 0)
{
com.Parameters.AddWithValue("@typeid", ddlColorType.SelectedValue);
}
if (!string.IsNullOrEmpty(txtCode.Text.Trim()))
{
com.Parameters.AddWithValue("@code", txtCode.Text);
}
if (!string.IsNullOrEmpty(txtDesc.Text.Trim()))
{
com.Parameters.AddWithValue("@desc", txtDesc.Text);
}
SqlDataAdapter da = new SqlDataAdapter(com);
DataSet ds = new DataSet();
try
{
da.Fill(ds, "search");
if (ds.Tables[0].Rows.Count > 0)
{
SearchGrid.DataSource = ds.Tables["search"];
}
else
{
lblMessage.Text = "رنگی با این مشخصات پیدا نشد";
SearchGrid.DataSource = null;
}
SearchGrid.DataBind();
}
catch (Exception ex)
{
lblMessage.Text = "خطا" + ex.Message;
}
}
}
public SelectMSCRMEntity(IOrganizationService Service, String SearchStr, String Title, Boolean ShowAllAtStart, String Entity, String NameAttribute, String IDAttribute, Boolean AutoAcceptOneResult)
{
InitializeComponent();
_Service = Service;
_SearchResult = new DataTable("searchresult");
_SearchResult.Columns.Add("id", typeof(String));
_SearchResult.Columns.Add("name", typeof(String));
SearchGrid.ItemsSource = _SearchResult;
SearchGrid.IsFilterEnabled = true;
SearchGrid.RefreshData();
foreach (DevExpress.Xpf.Grid.GridColumn _gc in SearchGrid.Columns)
{
_gc.AllowAutoFilter = true;
_gc.AutoFilterCondition = DevExpress.Xpf.Grid.AutoFilterCondition.Contains;
_gc.AllowEditing = DevExpress.Utils.DefaultBoolean.False;
}
// SearchGrid.GroupBy(SearchGrid.Columns["gctype"], DevExpress.Data.ColumnSortOrder.Ascending);
// SearchGrid.ExpandAllGroups();
_Entity = Entity;
_NameAttribute = NameAttribute;
_IDAttribute = IDAttribute;
if (SearchStr != "")
{
tbEntitySearch.Text = SearchStr.Trim();
}
if (ShowAllAtStart && tbEntitySearch.Text != "")
{
Int32 _count = GetSearchList(_Service, tbEntitySearch.Text.Trim(), _Entity, _NameAttribute, _IDAttribute);
if (_count == 1 && AutoAcceptOneResult)
{
Accept();
}
}
if (Title != "")
{
this.Title = Title;
}
tbEntitySearch.Focus();
}
/// <summary>
/// This is called when the inspector gui should be run.
/// </summary>
public override void OnInspectorGUI()
{
GUI.changed = false;
//get the grid
SearchGrid grid = target as SearchGrid;
if (grid)
{
//calc size limits and display slider
float gridArea = grid.transform.localScale.x * grid.transform.localScale.y * grid.transform.localScale.z;
float minCellSize = Mathf.Pow(gridArea / (float)SearchGrid.mc_nApproxMaxCells, 1.0f / 3.0f);
float maxCellSize = Mathf.Min(grid.transform.localScale.x, grid.transform.localScale.y, grid.transform.localScale.z);
float newCellSize = EditorGUILayout.Slider("Cell Size", grid.desiredCellSize, minCellSize, maxCellSize);
if (newCellSize != grid.desiredCellSize ||
SearchGrid.Instance != grid ||
GUI.changed ||
m_oLastPosition != grid.transform.position ||
m_oLastScale != grid.transform.localScale)
{
grid.desiredCellSize = newCellSize;
grid.Start();
EditorUtility.SetDirty(target);
}
//display stats
EditorGUILayout.LabelField("Grid Center:", grid.CenterWorldPoint.ToString("0.000"));
EditorGUILayout.LabelField("Grid Size:", grid.WorldSize.ToString("0.000"));
EditorGUILayout.LabelField("Cell Count:", grid.NumCells + " (" + grid.GridWidth + "x" + grid.GridHeight + "x" + grid.GridDepth + ")");
EditorGUILayout.Separator();
//display debug check boxes
grid.enableDebug = EditorGUILayout.BeginToggleGroup("Enable Debug", grid.enableDebug);
grid.drawGridDebug = EditorGUILayout.Toggle("Draw Grid", grid.drawGridDebug);
grid.drawCellDebug = EditorGUILayout.Toggle("Draw Cells", grid.drawCellDebug);
grid.drawObjectDebug = EditorGUILayout.Toggle("Draw Objects", grid.drawObjectDebug);
grid.drawSearchDebug = EditorGUILayout.Toggle("Draw Searches", grid.drawSearchDebug);
grid.drawStatsDebug = EditorGUILayout.Toggle("Draw Stats", grid.drawStatsDebug);
EditorGUILayout.EndToggleGroup();
m_oLastPosition = grid.transform.position;
m_oLastScale = grid.transform.localScale;
}
if (GUI.changed)
{
EditorUtility.SetDirty(target);
}
}
protected void Page_Load(object sender, EventArgs e)
{
var searchTerm = Request.Unvalidated.QueryString["q"];
if (!Regex.IsMatch(searchTerm, @"^[\p{L} \.\-]+$"))
{
throw new ApplicationException("Search term is not allowed");
}
SearchTerm.Text = AntiXssEncoder.HtmlEncode(searchTerm, true);
var products = new Product().GetSampleProductList();
SearchGrid.DataSource = products.Where(p => p.Name.IndexOf(searchTerm, StringComparison.OrdinalIgnoreCase) >= 0);
SearchGrid.DataBind();
}
public void CalculatePageNumber()
{
SearchGrid search = new SearchGrid();
search.sord = "asc";
search.sidx = "name";
search.page = 1;
IndexController controller = new IndexController();
JsonResult beerJsonResult = controller.FetchData(search) as JsonResult;
var json = JsonConvert.SerializeObject(beerJsonResult.Data);
var recordList = JsonConvert.DeserializeObject <JqGridFormat>(json);
Assert.AreEqual(1, recordList.page);
}
public static void PlotGrid <T>(SearchGrid <T> grid, GMapOverlay overlay, Color color = default(Color), int width = 3, int opacity = 255)
{
double bottomLat = grid.Bottom;
double topLat = grid.Bottom + grid.CellCountY * grid.GridSizeY;
double lng = grid.Left;
for (int i = 0; i < grid.CellCountX; i++)
{
var lineStart = new PointLatLng(bottomLat, lng);
var lineEnd = new PointLatLng(topLat, lng);
GMapRoute root = new GMapRoute(new List <PointLatLng> {
lineStart, lineEnd
}, "");
Pen stroke = (Pen)root.Stroke.Clone();
if (color != default(Color))
{
stroke.Color = Color.FromArgb(opacity, color);
}
stroke.Width = width;
root.Stroke = stroke;
overlay.Routes.Add(root);
lng = lng + grid.GridSizeX;
}
double leftLng = grid.Left;
double rightLng = grid.Left + grid.CellCountX * grid.GridSizeX;
double lat = grid.Bottom;
for (int i = 0; i < grid.CellCountY; i++)
{
var lineStart = new PointLatLng(lat, leftLng);
var lineEnd = new PointLatLng(lat, rightLng);
GMapRoute root = new GMapRoute(new List <PointLatLng> {
lineStart, lineEnd
}, "");
Pen stroke = (Pen)root.Stroke.Clone();
if (color != default(Color))
{
stroke.Color = Color.FromArgb(opacity, color);
}
stroke.Width = width;
root.Stroke = stroke;
overlay.Routes.Add(root);
lat = lat + grid.GridSizeY;
}
}
/// <summary>
/// The main method that is used to initialize the grid with user data.
/// The provided data must be a two dimensional array of class instances that implement the <see cref="IPathNode"/> interface.
/// The array must be correctly initialized with no null elements.
/// The array cannot have any dimensions of zero length.
/// </summary>
/// <param name="grid">The user input grid</param>
public void constructGrid(IPathNode[,] grid)
{
// Create the search provider
searchGrid = CreateSearchProvider(grid);
// Check for invalid provider
if (searchGrid == null)
{
throw new NullReferenceException("Failed to create an instance of 'SearchGrid'. If a custom implementation of 'createSearchProvider' is used, make sure it is not returning null");
}
// Register obstacle checker
searchGrid.CheckIndexOccupied += isIndexOccupied;
// Set the ready flag
isReady = true;
}
void ShowSearch_OnClick(object sender, RoutedEventArgs e)
{
DoubleAnimation animation;
if (_searchIsOpen)
{
animation = new DoubleAnimation(SearchClosedLeft, _searchDuration);
}
else
{
animation = new DoubleAnimation(SearchOpenLeft, _searchDuration);
}
_searchIsOpen = !_searchIsOpen;
SearchGrid.BeginAnimation(Canvas.LeftProperty, animation);
}
void FormatGrid()
{
if (SearchGrid.Rows.Count == 0)
{
DataTable DT = Data2.Connection.D_Supplier.Get_AllShort(UserId);
if (DT != null)
{
SearchGrid.DataSource = DT;
SearchGrid.DataBind();
}
for (int a = 0; a < SearchGrid.Rows.Count; a++)
{
HyperLink HLEdit = new HyperLink();
HLEdit.Text = "Editar";
HLEdit.NavigateUrl = "/MyManager/Proveedores?edt=" + SearchGrid.Rows[a].Cells[0].Text.ToString();
HyperLink HLDelete = new HyperLink();
HLDelete.Text = "Borrar";
HLDelete.NavigateUrl = "/MyManager/Proveedores?del=" + SearchGrid.Rows[a].Cells[0].Text.ToString();
HtmlGenericControl HTMLSeparator = new HtmlGenericControl("span");
SearchGrid.Rows[a].Cells[4].Controls.Add(HLEdit);
SearchGrid.Rows[a].Cells[4].Controls.Add(HLDelete);
SearchGrid.Rows[a].Cells[4].CssClass = "AtroxDarkLink";
}
IClientCapability MyCLient = ClientCapabilityProvider.CurrentClientCapability;
if (MyCLient.IsMobile)
{
SearchGrid.Columns[3].Visible = false;
SearchGrid.Columns[4].Visible = false;
for (int a = 0; a < SearchGrid.Rows.Count; a++)
{
string t_Telephone = SearchGrid.Rows[a].Cells[2].Text;
SearchGrid.Rows[a].Cells[2].Text = "";
HyperLink HLTelephone = new HyperLink();
HLTelephone.Text = t_Telephone;
HLTelephone.NavigateUrl = "tel:" + t_Telephone;
SearchGrid.Rows[a].Cells[2].Controls.Add(HLTelephone);
}
}
}
}
/// <summary>
/// Fetch list of beers and format data according to JqGrid requirement
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public JsonResult FetchData(SearchGrid search)
{
try
{
BusinessManager bm = new BusinessManager();
BeerList beerlist = bm.FetchBeerList(search);
var jsonData = new
{
total = beerlist.numberOfPages,
page = beerlist.currentPage,
records = beerlist.totalResults,
rows = beerlist.data
};
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json("{Message :" + ex.Message + "}", JsonRequestBehavior.AllowGet));
}
}
protected void Search_btn_Click(object sender, EventArgs e)
{
string column = SearchByProperty.SelectedValue;
string seeking = Seeking_str.Text;
var adminRepo = new Repository();
adminRepo.OpenConnection(connection_str);
SearchPackage paket = new SearchPackage();
paket.criterion = column;
paket.value = seeking;
var books = adminRepo.WantedBooksByCriterion(paket);
adminRepo.CloseConnection();
SearchGrid.DataSource = books;
SearchGrid.DataBind();
}
protected override void Awake()
{
base.Awake();
m_instance = this;
m_startNode = GetNode(0, m_row / 2);
m_startNode.SetSearchType(SearchType.Start, false);
m_goalNode = GetNode(m_col - 1, m_row / 2);
m_goalNode.SetSearchType(SearchType.Goal, false);
List <string> options = new List <string>()
{
"Obstacle", "Ground", "Water"
};
m_brushTypeDropDown.ClearOptions();
m_brushTypeDropDown.AddOptions(options);
m_brushTypeDropDown.onValueChanged.AddListener(OnChangeBrushType);
m_brushType = Define.c_costObstacle;
}
