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));
}
