private void setParameter(iSqlParameter[] parms, UserrightInfo info) { try { int i = -1; parms[++i].Value = info.R_new; parms[++i].Value = info.R_upt; parms[++i].Value = info.R_del; parms[++i].Value = info.R_sys; parms[++i].Value = info.Id; return; } catch (Exception ex) { throw ex; } }
private UserrightInfo getDataReader(iSqlDataReader dar) { try { int i = -1; UserrightInfo info = new UserrightInfo(); info.R_new = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.R_upt = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.R_del = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.R_sys = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); return info; } catch (Exception ex) { throw ex; } }
public bool Save(UserrightInfo info) { try { using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM)) { using (iSqlTransaction trans = iConn.BeginTransaction()) { try { this.Saveitem(trans, info); trans.Commit(); } catch (Exception ex) { trans.Rollback(); throw ex; } } iConn.Close(); } return true; } catch (Exception ex) { throw ex; } }
public bool Saveitem(iSqlTransaction trans, UserrightInfo info) { try { if (trans == null || info == null) return false; string SQL = string.Empty; if (info.Id == 0) { SQL = SQL_INSERT; info.Id = (int)HELPER.getNewID(trans, TABLENAME); iSqlParameter[] parms = this.getParameter(SQL); this.setParameter(parms, info); HELPER.executeNonQuery(trans, iCommandType.Text, SQL, parms); } else if (HELPER.isExist(trans, TABLENAME, info.Id)) { SQL = SQL_UPDATE; iSqlParameter[] parms = this.getParameter(SQL); this.setParameter(parms, info); HELPER.executeNonQuery(trans, iCommandType.Text, SQL, parms); } else { SQL = SQL_INSERT; info.Id = (int)HELPER.getNewID(trans, TABLENAME); iSqlParameter[] parms = this.getParameter(SQL); this.setParameter(parms, info); HELPER.executeNonQuery(trans, iCommandType.Text, SQL, parms); } return true; } catch (Exception ex) { throw ex; } }
private UserInfo Take() { try { int iid = 0; int.TryParse(txtId.Value, out iid); UserInfo info = (new CUser()).Wcmm_Getinfo(iid); if (info == null) info = new UserInfo(); info.Id = iid; info.Name = txtName.Text.Trim(); if (iid == 0) info.Username = CFunctions.remove_blank(info.Name); info.Password = CFunctions.MBEncrypt("DFTY$FDSSDYE$#%"); info.Email = info.Username + "@dangdong.vn"; info.Pis = info.Pis == 0 ? 1 : info.Pis; if (PARENT != null) { info.Pid = PARENT.Id; info.Depth = PARENT.Depth + 1; } else { info.Depth = info.Pid != 0 ? info.Depth : 1; } info.Status = CCommon.GetStatus_upt(); info.Timeupdate = DateTime.Now; UserrightInfo rinfo = new UserrightInfo(); rinfo.Id = info.Id; string RPages = ""; if (dtlListRPages.Items.Count > 0) { foreach (DataListItem row in dtlListRPages.Items) { string Navigateurl = dtlListRPages.DataKeys[row.ItemIndex].ToString(); CheckBox RPages_typeof = (CheckBox)row.FindControl("RPages_typeof"); ListBox RPages_cid = (ListBox)row.FindControl("RPages_cid"); if (RPages_typeof.Checked) { string page = Navigateurl.Replace("l.aspx", ""); RPages += page + "#"; foreach (ListItem item in RPages_cid.Items) { if (item.Selected) RPages += page + item.Value + "#"; } } } } rinfo.R_new = rinfo.R_upt = rinfo.R_del = "#" + RPages; rinfo.R_sys = ""; info.iRight = rinfo; return info; } catch { return null; } }