public void Bind()
{
dataGridViewX1.Columns.Add(new DataGridViewTextBoxColumn()
{
HeaderText = "产地", DataPropertyName = "ProductionAddress", Name = "ProductionAddress"
});
dataGridViewX1.Columns.Add(new DataGridViewTextBoxColumn()
{
HeaderText = "片型", Name = "DrugsBase_Formulation2",
});
dataGridViewX1.Columns.Add(new DataGridViewTextBoxColumn()
{
HeaderText = "制法", Name = "ProductionMethodName",
});
dataGridViewX1.Columns.Add(new DataGridViewTextBoxColumn()
{
HeaderText = "等级", Name = "ProductionLevelName",
});
soso.syntoolSoapClient bll = new soso.syntoolSoapClient();
var li = bll.GetListAll101(PageSize, PageIndex, order, orderField, like, whereField, whereString, sql, Login.authKey);
if (li != null)
{
dataGridViewX1.Rows.Clear();
for (int i = 0; i < li.Tables[0].Rows.Count; i++)
{
dataGridViewX1.Rows.Add();
dataGridViewX1.Rows[i].Cells["ProductionAddress"].Value = li.Tables[0].Rows[i]["ProductionAddress"].ToString().Trim();
dataGridViewX1.Rows[i].Cells["DrugsBase_Formulation2"].Value = li.Tables[0].Rows[i]["DrugsBase_Formulation2"].ToString().Trim();
dataGridViewX1.Rows[i].Cells["ProductionMethodName"].Value = li.Tables[0].Rows[i]["ProductionMethodName"].ToString().Trim();
dataGridViewX1.Rows[i].Cells["ProductionLevelName"].Value = li.Tables[0].Rows[i]["ProductionLevelName"].ToString().Trim();
dataGridViewX1.Rows[i].Cells["Column9"].Value = li.Tables[0].Rows[i]["Product_ID"].ToString().Trim();
dataGridViewX1.Rows[i].Cells["Column1"].Value = li.Tables[0].Rows[i]["DrugsBase_DrugName"].ToString().Trim();
dataGridViewX1.Rows[i].Cells["Column1"].ToolTipText = "双击查看图片";
dataGridViewX1.Rows[i].Cells["Column2"].Value = li.Tables[0].Rows[i]["DrugsBase_Specification"].ToString().Trim();
dataGridViewX1.Rows[i].Cells["Column3"].Value = li.Tables[0].Rows[i]["DrugsBase_Formulation"].ToString().Trim();
dataGridViewX1.Rows[i].Cells[6].Value = li.Tables[0].Rows[i]["DrugsBase_Manufacturer"].ToString().Trim();
dataGridViewX1.Rows[i].Cells[7].Value = li.Tables[0].Rows[i]["DrugsBase_ApprovalNumber"].ToString().Trim();
dataGridViewX1.Rows[i].Cells[8].Value = li.Tables[0].Rows[i]["Registration_No"].ToString().Trim();
dataGridViewX1.Rows[i].Cells["Goods_Unit"].Value = li.Tables[0].Rows[i]["Goods_Unit"].ToString().Trim();
dataGridViewX1.Rows[i].Cells["Goods_Pcs"].Value = li.Tables[0].Rows[i]["Goods_Pcs"].ToString().Trim();
dataGridViewX1.Rows[i].Cells["Goods_Id"].Value = li.Tables[0].Rows[i]["Goods_Id"].ToString().Trim();
dataGridViewX1.Rows[i].Cells["Goods_Pcs_Small"].Value = li.Tables[0].Rows[i]["Goods_Pcs_Small"].ToString().Trim();
var dr = li.Tables[0].Rows[i];
dataGridViewX1.Rows[i].Cells["Column6"].Value = string.Format("{0}{1}/{2}", dr["Goods_ConveRatio"], dr["Goods_ConveRatio_Unit"], dr["Goods_Unit"]);
dataGridViewX1.Rows[i].Cells["Product_ID"].Value = li.Tables[0].Rows[i]["Product_ID"].ToString().Trim();
dataGridViewX1.Rows[i].Cells["Column8"].ToolTipText = li.Tables[0].Rows[i]["Product_ID"].ToString().Trim();
dataGridViewX1.Rows[i].Cells["Column7"].Value = dr["Goods_ConveRatio"].ToString();
}
recordCount = int.Parse(li.Tables[1].Rows[0]["recordCount"].ToString());
pageCount = int.Parse(li.Tables[1].Rows[0]["pageCount"].ToString());
paginger();
}
else
{
MessageBox.Show("您的登陆状态已经失效，请关闭后重新登陆!", "操作失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
