public List<RPCFan> RetrieveFirstObject(WorkbookPart wbPart, Sheet theSheet) { string abc = "ABCDEFGHIJKLMNOPQRSTUVWXYZ"; WorksheetPart wsPart = (WorksheetPart)(wbPart.GetPartById(theSheet.Id)); Cell theCell = wsPart.Worksheet.Descendants<Cell>(). Where(c => c != null).FirstOrDefault(); string first = FindCellInnerValue(wbPart, theCell); var letra = first.Substring(0, 1); int numeros = int.Parse(first.Substring(1)); int i = abc.IndexOf(letra); List<RPCFan> retorno = new List<RPCFan>(); int countFans = 0; int numeroscopy = numeros; while (theCell != null) { string newRef = abc[i].ToString() + (numeroscopy++ + 1).ToString(); theCell = wsPart.Worksheet.Descendants<Cell>(). Where(c => c.CellReference == newRef).FirstOrDefault(); countFans++; } for (int ii = 0; ii < (countFans - 1); ii++) { string newRef; i = abc.IndexOf(letra); theCell = new Cell(); var fan = new RPCFan(); List<string> data = new List<string>(); while (theCell != null) { newRef = abc[i++].ToString() + (numeros + 1).ToString(); theCell = wsPart.Worksheet.Descendants<Cell>(). Where(c => c.CellReference == newRef).FirstOrDefault(); var value = FindCellInnerValue(wbPart, theCell, false); data.Add(value); //i++; } fan.YaEntro = false; fan.LastCell = abc[i-2].ToString() + (numeros + 1).ToString(); fan.ID = data[0]; fan.Nombre = data[1]; fan.CardNum = data[2]; fan.DNI = data[3]; fan.Ingreso = data[4]; if (data[5]!="0") fan.YaEntro = true; retorno.Add(fan); numeros++; } return retorno; }
private void MarkCell(RPCFan myfan) { WorksheetPart wsPart = (WorksheetPart)(wbPart.GetPartById(theSheet.Id)); Cell theCellular = wsPart.Worksheet.Descendants<Cell>(). Where(c => c.CellReference == myfan.LastCell).FirstOrDefault(); theCellular.CellValue = new CellValue("X"); theCellular.DataType = new EnumValue<CellValues>(CellValues.String); // Save wsPart.Worksheet.Save(); }
private void button1_Click(object sender, EventArgs e) { txtDNI.Text = ultimo.DNI; txtIngreso.Text = ultimo.Ingreso; txtNom.Text = ultimo.Nombre; txtRPC.Text = ultimo.CardNum; ultimo = new RPCFan(); this.Focus(); }
private void Ingreso_KeyPress(object sender, KeyPressEventArgs e) { try { if (e.KeyChar >= 48 && e.KeyChar <= 57) { cardPrimaryKey += e.KeyChar; if (cardPrimaryKey.Length == 10) { Clean(); txtInfo.Text = ""; RPCFan myfan = rpc.KeyPressLengthAlert(cardPrimaryKey, firstCell,entered); if (myfan == null) txtInfo.Text = "La tarjeta no tiene ingresos asignados!"; else if (myfan.ID == null) txtInfo.Text = "Esta tarjeta ya fue ingresada!"; else { this.ultimo = myfan; txtDNI.Text = myfan.DNI; txtIngreso.Text = myfan.Ingreso; txtNom.Text = myfan.Nombre; txtRPC.Text = myfan.CardNum; } cardPrimaryKey = ""; } } else if (e.KeyChar == (char)Keys.Enter) { e.Handled = true; } } catch (Exception) { } }