/// <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 }