public void DeleteLogHandlesTypeExpectedReturnsDeleteLogService()
{
var esb = new DeleteLog();
var result = esb.HandlesType();
Assert.AreEqual("DeleteLogService", result);
}
/// <summary>
/// 本函数实现标记资讯， 短趣，活动 删除列，并且把记录写在 DeleteLog 中
/// </summary>
/// <param name="CategoryId"></param> 参数解释：待删除 ID 的所在分类 1 资讯 ； 2 活动； 3 短趣
/// <param name="DelId"></param> 参数解释:待删除 ID
/// <param name="OperatorId"></param> 参数解释:本次操作的管理员 ID
/// <returns></returns>
public bool delItem()
{
try
{
//记录准备删除的那条记录
if (!recordDelFlag(true))
{
return(false);
}
using (var db = new huxiuEntities())
{
//new 一个 delelog 对象，进行添加操作
DeleteLog addDelLog = new DeleteLog();
addDelLog.DelAdminId = OperatorId;
addDelLog.DelTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
addDelLog.Category = CategoryId;
addDelLog.LogId = DelId;
//添加记录表中
db.DeleteLog.Add(addDelLog);
//保存更改
db.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public void DeleteLogExecuteWithValidPathAndLockedExpectedReturnsError()
{
//Lock because of access to file system
lock (SyncRoot)
{
var fileName = Guid.NewGuid().ToString() + "_Test.log";
var path = Path.Combine(_testDir, fileName);
File.WriteAllText(path, "hello test");
Assert.IsTrue(File.Exists(path));
var fs = File.OpenRead(path);
try
{
var workspace = new Mock <IWorkspace>();
var values = new Dictionary <string, StringBuilder> {
{ "ResourcePath", new StringBuilder(fileName) }, { "Directory", new StringBuilder(_testDir) }
};
var esb = new DeleteLog();
var result = esb.Execute(values, workspace.Object);
var msg = ConvertToMsg(result);
Assert.IsTrue(msg.Message.ToString().StartsWith("DeleteLog: Error"));
}
finally
{
fs.Close();
}
}
}
/// <summary>
/// 恢复删除
/// </summary>
/// <returns></returns>
public bool recoverDel()
{
try
{
//把原来表里面的数据删除标志位 置 0
if (!recordDelFlag(false))
{
return(false);
}
//删除记录表中的数据
using (var db = new huxiuEntities())
{
DeleteLog del = (from it in db.DeleteLog
where it.Category == CategoryId && it.LogId == DelId
select it).FirstOrDefault();
db.DeleteLog.Remove(del);
db.SaveChanges();
}
return(true);
}
catch
{
return(false);
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string id = context.Request["id"].ToString();
string type = context.Request["type"].ToString(); //0 是入 1是出
if (type == "0")
{
DeleteLog.InsertLog(id, 0);
if (hb.ProExecinset("exec pro_Delstock '" + id + "','" + type + "' "))
{
context.Response.Write("{\"result\":\"100\"}");
}
else
{
context.Response.Write("{\"result\":\"200\"}");
}
}
if (type == "1")
{
DeleteLog.InsertLog(id, 1);
if (hb.ProExecinset("exec pro_Delstock '" + id + "','" + type + "' "))
{
context.Response.Write("{\"result\":\"100\"}");
}
else
{
context.Response.Write("{\"result\":\"200\"}");
}
}
}
public void GetAuthorizationContextForService_ShouldReturnContext()
{
//------------Setup for test--------------------------
var deleteLog = new DeleteLog();
//------------Execute Test---------------------------
var resId = deleteLog.GetAuthorizationContextForService();
//------------Assert Results-------------------------
Assert.AreEqual(AuthorizationContext.Administrator, resId);
}
public void GetResourceID_ShouldReturnEmptyGuid()
{
//------------Setup for test--------------------------
var deleteLog = new DeleteLog();
//------------Execute Test---------------------------
var resId = deleteLog.GetResourceID(new Dictionary <string, StringBuilder>());
//------------Assert Results-------------------------
Assert.AreEqual(Guid.Empty, resId);
}
protected void Page_Load(object sender, EventArgs e)
{
string id = GetQueryString("id");
string sTable = GetQueryString("table");
string type = GetQueryString("type");
bool bl = false;
string sResult = "";
string sql = "DELETE dbo.SYS_RightStore WHERE SP_code='" + isPartcode() + "' AND SR_storecode IN (SELECT Basecode FROM dbo.BaseStore WHERE id='" + id + "')";
if (sTable == "BaseStore")
{
DeleteLog.InsertLog(id, 3);
//删除该角色仓库权限
bl = hb.ProExecinset(sql);
//管理员操作则直接删除仓库
if (isPartcode() == "0001")
{
bl = hb.delbase(sTable, id);
}
}
else if (sTable == "baseinfo")
{
DeleteLog.InsertLog(id, 4);
bl = hb.delbase(sTable, id);
}
else
{
DeleteLog.InsertLog(id, 2);
string str = "(select states from transferslip where id='" + id + "')hh";
DataTable dt = hb.getdate("*", str);
string s = dt.Rows[0][0].ToString();
if (s == "待出库")
{
bl = hb.delbase(sTable, id);
}
}
if (bl == true)
{
sResult = "{\"result\":\"100\"}"; //删除成功
}
else
{
sResult = "{\"result\":\"200\"}"; //失败
}
Response.Write(sResult);
Response.End();
}
public void DeleteLogExecuteWithNonExistingPathExpectedReturnsError()
{
var workspace = new Mock <IWorkspace>();
var values = new Dictionary <string, StringBuilder> {
{ "ResourcePath", new StringBuilder(Guid.NewGuid().ToString()) }, { "Directory", new StringBuilder("C:") }
};
var esb = new DeleteLog();
var result = esb.Execute(values, workspace.Object);
var msg = ConvertToMsg(result);
Assert.IsTrue(msg.Message.ToString().StartsWith("DeleteLog: Error"));
}
public void DeleteLogCreateServiceEntryExpectedReturnsDynamicService()
{
var esb = new DeleteLog();
var result = esb.CreateServiceEntry();
Assert.AreEqual(esb.HandlesType(), result.Name);
Assert.AreEqual("<DataList><Directory ColumnIODirection=\"Input\"/><ResourcePath ColumnIODirection=\"Input\"/><Dev2System.ManagmentServicePayload ColumnIODirection=\"Both\"></Dev2System.ManagmentServicePayload></DataList>", result.DataListSpecification.ToString());
Assert.AreEqual(1, result.Actions.Count);
var serviceAction = result.Actions[0];
Assert.AreEqual(esb.HandlesType(), serviceAction.Name);
Assert.AreEqual(enActionType.InvokeManagementDynamicService, serviceAction.ActionType);
Assert.AreEqual(esb.HandlesType(), serviceAction.SourceMethod);
}
/// <summary>
/// 本函数用来删除超过阈值的记录，删除原始记录和记录删除行为的记录
/// </summary>
/// <returns>返回 bool </returns>
public bool dellongtimelog()
{
//获取当前时间
DateTime now = DateTime.Now;
try
{
using (var db = new huxiuEntities())
{
//查询所有超过删除阈值的条目
var delList = from it in db.DeleteLog
// where (Convert.ToDateTime(it.DelTime) - now).Days > LogDeadline
select it;
//遍历结果集，进行删除 DeleteLog 和 相应分类下面的条目
foreach (var item in delList)
{
//转化字符串到时间
DateTime tt = Convert.ToDateTime(item.DelTime);
//用 TimeSpan 计算相差天数
int tsday = Convert.ToInt32((now - tt).TotalDays);
//和阈值比较
if (tsday > LogDeadline)
{
delSourceData(item.Category, item.LogId);
DeleteLog delLogId = db.DeleteLog.SingleOrDefault(a => a.DelId == item.DelId);
db.DeleteLog.Remove(delLogId);
}
}
db.SaveChanges();
}
return(true);
}
catch
{
return(false);
}
}
