/// <summary>
/// 判断是否登陆成功
/// </summary>
/// <param name="userName">用户名</param>
/// <param name="password">密码</param>
/// <returns></returns>
public bool LoginIn(string userName, string password)
{
if (IsUserExist(userName))
{
string sql = $"select count(*) from Users Where userName = '******' and password = '******';";
return((int)AccessDbHelper.SelectForScalar(sql) > 0);
}
return(false);
}
public override void InitializeDisplay()
{
using (var helper = new AccessDbHelper())
{
Items = helper.GetDataTable(@"SELECT * FROM [CUSTOMER] WHERE ISDELETED = 0").ToItemList <Customer>().Select(x => (IModel)x.ToViewModel()).ToList();
}
base.InitializeDisplay();
}
public override void InitializeDisplay()
{
using (var helper = new AccessDbHelper())
{
Items = helper.GetDataTable(string.Format(@"SELECT * FROM [Prescription] WHERE CustomerId= {0} AND ISDELETED = 0", CustomerInfo.Id)).ToItemList <Prescription>().Select(x => (IModel)x.ToViewModel()).ToList();
}
base.InitializeDisplay();
}
private void btnSelectDrugs_Click(object sender, EventArgs e)
{
string sql = string.Format("select *from DrugsTable");;
if (txtDrugs.Text.Trim() != string.Empty)
{
sql += string.Format(" where DrugsName like '%{0}%'", txtDrugs.Text.Trim());
}
DataTable dt = AccessDbHelper.ExecuteDataTable(sql);
dataGridView1.DataSource = dt;
}
protected override void ProcessRecord()
{
WriteProgress(new ProgressRecord(1, "Conversion", "Converting database..."));
AccessDbHelper acccessdbHelper = new AccessDbHelper(AccessDbFilePath, "Database");
IJsonConverter dbJsonConverter = new DataSetConverter(acccessdbHelper.GetDataSet());
string databaseJson = dbJsonConverter.ConvertToJson();
if (SaveOutputToFile)
{
FileHelper.SaveToFile(databaseJson, $"output_{Guid.NewGuid()}.json");
}
WriteObject(databaseJson);
}
private void Login(object payload)
{
if (string.IsNullOrEmpty(UserName) || string.IsNullOrEmpty(Password))
{
Logger.Warn(string.Format("Login attemp failed for user {0}", UserName));
MessageBox.Show("用户名或者密码不能为空！", "登录失败", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
using (AccessDbHelper helper = new AccessDbHelper())
{
object passObject = null;
try
{
passObject = helper.ExecuteScalar(string.Format("SELECT [PASSWORD] FROM [USER] WHERE USERNAME='******'", UserName));
}
catch (Exception)
{
Logger.Warn(string.Format("Login attemp failed for user {0}", UserName));
//Noting to do
//Password can't be got.
}
if (passObject != null && passObject.ToString() == Password)
{
Logger.Info(string.Format("User {0} login.", UserName));
AppContext.CurrentUser.UserName = UserName;
//AppContext.CurrentUser = new Entity.UserEntity() { UserName = UserName };
OnBack("");
}
else
{
Logger.Warn(string.Format("Login attemp failed for user {0}", UserName));
MessageBox.Show("用户名或者密码不正确！", "登录失败", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
//int count = (int)helper.ExecuteScalar(string.Format("select count(*) from [user] where username='******' and password='******'", UserName, Password));
//if (count > 0)
//{
// OnBack("");
//}
//else
//{
// Logger.Warn(string.Format("Login attemp failed for user {0}", UserName));
// MessageBox.Show("用户名或者密码不正确！", "登录失败", MessageBoxButton.OK, MessageBoxImage.Error);
// return;
//}
}
}
public List <string> GetTeacher()
{
string sql = "select RealName from Users Where IsTeacher = true;";
var dr = AccessDbHelper.SelectForDataReader(sql);
List <string> teachers = new List <string>();
while (dr.Read())
{
string TeacherName = dr["RealName"].ToString();
teachers.Add(TeacherName);
}
return(teachers);
}
private void dataGridView3_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
try
{
//取消打印
if (dataGridView3.Columns[e.ColumnIndex].Name == "btnPrintDel")
{
int RowIndex = Convert.ToInt32(e.RowIndex);
string DrugsID = dataGridView3.Rows[RowIndex].Cells[0].Value.ToString();
string SelectSQL = string.Format("select *from DrugsTable where DrugsID={0}", DrugsID);
string UpdateSQL;
DataTable dt = AccessDbHelper.ExecuteDataTable(SelectSQL);
//库存数据变更
//查询现有库存数量
int stock = Convert.ToInt32(dt.Rows[0]["Stock"]);
//删除打印的数量与现有库存相加
stock += Convert.ToInt32(dataGridView3.Rows[RowIndex].Cells[10].Value);
//更新现有库存数据
UpdateSQL = string.Format("UPDATE DrugsTable SET Stock='{0}' WHERE DrugsID={1} ", stock, DrugsID);
if (!(AccessDbHelper.ExecuteNonQuery(UpdateSQL) > 0))
{
if (!ignore)//判断消息是否要忽略
{
DialogResult dialogResult = MessageBox.Show("更新库存失败,但不会影响您的打印！不再提示此类消息？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Error);
if (dialogResult == System.Windows.Forms.DialogResult.Yes)
{
ignore = true;
}
}
}
//删除打印区的数据
DataGridViewRow row = dataGridView3.Rows[RowIndex];
dataGridView3.Rows.Remove(row);
//重新计算价格
CountNum();
//刷新库存
btnSelectDrugs_Click(null, null);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public List <Storage> GetAllStorage()
{
var dr = AccessDbHelper.SelectDataReader("select * from Storage;");
List <Storage> storages = new List <Storage>();
while (dr.Read())
{
Storage storage = new Storage();
storage.Id = dr["Id"].ToString();
storage.SlaveAddress = Convert.ToInt32(dr["Id"].ToString());
storage.FuncCode = dr["Id"].ToString();
storage.StartAddress = Convert.ToInt32(dr["Id"].ToString());
storage.Length = Convert.ToInt32(dr["Id"].ToString());
storages.Add(storage);
}
return(storages);
}
public static bool DeleteFromDb(this IDataModel obj)
{
try
{
using (AccessDbHelper helper = new AccessDbHelper())
{
helper.ExecuteSQLNonQuery(string.Format("UPDATE [{0}] SET ISDELETED =1 WHERE ID={1}", obj.GetType().Name, ((IDataModel)obj).Id));
}
return(true);
}
catch (Exception ex)
{
ApplicationContext.Current.Logger.Error("DeleteFromDb failed.", ex);
}
return(false);
}
/// <summary>
///
/// </summary>
/// <param name="RowIndex">第RowIndex行</param>
/// <param name="GoodsCount">出仓货物数量</param>
void AddPrintItemToGridView(int RowIndex, int GoodsCount)
{
//获取主键标识
string DrugsID = dataGridView1.Rows[RowIndex].Cells["DrugsID"].Value.ToString();
int surplus = Convert.ToInt32(dataGridView1.Rows[RowIndex].Cells["Stock"].Value) - GoodsCount;
string strSQL = string.Format("UPDATE DrugsTable SET Stock='{0}' WHERE DrugsID={1}", surplus, DrugsID);
try
{
//数据库更新库存数据
//BUG 执行成功依然返回0
//if (AccessDbHelper.ExecuteNonQuery(strSQL) > 0)
//{
// //只提示用户库存未更新！不影响用户使用打印数据
// MessageBox.Show("库存信息更新失败！您依然可以进行打印，但库存信息有错误！");
//}
//更新库存
AccessDbHelper.ExecuteNonQuery(strSQL);
//取得其他字段值
string DrugsName = dataGridView1.Rows[RowIndex].Cells["DrugsName"].Value.ToString();
string Specification = dataGridView1.Rows[RowIndex].Cells["Specification"].Value.ToString();
string Model = dataGridView1.Rows[RowIndex].Cells["Model"].Value.ToString();
string Unti = dataGridView1.Rows[RowIndex].Cells["Unti"].Value.ToString();
string Price = dataGridView1.Rows[RowIndex].Cells["Price"].Value.ToString();
string Origin = dataGridView1.Rows[RowIndex].Cells["Origin"].Value.ToString();
string Batch = dataGridView1.Rows[RowIndex].Cells["Batch"].Value.ToString();
string ProductionDate = Convert.ToDateTime(dataGridView1.Rows[RowIndex].Cells["ProductionDate"].Value).ToString("yyyy-MM-dd");
string Validity = Convert.ToDateTime(dataGridView1.Rows[RowIndex].Cells["Validity"].Value).ToString("yyyy-MM-dd");
string Stock = GoodsCount.ToString();
string Quality = dataGridView1.Rows[RowIndex].Cells["Quality"].Value.ToString();
dataGridView3.Rows.Add(DrugsID, DrugsName, Specification, Model, Unti, Price, Origin, Batch, ProductionDate, Validity, Stock, Quality);
//清空：计算价格
CountNum();
}
catch (Exception ex)
{
MessageBox.Show("库存信息更新失败！请稍后再试。错误信息:" + ex.Message);
}
finally {
//刷新表格数据
btnSelectDrugs_Click(null, null);
}
}
public static bool SaveToDb(this IDataModel obj)
{
try
{
using (var helper = new AccessDbHelper())
{
string insertParams = GetInsertString(obj);
helper.ExecuteSQLNonQuery(string.Format("INSERT INTO [{0}] {1}", obj.GetType().Name, insertParams));
}
return(true);
}
catch (Exception ex)
{
ApplicationContext.Current.Logger.Error("DeleteFromDb failed.", ex);
}
return(false);
}
public static bool UpdateToDb(this IDataModel obj)
{
try
{
using (var helper = new AccessDbHelper())
{
string updateParams = GetUpdateString(obj);
helper.ExecuteSQLNonQuery(string.Format("UPDATE [{0}] SET {1}", obj.GetType().Name, updateParams));
}
return(true);
}
catch (Exception ex)
{
ApplicationContext.Current.Logger.Error("DeleteFromDb failed.", ex);
}
return(false);
}
/// <summary>
/// 获取当前用户信息
/// </summary>
/// <param name="userName">用户名</param>
/// <returns>返回用户信息</returns>
public User GetUserInfo(string userName)
{
string sql = $"select * from Users Where userName = '******';";
var dr = AccessDbHelper.SelectForDataReader(sql);
User user = new User();
while (dr.Read())
{
user.UserID = dr["UserID"].ToString();
user.UserName = dr["UserName"].ToString();
user.RealName = dr["RealName"].ToString();
user.Password = dr["Password"].ToString();
user.Avatar = dr["Avatar"].ToString();
user.Gender = Convert.ToInt32(dr["Gender"]);
user.IsValidation = (bool)dr["IsValidation"];
user.IsCanLogin = (bool)dr["IsCanLogin"];
user.IsTeacher = (bool)dr["IsTeacher"];
}
return(user);
}
private void btnAdd_Click(object sender, EventArgs e)
{
string StrSql = "insert into DrugsTable (DrugsName,Specification,Model,Unti,Price,Origin,Batch,ProductionDate,Validity,Stock,Quality)values(@DrugsName,@Specificatio,@Model,@Unti,@Price,@Origin,@Batch,@ProductionDate,@Validity,@Stock,@Quality)";
try
{
if (AccessDbHelper.ExecuteNonQuery(StrSql,
new OleDbParameter("@DrugsName", txtDrugsName.Text.Trim()),
new OleDbParameter("@Specification", txtSpecification.Text.Trim()),
new OleDbParameter("@Model", txtModel.Text.Trim()),
new OleDbParameter("@Unti", txtUnti.Text.Trim()),
new OleDbParameter("@Price", txtPrice.Text.Trim() == string.Empty?"0":txtPrice.Text.Trim()),
new OleDbParameter("@Origin", txtOrigin.Text.Trim()),
new OleDbParameter("@Batch", txtBatch.Text.Trim()),
new OleDbParameter("@ProductionDate", dtpProductionDate.Value.ToShortDateString()),
new OleDbParameter("@Validity", dtpValidity.Value.ToShortDateString()),
new OleDbParameter("@Stock", txtStock.Text.Trim() == string.Empty?"0":txtStock.Text.Trim()),
new OleDbParameter("@Quality", txtQuality.Text.Trim())
) > 0)
{
txtDrugsName.Text = string.Empty;
txtBatch.Text = string.Empty;
txtModel.Text = string.Empty;
txtOrigin.Text = string.Empty;
txtPrice.Text = string.Empty;
txtQuality.Text = string.Empty;
txtSpecification.Text = string.Empty;
txtStock.Text = string.Empty;
txtUnti.Text = string.Empty;
MessageBox.Show("添加成功！");
}
else
{
MessageBox.Show("添加失败！");
}
}
catch (Exception ex)
{
MessageBox.Show("添加失败！");
}
}
public static void Upgrade()
{
//IDataModel
var assembly = typeof(IDataModel).Assembly;
var dataModelList = assembly.GetTypes().Where(x => x.GetInterfaces().Contains(typeof(IDataModel))).ToList();
foreach (var item in dataModelList)
{
string tableName = item.Name;
var properties = item.GetProperties();
using (var helper = new AccessDbHelper())
{
var table = helper.GetDataTable(string.Format("SELECT * FROM [{0}]", tableName));
foreach (var property in properties)
{
if (!table.Columns.Contains(property.Name))
{
helper.ExecuteSQLNonQuery(string.Format("ALTER TABLE [{0}] ADD COLUMN [{1}] {2}", tableName, property.Name, GetDBType(property)));
}
}
}
}
}
//清除打印区
private void btnClearPrint_Click(object sender, EventArgs e)
{
foreach (DataGridViewColumn Columns in dataGridView3.Columns)
{
foreach (DataGridViewRow row in dataGridView3.Rows)
{
//获取取消打印行的数据的主键
string DrugsID = row.Cells[0].Value.ToString();
//查询取消打印行现有库存数量
string SelectSQL = string.Format("select *from DrugsTable where DrugsID={0}", DrugsID);
DataTable dt = AccessDbHelper.ExecuteDataTable(SelectSQL);
int stock = Convert.ToInt32(dt.Rows[0]["Stock"]);
//删除打印的数量与现有库存相加
stock += Convert.ToInt32(row.Cells[10].Value);
//更新现有库存数据
string UpdateSQL = string.Format("UPDATE DrugsTable SET Stock='{0}' WHERE DrugsID={1}", stock, DrugsID);
if (!(AccessDbHelper.ExecuteNonQuery(UpdateSQL) > 0))
{
if (!ignore)//判断消息是否要忽略
{
DialogResult dialogResult = MessageBox.Show("更新库存失败,但不会影响您的打印！不再提示此类消息？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Error);
if (dialogResult == System.Windows.Forms.DialogResult.Yes)
{
ignore = true;
}
}
}
dataGridView3.Rows.Remove(row);//删除行
}
}
//刷新表格数据
btnSelectDrugs_Click(null, null);
//清空：计算价格
CountNum();
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
//删除
if (dataGridView1.Columns[e.ColumnIndex].Name == "colbtnDel")
{
int RowIndex = Convert.ToInt32(e.RowIndex);
//点击按钮操作
string DrugsID = dataGridView1.Rows[RowIndex].Cells["DrugsID"].Value.ToString();
string DrugsName = dataGridView1.Rows[RowIndex].Cells["DrugsName"].Value.ToString();
DialogResult dr = MessageBox.Show(string.Format("确认删除[{0}]吗", DrugsName), "提示", MessageBoxButtons.OKCancel);
if (dr == DialogResult.OK)
{
//数据删除
string strSQL = string.Format("DELETE FROM DrugsTable WHERE DrugsID = {0} ", DrugsID);
if (AccessDbHelper.ExecuteNonQuery(strSQL) > 0)
{
//刷新DataGridView
btnSelectDrugs_Click(null, null);
}
else
{
MessageBox.Show(string.Format("删除时 [{0}] 失败！", DrugsName));
}
}
}
//编辑
else if (dataGridView1.Columns[e.ColumnIndex].Name == "colbtnEdit")
{
try
{
int RowIndex = Convert.ToInt32(e.RowIndex);
//主键
string DrugsID = dataGridView1.Rows[RowIndex].Cells["DrugsID"].Value.ToString();
//取得其他字段值
string DrugsName = dataGridView1.Rows[RowIndex].Cells["DrugsName"].Value.ToString();;
string Specification = dataGridView1.Rows[RowIndex].Cells["Specification"].Value.ToString();
string Model = dataGridView1.Rows[RowIndex].Cells["Model"].Value.ToString();
string Unti = dataGridView1.Rows[RowIndex].Cells["Unti"].Value.ToString();
string Price = dataGridView1.Rows[RowIndex].Cells["Price"].Value.ToString();
string Origin = dataGridView1.Rows[RowIndex].Cells["Origin"].Value.ToString();
string Batch = dataGridView1.Rows[RowIndex].Cells["Batch"].Value.ToString();
string ProductionDate = dataGridView1.Rows[RowIndex].Cells["ProductionDate"].Value.ToString();
string Validity = dataGridView1.Rows[RowIndex].Cells["Validity"].Value.ToString();
string Stock = dataGridView1.Rows[RowIndex].Cells["Stock"].Value.ToString();
string Quality = dataGridView1.Rows[RowIndex].Cells["Quality"].Value.ToString();
//构造执行语句
string strSQL = string.Format("UPDATE DrugsTable SET DrugsName='{0}',Specification='{1}',Model='{2}',Unti='{3}',Price='{4}',Origin='{5}',Batch='{6}',ProductionDate='{7}',Validity='{8}',Stock='{9}',Quality='{10}' WHERE DrugsID={11}",
DrugsName,
Specification,
Model,
Unti,
Price == null || Price == string.Empty?"0":Price,
Origin,
Batch,
ProductionDate,
Validity,
Stock == null || Stock == string.Empty ? "0" : Stock,
Quality,
DrugsID
);
if (AccessDbHelper.ExecuteNonQuery(strSQL) > 0)
{
MessageBox.Show("修改成功！");
//刷新DataGridView
btnSelectDrugs_Click(null, null);
}
else
{
MessageBox.Show("修改失败！请检查数据是否填写正确");
}
}
catch
{
MessageBox.Show("修改失败！");
}
}
//打印
else if (dataGridView1.Columns[e.ColumnIndex].Name == "colbtnPrint")
{
try
{
int RowIndex = Convert.ToInt32(e.RowIndex);
//主键
string DrugsID = dataGridView1.Rows[RowIndex].Cells["DrugsID"].Value.ToString();
string DrugsName = dataGridView1.Rows[RowIndex].Cells["DrugsName"].Value.ToString();
int GoodsCount = Convert.ToInt32(dataGridView1.Rows[RowIndex].Cells["Stock"].Value);
CallBack AddPrint_CallBack = new CallBack(AddPrintItemToGridView);
new AddPrint(AddPrint_CallBack, RowIndex, DrugsName, GoodsCount).ShowDialog();
//MessageBox.Show(dataGridView3.Rows[0].Cells[0].Value.ToString());
}
catch (Exception)
{
throw;
}
}
}
/// <summary>
/// 判断用户名是否存在
/// </summary>
/// <param name="userName">用户名</param>
/// <returns>存在或不存在</returns>
public bool IsUserExist(string userName)
{
string sql = $"select count(*) from Users Where userName = '******';";
return((int)AccessDbHelper.SelectForScalar(sql) > 0);
}
private void MainForm_Load(object sender, EventArgs e)
{
dataGridView1.RowsDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView3.RowsDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
//ReportParameterCostume ReportParameterPrintDate ReportParameterID ReportParameterRed ReportParameterCountAll
//ReportParameterCountAllCN ReportParameterDrawer ReportParameterPhone ReportParameterRecAddr ReportParameterWhite ReportParameterBlue
//ReportParameterSalesman ReportParameterVerification ReportParameterDelivery ReportParameterSaver ReportParameterPrintTime
PrintParams.Add("ReportParameterCostume", "");
PrintParams.Add("ReportParameterPrintDate", "");
PrintParams.Add("ReportParameterID", "");
PrintParams.Add("ReportParameterRed", "");
PrintParams.Add("ReportParameterCountAll", "");
PrintParams.Add("ReportParameterCountAllCN", "");
PrintParams.Add("ReportParameterDrawer", "");
PrintParams.Add("ReportParameterPhone", "");
PrintParams.Add("ReportParameterRecAddr", "");
PrintParams.Add("ReportParameterWhite", "");
PrintParams.Add("ReportParameterBlue", "");
PrintParams.Add("ReportParameterSalesman", "");
PrintParams.Add("ReportParameterVerification", "");
PrintParams.Add("ReportParameterDelivery", "");
PrintParams.Add("ReportParameterSaver", "");
PrintParams.Add("ReportParameterPrintTime", "");
PrintParams.Add("ReportParameterYellow", "");
#region 初始化数据库
string filePath = Environment.CurrentDirectory + @"\DrugsDatabase.mdb";
//初始化数据库，若数据库不存在则创建
if (!File.Exists(filePath))
{
if (AccessDbHelper.CreateAccessDb(filePath))
{
#region 初始化表字段
//药品名称 DrugsName
ADOX.ColumnClass DrugsName = new ADOX.ColumnClass
{
//ParentCatalog = catalog,
Name = "DrugsName",
Attributes = ColumnAttributesEnum.adColNullable, //允许空值
Type = DataTypeEnum.adVarWChar,
DefinedSize = 255,
};
//规格 Specification
ADOX.ColumnClass Specification = new ADOX.ColumnClass
{
//ParentCatalog = catalog,
Name = "Specification",
Attributes = ColumnAttributesEnum.adColNullable, //允许空值
Type = DataTypeEnum.adVarWChar,
DefinedSize = 255,
};
//型号 Model
ADOX.ColumnClass Model = new ADOX.ColumnClass
{
//ParentCatalog = catalog,
Name = "Model",
Attributes = ColumnAttributesEnum.adColNullable, //允许空值
Type = DataTypeEnum.adVarWChar,
DefinedSize = 50,
};
//单位 Unti
ADOX.ColumnClass Unti = new ADOX.ColumnClass
{
//ParentCatalog = catalog,
Name = "Unti",
Attributes = ColumnAttributesEnum.adColNullable, //允许空值
Type = DataTypeEnum.adVarWChar,
DefinedSize = 50,
};
//单价 Price
ADOX.ColumnClass Price = new ADOX.ColumnClass
{
//ParentCatalog = catalog,
Name = "Price",
Attributes = ColumnAttributesEnum.adColNullable, //允许空值
Type = DataTypeEnum.adDouble,
DefinedSize = 50,
};
//产地 Origin
ADOX.ColumnClass Origin = new ADOX.ColumnClass
{
//ParentCatalog = catalog,
Name = "Origin",
Attributes = ColumnAttributesEnum.adColNullable, //允许空值
Type = DataTypeEnum.adVarWChar,
DefinedSize = 255,
};
//批准批号 Batch
ADOX.ColumnClass Batch = new ADOX.ColumnClass
{
//ParentCatalog = catalog,
Name = "Batch",
Attributes = ColumnAttributesEnum.adColNullable, //允许空值
Type = DataTypeEnum.adVarWChar,
DefinedSize = 50,
};
//生产日期 ProductionDate
ADOX.ColumnClass ProductionDate = new ADOX.ColumnClass
{
//ParentCatalog = catalog,
Name = "ProductionDate",
Attributes = ColumnAttributesEnum.adColNullable, //允许空值
Type = ADOX.DataTypeEnum.adDate,
};
//有效日期 Validity
ADOX.ColumnClass Validity = new ADOX.ColumnClass
{
//ParentCatalog = catalog,
Name = "Validity",
Attributes = ColumnAttributesEnum.adColNullable, //允许空值
Type = ADOX.DataTypeEnum.adDate,
};
//库存 Stock
ADOX.ColumnClass Stock = new ADOX.ColumnClass
{
//ParentCatalog = catalog,
Name = "Stock",
Attributes = ColumnAttributesEnum.adColNullable, //允许空值
Type = ADOX.DataTypeEnum.adInteger,
DefinedSize = 100
};
//质量状况 Quality
ADOX.ColumnClass Quality = new ADOX.ColumnClass
{
//ParentCatalog = catalog,
Name = "Quality",
Attributes = ColumnAttributesEnum.adColNullable, //允许空值
Type = ADOX.DataTypeEnum.adVarWChar,
DefinedSize = 255
};
#endregion
List <ADOX.ColumnClass> columns = new List <ADOX.ColumnClass>();
columns.Add(DrugsName);
columns.Add(Specification);
columns.Add(Model);
columns.Add(Unti);
columns.Add(Price);
columns.Add(Origin);
columns.Add(Batch);
columns.Add(ProductionDate);
columns.Add(Validity);
columns.Add(Stock);
columns.Add(Quality);
AccessDbHelper.CreateAccessTable(filePath, "DrugsTable", columns);
}
else
{
MessageBox.Show("数据库创建失败，以管理员身份运行！或添加数据库[DrugsDatabase.mdb]到程序运行目录下。", "警告");
}
}
else
{
ReflashDataGridView();
}
#endregion
#region DataGridView 按钮渲染
DataGridViewButtonColumn btnDel = new DataGridViewButtonColumn();
btnDel.Name = "colbtnDel";
btnDel.HeaderText = "操作";
btnDel.DefaultCellStyle.NullValue = "删除";
DataGridViewButtonColumn btnEdit = new DataGridViewButtonColumn();
btnEdit.Name = "colbtnEdit";
btnEdit.HeaderText = "操作";
btnEdit.DefaultCellStyle.NullValue = "编辑";
DataGridViewButtonColumn btnPrint = new DataGridViewButtonColumn();
btnPrint.Name = "colbtnPrint";
btnPrint.HeaderText = "操作";
btnPrint.DefaultCellStyle.NullValue = "打印";
dataGridView1.Columns.Add(btnDel);
dataGridView1.Columns.Add(btnEdit);
dataGridView1.Columns.Add(btnPrint);
DataGridViewButtonColumn btnPrintDel = new DataGridViewButtonColumn();
btnPrintDel.Name = "btnPrintDel";
btnPrintDel.HeaderText = "操作";
btnPrintDel.DefaultCellStyle.NullValue = "删除";
dataGridView3.Columns.Add(btnPrintDel);
#endregion
}
private void ReflashDataGridView()
{
string strSQL = "select *from DrugsTable";
dataGridView1.DataSource = AccessDbHelper.ExecuteDataTable(strSQL);
}
