/// <summary>
/// 填充数据表，返回一个新的DataTable;
/// </summary>
/// <param name="uadapter">MySql_Utils下的工具数据类型</param>
private void Fill_Form(ref MySqlCmd.MySqlAdapter uadapter)
{
try {
DataSet ds = new DataSet();
uadapter.adapter.Fill(ds, "order_form");
DataTable dt = ds.Tables["order_form"];
DataTable view_dt = new DataTable();
for (int i = 0; i < uadapter.columns.Length; i++)
{
view_dt.Columns.Add(uadapter.columns[i]);
}
DataRow new_row = null;
foreach (DataRow row in dt.Rows)
{
new_row = view_dt.NewRow();
for (int i = 0; i < uadapter.columns.Length; i++)
{
new_row[i] = row[Database.convert_name_columns(uadapter.columns[i])];
}
view_dt.Rows.Add(new_row);
}
uadapter.grid_view.DataSource = view_dt;
uadapter.grid_view.DataBind();
uadapter.data_table = view_dt;
}
catch (Exception ex) {
return;
}
}
protected void FilledCurrentDataGrid()
{
string select_string = "SELECT * FROM ORDER_FORM";
MySqlCmd.MySqlAdapter adapter = new MySqlCmd.MySqlAdapter();
adapter.grid_view = this.GridView1;
adapter.columns = other_cabinet_column;
FormFillTools.FilledCurrentForm(WebConfigurationManager.ConnectionStrings["senshang_database_connection_string"].ToString(),
select_string, ref adapter);
g_dt = adapter.data_table;
}
protected void FilledCurrentDataGrid(string search_string)
{
string select_string = "SELECT * FROM ORDER_FORM WHERE `" + Database.convert_columns_name("item") + "` = \"" +
search_string.Trim() + "\" OR `" + Database.convert_columns_name("owner") + "` =\"" + search_string.Trim()
+ "\" OR `" + Database.convert_columns_name("confirm_number") + "` =\"" + search_string.Trim() + "\"";
MySqlCmd.MySqlAdapter adapter = new MySqlCmd.MySqlAdapter();
adapter.grid_view = this.GridView1;
adapter.columns = other_cabinet_column;
FormFillTools.FilledCurrentForm(WebConfigurationManager.ConnectionStrings["senshang_database_connection_string"].ToString(),
select_string, ref adapter);
g_dt = adapter.data_table;
}
/// <summary>
/// 此方法提供了一个统一的填充DataGridView对象的实现模板
/// </summary>
/// <param name="select_string">调用的MySql select syntax</param>
/// <param name="grid_view">需要填充的GridView对象</param>
/// <param name="columns">填充时构造的数据列名</param>
/// <returns>返回一个DataTable对象</returns>
public static DataTable UtilityFilledGridViewFunction(GridView grid_view, string[] columns, string select_string = null)
{
string select = null;
if (select_string == null)
{
select = PlatformManage.User._user.Select_string;
}
else
{
select = select_string;
}
MySqlCmd.MySqlAdapter adapter = new MySqlCmd.MySqlAdapter();
adapter.grid_view = grid_view;
adapter.columns = columns;
FormFillTools.FilledCurrentForm(WebConfigurationManager.ConnectionStrings["MySqlConnectionString"].ToString(),
select, ref adapter);
return(adapter.data_table);
}
/// <summary>
/// 填充表格
/// </summary>
/// <param name="select_string">数据库SELECT命令</param>
/// /// <returns>view_dt应返回给一个用户自定义的全局DataTable</returns>
public static void FilledCurrentForm(string connect_string, string select_string, ref MySqlCmd.MySqlAdapter adapter)
{
MySqlConnection conn = MySqlCmd.Connection(connect_string);
MySqlCmd.SetMySqlDataAdapter(select_string, conn, ref adapter, Instance.Fill_Form);
}
