static ConfigManagemt()
{
_init = new Model.ConfigModel();
//_init.Logger.Level = "DEBUG";
//_init.Logger.ProjectName = "My_Logger";
//_init.Logger.Type = "File";
}
public int AddConfig(Model.ConfigModel model, Model.ConfigLogModel mdlog)
{
int rtn = 0;
using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionString))
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [Config]");
strSql.Append("(TId,KId,Title,Val,Types,States,Sort,Remark)");
strSql.Append(" values (@TId,@KId,@Title,@Val,@Types,@States,@Sort,@Remark)");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@TId", DbTool.FixSqlParameter(model.TId)),
new SqlParameter("@KId", DbTool.FixSqlParameter(model.KId))
, new SqlParameter("@Title", DbTool.FixSqlParameter(model.Title))
, new SqlParameter("@Val", DbTool.FixSqlParameter(model.Val))
, new SqlParameter("@Types", DbTool.FixSqlParameter(model.Types))
, new SqlParameter("@States", DbTool.FixSqlParameter(model.States))
, new SqlParameter("@Sort", DbTool.FixSqlParameter(model.Sort))
, new SqlParameter("@Remark", DbTool.FixSqlParameter(model.Remark))
};
rtn += SqlHelper.ExecuteNonQuery(trans, CommandType.Text, strSql.ToString(), parameters);
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("insert into [ConfigLog]");
strSql2.Append("(ConfigId,UserId,Title,Note,CTime)");
strSql2.Append(" values (@ConfigId,@UserId,@Title,@Note,@CTime)");
strSql2.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters2 =
{
new SqlParameter("@ConfigId", DbTool.FixSqlParameter(mdlog.ConfigId))
, new SqlParameter("@UserId", DbTool.FixSqlParameter(mdlog.UserId))
, new SqlParameter("@Title", DbTool.FixSqlParameter(mdlog.Title))
, new SqlParameter("@Note", DbTool.FixSqlParameter(mdlog.Note))
, new SqlParameter("@CTime", DbTool.FixSqlParameter(mdlog.CTime))
};
rtn += SqlHelper.ExecuteNonQuery(trans, CommandType.Text, strSql2.ToString(), parameters2);
trans.Commit();
return(rtn);
}
catch (Exception)
{
trans.Rollback();
rtn = 0;
}
}
}
return(0);
}
private new void ButtonOkClick()
{
Model.ConfigModel configModel = GetModel();
GetFields(configModel);
SaveModel(configModel);
GetController <Model.ConfigModel>().SaveConfigSeq(GetValue <Model.ConfigSeqModel>(base.SAPForm.DataSources.DataTables.Item(DATA_SEQ), (Matrix)base.SAPForm.Items.Item(MATRIX_SEQ).Specific));
base.SAPForm.Close();
}
protected void BindDataReader(Model.ConfigModel model, SqlDataReader dr)
{
model.Id = DbTool.ConvertObject <System.Int32>(dr["Id"]);
model.TId = DbTool.ConvertObject <System.Int32>(dr["TId"]);
model.KId = DbTool.ConvertObject <System.Int32>(dr["KId"]);
model.Title = DbTool.ConvertObject <System.String>(dr["Title"]);
model.Val = DbTool.ConvertObject <System.String>(dr["Val"]);
model.Types = DbTool.ConvertObject <System.Int32>(dr["Types"]);
model.States = DbTool.ConvertObject <System.Int32>(dr["States"]);
model.Sort = DbTool.ConvertObject <System.Int32>(dr["Sort"]);
model.Remark = DbTool.ConvertObject <System.String>(dr["Remark"]);
}
public static Model.ConfigModel GetKeyConfig(int key)
{
var objectdel = CacheBase.FindCacheObjectInfo;
Model.ConfigModel model = objectdel.Where(w => w.KId == key).FirstOrDefault();
if (model == null)
{
throw new ArgumentNullException("key不存在");
}
return(model);
}
public int DelConfig(Model.ConfigModel model, Model.ConfigLogModel mdlog)
{
int rtn = 0;
using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionString))
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from Config ");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@Id", model.Id)
};
rtn += SqlHelper.ExecuteNonQuery(trans, CommandType.Text, strSql.ToString(), parameters);
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("insert into [ConfigLog]");
strSql2.Append("(ConfigId,UserId,Title,Note,CTime)");
strSql2.Append(" values (@ConfigId,@UserId,@Title,@Note,@CTime)");
strSql2.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters2 =
{
new SqlParameter("@ConfigId", DbTool.FixSqlParameter(mdlog.ConfigId))
, new SqlParameter("@UserId", DbTool.FixSqlParameter(mdlog.UserId))
, new SqlParameter("@Title", DbTool.FixSqlParameter(mdlog.Title))
, new SqlParameter("@Note", DbTool.FixSqlParameter(mdlog.Note))
, new SqlParameter("@CTime", DbTool.FixSqlParameter(mdlog.CTime))
};
rtn += SqlHelper.ExecuteNonQuery(trans, CommandType.Text, strSql2.ToString(), parameters2);
trans.Commit();
return(rtn);
}
catch (Exception)
{
trans.Rollback();
rtn = 0;
}
}
}
return(0);
}
public Model.ConfigModel GetModelKId(int KId)
{
string sql = "select top 1 * from Config where KId =" + KId;
Model.ConfigModel model = new Model.ConfigModel();
SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, sql.ToString());
if (dr.Read())
{
//var fields = DbTool.GetReaderFieldNames(dr);
//model = AutoBindDataReader(dr, fields);
BindDataReader(model, dr);
}
dr.Close();
return(model);
}
public int UpdateStates(Model.ConfigModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Config set ");
strSql.Append("States=@States ");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@States", DbTool.FixSqlParameter(model.States))
, new SqlParameter("@Id", model.Id)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters));
}
public void SaveConfig(Model.ConfigModel configModel)
{
Type modelType = typeof(T);
Type daoType = Type.GetType(modelType.AssemblyQualifiedName.Replace("Model", "DAO"));
if (daoType == null)
{
m_ConfigDAO.Save(configModel as T);
}
else
{
var dao = (DAO.BaseDAO <T>)Activator.CreateInstance(daoType);
dao.Save(configModel as T);
}
}
protected Model.ConfigModel AutoBindDataReader(SqlDataReader dr, params string[] fields)
{
var model = new Model.ConfigModel();
if (DbTool.HasFields("Id", fields))
{
model.Id = DbTool.ConvertObject <System.Int32>(dr["Id"]);
}
if (DbTool.HasFields("TId", fields))
{
model.TId = DbTool.ConvertObject <System.Int32>(dr["TId"]);
}
if (DbTool.HasFields("KId", fields))
{
model.KId = DbTool.ConvertObject <System.Int32>(dr["KId"]);
}
if (DbTool.HasFields("Title", fields))
{
model.Title = DbTool.ConvertObject <System.String>(dr["Title"]);
}
if (DbTool.HasFields("Val", fields))
{
model.Val = DbTool.ConvertObject <System.String>(dr["Val"]);
}
if (DbTool.HasFields("Types", fields))
{
model.Types = DbTool.ConvertObject <System.Int32>(dr["Types"]);
}
if (DbTool.HasFields("States", fields))
{
model.States = DbTool.ConvertObject <System.Int32>(dr["States"]);
}
if (DbTool.HasFields("Sort", fields))
{
model.Sort = DbTool.ConvertObject <System.Int32>(dr["Sort"]);
}
if (DbTool.HasFields("Remark", fields))
{
model.Remark = DbTool.ConvertObject <System.String>(dr["Remark"]);
}
return(model);
}
public List <Model.ConfigModel> GetModelList()
{
List <Model.ConfigModel> result = new List <Model.ConfigModel>();
string sql = "select * from Config where 1=1";
Model.ConfigModel model = new Model.ConfigModel();
SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, sql.ToString());
//var fields = DbTool.GetReaderFieldNames(dr);
while (dr.Read())
{
//model = AutoBindDataReader(dr, fields);
model = new Model.ConfigModel();
BindDataReader(model, dr);
result.Add(model);
}
dr.Close();
return(result);
}
protected override void CreateControls()
{
try
{
SAPForm.Title = string.Format(SAPForm.Title, AddOn.Instance.MainController.AddOnName);
ControlMenus(false, false, false);
Model.ConfigModel configModel = GetModel();
SetFields(configModel);
List <Model.ConfigSeqModel> configSeqList = GetController <Model.ConfigModel>().GetListConfigSeq();
SetValue <Model.ConfigSeqModel>(base.SAPForm.DataSources.DataTables.Item(DATA_SEQ), (Matrix)base.SAPForm.Items.Item(MATRIX_SEQ).Specific, configSeqList);
}
catch (Exception e)
{
Controller.ConnectionController.Instance.Application.StatusBar.SetText(e.Message);
}
}
public int Update(Model.ConfigModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Config set ");
strSql.Append("KId=@KId,Title=@Title,Val=@Val,Types=@Types,States=@States,Sort=@Sort,Remark=@Remark ");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@KId", DbTool.FixSqlParameter(model.KId))
, new SqlParameter("@Title", DbTool.FixSqlParameter(model.Title))
, new SqlParameter("@Val", DbTool.FixSqlParameter(model.Val))
, new SqlParameter("@Types", DbTool.FixSqlParameter(model.Types))
, new SqlParameter("@States", DbTool.FixSqlParameter(model.States))
, new SqlParameter("@Sort", DbTool.FixSqlParameter(model.Sort))
, new SqlParameter("@Remark", DbTool.FixSqlParameter(model.Remark))
, new SqlParameter("@Id", model.Id)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters));
}
public int Add(Model.ConfigModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [Config]");
strSql.Append("(TId,KId,Title,Val,Types,States,Sort,Remark)");
strSql.Append(" values (@TId,@KId,@Title,@Types,@States,@Remark)");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@TId", DbTool.FixSqlParameter(model.TId)),
new SqlParameter("@KId", DbTool.FixSqlParameter(model.KId))
, new SqlParameter("@Title", DbTool.FixSqlParameter(model.Title))
, new SqlParameter("@Val", DbTool.FixSqlParameter(model.Val))
, new SqlParameter("@Types", DbTool.FixSqlParameter(model.Types))
, new SqlParameter("@States", DbTool.FixSqlParameter(model.States))
, new SqlParameter("@Sort", DbTool.FixSqlParameter(model.Sort))
, new SqlParameter("@Remark", DbTool.FixSqlParameter(model.Remark))
};
return(DbTool.ConvertObject <int>(SqlHelper.ExecuteScalar(conn, CommandType.Text, strSql.ToString(), parameters), 0));
}
protected virtual void SaveModel(Model.ConfigModel configModel)
{
GetController <Model.ConfigModel>().SaveConfig(configModel);
}
protected virtual void GetFields(Model.ConfigModel configModel)
{
configModel.Code = 1;
configModel.AutoCreateMetadata = GetValue(CHECK_AUTO_CREATE_METADATA);
configModel.ActivateLog = GetValue(CHECK_LOG);
}
protected virtual void SetFields(Model.ConfigModel configModel)
{
SetValue(CHECK_AUTO_CREATE_METADATA, configModel.AutoCreateMetadata);
SetValue(CHECK_LOG, configModel.ActivateLog);
}
