public List <clt_detail_info> Readt_PICServer(string conditions)
{
OleDbConnection aConnection = new OleDbConnection(ConStr);
List <clt_detail_info> ClaimReport_Server = new List <clt_detail_info>();
if (aConnection.State == ConnectionState.Closed)
{
aConnection.Open();
}
OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(conditions, aConnection);
OleDbCommandBuilder mybuilder = new OleDbCommandBuilder(myDataAdapter);
DataSet ds = new DataSet();
myDataAdapter.Fill(ds, "Detailed");
foreach (DataRow reader in ds.Tables["Detailed"].Rows)
{
clt_detail_info item = new clt_detail_info();
if (reader["id"].ToString() != "")
{
item.Order_id = reader["id"].ToString();
}
//if (reader["FItemID"].ToString() != "")
// item.Order_id = reader["FItemID"].ToString();
if (reader["img"].ToString() != "")
{
item.img = reader["img"].ToString();
item.imagebytes = (byte[])reader["img"];
}
if (reader["no"].ToString() != "")
{
item.no = reader["no"].ToString();
}
if (reader["num"].ToString() != "")
{
item.num = reader["num"].ToString();
}
if (reader["FFileName"].ToString() != "")
{
item.FFileName = reader["FFileName"].ToString();
}
ClaimReport_Server.Add(item);
//这里做数据处理....
}
return(ClaimReport_Server);
}
private void InitialSystemInfo()
{
readCards = new List <clt_detail_info>();
FileStream fs;
string file = @"C:\" + DateTime.Now.ToString("yyyyMMddHHmmssff") + ".BMP";
fs = new FileStream(file, FileMode.OpenOrCreate, FileAccess.Write);
for (int i = 0; i < 100; i++)
{
clt_detail_info item = new clt_detail_info();
item.Order_id = i.ToString();
item.num = "nmm" + i.ToString();
item.no = "no" + i.ToString();
#region 绑定图片列 HTTP
//string mdbpath2_Ctirx = AppDomain.CurrentDomain.BaseDirectory + "\\116ae547bbc0baa3528d6b3f81cb7812.jpg";//记录 Status click 和选择哪个服务器
//mdbpath2_Ctirx = "https://images.cnblogs.com/cnblogs_com/dylanwind/Photo.PNG";
//item.image_path = mdbpath2_Ctirx;
//string sql2 = "select * from Detailed where id='" + item.Order_id + "'";
//List<clt_detail_info> readCards1 = BusinessHelp.Readt_PICServer(sql2);
//if (readCards1.Count > 0 && readCards1[0].imagebytes != null)
//{
// file = @"C:\" + DateTime.Now.ToString("yyyyMMddHHmmssff") + ".BMP";
// fs = new FileStream(file, FileMode.OpenOrCreate, FileAccess.Write);
// fs.Write(readCards1[0].imagebytes, 0, readCards1[0].imagebytes.GetUpperBound(0));
// item.image_path = file;
//}
#endregion
readCards.Add(item);
}
fs.Close();
//绑定dav
this.gvList.AutoGenerateColumns = false;
sortablePendingOrderList = new SortableBindingList <clt_detail_info>(readCards);
this.gvList.DataSource = sortablePendingOrderList;
gvList.DataKeyNames = new string[] { "Order_id" };//主键
this.gvList.DataBind();
}
