public void Insert(string tableName, CID cid)
{
OleDbHelper.ExecuteNonQuery("Main", @"INSERT INTO " + tableName +
@" (CID码,是否是新事件,事件类型,辅助信息,处理策略,是否发送短信)
VALUES (@CIDCode,@IsNewEvent,@EventTpye,@EventInformation,@StrategiesName,@IsSendMessage)",
new OleDbParameter("@CIDCode", OleDbHelper.ToDbValue(cid.CIDCode)),
new OleDbParameter("@IsNewEvent", OleDbHelper.ToDbValue(cid.IsNewEvent)),
new OleDbParameter("@EventTpye", OleDbHelper.ToDbValue(cid.EventTpye)),
new OleDbParameter("@EventInformation", OleDbHelper.ToDbValue(cid.EventInformation)),
new OleDbParameter("@StrategiesName", OleDbHelper.ToDbValue(cid.StrategiesName)),
new OleDbParameter("@IsSendMessage", OleDbHelper.ToDbValue(cid.IsSendMessage)));
}
/// <summary>
/// 获取数据库表名得到对象数组
/// </summary>
/// <param name="formName"></param>
/// <returns></returns>
public CID[] GetReportFormatArray(string formName)
{
DataTable dt = OleDbHelper.ExecuteDataTable("Main", "select * from " + formName);
CID[] cids = new CID[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow row = dt.Rows[i];
cids[i] = ToCID(row);
}
return(cids);
}
private CID ToCID(DataRow row)
{
CID cid = new CID();
cid.ID = (int)row["序号"];
cid.CIDCode = (string)row["CID码"];
cid.IsNewEvent = (bool)OleDbHelper.FromDbValue(row["是否是新事件"]);
cid.EventInformation = (string)OleDbHelper.FromDbValue(row["辅助信息"]);
cid.EventTpye = (string)OleDbHelper.FromDbValue(row["事件类型"]);
cid.StrategiesName = (string)OleDbHelper.FromDbValue(row["处理策略"]);
cid.IsSendMessage = (bool)OleDbHelper.FromDbValue(row["是否发送短信"]);
return(cid);
}
public void Update(string tableName, CID cid)
{
OleDbHelper.ExecuteNonQuery("Main", @"UPDATE " + tableName +
@" SET [CID码]=@CIDCode
,[是否是新事件]=@IsNewEvent
,[事件类型]=@EventTpye
,[辅助信息]=@EventInformation
,[处理策略]=@StrategiesName
,[是否发送短信]=@IsSendMessage
WHERE [序号]=@ID",
new OleDbParameter("@CIDCode", OleDbHelper.ToDbValue(cid.CIDCode)),
new OleDbParameter("@IsNewEvent", OleDbHelper.ToDbValue(cid.IsNewEvent)),
new OleDbParameter("@EventTpye", OleDbHelper.ToDbValue(cid.EventTpye)),
new OleDbParameter("@EventInformation", OleDbHelper.ToDbValue(cid.EventInformation)),
new OleDbParameter("@StrategiesName", OleDbHelper.ToDbValue(cid.StrategiesName)),
new OleDbParameter("@IsSendMessage", OleDbHelper.ToDbValue(cid.IsSendMessage)),
new OleDbParameter("@ID", OleDbHelper.ToDbValue(cid.ID)));
}
