protected void btInsert_Click(object sender, EventArgs e)
{
if (MyDataSource.Insert() >= 1)
{
Response.Write("<script>alert('添加成功')</script>");
}
}
private void CreateMenuItems()
{
MyDataSource data = new MyDataSource();
Menu.DataSource = data;
Menu.DataBind();
}
protected void btDelete_Click(object sender, EventArgs e)
{
if (MyDataSource.Delete() >= 1)
{
Response.Write("<script>alert('删除成功')</script>");
}
}
/// <summary>
/// Verify field names against database. Combines the ability to add and remove
/// fields from Database.
/// </summary><returns>true if modified, false if not needed, throws exception if fail</returns>
public bool VerifyOrCreateAndRemoveFields(bool createTableIfMissing = true)
{
VerifyOrCreateClassFieldsInDbTable(createTableIfMissing);
var dbAllFieldNames = _dbFieldNames.ToArray().ToList();
dbAllFieldNames.Add(IDField);
var extraDbFieldNames = GetDbFieldNames().Except(dbAllFieldNames).ToArray();
if (extraDbFieldNames.Length == 0)
{
return(false);
}
var sb = new StringBuilder();
bool firstField = true;
foreach (var fieldName in extraDbFieldNames)
{
if (firstField)
{
sb.Append(",");
}
sb.Append(fieldName);
sb.Append(" ");
firstField = false;
}
MyDataSource.ExecuteSql($"alter table {TableName} drop {sb}");
return(true);
}
protected override void OnCreate(Bundle bundle)
{
base.OnCreate(bundle);
SetContentView(Resource.Layout.Main);
var button = FindViewById <Button>(Resource.Id.MyButton);
button.Click += (s, e) => {
var ds = new MyDataSource();
ds.Authenticate().ContinueWith(
t =>
{
var isauth = t.Result;
if (isauth)
{
var result = ds.QueryDataSoruce <DsParams>("your dataset", new DsParams {
qty = 2
}).Result;
System.Diagnostics.Debug.WriteLine(result.ToString());
}
}
);
};
}
protected void cbCars_ItemsRequestedByFilterCondition(object source, DevExpress.Web.ASPxEditors.ListEditItemsRequestedByFilterConditionEventArgs e)
{
var data = MyDataSource.GetData(cbLocation.Text);
var query = from r in data where r.Text.StartsWith(e.Filter) select r;
cbCars.DataSource = query.Skip(e.BeginIndex).Take(e.EndIndex - e.BeginIndex + 1);
cbCars.DataBind();
}
protected void Button3_Click(object sender, EventArgs e)
{
int i = MyDataSource.Delete();
if (i == 1)
{
message.Text = "Profile Deleted Successfully !";
}
}
protected void cbCars_ItemRequestedByValue(object source, DevExpress.Web.ASPxEditors.ListEditItemRequestedByValueEventArgs e)
{
if (e.Value != null && e.Value is int)
{
var data = MyDataSource.GetData(cbLocation.Text);
var query = from r in data where r.Value == (int)e.Value select r;
cbCars.DataSource = query;
cbCars.DataBind();
}
}
/// <summary>
/// Get the names of the columns as defined in the database
/// </summary>
/// <returns></returns>
public string[] GetDbFieldNames()
{
string sql = "select Top 1 * from " + TableName;
var reader = MyDataSource.ExecuteReader(sql);
var schemaTable = reader.GetSchemaTable();
MyDataSource.DisposeReader(reader);
return((from dr in schemaTable?.Rows.Cast <DataRow>()
select dr["ColumnName"].ToString()).ToArray());
}
/// <summary>
/// Add missing fields to database that are found in record class.
/// </summary><returns>true if changed, false if no need to change, throw exceptions on errors</returns>
public bool VerifyOrCreateClassFieldsInDbTable(bool createTableIfMissing = true)
{
if (createTableIfMissing && !MyDataSource.GetDataTableNames().Contains(TableName))
{
CreateDataTable();
return(true);
}
// field name exceptions, index matches location in fieldInfos
var missingDbFieldNames = _dbFieldNames.Except(GetDbFieldNames()).ToArray();
if (missingDbFieldNames.Length == 0)
{
return(false);
}
try {
var sb = new StringBuilder();
bool firstField = true;
foreach (var dbFieldName in missingDbFieldNames)
{
if (!firstField)
{
sb.Append(",");
}
int fiIndex = _dbFieldNames.IndexOf(dbFieldName);
string fixDbFn = dbFieldName;
int fnSepIdx = fixDbFn.IndexOf(".[", StringComparison.Ordinal);
if (MyDataSource is DataFileSource dfSrc && dfSrc.FileType != DataFileType.Access2007 &&
dfSrc.FileType != DataFileType.AccessMdb && fnSepIdx >= 0)
{
fixDbFn = fixDbFn.Substring(fnSepIdx + 2, fixDbFn.Length - fnSepIdx - 3);
}
sb.Append(fixDbFn);
sb.Append(" ");
sb.Append(FieldInfoToSqlType(_fieldInfos[fiIndex]));
firstField = false;
}
MyDataSource.ExecuteSql($"alter table {TableName} add {sb}");
} catch {
//on fail remove all fieldInfos not contained in database.
foreach (var dbFieldName in missingDbFieldNames)
{
int fiIndex = _dbFieldNames.IndexOf(dbFieldName);
_fieldInfos.RemoveAt(fiIndex);
_dbFieldNames.RemoveAt(fiIndex);
}
throw;
}
return(true);
}
protected void Button2_Click(object sender, EventArgs e)
{
DataView dataView = (DataView)MyDataSource.Select(DataSourceSelectArguments.Empty);
DataTable table = dataView.ToTable();
TextBox1.Text = table.Rows[0].ItemArray[1].ToString();
TextBox2.Text = table.Rows[0].ItemArray[2].ToString();
TextBox3.Text = table.Rows[0].ItemArray[3].ToString();
TextBox4.Text = table.Rows[0].ItemArray[5].ToString();
TextBox5.Text = table.Rows[0].ItemArray[4].ToString();
TextBox6.Text = table.Rows[0].ItemArray[6].ToString();
}
public void MyDataBind()
{
Text = new StringBuilder();
foreach (PropertyInfo p in MyDataSource.GetType().GetProperties())
{
Text.Append(string.Format("<b>{0}</b>", p.Name));
Text.Append(":");
if (p.GetIndexParameters() == null || p.GetIndexParameters().Length == 0)
{
Text.Append(p.GetValue(MyDataSource, null));
}
Text.Append("<br />");
}
}
//删除文件
public static string mDeleteFile(string mPath)
{
string res = null;
if (System.IO.File.Exists(Path.GetFullPath(mPath)))
{
File.Delete(Path.GetFullPath(mPath));
MyDataSource.PrintLogs("删除文件" + mPath);
}
else
{
MyDataSource.PrintLogs("删除图片:图片文件不存在");
res = "文件路径不存在";
}
return(res);
}
public void Fill()
{
if (this.isFilled)
{
return;
}
MyDataSource source = new MyDataSource();
foreach (DataRow row in source.RecordsSet.Tables["DateTable"].Rows)
{
this.SourceCollection.Add(new DateEntity(row));
}
this.isFilled = true;
}
public override void Run()
{
StartTime = DateTime.Parse("01/01/2008", CultureInfo.InvariantCulture);
EndTime = DateTime.Now.Date - TimeSpan.FromDays(5);
var ds = new MyDataSource();
AddDataSource(ds);
foreach (var s in SimTimes)
{
_plotter.SelectChart(Name, "date");
_plotter.SetX(SimTime[0]);
_plotter.Plot(ds.Instrument.Name, ds.Instrument.Close[0]);
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
var ds = new MyDataSource();
ds.Authenticate().ContinueWith(
t =>
{
var isauth = t.Result;
if (isauth)
{
var result = ds.QueryDataSoruce <DsParams>("getTellagoVacationsfff", new DsParams {
qty = 2
}).Result;
System.Diagnostics.Debug.WriteLine(result.ToString());
}
}
);
}
public int[] GetIDs(bool sortByID = false)
{
if (string.IsNullOrEmpty(IDField))
{
return(null);
}
var sql = "select " + IDField + " from " + TableName + (sortByID ? " order by " + IDField + " asc;" : "");
var r = MyDataSource.ExecuteReader(sql);
var result = new List <int>();
while (r.Read())
{
var id = r.GetInt32(0);
result.Add(id);
}
MyDataSource.DisposeReader(r);
return(result.ToArray());
}
public TField[] GetFieldDistinctValues <TField>(string fieldName, bool sort = false)
{
var fi = typeof(T).GetField(fieldName);
if (fi == null)
{
throw new Exception("FieldName doesn't match any public field in type");
}
int fiIndex = _fieldInfos.IndexOf(fi);
var dbFn = _dbFieldNames[fiIndex];
var sql = $"select distinct {dbFn} from {TableName}" + (sort ? $" order by {dbFn} asc;" : "");
var r = MyDataSource.ExecuteReader(sql);
var result = new List <TField>();
while (r.Read())
{
var vO = r[0];
result.Add((TField)vO);
}
MyDataSource.DisposeReader(r);
return(result.ToArray());
}
public static void Async2b_Events()
{
MyDataSource src = null;
src.DataAvailable += (o, e) =>
{
if (cond(e.Data))
{
var y = f(e.Data);
if (cond2(y))
{
RaiseTransformedDataAvailable(y);
}
}
};
// now consumers interested in the filtered, transformed data attach
// to Streams.TransformedDataAvailable instead of MyDataSource.DataAvailable
// Notice that we can't return the event itself because events aren't first
// class citizens.
}
private void getCarouselData()
{
var item = new ShowcaseImagesModel
{
showcaseImage = "Image1.jpg"
};
var item2 = new ShowcaseImagesModel
{
showcaseImage = "Image3.jpg"
};
MyDataSource.Add(item);
MyDataSource.Add(item2);
MyDataSource.Add(item);
MyDataSource.Add(item2);
MyDataSource.Add(item);
MyDataSource.Add(item2);
MyDataSource.Add(item);
MyDataSource.Add(item2);
MyDataSource.Add(item);
MyDataSource.Add(item2);
}
public static void update (Page p)
{
LiteralControl lcb = new LiteralControl (HtmlDiff.BEGIN_TAG);
LiteralControl lce = new LiteralControl (HtmlDiff.END_TAG);
ObjectDataSourceView view;
GridView grid = new GridView ();
MyDataSource ds = new MyDataSource ();
ds.ID = "ObjectDataSource1";
ds.TypeName = "MonoTests.System.Web.UI.WebControls.DataSourceObject";
ds.SelectMethod = "Select";
ds.DeleteMethod = "Delete";
ds.InsertMethod = "Insert";
ds.UpdateMethod = "Update";
Parameter p1 = new Parameter ("ID", TypeCode.String);
Parameter p2 = new Parameter ("FName", TypeCode.String);
Parameter p3 = new Parameter ("LName", TypeCode.String);
ds.UpdateParameters.Add (p1);
ds.UpdateParameters.Add (p2);
ds.UpdateParameters.Add (p3);
grid.ID = "Grid";
grid.DataSourceID = "ObjectDataSource1";
p.Form.Controls.Add (lcb);
p.Form.Controls.Add (ds);
p.Form.Controls.Add (grid);
p.Form.Controls.Add (lce);
view = (ObjectDataSourceView) ds.DoGetView ("defaultView");
view.Updating += new ObjectDataSourceMethodEventHandler (Event);
DataSourceObject.InitDS ();
Hashtable table = new Hashtable ();
table.Add ("ID", "1001");
table.Add ("FName", "Yonik");
table.Add ("LName", "Laim");
view.Update (null, table, null);
Assert.AreEqual (true, view.CanUpdate, "CanUpdate");
Assert.AreEqual ("Update", view.UpdateMethod, "UpdateMethod");
Assert.AreEqual (3, view.UpdateParameters.Count, "UpdateParameters.Count");
Assert.AreEqual ("ID", view.UpdateParameters[0].Name, "UpdateParametersName#1");
Assert.AreEqual ("FName", view.UpdateParameters[1].Name, "UpdateParametersName#2");
Assert.AreEqual ("LName", view.UpdateParameters[2].Name, "UpdateParametersName#3");
ObjectDataSourceViewTest.Eventassert ("Update event has not fired");
}
public static void selectcount (Page p)
{
// This method will render grid view with paging
// Note : ObjectDataSource will return page counter 5 hard coded
LiteralControl lcb = new LiteralControl (HtmlDiff.BEGIN_TAG);
LiteralControl lce = new LiteralControl (HtmlDiff.END_TAG);
ObjectDataSourceView view;
GridView grid = new GridView ();
MyDataSource ds = new MyDataSource ();
ds.ID = "ObjectDataSource2";
ds.EnablePaging = true;
ds.TypeName = "MonoTests.System.Web.UI.WebControls.DataSourceObject";
ds.SelectMethod = "Select";
ds.SelectCountMethod = "SelectCount";
grid.ID = "Grid";
grid.DataKeyNames = new string[] { "ID" };
grid.DataSourceID = "ObjectDataSource2";
grid.AllowPaging = true;
grid.PageSize = 1;
p.Form.Controls.Add (lcb);
p.Form.Controls.Add (ds);
p.Form.Controls.Add (grid);
p.Form.Controls.Add (lce);
view = (ObjectDataSourceView) ds.DoGetView ("DefaultView");
Assert.IsTrue (view.CanRetrieveTotalRowCount, "CanRetrieveTotalRowCount");
}
public static void select (Page p)
{
LiteralControl lcb = new LiteralControl (HtmlDiff.BEGIN_TAG);
LiteralControl lce = new LiteralControl (HtmlDiff.END_TAG);
ObjectDataSourceView view;
GridView grid = new GridView ();
MyDataSource ds = new MyDataSource ();
ds.ID = "ObjectDataSource2";
ds.TypeName = "MonoTests.System.Web.UI.WebControls.DataSourceObject";
ds.SelectMethod = "Select";
grid.ID = "Grid";
grid.DataKeyNames = new string[] { "ID" };
grid.DataSourceID = "ObjectDataSource2";
p.Form.Controls.Add (lcb);
p.Form.Controls.Add (ds);
p.Form.Controls.Add (grid);
p.Form.Controls.Add (lce);
view = (ObjectDataSourceView) ds.DoGetView ("DefaultView");
view.Selecting += new ObjectDataSourceSelectingEventHandler (view_Selecting);
DataSourceObject.InitDS ();
DataView view1 = (DataView) view.Select (new DataSourceSelectArguments ());
Assert.AreEqual (1, view1.Count, "SelectedRowsCount");
Assert.AreEqual (1001, view1[0].Row["ID"], "SelectedRowsValue#1");
Assert.AreEqual ("Mahesh", view1[0].Row["FName"], "SelectedRowsValue#2");
Assert.AreEqual ("Chand", view1[0].Row["LName"], "SelectedRowsValue#3");
ObjectDataSourceViewTest.Eventassert ("Select event has not fired");
}
public void ViewState ()
{
// Note :
// IStateManager implementation allows public access to control state
// Nothing added to viewstate
ObjectDataSourceView view;
MyDataSource ds = new MyDataSource ();
ds.ID = "ObjectDataSource2";
ds.TypeName = "MonoTests.System.Web.UI.WebControls.DataSourceObject";
ds.SelectMethod = "Select";
ds.SelectCountMethod = "SelectCount";
view = (ObjectDataSourceView) ds.DoGetView ("DefaultView");
((IStateManager) view).TrackViewState ();
view.ConflictDetection = ConflictOptions.CompareAllValues;
view.ConvertNullToDBNull = true;
view.DataObjectTypeName = "test";
view.DeleteMethod = "test";
view.EnablePaging = true;
view.InsertMethod = "test";
view.FilterExpression = "test";
view.MaximumRowsParameterName = "test";
view.SelectCountMethod = "test";
view.SelectMethod = "test";
view.OldValuesParameterFormatString = "test";
view.StartRowIndexParameterName = "test";
view.TypeName = "test";
view.UpdateMethod = "test";
object state = ((IStateManager) view).SaveViewState ();
Assert.IsNull (state, "ViewState#1");
ObjectDataSourceView copy = new ObjectDataSourceView (ds, "DefaultView", null);
((IStateManager) copy).LoadViewState (state);
}
public void ViewStateSupport ()
{
ObjectDataSourceView view;
MyDataSource ds = new MyDataSource ();
ds.ID = "ObjectDataSource2";
ds.TypeName = "MonoTests.System.Web.UI.WebControls.DataSourceObject";
ds.SelectMethod = "Select";
ds.SelectCountMethod = "SelectCount";
view = (ObjectDataSourceView) ds.DoGetView ("DefaultView");
((IStateManager) view).TrackViewState ();
Parameter p1 = new Parameter ("test", TypeCode.String);
Assert.IsTrue (((IStateManager) view).IsTrackingViewState, "IsTrackingViewState");
Assert.IsTrue (((IStateManager) view.FilterParameters).IsTrackingViewState, "FilterParameters.IsTrackingViewState");
Assert.IsTrue (((IStateManager) view.SelectParameters).IsTrackingViewState, "SelecteParameters.IsTrackingViewState");
Assert.IsFalse (((IStateManager) view.DeleteParameters).IsTrackingViewState, "DeleteParameters.IsTrackingViewState");
Assert.IsFalse (((IStateManager) view.InsertParameters).IsTrackingViewState, "InsertParameters.IsTrackingViewState");
Assert.IsFalse (((IStateManager) view.UpdateParameters).IsTrackingViewState, "UpdateParameters.IsTrackingViewState");
object state = ((IStateManager) view).SaveViewState ();
Assert.IsNull (state, "view ViewState not null");
view.DeleteParameters.Add (p1);
view.InsertParameters.Add (p1);
//view.UpdateParameters.Add (p1);
state = ((IStateManager) view).SaveViewState ();
Assert.IsNull (state, "view ViewState not null");
view.FilterParameters.Add (p1);
//view.SelectParameters.Add (p1);
state = ((IStateManager) view).SaveViewState ();
Assert.IsNotNull (state, "view ViewState not null");
state = ((IStateManager) view.FilterParameters).SaveViewState ();
Assert.IsNotNull (state, "FilterParamenters ViewState not null");
state = ((IStateManager) view.SelectParameters).SaveViewState ();
Assert.IsNull (state, "SelectParameters ViewState not null");
state = ((IStateManager) view.DeleteParameters).SaveViewState ();
Assert.IsNotNull (state, "DeleteParameters ViewState not null");
state = ((IStateManager) view.InsertParameters).SaveViewState ();
Assert.IsNotNull (state, "InsertParameters ViewState not null");
state = ((IStateManager) view.UpdateParameters).SaveViewState ();
Assert.IsNull (state, "UpdateParameters ViewState not null");
}
public static void DataGrid1_UpdateCommand (object source, DataGridCommandEventArgs e)
{
DataGrid DataGrid1 = (DataGrid) source;
MyDataSource ds = new MyDataSource ();
TextBox edittedName = (TextBox) e.Item.Cells [1].Controls [0];
ds.UpdateItem (e.Item.DataSetIndex, Int32.Parse (e.Item.Cells [0].Text), edittedName.Text);
DataGrid1.EditItemIndex = -1;
DataGrid1.DataBind ();
}
public static void DataGrid1_DeleteCommand (object source, DataGridCommandEventArgs e)
{
DataGrid DataGrid1 = (DataGrid) source;
MyDataSource ds = new MyDataSource ();
ds.DeleteItem (e.Item.DataSetIndex);
DataGrid1.DataBind ();
}