public async Task <IActionResult> Edit(long id, [Bind("Codigo,Descricao")] CFOP cFOPs)
{
if (id != cFOPs.Codigo)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(cFOPs);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CFOPExists(cFOPs.Codigo))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(cFOPs));
}
/// <summary>
/// Retorna o texto do registro do tipo 70 para uso do SIntegra.
/// </summary>
/// <returns>Uma string com os dados formatados para uso do SIntegra.</returns>
public override string ToString()
{
// Formata os dados para o retorno do método
string n01 = Tipo.ToString().PadLeft(2, '0');
string n02 = Cnpj.PadLeft(14, '0');
string n03 = InscEst.PadRight(14);
string n04 = FormatData(DataEmissao);
string n05 = UfEmit.PadRight(2);
string n06 = Modelo.ToString().PadLeft(2, '0');
string n07 = Serie;
string n08 = Subserie.ToString().PadLeft(2, '0');
string n09 = Numero.ToString().PadLeft(6, '0');
string n10 = CFOP.ToString().PadLeft(4, '0');
string n11 = ValorTotal.ToString("0##########.#0").Remove(11, 1);
string n12 = BcIcms.ToString("0###########.#0").Remove(12, 1);
string n13 = ValorIcms.ToString("0###########.#0").Remove(12, 1);
string n14 = Isenta.ToString("0###########.#0").Remove(12, 1);
string n15 = Outras.ToString("0###########.#0").Remove(12, 1);
string n16 = TipoFrete.ToString();
string n17 = Situacao == TipoSituacao.Normal ? "N" : "S";
// Retorna os dados formatados
return(n01 + n02 + n03 + n04 + n05 + n06 + n07 + n08 + n09 + n10 +
n11 + n12 + n13 + n14 + n15 + n16 + n17);
}
public async Task <ActionResult> Put(CFOP cfop)
{
_db.Entry(cfop).State = EntityState.Modified;
await _db.SaveChangesAsync();
return(NoContent());
}
/// <summary>
/// Retorna o texto do registro do tipo 54 para uso do SIntegra.
/// </summary>
/// <returns>Uma string com os dados formatados para uso do SIntegra.</returns>
public override string ToString()
{
// Formata os dados para o retorno do método
string n01 = Tipo.ToString();
string n02 = CNPJ.PadLeft(14, '0');
string n03 = Modelo.PadLeft(2, '0');
string n04 = Serie.ToString().PadRight(3);
string n05 = Numero.ToString().PadLeft(6, '0');
string n06 = CFOP.PadLeft(4, '0');
string n07 = CST.PadRight(3);
string n08 = NumeroItem.ToString().PadLeft(3, '0');
string n09 = !string.IsNullOrEmpty(CodigoProduto) && CodigoProduto.Length > 14 ?
CodigoProduto.Substring(0, 14) : !string.IsNullOrEmpty(CodigoProduto) ?
CodigoProduto.PadRight(14) : "".PadRight(14);
string n10 = Quantidade.ToString("0#######.##0").Remove(8, 1);
string n11 = ValorProduto.ToString("0#########.#0").Remove(10, 1);
string n12 = ValorDesconto.ToString("0#########.#0").Remove(10, 1);
string n13 = BaseCalcICMS.ToString("0#########.#0").Remove(10, 1);
string n14 = BaseCalcICMSST.ToString("0#########.#0").Remove(10, 1);
string n15 = ValorIPI.ToString("0#########.#0").Remove(10, 1);
string n16 = AliquotaICMS.ToString("0#.#0").Remove(2, 1);
// Retorna os dados formatados
return(n01 + n02 + n03 + n04 + n05 + n06 + n07 + n08 + n09 + n10 +
n11 + n12 + n13 + n14 + n15 + n16);
}
private void RestoreClick()
{
if (cfop == CFOP.None)
{
cfop = CFOP.Cross;
}
}
public async Task <ActionResult> Post(CFOP cfop)
{
_db.Add(cfop);
await _db.SaveChangesAsync();
return(new CreatedAtRouteResult(nameof(GetByCFOP), new { cfop.Codigo }, cfop));
}
public string gerarLinhaTexto()
{
string retorno = "";
retorno += Funcoes.Formatar(tipo.ToString(), 2, true, '0');
retorno += Funcoes.Formatar(cnpj, 14, false, '0');
retorno += Funcoes.Formatar(inscricaoEstadual, 14, true, ' ');
retorno += Funcoes.Formatar(dataEmissao.ToString("yyyyMMdd"), 8, true, '0');
retorno += Funcoes.Formatar(UnidadeFederacao.ToString(), 2, true, '0');
retorno += Funcoes.Formatar(Modelo.ToString(), 2, true, '0');
retorno += Funcoes.Formatar(Serie.ToString(), 1, true, '0');
retorno += Funcoes.Formatar(Subserie.ToString(), 2, true, '0');
retorno += Funcoes.Formatar(Numero.ToString(), 6, true, '0');
retorno += Funcoes.Formatar(CFOP.ToString(), 4, true, '0');
retorno += Funcoes.Formatar(valorTotal.ToString("n2"), 13, false, '0');
retorno += Funcoes.Formatar(BaseCalculo.ToString("n2"), 14, false, '0');
retorno += Funcoes.Formatar(ValorICMS.ToString("n2"), 14, false, '0');
retorno += Funcoes.Formatar(Isenta_nao_tributada.ToString("n2"), 14, false, '0');
retorno += Funcoes.Formatar(Outras.ToString("n2"), 14, false, '0');
retorno += Funcoes.Formatar(Modalidade.ToString(), 1, true, '0');
retorno += Funcoes.Formatar(Situacao.ToString(), 1, true, '0');
return(retorno);
}
private void Complete()
{
cfop = CFOP.None;
isBusy = false;
thirdPosFinish = true;
thirdCornerPosFinish = true;
ShowDialog();
}
public List<CFOP> Filtrar(CFOP CFOP)
{
return repositoryCFOP.ObterPorFiltros(b => (
(CFOP.ID == Guid.Empty || b.ID == CFOP.ID) &&
(CFOP.nome == null || b.nome.ToUpper().Contains(CFOP.nome)) &&
(CFOP.codigo == null || b.codigo.ToUpper().Contains(CFOP.codigo))
)).ToList();
}
public async Task <IActionResult> Create([Bind("Codigo,Descricao")] CFOP cFOPs)
{
if (ModelState.IsValid)
{
_context.Add(cFOPs);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(cFOPs));
}
public async Task <IActionResult> Create([Bind("Id_produto,Nome,Valor_unitario,Unidade_medida,Descricao,Estoque_minimo,Estoque_maximo,Estoque_atual,Peso_bruto, Peso_liquido,Fornecedor_Cnpj, Fornecedor, CST_Codigo, CST, CFOP_Codigo, CFOP, NCM_Codigo, NCM")] Produto produto)
{
if (ModelState.IsValid)
{
Fornecedor fornecedor = new Fornecedor();
fornecedor.Cnpj = produto.Fornecedor_Cnpj;
CST cst = new CST();
cst.Codigo = produto.CST_Codigo;
CFOP cfop = new CFOP();
cfop.Codigo = produto.CFOP_Codigo;
NCM ncm = new NCM();
ncm.Codigo = produto.NCM_Codigo;
string lastestFornecedorId = fornecedor.Cnpj;
produto.Fornecedor_Cnpj = lastestFornecedorId;
string lastestCSTId = cst.Codigo;
produto.CST_Codigo = lastestCSTId;
long lastestCFOPId = cfop.Codigo;
produto.CFOP_Codigo = lastestCFOPId;
long lastestNCMId = ncm.Codigo;
produto.NCM_Codigo = lastestNCMId;
DateTime localDate = DateTime.Now;
Historico historico = new Historico();
historico.Data_inicio = localDate;
historico.Produto = produto;
historico.Produto_Id_produto = produto.Id_produto;
historico.Valor = produto.Valor_unitario;
_context.Add(produto);
_context.Historico.Add(historico);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["Fornecedor_Cnpj"] = new SelectList(_context.Fornecedor, "Cnpj", "NomeEmpresa", produto.Fornecedor_Cnpj);
ViewData["CFOP_Codigo"] = new SelectList(_context.CFOP, "Codigo", "FullName");
ViewData["NCM_Codigo"] = new SelectList(_context.NCM, "Codigo", "FullName");
ViewData["CST_Codigo"] = new SelectList(_context.CST, "Codigo", "FullName");
return(View(produto));
}
public CFOP getCFOP_ID(int id)
{
try
{
SQL = string.Format("SELECT id, nome FROM fiscal_cfop WHERE id = {0} ", id);
ds = con.ConsultaSQL(SQL);
CFOP obj = null;
foreach (DataRow dr in ds.Tables[0].Rows)
{
obj = new CFOP();
obj.Id = int.Parse(dr["id"].ToString());
obj.nome = dr["nome"].ToString();
}
return(obj);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private void Init()
{
steps = 0;
isKeyDown = false;
doRotate = false;
doAutoRotate = false;
isBusy = false;
curAngle = 0f;
success = false;
direction = 1;
colorIndex = 0; //0-红；1-绿；2-橙；3-蓝
cfop = CFOP.None;
thirdCrossFinish = false;
thirdCornerFinish = false;
thirdColorFinish = false;
thirdPosFinish = false;
thirdCrossPosFinish = false;
thirdCornerPosFinish = false;
simulateFinish = false;
orderList.Clear();
}
public List <CFOP> selectCFOP()
{
try
{
SQL = "SELECT * FROM fical_cfop ORDER BY id";
ds = con.ConsultaSQL(SQL);
List <CFOP> ls = new List <CFOP>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
CFOP cfop = new CFOP();
cfop.Id = int.Parse(dr["id"].ToString());
cfop.nome = dr["nome"].ToString();
ls.Add(cfop);
}
return(ls);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
/// <summary>
/// Retorna o texto do registro do tipo 51 para uso do SIntegra.
/// </summary>
/// <returns>Uma string com os dados formatados para uso do SIntegra.</returns>
public override string ToString()
{
// Formata os dados para o retorno do método
string n01 = Tipo.ToString().PadLeft(2, '0');
string n02 = CNPJ.PadLeft(14, '0');
string n03 = InscEstadual.PadRight(14);
string n04 = FormatData(DataEmissaoRecebimento);
string n05 = UF.PadRight(2);
string n06 = Serie.ToString().PadRight(3);
string n07 = Numero.ToString().PadLeft(6, '0');
string n08 = CFOP.PadLeft(4, '0');
string n09 = ValorTotal.ToString("0##########.#0").Remove(11, 1);
string n10 = ValorIPI.ToString("0##########.#0").Remove(11, 1);
string n11 = ValorIsentoIPI.ToString("0##########.#0").Remove(11, 1);
string n12 = ValorNaoIPI.ToString("0##########.#0").Remove(11, 1);
string n13 = "".PadRight(20);
string n14 = Situacao == TipoSituacao.Normal ? "N" : "S";
// Retorna os dados formatados
return(n01 + n02 + n03 + n04 + n05 + n06 + n07 + n08 + n09 + n10 +
n11 + n12 + n13 + n14);
}
/// <summary>
/// Retorna o texto do registro do tipo 53 para uso do SIntegra.
/// </summary>
/// <returns>Uma string com os dados formatados para uso do SIntegra.</returns>
public override string ToString()
{
// Formata os dados para o retorno do método
string n01 = Tipo.ToString();
string n02 = CNPJ.PadLeft(14, '0');
string n03 = InscEstadual.PadRight(14);
string n04 = FormatData(DataEmissaoRecebimento);
string n05 = UF.PadRight(2);
string n06 = Modelo.PadLeft(2, '0');
string n07 = Serie.ToString().PadRight(3);
string n08 = Numero.ToString().PadLeft(6, '0');
string n09 = CFOP.PadLeft(4, '0');
string n10 = Emitente == TipoEmitente.Proprio ? "P" : "T";
string n11 = BaseCalcICMSST.ToString("0##########.#0").Remove(11, 1);
string n12 = ICMSRetido.ToString("0##########.#0").Remove(11, 1);
string n13 = DespesasAcessorias.ToString("0##########.#0").Remove(11, 1);
string n14 = Situacao == TipoSituacao.Normal ? "N" : "S";
string n15 = (int)CodigoAntecipacao != 0 ? ((int)CodigoAntecipacao).ToString() : " ";
string n16 = "".PadLeft(29);
// Retorna os dados formatados
return(n01 + n02 + n03 + n04 + n05 + n06 + n07 + n08 + n09 + n10 +
n11 + n12 + n13 + n14 + n15 + n16);
}
//中层
private void SecondLayer()
{
isBusy = true;
if (colorIndex > 3)
{
colorIndex = 0;
cfop = CFOP.ThirdLayer;
isBusy = false;
return;
}
var curCube = secondLayerList[colorIndex];
for (var i = 0; i <= 26; i++)
{
var myCube = cubeArray[i].Cube;
var pos = cubeArray[i].Pos;
var curPos = ChangePos(myCube.transform.localPosition);
if (pos == curCube)
{
if (curPos == pos) //中右前
{
if (ChangeRotate(myCube.transform.localRotation) != new Vector3(0, 0, 0))
{
SecondLayerExp1();
orderList.Add(keyCodes[(int)RotateKey.U]);
orderList.Add(keyCodes[(int)RotateKey.U]);
SecondLayerExp1();
}
else
{
colorIndex++;
isBusy = false;
return;
}
}
else if (curPos == ChangeAngle(new Vector3(-1, 0, -1))) //中左前
{
orderList.Add(keyCodes[ChangeKey((int)RotateKey.F + colorIndex)]);
orderList.Add(keyCodes[(int)RotateKey.U2]);
orderList.Add(keyCodes[ChangeKey((int)RotateKey.F2 + colorIndex)]);
orderList.Add(keyCodes[(int)RotateKey.U2]);
orderList.Add(keyCodes[ChangeKey((int)RotateKey.L2 + colorIndex)]);
orderList.Add(keyCodes[(int)RotateKey.U]);
orderList.Add(keyCodes[ChangeKey((int)RotateKey.L + colorIndex)]);
SecondLayerExp2();
}
else if (curPos == ChangeAngle(new Vector3(-1, 0, 1))) //中左后
{
orderList.Add(keyCodes[ChangeKey((int)RotateKey.L + colorIndex)]);
orderList.Add(keyCodes[(int)RotateKey.U2]);
orderList.Add(keyCodes[ChangeKey((int)RotateKey.L2 + colorIndex)]);
orderList.Add(keyCodes[(int)RotateKey.U2]);
orderList.Add(keyCodes[ChangeKey((int)RotateKey.B2 + colorIndex)]);
orderList.Add(keyCodes[(int)RotateKey.U]);
orderList.Add(keyCodes[ChangeKey((int)RotateKey.B + colorIndex)]);
SecondLayerExp1();
}
else if (curPos == ChangeAngle(new Vector3(1, 0, 1))) //中右后
{
orderList.Add(keyCodes[ChangeKey((int)RotateKey.B + colorIndex)]);
orderList.Add(keyCodes[(int)RotateKey.U2]);
orderList.Add(keyCodes[ChangeKey((int)RotateKey.B2 + colorIndex)]);
orderList.Add(keyCodes[(int)RotateKey.U2]);
orderList.Add(keyCodes[ChangeKey((int)RotateKey.R2 + colorIndex)]);
orderList.Add(keyCodes[(int)RotateKey.U]);
orderList.Add(keyCodes[ChangeKey((int)RotateKey.R + colorIndex)]);
orderList.Add(keyCodes[(int)RotateKey.U]);
orderList.Add(keyCodes[(int)RotateKey.U]);
SecondLayerExp2();
}
else if (curPos == ChangeAngle(new Vector3(0, 1, -1))) //上前
{
SecondLayerExp1();
}
else if (curPos == ChangeAngle(new Vector3(1, 1, 0))) //上右
{
SecondLayerExp2();
}
else if (curPos == ChangeAngle(new Vector3(0, 1, 1))) //上后
{
orderList.Add(keyCodes[(int)RotateKey.U]);
SecondLayerExp2();
}
else if (curPos == ChangeAngle(new Vector3(-1, 1, 0))) //上左
{
orderList.Add(keyCodes[(int)RotateKey.U]);
orderList.Add(keyCodes[(int)RotateKey.U]);
SecondLayerExp2();
}
StartAutoRotate();
break;
}
}
}
//底层
private void FirstLayer()
{
isBusy = true;
if (colorIndex > 3)
{
colorIndex = 0;
cfop = CFOP.SecondLayer;
isBusy = false;
return;
}
var curCube = firstLayerCornerList[colorIndex];
for (var i = 0; i <= 26; i++)
{
var myCube = cubeArray[i].Cube;
var pos = cubeArray[i].Pos;
var curPos = ChangePos(myCube.transform.localPosition);
if (pos == curCube)
{
if (curPos == pos) //右下前
{
if (ChangeRotate(myCube.transform.localRotation) != new Vector3(0, 0, 0))
{
orderList.Add(keyCodes[ChangeKey((int)RotateKey.R + colorIndex)]);
orderList.Add(keyCodes[(int)RotateKey.U2]);
orderList.Add(keyCodes[ChangeKey((int)RotateKey.R2 + colorIndex)]);
orderList.Add(keyCodes[(int)RotateKey.U]);
orderList.Add(keyCodes[ChangeKey((int)RotateKey.R + colorIndex)]);
orderList.Add(keyCodes[(int)RotateKey.U2]);
orderList.Add(keyCodes[ChangeKey((int)RotateKey.R2 + colorIndex)]);
}
else
{
colorIndex++;
isBusy = false;
return;
}
}
else if (curPos == ChangeAngle(new Vector3(-1, -1, -1))) //左前下
{
orderList.Add(keyCodes[ChangeKey((int)RotateKey.F + colorIndex)]);
orderList.Add(keyCodes[(int)RotateKey.U]);
orderList.Add(keyCodes[ChangeKey((int)RotateKey.F2 + colorIndex)]);
orderList.Add(keyCodes[(int)RotateKey.U]);
orderList.Add(keyCodes[(int)RotateKey.U]);
orderList.Add(keyCodes[ChangeKey((int)RotateKey.R + colorIndex)]);
orderList.Add(keyCodes[(int)RotateKey.U]);
orderList.Add(keyCodes[ChangeKey((int)RotateKey.R2 + colorIndex)]);
}
else if (curPos == ChangeAngle(new Vector3(-1, -1, 1))) //左后下
{
orderList.Add(keyCodes[ChangeKey((int)RotateKey.B2 + colorIndex)]);
orderList.Add(keyCodes[(int)RotateKey.U]);
orderList.Add(keyCodes[(int)RotateKey.U]);
orderList.Add(keyCodes[ChangeKey((int)RotateKey.B + colorIndex)]);
orderList.Add(keyCodes[ChangeKey((int)RotateKey.R + colorIndex)]);
orderList.Add(keyCodes[(int)RotateKey.U]);
orderList.Add(keyCodes[ChangeKey((int)RotateKey.R2 + colorIndex)]);
}
else if (curPos == ChangeAngle(new Vector3(1, -1, 1))) //右后下
{
orderList.Add(keyCodes[ChangeKey((int)RotateKey.B + colorIndex)]);
orderList.Add(keyCodes[(int)RotateKey.U]);
orderList.Add(keyCodes[ChangeKey((int)RotateKey.B2 + colorIndex)]);
orderList.Add(keyCodes[ChangeKey((int)RotateKey.R + colorIndex)]);
orderList.Add(keyCodes[(int)RotateKey.U]);
orderList.Add(keyCodes[ChangeKey((int)RotateKey.R2 + colorIndex)]);
}
else if (curPos == ChangeAngle(new Vector3(-1, 1, -1))) //左上前
{
orderList.Add(keyCodes[ChangeKey((int)RotateKey.R + colorIndex)]);
orderList.Add(keyCodes[(int)RotateKey.U2]);
orderList.Add(keyCodes[ChangeKey((int)RotateKey.R2 + colorIndex)]);
}
else if (curPos == ChangeAngle(new Vector3(-1, 1, 1))) //左上后
{
orderList.Add(keyCodes[ChangeKey((int)RotateKey.R + colorIndex)]);
orderList.Add(keyCodes[(int)RotateKey.U]);
orderList.Add(keyCodes[(int)RotateKey.U]);
orderList.Add(keyCodes[ChangeKey((int)RotateKey.R2 + colorIndex)]);
}
else if (curPos == ChangeAngle(new Vector3(1, 1, 1))) //右上后
{
orderList.Add(keyCodes[(int)RotateKey.U]);
orderList.Add(keyCodes[ChangeKey((int)RotateKey.R + colorIndex)]);
orderList.Add(keyCodes[(int)RotateKey.U2]);
orderList.Add(keyCodes[ChangeKey((int)RotateKey.R2 + colorIndex)]);
}
else if (curPos == ChangeAngle(new Vector3(1, 1, -1))) //右上前
{
orderList.Add(keyCodes[ChangeKey((int)RotateKey.R + colorIndex)]);
orderList.Add(keyCodes[(int)RotateKey.U]);
orderList.Add(keyCodes[ChangeKey((int)RotateKey.R2 + colorIndex)]);
}
StartAutoRotate();
break;
}
}
}
public Result Salvar(CFOP CFOP)
{
Result retorno = new Result();
try
{
if (CFOP.ID == Guid.Empty)
{
CFOP.ID = Guid.NewGuid();
repositoryCFOP.Adicionar(CFOP);
}
else
{
repositoryCFOP.Alterar(CFOP);
}
context.SaveChanges();
retorno.Ok("Cadastro realizado com sucesso.");
}
catch (Exception erro)
{
retorno.Erro(erro.Message);
}
return retorno;
}
