/// <summary>
/// 保存collecttypedata数据集数据
/// </summary>
/// <param name="collecttypedata">数据集对象</param>
/// <returns>返回保存后的响应信息</returns>
public String SaveCollectType(CollectTypeData collecttypedata)
{
#region
CollectTypeClass collecttypeclass = new CollectTypeClass();
return(base.Save(collecttypedata, collecttypeclass));
#endregion
}
/// <summary>
/// 获取CollectType数据表的全部数据
/// </summary>
/// <returns>Json字符串</returns>
public string GetJsonByAll()
{
#region
int totalCount = 0;
CollectTypeData collecttypedata = this.getData(null);
totalCount = collecttypedata.Tables[0].Rows.Count;
return(base.GetJson(collecttypedata, totalCount));
#endregion
}
/// <summary>
/// 根据主键值检索符合该条件的记录，用于编辑和删除记录时。
/// </summary>
/// <param name="collectTypeId">主键-</param>
/// <returns></returns>
private CollectTypeData getData(string collectTypeId)
{
#region
CollectTypeData collecttypedata = new CollectTypeData();
DBConditions querybusinessparams = new DBConditions();
querybusinessparams.Add(CollectTypeData.collectTypeId, EnumSqlType.sqlint, EnumCondition.Equal, collectTypeId);
this._collecttypeclass.GetSingleT(collecttypedata, querybusinessparams);
return(collecttypedata);
#endregion
}
/// <summary>
/// 添加CollectType表行数据（如主键为非自增型字段，则自行修改代码）
/// </summary>
/// <param name="collecttypedata">数据集对象</param>
/// <param name="collecttype">实体对象</param>
public void AddRow(ref CollectTypeData collecttypedata, EntityCollectType collecttype)
{
#region
DataRow dr = collecttypedata.Tables[0].NewRow();
collecttypedata.Assign(dr, CollectTypeData.collectTypeId, collecttype.collectTypeId);
collecttypedata.Assign(dr, CollectTypeData.releaseNo, collecttype.releaseNo);
collecttypedata.Assign(dr, CollectTypeData.releaseType, collecttype.releaseType);
collecttypedata.Assign(dr, CollectTypeData.releaseTime, collecttype.releaseTime);
collecttypedata.Assign(dr, CollectTypeData.writeUser, collecttype.writeUser);
collecttypedata.Assign(dr, CollectTypeData.writeTime, collecttype.writeTime);
collecttypedata.Assign(dr, CollectTypeData.writeIp, collecttype.writeIp);
collecttypedata.Tables[0].Rows.Add(dr);
#endregion
}
/// <summary>
/// 删除collecttypedata数据集中指定的行数据
/// </summary>
/// <param name="collecttypedata">数据集对象</param>
/// <param name="collectTypeId">主键-</param>
public void DeleteRow(ref CollectTypeData collecttypedata, string collectTypeId)
{
#region
if (collecttypedata.Tables[0].Rows.Count <= 0)
{
collecttypedata = this.getData(collectTypeId);
}
DataRow dr = collecttypedata.Tables[0].Rows.Find(new object[1] {
collectTypeId
});
if (dr != null)
{
dr.Delete();
}
#endregion
}
/// <summary>
/// 编辑collecttypedata数据集中指定的行数据
/// </summary>
/// <param name="collecttypedata">数据集对象</param>
/// <param name="collecttype">实体对象</param>
public void EditRow(ref CollectTypeData collecttypedata, EntityCollectType collecttype)
{
#region
if (collecttypedata.Tables[0].Rows.Count <= 0)
{
collecttypedata = this.getData(collecttype.collectTypeId);
}
DataRow dr = collecttypedata.Tables[0].Rows.Find(new object[1] {
collecttype.collectTypeId
});
collecttypedata.Assign(dr, CollectTypeData.collectTypeId, collecttype.collectTypeId);
collecttypedata.Assign(dr, CollectTypeData.releaseNo, collecttype.releaseNo);
collecttypedata.Assign(dr, CollectTypeData.releaseType, collecttype.releaseType);
collecttypedata.Assign(dr, CollectTypeData.releaseTime, collecttype.releaseTime);
collecttypedata.Assign(dr, CollectTypeData.writeUser, collecttype.writeUser);
collecttypedata.Assign(dr, CollectTypeData.writeTime, collecttype.writeTime);
collecttypedata.Assign(dr, CollectTypeData.writeIp, collecttype.writeIp);
#endregion
}
/// <summary>
/// 根据条件筛选所有CollectType指定页码的数据（分页型）
/// </summary>
/// <param name="collecttype">实体对象</param>
/// <param name="pageparams">分页对象</param>
/// <param name="totalCount">符合条件的记录总数量</param>
/// <returns></returns>
public DataSet GetData(EntityCollectType collecttype, PageParams pageparams, out int totalCount)
{
#region
DBConditions querybusinessparams = new DBConditions(pageparams);
querybusinessparams.Add(CollectTypeData.collectTypeId, EnumSqlType.sqlint,
EnumCondition.Equal, collecttype.collectTypeId);
querybusinessparams.Add(CollectTypeData.releaseNo, EnumSqlType.nvarchar,
EnumCondition.Equal, collecttype.releaseNo);
querybusinessparams.Add(CollectTypeData.releaseType, EnumSqlType.tinyint,
EnumCondition.Equal, collecttype.releaseType);
querybusinessparams.Add(CollectTypeData.releaseTime, EnumSqlType.datetime,
EnumCondition.Equal, collecttype.releaseTime);
querybusinessparams.Add(CollectTypeData.writeUser, EnumSqlType.sqlint,
EnumCondition.Equal, collecttype.writeUser);
querybusinessparams.Add(CollectTypeData.writeTime, EnumSqlType.datetime,
EnumCondition.Equal, collecttype.writeTime);
querybusinessparams.Add(CollectTypeData.writeIp, EnumSqlType.nvarchar,
EnumCondition.Equal, collecttype.writeIp);
CollectTypeData collecttypedata = new CollectTypeData();
totalCount = this._collecttypeclass.GetSingleT(collecttypedata, querybusinessparams);
return(collecttypedata);
#endregion
}
