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