/// <summary>
/// 查询所有报表
/// </summary>
/// <returns></returns>
public List<NeuConfiguration> QueryAllReporter()
{
List<NeuConfiguration> reportList = new List<NeuConfiguration>();
//string sql = "";
//if(this.Sql.GetSql("Reporter.QueryAll",ref sql)==-1) return null;
//if(this.ExecQuery(sql)==-1) return null;
string sql = "";
if (this.Sql.GetSql("Reporter.QueryAll", ref sql) == -1) return null;
try
{
sql = string.Format(sql);
}
catch (Exception ex) { this.Err = ex.Message; return null; }
if (this.ExecQuery(sql) <= 0) return null;
while (this.Reader.Read())
{
NeuConfiguration NeuConfiguration = new NeuConfiguration();
NeuConfiguration = new NeuConfiguration();
NeuConfiguration.Type = Reader[0].ToString();
NeuConfiguration.ID = Reader[1].ToString();
NeuConfiguration.Remark = Reader[6].ToString();
reportList.Add(NeuConfiguration);
}
return reportList;
}
private int Update(NeuConfiguration NeuConfiguration)
{
//AbstractSqlModel sqlModel = new SqlModel("NeuConfiguration.Update");
//sqlModel["id"] = NeuConfiguration.Id;
//sqlModel["type"] = NeuConfiguration.Type;
//sqlModel["config_xml"] = NeuConfiguration.ConfigXml.OuterXml;
//sqlModel["oper_code"] = NeuConfiguration.OperCode;
//sqlModel["oper_date"] = NeuConfiguration.OperDate;
//sqlModel["valid_state"] = (NConvert.ToInt32(NeuConfiguration.ValidState)).ToString();
//sqlModel["remark"] = NeuConfiguration.Remark;
//return base.ExecuteNonQuery(sqlModel);
string[] args = new string[]{
NeuConfiguration.Type,
NeuConfiguration.ID,
NeuConfiguration.Remark,
NeuConfiguration.ConfigString,
FrameWork.Function.NConvert.ToInt32(NeuConfiguration.IsValidState).ToString(),
NeuConfiguration.OperCode,
NeuConfiguration.OperDate.ToString()
};
string sql = "";
if (this.Sql.GetSql("CONFIGURATIONMANAGERENTITY.UPDATE", ref sql) == -1) return -1;
try
{
sql = string.Format(sql, args);
}
catch (Exception ex) { this.Err = ex.Message; return -1; }
if (this.ExecNoQuery(sql) <= 0) return -1;
return 0;
}
/// <summary>
/// 保存配置属性
/// </summary>
/// <param name="neuConfiguration"></param>
/// <returns></returns>
public int Save(NeuConfiguration neuConfiguration)
{
int ret = Update(neuConfiguration);
if (ret == 0)
{
Insert(neuConfiguration);
}
return 0;
}
private NeuConfiguration GetEntity(string id, string type)
{
////
////AbstractSqlModel sqlModel = new SqlModel("ConfigurationManagerEntity.Get");
////sqlModel["id"] = id;
////sqlModel["type"] = type;
////using (DbDataReader reader = base.ExecuteReader(sqlModel))
////{
////}
NeuConfiguration neuConfiguration = null;
string sql = "";
if (this.Sql.GetSql("CONFIGURATIONMANAGERENTITY.GET", ref sql) == -1) return null;
try
{
sql = string.Format(sql,type,id);
}
catch (Exception ex) { this.Err = ex.Message; return null; }
if (this.ExecQuery(sql) <= 0) return null;
while (this.Reader.Read())
{
neuConfiguration = new NeuConfiguration();
neuConfiguration.Type = Reader[0].ToString();
neuConfiguration.ID = Reader[1].ToString();
neuConfiguration.ConfigString = Reader[2].ToString();
neuConfiguration.OperCode = Reader[3].ToString();
if (!Reader.IsDBNull(4))
neuConfiguration.OperDate = DateTime.Parse(Reader[4].ToString());
neuConfiguration.IsValidState =FrameWork.Function.NConvert.ToBoolean(Reader[5].ToString());
neuConfiguration.Remark = Reader[6].ToString();
}
this.Reader.Close();
return neuConfiguration;
}
