private void load()
{
SortedDictionary <int, MaterielTypeTable> materielGroupList = new SortedDictionary <int, MaterielTypeTable>();
string materielQuery = "SELECT PKEY, TYPE_NAME, GROUP_NUM, [DESC] FROM BASE_MATERIEL_TYPE ORDER BY PKEY";
if (m_MaterielTypeList.Count > 0)
{
m_MaterielTypeList.Clear();
}
using (DataTable dataTable = DatabaseAccessFactoryInstance.Instance.QueryDataTable(FormMain.DB_NAME, materielQuery))
{
foreach (DataRow row in dataTable.Rows)
{
MaterielTypeTable materielTyoe = new MaterielTypeTable();
materielTyoe.pkey = DbDataConvert.ToInt32(row[0]);
materielTyoe.name = DbDataConvert.ToString(row[1]);
materielTyoe.num = DbDataConvert.ToString(row[2]);
materielTyoe.desc = DbDataConvert.ToString(row[3]);
materielGroupList.Add(materielTyoe.pkey, materielTyoe);
}
}
m_MaterielTypeList = materielGroupList;
}
public MaterielTypeTable getMaterielTypeInfoFromPkey(int pkey)
{
MaterielTypeTable materielType = new MaterielTypeTable();
if (m_MaterielTypeList.ContainsKey(pkey))
{
materielType = (MaterielTypeTable)m_MaterielTypeList[pkey];
}
return(materielType);
}
public string getMaterielTypeNumFromPkey(int pkey)
{
string materielTypeNum = "";
if (m_MaterielTypeList.ContainsKey(pkey))
{
MaterielTypeTable record = (MaterielTypeTable)m_MaterielTypeList[pkey];
materielTypeNum = record.num;
}
return(materielTypeNum);
}
public string getMaterielTypeNameFromPkey(int pkey)
{
string materielTypeName = "未知分类名称";
if (m_MaterielTypeList.ContainsKey(pkey))
{
MaterielTypeTable record = (MaterielTypeTable)m_MaterielTypeList[pkey];
materielTypeName = record.name;
}
return(materielTypeName);
}
public void insert(MaterielTypeTable materielType)
{
string insert = "INSERT INTO [dbo].[BASE_MATERIEL_TYPE] ([TYPE_NAME],[DESC]) VALUES (";
insert += "'" + materielType.name + "',";
insert += "'" + materielType.desc + "'";
insert += ")";
try
{
DatabaseAccessFactoryInstance.Instance.ExecuteCommand(FormMain.DB_NAME, insert);
MessageBoxExtend.messageOK("数据保存成功");
load();
}
catch (Exception error)
{
MessageBoxExtend.messageWarning(error.Message);
return;
}
}
public void update(int pkey, MaterielTypeTable materielType)
{
string update = "UPDATE [dbo].[BASE_MATERIEL_TYPE] SET ";
update += "[TYPE_NAME] = '" + materielType.name + "',";
update += "[DESC] = '" + materielType.desc + "' ";
update += "WHERE PKEY = " + Convert.ToString(pkey);
try
{
DatabaseAccessFactoryInstance.Instance.ExecuteCommand(FormMain.DB_NAME, update);
MessageBoxExtend.messageOK("数据修改成功");
load();
}
catch (Exception error)
{
MessageBoxExtend.messageWarning(error.Message);
return;
}
}
