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