/// <summary>
/// 写日志
/// </summary>
/// <param name="entity">日志实体</param>
/// <returns></returns>
public static AjaxResult Add(C_S_Log entity)
{
AjaxResult msg = new AjaxResult();
string strSql = string.Format(@"INSERT INTO dbo.C_S_Log
VALUES ( NEWID() ,@OperateType ,@OperateUserId ,@ApplicationId ,
@ApplicationCode ,@Content ,GETDATE() ,@IPAddress, @MachineName )");
SqlParameter[] parameter = new SqlParameter[] {
new SqlParameter("OperateType", entity.OperateType),
new SqlParameter("OperateUserId", entity.OperateUserId),
new SqlParameter("ApplicationId", entity.ApplicationId),
new SqlParameter("ApplicationCode", entity.ApplicationCode),
new SqlParameter("Content", entity.Content),
new SqlParameter("IPAddress", entity.IPAddress),
new SqlParameter("MachineName", entity.MachineName)
};
int tmp = SqlHelper.ExecuteNonQuery(strSql, parameter);
if (tmp >= 1)
{
msg.data = "成功";
msg.state = 1;
msg.message = "写入日志成功。";
}
else
{
msg.data = "失败";
msg.state = -1;
msg.message = "写入日志失败。";
}
return(msg);
}
/// <summary>
/// 客户端更新日志
/// </summary>
/// <param name="appCode"></param>
/// <param name="userId"></param>
/// <param name="ip_HostName_state"></param>
/// <returns></returns>
public static AjaxResult WriteUpdateLog(string appCode, string userId, string ip_HostName_state)
{
AjaxResult msg = new AjaxResult();
//获取用户数据
string sqlStr = "SELECT * FROM dbo.[User] WHERE UserID=@UserID";
DataTable dt = SqlHelper.ExecuteDataTable(sqlStr, new SqlParameter[] { new SqlParameter("UserID", userId) });
string userName = string.Empty;
if (dt.Rows.Count > 0)
{
userName = dt.Rows[0]["DisplayName"].ToString();
}
//获取应用数据
dt = SqlHelper.ExecuteDataTable("SELECT * FROM dbo.C_S_Application WHERE ApplicationCode=@ApplicationCode", new SqlParameter[] { new SqlParameter("ApplicationCode", appCode) });
string applicationId = string.Empty;
if (dt.Rows.Count > 0)
{
applicationId = dt.Rows[0]["ApplicationId"].ToString();
}
//拆分获得 ip（ip地址） hostName（客户端） state （更新状态）
string[] ip_hostName_state = ip_HostName_state.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
//默认更新成功
int operateType = 1;
string content = "客户端更新成功。";
//如果更新失败
if (ip_hostName_state.Last() == "fail")
{
operateType = 2;
content = "客户端更新失败。";
}
C_S_Log entity = new C_S_Log()
{
OperateType = operateType,
OperateUserId = userName,
ApplicationId = applicationId,
ApplicationCode = appCode,
Content = content,
IPAddress = ip_hostName_state[0],
MachineName = ip_hostName_state[1]
};
msg = Add(entity);
return(msg);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="ApplicationId"></param>
/// <returns></returns>
public AjaxResult Delete(string ApplicationId)
{
AjaxResult msg = new AjaxResult();
DataTable dt = SqlHelper.ExecuteDataTable("select * from C_S_Application where ApplicationId = @ApplicationId", new SqlParameter[] { new SqlParameter("ApplicationId", ApplicationId) });
//删除应用的时候，连同应用的版本号一起删除
string sqlStr = "delete C_S_AppVersion where ApplicationId = @ApplicationId;";
sqlStr += "delete C_S_Application where ApplicationId = @ApplicationId";
SqlParameter[] parameter = { new SqlParameter("ApplicationId", ApplicationId) };
int result = SqlHelper.ExecuteNonQuery(sqlStr, parameter);
if (result > 0)
{
msg.data = "";
msg.state = "success";
msg.message = "删除成功！";
#region ===========记录操作日志=================
C_S_Log log = new C_S_Log()
{
OperateType = 3, //移除
OperateUserId = OperatorProvider.Provider.GetCurrent().UserName,
ApplicationId = ApplicationId,
Content = "删除应用",
ApplicationCode = "",
IPAddress = Net.Ip,
MachineName = Net.Host
};
if (dt.Rows.Count > 0)
{
log.ApplicationCode = dt.Rows[0]["ApplicationCode"].ToString();
}
CSLog_BLL.Add(log);
#endregion ======================================
}
else
{
msg.data = "";
msg.state = "error";
msg.message = "删除失败！";
}
return(msg);
}
/// <summary>
/// 新增
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public AjaxResult Add(C_S_Application entity)
{
AjaxResult msg = new AjaxResult();
List <SqlParameter> parameter = new List <SqlParameter>();
parameter.Add(new SqlParameter("ApplicationName", entity.ApplicationName));
parameter.Add(new SqlParameter("ApplicationCode", entity.ApplicationCode));
parameter.Add(new SqlParameter("Company", entity.Company));
string sqlStr = "select * from C_S_Application where (ApplicationName = @ApplicationName or ApplicationCode=@ApplicationCode) and Company = @Company";
DataTable dt = SqlHelper.ExecuteDataTable(sqlStr, parameter.ToArray());
if (dt.Rows.Count > 0)
{
msg.data = "";
msg.state = "error";
msg.message = "新增失败，该应用已经存在！";
}
else
{
sqlStr = @"INSERT INTO dbo.C_S_Application (ApplicationId,ApplicationName,ApplicationCode,
Company,SortCode,Remark,CreateBy,CreateTime,StartFileName)
VALUES ( @ApplicationId ,@ApplicationName ,
@ApplicationCode , @Company, @SortCode ,
@Remark , @CreateBy , @CreateTime,@StartFileName) ";
parameter.Clear();
parameter.Add(new SqlParameter("ApplicationId", entity.ApplicationId));
parameter.Add(new SqlParameter("ApplicationName", entity.ApplicationName));
parameter.Add(new SqlParameter("ApplicationCode", entity.ApplicationCode));
parameter.Add(new SqlParameter("SortCode", entity.SortCode));
parameter.Add(new SqlParameter("Company", entity.Company));
parameter.Add(new SqlParameter("Remark", entity.ApplicationName));
parameter.Add(new SqlParameter("CreateBy", entity.CreateBy));
parameter.Add(new SqlParameter("CreateTime", entity.CreateTime));
parameter.Add(new SqlParameter("StartFileName", entity.StartFileName));
int result = SqlHelper.ExecuteNonQuery(sqlStr, parameter.ToArray());
if (result == 1)
{
msg.data = "";
msg.state = "success";
msg.message = "新增成功！";
#region =====================写操作日志======================
C_S_Log log = new C_S_Log()
{
OperateType = 4, //新增
OperateUserId = entity.CreateBy,
ApplicationId = entity.ApplicationId,
ApplicationCode = entity.ApplicationCode,
Content = "新增应用",
IPAddress = Net.Ip,
MachineName = Net.Host
};
CSLog_BLL.Add(log);
#endregion =================================================
}
else
{
msg.data = "";
msg.state = "error";
msg.message = "新增失败！";
}
}
return(msg);
}
/// <summary>
/// 新增
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public AjaxResult Add(C_S_AppVersion entity)
{
DataTable dt = SqlHelper.ExecuteDataTable("select * from C_S_Application where ApplicationId = @ApplicationId", new SqlParameter[] { new SqlParameter("ApplicationId", entity.ApplicationId) });
entity.Create();
AjaxResult msg = new AjaxResult();
string sqlStr = @"INSERT INTO dbo.C_S_AppVersion(AppVersionId,ApplicationId,VersionCode,AppFileName,
AppDirectory,AppSize,Remark,CreateBy,CreateTime)
VALUES ( @AppVersionId , @ApplicationId ,
@VersionCode , @AppFileName ,
@AppDirectory , @AppSize ,
@Remark , @CreateBy , @CreateTime)";
SqlParameter[] parameter =
{
new SqlParameter("AppVersionId", entity.AppVersionId),
new SqlParameter("ApplicationId", entity.ApplicationId),
new SqlParameter("VersionCode", entity.VersionCode),
new SqlParameter("AppFileName", entity.AppFileName),
new SqlParameter("AppDirectory", entity.AppDirectory),
new SqlParameter("AppSize", entity.AppSize),
new SqlParameter("Remark", entity.Remark),
new SqlParameter("CreateBy", entity.CreateBy),
new SqlParameter("CreateTime", entity.CreateTime)
};
int result = SqlHelper.ExecuteNonQuery(sqlStr, parameter);
if (result == 1)
{
msg.data = "";
msg.state = "success";
msg.message = "新增成功！";
#region ===========记录操作日志=============
C_S_Log log = new C_S_Log()
{
OperateType = 0,//上传
OperateUserId = entity.CreateBy,
ApplicationId = entity.ApplicationId,
Content = "上传应用",
ApplicationCode = "",
IPAddress = Net.Ip,
MachineName = Net.Host
};
if (dt.Rows.Count > 0)
{
log.ApplicationCode = dt.Rows[0]["ApplicationCode"].ToString();
}
CSLog_BLL.Add(log);
#endregion =================================
}
else
{
msg.data = "";
msg.state = "error";
msg.message = "新增失败！";
}
return(msg);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="appVersionId"></param>
/// <returns></returns>
public AjaxResult Delete(string appVersionId)
{
AjaxResult msg = new AjaxResult();
try
{
string sqlStr1 = "select * from C_S_AppVersion where AppVersionId = @AppVersionId";
SqlParameter[] parameter = { new SqlParameter("AppVersionId", appVersionId) };
DataTable dt = SqlHelper.ExecuteDataTable(sqlStr1, parameter);
if (dt.Rows.Count > 0)
{
string applicationId = dt.Rows[0]["ApplicationId"].ToString();
DataTable dt_app = SqlHelper.ExecuteDataTable("select * from C_S_Application where ApplicationId = @ApplicationId", new SqlParameter[] { new SqlParameter("ApplicationId", applicationId) });
//先删除版本文件数据再删除应用版本数据
string sqlStr = @"delete C_S_VersionFile where AppVersionId = @AppVersionId
;delete C_S_AppVersion where AppVersionId = @AppVersionId";
string path = dt.Rows[0]["AppDirectory"].ToString();
SqlParameter[] parameter1 = { new SqlParameter("AppVersionId", appVersionId) };
int result = SqlHelper.ExecuteNonQuery(sqlStr, parameter1);
if (result > 0)
{
msg.data = "";
msg.state = "success";
msg.message = "删除成功！";
#region ===========记录操作日志=================
C_S_Log log = new C_S_Log()
{
OperateType = 3,//移除
OperateUserId = OperatorProvider.Provider.GetCurrent().UserName,
ApplicationId = applicationId,
Content = "删除版本",
ApplicationCode = "",
IPAddress = Net.Ip,
MachineName = Net.Host
};
if (dt.Rows.Count > 0)
{
log.ApplicationCode = dt_app.Rows[0]["ApplicationCode"].ToString();
}
CSLog_BLL.Add(log);
#endregion ======================================
}
else
{
msg.data = "";
msg.state = "error";
msg.message = "删除失败！";
}
}
else
{
msg.data = "";
msg.state = "success";
msg.message = "已删除";
}
}
catch (Exception ex)
{
log.Error(ex.Message);
msg.data = "";
msg.state = "error";
msg.message = "删除失败，程序发生异常！";
}
return(msg);
}