412 lines
15 KiB
C#
412 lines
15 KiB
C#
|
using System;
|
|||
|
|
using System.Collections.Generic;
|
|||
|
|
using System.Text;
|
|||
|
|
using System.Data;
|
|||
|
|
using System.Linq;
|
|||
|
|
using WeiSha.Common;
|
|||
|
|
using Song.Entities;
|
|||
|
|
|
|||
|
|
using WeiSha.Data;
|
|||
|
|
using Song.ServiceInterfaces;
|
|||
|
|
using System.Reflection;
|
|||
|
|
using System.Collections;
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
namespace Song.ServiceImpls
|
|||
|
|
{
|
|||
|
|
public class SystemParaCom : ISystemPara
|
|||
|
|
{
|
|||
|
|
/// <summary>
|
|||
|
|
/// 添加
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="entity">业务实体</param>
|
|||
|
|
public void Add(SystemPara entity)
|
|||
|
|
{
|
|||
|
|
if (IsExists(entity)) throw new Exception("当前参数已经存在");
|
|||
|
|
Gateway.Default.Save<SystemPara>(entity);
|
|||
|
|
this.Refresh(); //重新构建系统参数的缓存
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 修改
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="key">参数键</param>
|
|||
|
|
/// <param name="value">参数值</param>
|
|||
|
|
public void Save(string key, string value)
|
|||
|
|
{
|
|||
|
|
SystemPara Ps = Gateway.Default.From<SystemPara>().Where(SystemPara._.Sys_Key == key).ToFirst<SystemPara>();
|
|||
|
|
//如果是一个新对象
|
|||
|
|
if (Ps == null) Ps = new SystemPara();
|
|||
|
|
Ps.Sys_Key = key;
|
|||
|
|
Ps.Sys_Value = value;
|
|||
|
|
Gateway.Default.Save<SystemPara>(Ps);
|
|||
|
|
this.Refresh(); //重新构建系统参数的缓存
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 修改，且是否直接刷新全局参数
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="key"></param>
|
|||
|
|
/// <param name="value"></param>
|
|||
|
|
/// <param name="isRefresh"></param>
|
|||
|
|
public void Save(string key, string value, bool isRefresh)
|
|||
|
|
{
|
|||
|
|
SystemPara Ps = Gateway.Default.From<SystemPara>().Where(SystemPara._.Sys_Key == key).ToFirst<SystemPara>();
|
|||
|
|
//如果是一个新对象
|
|||
|
|
if (Ps == null) Ps = new SystemPara();
|
|||
|
|
Ps.Sys_Key = key;
|
|||
|
|
Ps.Sys_Value = value;
|
|||
|
|
Gateway.Default.Save<SystemPara>(Ps);
|
|||
|
|
if (isRefresh) this.Refresh(); //重新构建系统参数的缓存
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 修改
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="key">参数键</param>
|
|||
|
|
/// <param name="value">参数值</param>
|
|||
|
|
/// <param name="unit">参数的单位</param>
|
|||
|
|
public void Save(string key, string value, string unit)
|
|||
|
|
{
|
|||
|
|
SystemPara Ps = Gateway.Default.From<SystemPara>().Where(SystemPara._.Sys_Key == key).ToFirst<SystemPara>();
|
|||
|
|
//如果是一个新对象
|
|||
|
|
if (Ps == null)
|
|||
|
|
{
|
|||
|
|
Ps = new SystemPara();
|
|||
|
|
}
|
|||
|
|
Ps.Sys_Key = key;
|
|||
|
|
Ps.Sys_Value = value;
|
|||
|
|
Ps.Sys_Unit = unit;
|
|||
|
|
Gateway.Default.Save<SystemPara>(Ps);
|
|||
|
|
this.Refresh(); //重新构建系统参数的缓存
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 用实例保存
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="entity"></param>
|
|||
|
|
public void Save(SystemPara entity)
|
|||
|
|
{
|
|||
|
|
if (IsExists(entity)) throw new Exception("当前参数已经存在");
|
|||
|
|
Gateway.Default.Save<SystemPara>(entity);
|
|||
|
|
this.Refresh(); //重新构建系统参数的缓存
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 当前参数是否存在（通过参数名判断）
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="entity"></param>
|
|||
|
|
/// <returns>如果已经存在，则返回true</returns>
|
|||
|
|
public bool IsExists(SystemPara entity)
|
|||
|
|
{
|
|||
|
|
WhereClip wc = new WhereClip();
|
|||
|
|
wc.And(SystemPara._.Sys_Key == entity.Sys_Key);
|
|||
|
|
int obj = Gateway.Default.Count<SystemPara>(wc && SystemPara._.Sys_Id != entity.Sys_Id);
|
|||
|
|
return obj > 0;
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 刷新全局参数
|
|||
|
|
/// </summary>
|
|||
|
|
public List<SystemPara> Refresh()
|
|||
|
|
{
|
|||
|
|
try
|
|||
|
|
{
|
|||
|
|
WeiSha.Common.Cache<Song.Entities.SystemPara>.Data.Clear();
|
|||
|
|
}
|
|||
|
|
catch
|
|||
|
|
{
|
|||
|
|
}
|
|||
|
|
finally
|
|||
|
|
{
|
|||
|
|
SystemPara[] syspara = Gateway.Default.From<SystemPara>().OrderBy(SystemPara._.Sys_Key.Asc).ToArray<SystemPara>();
|
|||
|
|
foreach (Song.Entities.SystemPara p in syspara)
|
|||
|
|
WeiSha.Common.Cache<Song.Entities.SystemPara>.Data.Add(p);
|
|||
|
|
List<SystemPara> list = WeiSha.Common.Cache<SystemPara>.Data.List;
|
|||
|
|
}
|
|||
|
|
return WeiSha.Common.Cache<SystemPara>.Data.List;
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 删除
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="entity">业务实体</param>
|
|||
|
|
public void Delete(SystemPara entity)
|
|||
|
|
{
|
|||
|
|
Gateway.Default.Delete<SystemPara>(entity);
|
|||
|
|
this.Refresh(); //重新构建系统参数的缓存
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 删除，按主键ID；
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="identify">实体的主键</param>
|
|||
|
|
public void Delete(int identify)
|
|||
|
|
{
|
|||
|
|
Gateway.Default.Delete<SystemPara>(SystemPara._.Sys_Id == identify);
|
|||
|
|
this.Refresh(); //重新构建系统参数的缓存
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 删除，按键值
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="key"></param>
|
|||
|
|
public void Delete(string key)
|
|||
|
|
{
|
|||
|
|
Gateway.Default.Delete<SystemPara>(SystemPara._.Sys_Key == key);
|
|||
|
|
this.Refresh(); //重新构建系统参数的缓存
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 根据键，获取值
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="key"></param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public string GetValue(string key)
|
|||
|
|
{
|
|||
|
|
SystemPara curr = GetSingle(key);
|
|||
|
|
if (curr == null) return null;
|
|||
|
|
return !string.IsNullOrWhiteSpace(curr.Sys_Value) ? curr.Sys_Value.Trim() : curr.Sys_Default;
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 根据键，获取值
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="key">键值</param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public WeiSha.Common.Param.Method.ConvertToAnyValue this[string key]
|
|||
|
|
{
|
|||
|
|
get
|
|||
|
|
{
|
|||
|
|
SystemPara curr = GetSingle(key);
|
|||
|
|
if (curr == null) return new WeiSha.Common.Param.Method.ConvertToAnyValue(null);
|
|||
|
|
string val = !string.IsNullOrWhiteSpace(curr.Sys_Value) ? curr.Sys_Value.Trim() : curr.Sys_Default;
|
|||
|
|
WeiSha.Common.Param.Method.ConvertToAnyValue p = new WeiSha.Common.Param.Method.ConvertToAnyValue(val);
|
|||
|
|
p.Unit = curr.Sys_Unit;
|
|||
|
|
return p;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 获取单个实例
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="id"></param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public SystemPara GetSingle(int id)
|
|||
|
|
{
|
|||
|
|
return Gateway.Default.From<SystemPara>().Where(SystemPara._.Sys_Id == id).ToFirst<SystemPara>();
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 获取单个实例，通过键值获取
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="key"></param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public SystemPara GetSingle(string key)
|
|||
|
|
{
|
|||
|
|
SystemPara curr = null;
|
|||
|
|
//从缓存中读取
|
|||
|
|
List<SystemPara> list = WeiSha.Common.Cache<SystemPara>.Data.List;
|
|||
|
|
if (list == null) list = this.Refresh();
|
|||
|
|
if (list == null) return null;
|
|||
|
|
List<SystemPara> tm = (from l in list
|
|||
|
|
where l.Sys_Key == key
|
|||
|
|
select l).ToList<SystemPara>();
|
|||
|
|
if (tm.Count > 0) curr = tm[0];
|
|||
|
|
if (curr == null) curr = Gateway.Default.From<SystemPara>().Where(SystemPara._.Sys_Key == key).ToFirst<SystemPara>();
|
|||
|
|
return curr;
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 获取所有参数
|
|||
|
|
/// </summary>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public DataTable GetAll()
|
|||
|
|
{
|
|||
|
|
DataSet ds = Gateway.Default.From<SystemPara>().OrderBy(SystemPara._.Sys_Key.Asc).ToDataSet();
|
|||
|
|
if (ds.Tables.Count > 0)
|
|||
|
|
{
|
|||
|
|
return ds.Tables[0];
|
|||
|
|
}
|
|||
|
|
return null;
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 查询获取参数
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="searKey">键名</param>
|
|||
|
|
/// <param name="searIntro">参数说明</param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public DataTable GetAll(string searKey, string searIntro)
|
|||
|
|
{
|
|||
|
|
WhereClip wc = SystemPara._.Sys_Id > -1;
|
|||
|
|
if (searKey != null && searKey != "")
|
|||
|
|
{
|
|||
|
|
wc.And(SystemPara._.Sys_Key.Like("%" + searKey + "%"));
|
|||
|
|
}
|
|||
|
|
if (searIntro != null && searIntro != "")
|
|||
|
|
{
|
|||
|
|
wc.And(SystemPara._.Sys_ParaIntro.Like("%" + searIntro + "%"));
|
|||
|
|
}
|
|||
|
|
DataSet ds = Gateway.Default.From<SystemPara>().Where(wc).OrderBy(SystemPara._.Sys_Key.Asc).ToDataSet();
|
|||
|
|
if (ds.Tables.Count > 0)
|
|||
|
|
{
|
|||
|
|
return ds.Tables[0];
|
|||
|
|
}
|
|||
|
|
return null;
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 生成资金流水号
|
|||
|
|
/// </summary>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public string Serial()
|
|||
|
|
{
|
|||
|
|
//前缀
|
|||
|
|
string pre = "";
|
|||
|
|
Song.Entities.Organization org = Business.Do<IOrganization>().OrganCurrent();
|
|||
|
|
if (org != null) pre = org.Org_TwoDomain;
|
|||
|
|
//二级域名前缀
|
|||
|
|
int len = 4;
|
|||
|
|
if (string.IsNullOrWhiteSpace(pre)) pre = "";
|
|||
|
|
pre = pre.Replace(".", "");
|
|||
|
|
while (pre.Length < len) pre += "X"; //小于指定长度，则补位
|
|||
|
|
if (pre.Length > len) pre = pre.Substring(0, len); //大于指定长度，则截取
|
|||
|
|
//机构ID前缀
|
|||
|
|
string id = "";
|
|||
|
|
if (org != null) id = org.Org_ID.ToString("000");
|
|||
|
|
while (id.Length < 4) id = "0" + id;
|
|||
|
|
//序号
|
|||
|
|
string baseCode = DateTime.Now.ToString("yyyyMMddhhmmssffff");
|
|||
|
|
System.Random rd = new System.Random((int)DateTime.Now.Ticks + org.Org_ID);
|
|||
|
|
int rdNumber = rd.Next(0, 99);
|
|||
|
|
//长度：4+18+4+2=28
|
|||
|
|
return id + baseCode + pre.ToUpper() + string.Format("{0:00}", rdNumber);
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 测试是否完成授权
|
|||
|
|
/// </summary>
|
|||
|
|
public bool IsLicense()
|
|||
|
|
{
|
|||
|
|
WeiSha.Common.License lic = WeiSha.Common.License.Value;
|
|||
|
|
return lic.IsLicense;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 数据库完整性测试
|
|||
|
|
/// </summary>
|
|||
|
|
/// <returns>如果不缺少，则返回null；如果缺少，则返回"表名:字段"</returns>
|
|||
|
|
public List<string> DatabaseCompleteTest()
|
|||
|
|
{
|
|||
|
|
string path = AppDomain.CurrentDomain.SetupInformation.ApplicationBase + @"\\bin\\";
|
|||
|
|
string assemblyName = path + "Song.Entities.dll";
|
|||
|
|
System.Reflection.Assembly assembly = Assembly.LoadFrom(assemblyName);
|
|||
|
|
Type[] ts = assembly.GetTypes();
|
|||
|
|
List<string> classList = new List<string>();
|
|||
|
|
foreach (Type t in ts)
|
|||
|
|
{
|
|||
|
|
//创建实体
|
|||
|
|
object obj = System.Activator.CreateInstance(t);
|
|||
|
|
if (!(obj is WeiSha.Data.Entity)) continue;
|
|||
|
|
WeiSha.Data.Entity entity = (WeiSha.Data.Entity)obj;
|
|||
|
|
if (entity == null) continue;
|
|||
|
|
//对比缺少的字段
|
|||
|
|
try
|
|||
|
|
{
|
|||
|
|
DataSet ds = Gateway.Default.FromSql(string.Format("select top 1 * from [{0}]", t.Name)).ToDataSet();
|
|||
|
|
string fieldExist = "";
|
|||
|
|
PropertyInfo[] propertyinfo = t.GetProperties();
|
|||
|
|
foreach (PropertyInfo pi in propertyinfo)
|
|||
|
|
{
|
|||
|
|
bool isExist = false;
|
|||
|
|
foreach (DataColumn dc in ds.Tables[0].Columns)
|
|||
|
|
{
|
|||
|
|
if (dc.ColumnName == pi.Name)
|
|||
|
|
{
|
|||
|
|
isExist = true;
|
|||
|
|
break;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
if (!isExist)
|
|||
|
|
{
|
|||
|
|
fieldExist += pi.Name + ",";
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
if (fieldExist != "")
|
|||
|
|
classList.Add(t.Name + ":" + fieldExist);
|
|||
|
|
}
|
|||
|
|
catch
|
|||
|
|
{
|
|||
|
|
classList.Add(t.Name + ":（缺少整个表）");
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
return classList.Count < 1 ? null : classList;
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 数据库链接测试
|
|||
|
|
/// </summary>
|
|||
|
|
/// <returns>链接正确为true，否则为false</returns>
|
|||
|
|
public bool DatabaseLinkTest()
|
|||
|
|
{
|
|||
|
|
return Gateway.IsCorrect;
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 执行sql语句
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="sql"></param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public int ExecuteSql(string sql)
|
|||
|
|
{
|
|||
|
|
int i = Gateway.Default.FromSql(sql).Execute();
|
|||
|
|
return i;
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 执行sql语句，返回第一行第一列的数据
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="sql"></param>
|
|||
|
|
/// <returns>返回第一行第一列的数据</returns>
|
|||
|
|
public object ScalarSql(string sql)
|
|||
|
|
{
|
|||
|
|
return Gateway.Default.FromSql(sql).ToScalar();
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 执行sql语句，返回第一行
|
|||
|
|
/// </summary>
|
|||
|
|
/// <typeparam name="T"></typeparam>
|
|||
|
|
/// <param name="sql"></param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public T ScalarSql<T>(string sql) where T : WeiSha.Data.Entity
|
|||
|
|
{
|
|||
|
|
return Gateway.Default.FromSql(sql).ToFirst<T>();
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 执行sql语句
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="sql"></param>
|
|||
|
|
/// <returns>返回数据集</returns>
|
|||
|
|
public List<T> ForSql<T>(string sql) where T : WeiSha.Data.Entity
|
|||
|
|
{
|
|||
|
|
List<T> list = Gateway.Default.FromSql(sql).ToList<T>();
|
|||
|
|
return list;
|
|||
|
|
}
|
|||
|
|
/// <summary>
|
|||
|
|
/// 返回指定的数据集
|
|||
|
|
/// </summary>
|
|||
|
|
/// <param name="sql"></param>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public DataTable ForSql(string sql)
|
|||
|
|
{
|
|||
|
|
DataSet ds = Gateway.Default.FromSql(sql).ToDataSet();
|
|||
|
|
if (ds.Tables.Count > 0) return ds.Tables[0];
|
|||
|
|
return null;
|
|||
|
|
}
|
|||
|
|
#region IEnumerable 成员
|
|||
|
|
|
|||
|
|
/// <summary>
|
|||
|
|
/// 实现代迭器的功能，可以引用时用foreach循环
|
|||
|
|
/// </summary>
|
|||
|
|
/// <returns></returns>
|
|||
|
|
public IEnumerator GetEnumerator()
|
|||
|
|
{
|
|||
|
|
//从缓存中读取
|
|||
|
|
List<SystemPara> list = WeiSha.Common.Cache<SystemPara>.Data.List;
|
|||
|
|
if (list == null) list = this.Refresh();
|
|||
|
|
for (int i = 0; i < list.Count; i++)
|
|||
|
|
{
|
|||
|
|
WeiSha.Common.Param.Method.ConvertToAnyValue p = new WeiSha.Common.Param.Method.ConvertToAnyValue();
|
|||
|
|
p.ParaKey = list[i].Sys_Key;
|
|||
|
|
p.ParaValue = list[i].Sys_Value;
|
|||
|
|
p.Unit = list[i].Sys_Unit;
|
|||
|
|
yield return p;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
#endregion
|
|||
|
|
}
|
|||
|
|
}
|