DataOperate 类

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

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

       //对ComboBox控件进行数据绑定
       public void cboxBind(string M_str_sqlstr,string M_str_tbName,stringM_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,stringstr_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;
       }
           
    }
}