DAL/DALMed.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Models;

namespace DAL
{
    public class DALMed
    {
        //绑定药品数据
        public DataSet MedBind(int a, int b, string c)
        {
            StringBuilder sql = new StringBuilder();
            sql.Append("select * from tb_MedInfo,tb_Bsort,tb_Ssort where ");
            sql.Append("(tb_MedInfo.SsortID = tb_Ssort.SsortID) and (tb_Ssort.BsortID = tb_Bsort.BsortID)"); 
            return SQLHelper.PagedataSet(sql.ToString(), a, b, c);

        }

        //删除某个药品
        public int DeleteMed(CMedInfo med)
        {
            StringBuilder sql = new StringBuilder();
            sql.Append("delete from tb_MedInfo where MedID = @id");
            SqlParameter[] par ={
                                    new SqlParameter ("@id",SqlDbType.Int,4)
                                };
            par[0].Value = med.Med_id;
            return DBHelperSQL.ExecuteSql(sql.ToString(), par);
        }

        //通过药品名称查询药品
        public DataSet SelMN(int a, int b, string c, CMedInfo med)
        { 
            StringBuilder sql = new StringBuilder();
            sql.Append("select * from tb_MedInfo,tb_Bsort,tb_Ssort where ");
            sql.Append("(tb_MedInfo.SsortID = tb_Ssort.SsortID) and (tb_Ssort.BsortID = tb_Bsort.BsortID) and (MedName like '%"+ med.Med_name +"%')"); 
            DataSet ds = SQLHelper.PagedataSet(sql.ToString(), a, b, c);
            return ds;
        }

        //通过药品编号查询药品
        public DataSet SelMid(int a, int b, string c, CMedInfo med)
        {
            StringBuilder sql = new StringBuilder();
            sql.Append("select * from tb_MedInfo,tb_Bsort,tb_Ssort where ");
            sql.Append("(tb_MedInfo.SsortID = tb_Ssort.SsortID) and (tb_Ssort.BsortID = tb_Bsort.BsortID) and (MedID like '%" + med.Med_id + "%')");
            DataSet ds = SQLHelper.PagedataSet(sql.ToString(), a, b, c);
            return ds;
        }

        //通过药品名称查询是否有药品
        public int CountMNa(CMedInfo med)
        {
            string sql = "select count(*) from tb_MedInfo where MedName like '%" + med.Med_name + "%'";
            int result = Convert.ToInt32(DBHelperSQL.ExecuteSqlCell(sql));
            return result;