public ZFBLogEntity CreateLogContent(ZFBLogEntity entity) { SqlCommand cmd = CommandManager.GetCommand("CreateLogContent"); cmd.Parameters.Add(new SqlParameter("@ImportData", entity.ImportData)); entity.ContentSysNo = Convert.ToInt32(DBHelper.GetObject(cmd)); return(entity); }
public void CreateLog(ZFBLogEntity entity) { SqlCommand cmd = CommandManager.GetCommand("CreateLog"); cmd.Parameters.Add(new SqlParameter("@PayTermsNo", entity.PayTermsNo)); cmd.Parameters.Add(new SqlParameter("@PayTerms", entity.PayTerms)); cmd.Parameters.Add(new SqlParameter("@ContentSysNo", entity.ContentSysNo)); cmd.Parameters.Add(new SqlParameter("@InUser", entity.InUser)); cmd.Parameters.Add(new SqlParameter("@InDate", entity.InDate)); DBHelper.ExecuteSql(cmd); }
private static void CreateLog(XmlDocument xmlResult) { var zfbDA = new ZFBDA(); var logEnity = new ZFBLogEntity(); logEnity.ImportData = xmlResult.InnerXml; logEnity.PayTermsNo = 34; logEnity.PayTerms = "支付宝"; logEnity.InUser = "******"; logEnity.InDate = DateTime.Now; OnShowInfo("开始记录日志表"); try { logEnity = zfbDA.CreateLogContent(logEnity); zfbDA.CreateLog(logEnity); } catch (Exception ex) { OnShowInfo(string.Format("记录日志表失败:{0}", ex.Message)); } OnShowInfo("记录日志表完成"); }