DataOperate 类

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data;

namespace PharmacySystems.MyClass
{
   
    class DataOperate
    {
        DataCon  datacon = new DataCon();

        //对ComboBox控件进行数据绑定
        public void cboxBind(string M_str_sqlstr,string M_str_tbName,string M_str_tbMember,ComboBox cbox)
        {
            DataSet ds = datacon.getds(M_str_sqlstr,M_str_tbName);
            cbox.DataSource = ds.Tables[M_str_tbName];
            cbox.DisplayMember = M_str_tbMember;
        }

        //获取编号
        public string getId(string str_Table,string str_Field,string str_First)
        {
            DataSet ds = new DataSet();
            string NewId = "";
            int num = 0;
            string sqlstr = "select * from "+str_Table+" order by "+ str_Field ;
            ds = datacon.getds(sqlstr, str_Table);
            if (ds.Tables[0].Rows.Count == 0)
            {
                NewId = str_First+"00001";
                return NewId;
            }
            else
            {
                string MaxId = ds.Tables[0].Rows[ds.Tables[0].Rows.Count - 1][str_Field].ToString(); //获取已存在的最大值
                //MessageBox.Show(MaxId);
                num = Convert.ToInt32(MaxId.Substring(1, 5)) + 1;
                NewId = str_First + num.ToString("00000");
                return NewId;
            }
        }

        //DateTimePicker转换格式
        public string changgeDateTimePickerFormat(DateTimePicker dtp)
        {
            dtp.Format = DateTimePickerFormat.Custom;
            dtp.CustomFormat = "yyyy-MM-dd";
            string date  = dtp.Text.ToString();
            return date;
        }

        //判断新增时，是否出现DataGridview中的重复项，是返回true 否返回false
        public bool IsDgvRepeat(DataGridView dgv,string str)
        {
            if (dgv.RowCount > 1)
            {
                for (int i = 0; i < dgv.RowCount-1; i++)
                {
                    if (dgv[0, i].Value.ToString() == str)
                    {
                        MessageBox.Show("药品编号：" + str + "已经存在订单表中,请重新选择！");
                        return true;
                    }
                }              
            }  
            return false;
        }
           
    }
}