/// <summary>
/// 获取显示系统版信息
/// </summary>
public void ShowSystemVersion()
{
BLL.SystemManager systemMg = new BLL.SystemManager();
Models.ACL_System model = systemMg.GetOneById(Models.SqlHelper.Session._SystemId);
labSystemName.Text = "系统：" + model.SystemName;
labSystemVersion.Text = "系统版本：" + model.Version;
labListTime.Text = "更新时间：" + model.LastTime.ToString();
}
public SystemEditForm(Guid Id)
{
InitializeComponent();
model = systemMg.GetOneById(Id);
txtsysID.Text = model.Id.ToString();
txtsysName.Text = model.SystemName;
txtSortCode.Text = model.SortCode;
txtSimpleCode.Text = model.SimpleCode;
txtRemark.Text = model.SystemDescription;
}
/// <summary>
/// 检查程序是否更新
/// </summary>
/// <param name="systemId">系统ID</param>
/// <param name="version">当前版本信息</param>
/// <param name="lasttime">当前更新时间</param>
/// <returns>是否成新</returns>
public bool IsNeedUpdate(Guid systemId, string version)
{
Models.ACL_System model = GetOneById(systemId);
bool Result = false;
if (model == null)
{
Result = false;
}
if (model.Version.CompareTo(version) > 0)
{
Result = true;
}
return(Result);
}
public bool ModifyVersion(Models.ACL_System model)
{
SqlParameter[] cmdParam = new SqlParameter[] {
new SqlParameter("@Id", model.Id),
new SqlParameter("@URL", model.URL),
new SqlParameter("@Version", model.Version),
new SqlParameter("@LastTime", model.LastTime)
};
string sqlText = @"UPDATE [RightingSys].[dbo].[ACL_System]
SET [URL] = @URL
,[Version] = @Version
,[LastTime] = @LastTime
WHERE [Id] = @Id";
return(Models.SqlHelper.ExecuteNoQuery(sqlText, cmdParam) > 0 ? true : false);
}
public bool Modify(Models.ACL_System model)
{
SqlParameter[] cmdParam = new SqlParameter[] {
new SqlParameter("@Id", model.Id),
new SqlParameter("@SystemName", model.SystemName),
new SqlParameter("@SimpleCode", model.SimpleCode),
new SqlParameter("@SortCode", model.SortCode),
new SqlParameter("@SystemDescription", model.SystemDescription)
};
string sqlText = @"UPDATE [RightingSys].[dbo].[ACL_System]
SET [SystemName] = @SystemName
,[SimpleCode] = @SimpleCode
,[SortCode] = @SortCode
,[SystemDescription] = @SystemDescription
WHERE [Id] = @Id";
return(Models.SqlHelper.ExecuteNoQuery(sqlText, cmdParam) > 0 ? true : false);
}
public bool AddNew(Models.ACL_System model)
{
SqlParameter[] cmdParam = new SqlParameter[] {
new SqlParameter("@Id", model.Id),
new SqlParameter("@SystemName", model.SystemName),
new SqlParameter("@SimpleCode", model.SimpleCode),
new SqlParameter("@SortCode", model.SortCode),
new SqlParameter("@SystemDescription", model.SystemDescription)
};
string sqlText = @"[RightingSys].[dbo].[ACL_System]
([Id]
,[SystemName]
,[SimpleCode]
,[SortCode]
,[SystemDescription])
VALUES(@Id
,@SystemName
,@SimpleCode
,@SortCode
,@SystemDescription)";
return(Models.SqlHelper.ExecuteNoQuery(sqlText, cmdParam) > 0 ? true : false);
}
/// <summary>
/// 修改系统版本
/// </summary>
/// <param name="model">实体</param>
/// <returns></returns>
public bool ModifyVersion(Models.ACL_System model)
{
return(Sev.ModifyVersion(model));
}
/// <summary>
/// 修改系统信息
/// </summary>
/// <param name="model">实体</param>
/// <returns></returns>
public bool Modify(Models.ACL_System model)
{
return(Sev.Modify(model));
}
/// <summary>
/// 新增系统授权
/// </summary>
/// <param name="model">实体</param>
/// <returns></returns>
public bool AddNew(Models.ACL_System model)
{
return(Sev.AddNew(model));
}
public SystemVersionForm(Guid systemId)
{
InitializeComponent();
_SystemId = systemId;
model = systemMg.GetOneById(_SystemId);
}
public bool WriteVersionToDB(Models.ACL_System model)
{
return(systemMg.ModifyVersion(model));
}
