public bool Add(object[] dataArray) { try { OpenConnection(); foreach (object obj in dataArray) { USERGroupAutorizeDTO objJson = (USERGroupAutorizeDTO)obj; objJson.VIEW = Convert.ToBoolean(objJson.VIEW) == true ? "1" : "0"; objJson.EDIT = Convert.ToBoolean(objJson.EDIT) == true ? "1" : "0"; objJson.DELETE = Convert.ToBoolean(objJson.DELETE) == true ? "1" : "0"; objJson.Row_State = Convert.ToBoolean(objJson.Row_State) == true ? "1" : "0"; isCan = ExcecuteNoneQuery("sp_M_UserGroup_Autorize_Insert", objJson); } CloseConnection(); } catch (Exception ex) { throw new Exception(ex.Message); } finally { } return(isCan); }
public List <USERGroupAutorizeDTO> FindByObjList(object data) { List <SqlParameter> parameterList = new List <SqlParameter>(); objList = new List <USERGroupAutorizeDTO>(); dataTable = null; string procName = "sp_M_UserGroup_Autorize_FindByColumn"; try { dataTable = new DataTable(); adapter = new SqlDataAdapter(); SqlConnection conn = OpenConnection(); if (data != null) { parameterList.AddRange(GetParameters(procName, data).ToArray()); } command = new SqlCommand(procName, conn); command.CommandType = CommandType.StoredProcedure; if (data != null) { command.Parameters.AddRange(parameterList.ToArray()); } using (SqlDataReader reader = command.ExecuteReader()) { // objList = DTO.Util.ConvertX.GetListFromDataReader<MenuDTO>(reader) as List<MenuDTO>; while (reader.Read()) { obj = new USERGroupAutorizeDTO(); obj.USERGROUP_Autorize_OID = reader["UserGroup_Autorize_OID"].ToString(); obj.USERGROUPID = reader["USERGroupID"].ToString(); obj.MENU_OID = reader["MENU_OID"].ToString(); obj.MENUName = reader["MENUName"].ToString(); obj.Icon = reader["Icon"].ToString(); obj.MENUGROUP_OID = reader["MENUGroup_OID"].ToString(); obj.MENUGROUPName = reader["MENUGroupName"].ToString(); obj.VIEW = reader["VIEW"].ToString(); obj.EDIT = reader["EDIT"].ToString(); obj.DELETE = reader["DELETE"].ToString(); obj.APPROVE = reader["APPROVE"].ToString(); obj.Row_State = reader["ROW_STATE"].ToString(); objList.Add(obj); // ReadSingleRow((IDataRecord)reader); } } } catch (Exception ex) { } finally { CloseConnection(); } return(objList); }