/// <summary>
/// 添加一个实体类
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private XBase.Model.Decision.DataMySubscribe GetList(SqlDataReader dr)
{
XBase.Model.Decision.DataMySubscribe entity = new XBase.Model.Decision.DataMySubscribe();
entity.ID = SqlClientUtility.GetInt32(dr, "ID", 0);
entity.CompanyCD = SqlClientUtility.GetString(dr, "CompanyCD", String.Empty);
entity.DataID = SqlClientUtility.GetString(dr, "DataID", String.Empty);
entity.DataName = SqlClientUtility.GetString(dr, "DataName", String.Empty);
entity.DataVarValue = SqlClientUtility.GetString(dr, "DataVarValue", String.Empty);
entity.Conditions = SqlClientUtility.GetString(dr, "Conditions", String.Empty);
entity.MyMobile = SqlClientUtility.GetString(dr, "MyMobile", String.Empty);
entity.Creator = SqlClientUtility.GetString(dr, "Creator", String.Empty);
entity.CreateDate = SqlClientUtility.GetDateTime(dr, "CreateDate", DateTime.Now);
entity.DataNote = SqlClientUtility.GetString(dr, "DataNote", String.Empty);
entity.Frequency = SqlClientUtility.GetString(dr, "Frequency", String.Empty);
entity.Format = SqlClientUtility.GetString(dr, "Format", String.Empty);
return(entity);
}
/// <summary>
/// 条件查询
/// </summary>
/// <param name="cond">查询条件,多个条件应该以And连接</param>
/// <param name="orderExp">展现顺序</param>
/// <returns>List</returns>
public IList <XBase.Model.Decision.DataMySubscribe> GetDataMySubscribleListbyCond(string cond, string orderExp)
{
SqlParameter[] parameters = new SqlParameter[] {
SqlParameterHelper.MakeInParam("@Where", SqlDbType.VarChar, 100, cond),
SqlParameterHelper.MakeInParam("@OrderExp", SqlDbType.VarChar, 50, orderExp)
};
XBase.Model.Decision.DataMySubscribe entity = null;
List <XBase.Model.Decision.DataMySubscribe> lst = new List <XBase.Model.Decision.DataMySubscribe>();
SqlDataReader dr;
Database.RunProc("statdba.DataMySubscribe_SelectbyCond", parameters, out dr);
while (dr.Read())
{
entity = GetList(dr);
lst.Add(entity);
}
return(lst);
}
/// <summary>
/// 修改一条记录
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public bool ModDataMySubscrible(XBase.Model.Decision.DataMySubscribe entity)
{
SqlParameter[] parameters = new SqlParameter[] {
SqlParameterHelper.MakeInParam("@ID", SqlDbType.Int, 4, entity.ID),
SqlParameterHelper.MakeInParam("@DataId", SqlDbType.VarChar, 100, entity.DataID),
SqlParameterHelper.MakeInParam("@DataName", SqlDbType.VarChar, 400, entity.DataName),
SqlParameterHelper.MakeInParam("@DataVarValue", SqlDbType.VarChar, 1000, entity.DataVarValue),
SqlParameterHelper.MakeInParam("@Conditions", SqlDbType.VarChar, 100, entity.Conditions),
SqlParameterHelper.MakeInParam("@MyMobile", SqlDbType.VarChar, 100, entity.MyMobile),
SqlParameterHelper.MakeInParam("@DataNote", SqlDbType.VarChar, 200, entity.DataNote),
SqlParameterHelper.MakeInParam("@Frequency", SqlDbType.VarChar, 50, entity.Frequency),
SqlParameterHelper.MakeInParam("@Format", SqlDbType.VarChar, 200, entity.Format)
};
bool ret;
Database.RunProc("statdba.DataMySubscribe_Modify", parameters, out ret);
return(ret);
}
/// <summary>
/// 添加一条记录
/// </summary>
/// <param name="val"></param>
/// <returns></returns>
public bool AddDataMySubscribe(XBase.Model.Decision.DataMySubscribe entity, out int Id)
{
SqlParameter[] parameters = new SqlParameter[] {
SqlParameterHelper.MakeInParam("@CompanyCD", SqlDbType.VarChar, 8, entity.CompanyCD),
SqlParameterHelper.MakeInParam("@DataID", SqlDbType.VarChar, 100, entity.DataID),
SqlParameterHelper.MakeInParam("@DataName", SqlDbType.VarChar, 400, entity.DataName),
SqlParameterHelper.MakeInParam("@DataVarValue", SqlDbType.VarChar, 1000, entity.DataVarValue),
SqlParameterHelper.MakeInParam("@Conditions", SqlDbType.VarChar, 100, entity.Conditions),
SqlParameterHelper.MakeInParam("@MyMobile", SqlDbType.VarChar, 100, entity.MyMobile),
SqlParameterHelper.MakeInParam("@Creator", SqlDbType.VarChar, 20, entity.Creator),
SqlParameterHelper.MakeInParam("@CreateDate", SqlDbType.DateTime, 8, entity.CreateDate),
SqlParameterHelper.MakeInParam("@DataNote", SqlDbType.VarChar, 200, entity.DataNote),
SqlParameterHelper.MakeInParam("@Frequency", SqlDbType.VarChar, 50, entity.Frequency),
SqlParameterHelper.MakeInParam("@Format", SqlDbType.VarChar, 200, entity.Format),
SqlParameterHelper.MakeOutParam("@ID", SqlDbType.Int, 6)
};
bool ret;
Database.RunProc("statdba.DataMySubscribe_Create", parameters, out ret);
Id = Convert.ToInt32(parameters[11].Value);
return(ret);
}
/// <summary>
/// 添加一个实体类
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private XBase.Model.Decision.DataMySubscribe GetList(SqlDataReader dr)
{
XBase.Model.Decision.DataMySubscribe entity = new XBase.Model.Decision.DataMySubscribe();
entity.ID = SqlClientUtility.GetInt32(dr, "ID", 0);
entity.CompanyCD = SqlClientUtility.GetString(dr, "CompanyCD", String.Empty);
entity.DataID = SqlClientUtility.GetString(dr, "DataID",String.Empty);
entity.DataName = SqlClientUtility.GetString(dr, "DataName", String.Empty);
entity.DataVarValue = SqlClientUtility.GetString(dr, "DataVarValue", String.Empty);
entity.Conditions = SqlClientUtility.GetString(dr, "Conditions", String.Empty);
entity.MyMobile = SqlClientUtility.GetString(dr, "MyMobile", String.Empty);
entity.Creator = SqlClientUtility.GetString(dr, "Creator", String.Empty);
entity.CreateDate = SqlClientUtility.GetDateTime(dr, "CreateDate", DateTime.Now);
entity.DataNote = SqlClientUtility.GetString(dr, "DataNote", String.Empty);
entity.Frequency = SqlClientUtility.GetString(dr, "Frequency", String.Empty);
entity.Format = SqlClientUtility.GetString(dr, "Format", String.Empty);
return entity;
}
/// <summary>
/// 修改一条记录
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public bool ModDataMySubscrible(XBase.Model.Decision.DataMySubscribe entity)
{
return(dal.ModDataMySubscrible(entity));
}
/// <summary>
/// 添加一条记录
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public bool AddDataMySubscribe(XBase.Model.Decision.DataMySubscribe entity, out int Id)
{
return(dal.AddDataMySubscribe(entity, out Id));
}
