public void update(int pkey, BillConfigTable record)
{
string sql = "UPDATE [dbo].[BASE_BILL_CONFIG] SET ";
sql += "CODE = '" + Convert.ToString(record.code) + "',";
sql += "IS_INPUT = " + Convert.ToString(record.isInput) + ",";
sql += "IS_AUTO_SAVE = " + Convert.ToString(record.isAutoSave) + ",";
sql += "IS_USE_SYSDATE = " + Convert.ToString(record.isUseSysdate) + ",";
sql += "NUM = " + Convert.ToString(record.num) + ",";
sql += "FRONT = '" + Convert.ToString(record.front) + "',";
sql += "IS_USE_RULES = " + Convert.ToString(record.isUseRules);
sql += "WHERE PKEY = " + Convert.ToString(pkey);
try
{
DatabaseAccessFactoryInstance.Instance.ExecuteCommand(FormMain.DB_NAME, sql);
MessageBoxExtend.messageOK("数据修改成功");
load();
}
catch (Exception error)
{
MessageBoxExtend.messageWarning(error.Message);
return;
}
}
private void load()
{
string sql = "SELECT [PKEY],[BILL_TYPE],[NAME],[CODE],[IS_INPUT],[IS_AUTO_SAVE],[IS_USE_RULES],[FRONT],[IS_USE_SYSDATE],[NUM] ";
sql += "FROM [dbo].[BASE_BILL_CONFIG] ORDER BY PKEY";
m_billConfigList.Clear();
using (DataTable dataTable = DatabaseAccessFactoryInstance.Instance.QueryDataTable(FormMain.DB_NAME, sql))
{
foreach (DataRow row in dataTable.Rows)
{
BillConfigTable record = new BillConfigTable();
record.pkey = DbDataConvert.ToInt32(row["PKEY"]);
record.billpType = DbDataConvert.ToInt32(row["BILL_TYPE"]);
record.name = DbDataConvert.ToString(row["NAME"]);
record.code = DbDataConvert.ToString(row["CODE"]);
record.isInput = DbDataConvert.ToInt32(row["IS_INPUT"]);
record.isAutoSave = DbDataConvert.ToInt32(row["IS_AUTO_SAVE"]);
record.isUseRules = DbDataConvert.ToInt32(row["IS_USE_RULES"]);
record.front = DbDataConvert.ToString(row["FRONT"]);
record.isUseSysdate = DbDataConvert.ToInt32(row["IS_USE_SYSDATE"]);
record.num = DbDataConvert.ToInt32(row["NUM"]);
m_billConfigList.Add(m_billConfigList.Count, record);
}
}
}
public BillConfigTable getBillConfigInfoFromPeky(int pkey)
{
BillConfigTable billConfig = new BillConfigTable();
if (m_billConfigList.Count == 0)
{
load();
}
foreach (KeyValuePair <int, BillConfigTable> index in m_billConfigList)
{
BillConfigTable record = new BillConfigTable();
record = index.Value;
if (record.pkey == pkey)
{
billConfig = record;
break;
}
}
return(billConfig);
}
