public ActionResult SaveShareSConfig(ShareSupervisionConfig ssc) { if (ssc.PKId == 0) { ssc.CreateDateTime = DateTime.Now; ssc.UpdateDateTime = DateTime.Now; ssc.Creator = ThreadIdentity.Operator.Name; bool flag = ShareConfigManager.InsertShareSConfig(ssc); } else { ssc.UpdateDateTime = DateTime.Now; bool flag = ShareConfigManager.UpdateShareSConfig(ssc); } ShareConfigLog scl = new ShareConfigLog() { ConfigId = ssc.JumpId, Operator = ThreadIdentity.Operator.Name, OperateType = 1, CreateDateTime = DateTime.Now, LastUpdateDateTime = DateTime.Now }; bool flaglog = ShareConfigManager.InsertShareConfigLog(scl); return(Redirect("TemplateEdit?id=" + ssc.JumpId)); }
public ActionResult SaveShareConfig(ShareConfigSource scs) { if (scs.PKId == 0) { scs.CreateDateTime = DateTime.Now; scs.UpdateDateTime = DateTime.Now; scs.Creator = ThreadIdentity.Operator.Name; int pkid = ShareConfigManager.InsertShareConfig(scs); scs.PKId = pkid; //写操作记录 ShareConfigLog scl = new ShareConfigLog() { ConfigId = scs.PKId, Operator = ThreadIdentity.Operator.Name, OperateType = 0, CreateDateTime = DateTime.Now, LastUpdateDateTime = DateTime.Now }; ShareConfigManager.InsertShareConfigLog(scl); } else if (scs.PKId > 0) { scs.UpdateDateTime = DateTime.Now; string oldlocation = ShareConfigManager.SelectLocationByPKId(scs.PKId); string newlocation = scs.Location; ShareConfigManager.UpdateShareConfig(scs); //写操作记录 ShareConfigLog scl = new ShareConfigLog() { ConfigId = scs.PKId, Operator = ThreadIdentity.Operator.Name, OperateType = 1, CreateDateTime = DateTime.Now, LastUpdateDateTime = DateTime.Now }; ShareConfigManager.InsertShareConfigLog(scl); } else { scs.CreateDateTime = DateTime.Now; scs.UpdateDateTime = DateTime.Now; scs.Creator = ThreadIdentity.Operator.Name; int pkid = ShareConfigManager.InsertShareConfig(scs); scs.PKId = pkid; //写操作记录 ShareConfigLog scl = new ShareConfigLog() { ConfigId = scs.PKId, Operator = ThreadIdentity.Operator.Name, OperateType = 0, CreateDateTime = DateTime.Now, LastUpdateDateTime = DateTime.Now }; ShareConfigManager.InsertShareConfigLog(scl); } return(Json(scs.PKId)); }
public bool DelShareSConfig(int id, int configid) { ShareConfigLog scl = new ShareConfigLog() { ConfigId = configid, Operator = ThreadIdentity.Operator.Name, OperateType = 1, CreateDateTime = DateTime.Now, LastUpdateDateTime = DateTime.Now }; bool flaglog = ShareConfigManager.InsertShareConfigLog(scl); return(ShareConfigManager.DeleteShareSConfigById(id)); }
public static bool InsertShareConfigLog(SqlConnection conn, ShareConfigLog scl) { string insertShareConfigLogText = @" INSERT INTO Configuration..ShareConfigLog(ConfigId,Operator,OperateType,CreateDateTime,LastUpdateDateTime) VALUES (@configid,@operator,@operatetype,@createdatetime,@lastupdatedatetime)"; var sqlParam = new[] { new SqlParameter("@configid", scl.ConfigId), new SqlParameter("@operator", scl.Operator), new SqlParameter("@operatetype", scl.OperateType), new SqlParameter("@createdatetime", scl.CreateDateTime), new SqlParameter("@lastupdatedatetime", scl.LastUpdateDateTime), }; return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, insertShareConfigLogText, sqlParam) > 0 ? true : false); }
public bool InsertShareConfigLog(ShareConfigLog scl) { try { return(handler.InsertShareConfigLog(scl)); } catch (TuhuBizException) { throw; } catch (Exception ex) { var exception = new DownloadAppException(1, "InsertShareConfigLog", ex); Logger.Log(Level.Error, exception, "InsertShareConfigLog"); throw ex; } }
public bool InsertShareConfigLog(ShareConfigLog scl) { Func <SqlConnection, bool> action = (connection) => DalShareConfig.InsertShareConfigLog(connection, scl); return(dbManager.Execute(action)); }