/// <summary>
/// Prescribe
/// </summary>
/// <param name="T_ID">坐诊ID</param>
/// <param name="M_ID">药品ID</param>
/// <param name="Count">药品数量</param>
public static bool Prescribe(int T_ID, int M_ID, int Count)
{
// 插入药品记录
var command = new SqlCommand("insert into Med_Record values (@T_ID, @M_ID, @Count)");
command.Parameters.AddRange(new SqlParameter[] {
new SqlParameter("@T_ID", T_ID),
new SqlParameter("@M_ID", M_ID),
new SqlParameter("@Count", Count)
});
bool med_log_result = DB.Execute(command);
if (!med_log_result)
{
Console.WriteLine("插入药品记录失败");
}
// 减少库存
var stock = Med.Get_Med_By_Id(M_ID).M_Stock;
var decrease_stock = new SqlCommand("update Med set M_Stock = @M_Stock where M_ID = @M_ID");
decrease_stock.Parameters.AddRange(new SqlParameter[] {
new SqlParameter("@M_ID", M_ID),
new SqlParameter("@M_Stock", stock - Count)
});
bool decrease_stock_result = DB.Execute(decrease_stock);
if (!decrease_stock_result)
{
Console.WriteLine("减少库存失败");
}
return(med_log_result && decrease_stock_result);
}
/// <summary>
/// 创建药品
/// </summary>
/// <param name="med">Med 类对象</param>
public static bool Add(Med med)
{
//初始化SQL命令
var cmd = new SqlCommand(@"insert into Med(M_Name, M_Category, M_Unit, M_Price, M_Stock, M_Effect)"
+ " values(@M_Name, @M_Category, @M_Unit, @M_Price, @M_Stock, @M_Effect)");
cmd.Parameters.AddRange(new SqlParameter[] {
new SqlParameter("@M_Name", med.M_Name),
new SqlParameter("@M_Category", med.M_Category),
new SqlParameter("@M_Unit", med.M_Unit),
new SqlParameter("@M_Price", med.M_Price),
new SqlParameter("@M_Stock", med.M_Stock),
new SqlParameter("@M_Effect", med.M_Effect),
});
//调用执行指令
return(DB.Execute(cmd));
}
public Meds_Management_Edit_Med_Page(Meds_Management_Landing_Page landing_Page, Server.Models.Med med_to_edit)
{
InitializeComponent();
Label_Title.Text = "修改药品";
label9.Text = "修改成功";
Label_Save.Text = "修改";
Landing_Page = landing_Page;
pictureBox1.Image = Properties.Resources.Edit;
Load_Med_Info(med_to_edit);
med = med_to_edit;
}
