private void load()
{
SortedDictionary <int, CustomerTypeTable> customerGroupList = new SortedDictionary <int, CustomerTypeTable>();
string customerQuery = "SELECT PKEY, TYPE_NAME, [DESC] FROM BASE_CUSTOMER_TYPE ORDER BY PKEY";
if (m_CustomerTypeList.Count > 0)
{
m_CustomerTypeList.Clear();
}
using (DataTable dataTable = DatabaseAccessFactoryInstance.Instance.QueryDataTable(FormMain.DB_NAME, customerQuery))
{
foreach (DataRow row in dataTable.Rows)
{
CustomerTypeTable customerTyoe = new CustomerTypeTable();
customerTyoe.pkey = DbDataConvert.ToInt32(row[0]);
customerTyoe.name = DbDataConvert.ToString(row[1]);
customerTyoe.desc = DbDataConvert.ToString(row[2]);
customerGroupList.Add(customerTyoe.pkey, customerTyoe);
}
}
m_CustomerTypeList = customerGroupList;
}
public CustomerTypeTable getCustomerTypeInfoFromPkey(int pkey)
{
CustomerTypeTable customerType = new CustomerTypeTable();
if (m_CustomerTypeList.ContainsKey(pkey))
{
customerType = (CustomerTypeTable)m_CustomerTypeList[pkey];
}
return(customerType);
}
public string getCustomerTypeNameFromPkey(int pkey)
{
string customerTypeName = "未知分类名称";
if (m_CustomerTypeList.ContainsKey(pkey))
{
CustomerTypeTable record = (CustomerTypeTable)m_CustomerTypeList[pkey];
customerTypeName = record.name;
}
return(customerTypeName);
}
public void insert(CustomerTypeTable customerType)
{
string insert = "INSERT INTO [dbo].[BASE_CUSTOMER_TYPE] ([TYPE_NAME],[DESC]) VALUES (";
insert += "'" + customerType.name + "',";
insert += "'" + customerType.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, CustomerTypeTable customerType)
{
string update = "UPDATE [dbo].[BASE_CUSTOMER_TYPE] SET ";
update += "[TYPE_NAME] = '" + customerType.name + "',";
update += "[DESC] = '" + customerType.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;
}
}
