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