/// <summary>
/// 修改药品信息
/// </summary>
/// <returns>影响行数</returns>
public int changeDrug()
{
string change_sql = string.Format("UPDATE tb_drug SET d_name='{0}',d_unit={1},d_spec='{2}',d_origin='{3}',d_lot_num='{4}',d_reserve={5},d_w_price={6},d_r_price={7} WHERE d_id={8}", Name, Unit, Spec, Origin, Lot_num, Reserve, W_price, R_price, KEY);
int result = MySqlTools.ExecuteNonQuery(change_sql);
return(result);
}
/// <summary>
/// 订单信息写入数据库
/// </summary>
private void insertOrder(Drug drug, double n)
{
string date = DateTime.Now.ToLongDateString().ToString();
string name = drug.Name;
double number = n;
double r_price = drug.R_price;
double money = (drug.R_price - drug.W_price) * n;
string sql = string.Format("INSERT INTO tb_order (o_time,o_name,o_num,o_r_price,o_money) VALUES ('{0}','{1}',{2},{3},{4})", date, name, number, r_price, money);
int result = MySqlTools.ExecuteNonQuery(sql);
}
/// <summary>
/// 带参构造器，用于修改信息是显示当前信息
/// </summary>
/// <param name="key">主键</param>
public Drug(int key)
{
KEY = key;
//根据KEY Select tb_drug；初始化属性
string sql = "SELECT * FROM tb_drug WHERE d_id=" + key;
DataTable dt = MySqlTools.GetDataSet(sql).Tables[0];
Name = dt.Rows[0][1].ToString();
Unit = (int)dt.Rows[0][2];
Spec = dt.Rows[0][3].ToString();
Origin = dt.Rows[0][4].ToString();
Lot_num = dt.Rows[0][5].ToString();
Reserve = (double)dt.Rows[0][6];
W_price = (double)dt.Rows[0][7];
R_price = (double)dt.Rows[0][8];
}
/// <summary>
/// 添加药品信息
/// </summary>
/// <returns>影响的行数</returns>
public int addDrug()
{
string sql = string.Format("select * from tb_drug where d_name='{0}'", Name);
try
{
if ((int)MySqlTools.ExecuteScalar(sql) > 0)
{
return(-1);
}
}
catch (Exception)
{
}
string add_sql = string.Format("INSERT INTO tb_drug (d_name,d_unit,d_spec,d_origin,d_lot_num,d_reserve,d_w_price,d_r_price) VALUES ('{0}', {1},'{2}','{3}','{4}',{5},{6},{7})", Name, Unit, Spec, Origin, Lot_num, Reserve, W_price, R_price);
int result = MySqlTools.ExecuteNonQuery(add_sql);
return(result);
}
