/// <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; }