private List <BusinessMsg> DataTable2BusinessMsgs(DataTable dt) { List <BusinessMsg> list = new List <BusinessMsg>(); foreach (DataRow dr in dt.Rows) { BusinessMsg bizmsg = DataRow2BusinessMsg(dr); list.Add(bizmsg); } return(list); }
private BusinessMsg DataRow2BusinessMsg(DataRow dr) { BusinessMsg bizmsg = new BusinessMsg(); bizmsg.MsgID = dr["MsgId"].ToInt64(); bizmsg.SystemName = dr["SystemName"].ToString(); bizmsg.ModuleName = dr["ModuleName"].ToString(); bizmsg.KeyString = dr["KeyString"].ToString(); bizmsg.MsgType = (BizMsgType)Enum.Parse(typeof(BizMsgType), dr["MsgType"].ToString()); bizmsg.MsgInfo = dr["MsgInfo"].ToString(); bizmsg.OperatorID = dr["OperatorId"].ToString(); bizmsg.OperatorName = dr["OperatorName"].ToString(); bizmsg.OperateDateTime = dr["OperateDateTime"].ToDateTime(); return(bizmsg); }
public BusinessMsg AppendBizMsg(BusinessMsg businessMsg) { SqlParameterCollection spc = DB.CreateSqlParameterCollection(); spc.Add("@SystemName", businessMsg.SystemName); spc.Add("@ModuleName", businessMsg.ModuleName); spc.Add("@KeyString", businessMsg.KeyString); spc.Add("@MsgType", businessMsg.MsgType.ToString()); spc.Add("@MsgInfo", businessMsg.MsgInfo); spc.Add("@OperatorID", businessMsg.OperatorID); spc.Add("@OperatorName", businessMsg.OperatorName); businessMsg.OperateDateTime = DateTime.Now; spc.Add("@OperateDateTime", businessMsg.OperateDateTime); string sql = "insert into g_BusinessMsg(SystemName, ModuleName, KeyString, MsgType, MsgInfo, OperatorID, OperatorName, OperateDateTime)" + "values(@SystemName, @ModuleName, @KeyString, @MsgType, @MsgInfo, @OperatorID, @OperatorName, @OperateDateTime)"; DB.ExecuteNonQuerySql(sql, spc); businessMsg.MsgID = DB.ExeSqlForObject("select max(MsgID) from g_BusinessMsg", null).ToInt64(); return(businessMsg); }