public bool IncluirCliente() { ClasseBanco csBanco = new ClasseBanco(); string iCodigoCliente = this.ProximoCodigoCliente(csBanco); string sCampos = "CodCli, Ativo, Cliente, Fornecedor, Prospect, RazSoc, NomFan, CGC_CPF, RgCli, EndCli, Numero, Bairro, CidCli, Complemento," + "Cep, Celular, Contato, DatCad, Email, EstCli, FaxCli, RamCli, TelCli, TipoCli, OBS1 "; string dtDataCadastro = DateTime.Today.Year + "/" + String.Format("{0:00}", DateTime.Today.Month) + "/" + String.Format("{0:00}", DateTime.Today.Day); string sValores = iCodigoCliente + "," + "'" + this.Ativo + "','" + this.bCliente + "','" + this.Fornecedor + "','" + this.Prospect + "','" + this.RazSoc + "','" + this.NomFan + "','" + this.CGC_CPF + "','" + this.RgCli + "','" + this.EndCli + "','" + this.Numero + "','" + this.Bairro + "','" + this.CidCli + "','" + this.Complemento + "','" + this.Cep + "','" + this.Celular + "','" + this.Contato + "','" + dtDataCadastro + "','" + this.Email + "','" + this.EstCli + "','" + this.FaxCli + "','" + this.RamCli + "','" + this.TelCli + "','" + this.TipoCli + "','" + this.Obs1 + "'"; sValores = Funcoes.RetiraCaracteres(sValores); //Insere na VENDCLI int iVendedor = Convert.ToInt32(Session["CodVend"]); int iEmpresa = Convert.ToInt32(Session["EmpresaCODEMP"]); int iSequencia = 1; csBanco.FU_Insert("VENDCLI", "CodEmp, CodCli, CodVen, TelVend_VendCli, Vend_VendCli, DataAdm", "" + iEmpresa + "," + iCodigoCliente + "," + iVendedor + ", 'N', 'S', CONVERT (datetime, GETDATE())"); //GRAVAR CLI_OBS com as Referencias var r = csBanco.Query("SELECT ISNULL(MAX(CODSEQ),0) + 1 FROM CLI_OBS WHERE CODCLI = " + iCodigoCliente); if (r.Read()) { iSequencia = Convert.ToInt16(r[0].ToString()); } r.Close(); if (this._RefBancaria != "") { csBanco.FU_Insert("CLI_OBS", "CodSeq, CodCli, Obs", "" + iSequencia + "," + iCodigoCliente + ",'Ref. Bancaria : " + this._RefBancaria + "'"); iSequencia = iSequencia + 1; } if (this._RefBancaria2 != "") { csBanco.FU_Insert("CLI_OBS", "CodSeq, CodCli, Obs", "" + iSequencia + "," + iCodigoCliente + ",'Ref. Bancaria II : " + this._RefBancaria2 + "'"); iSequencia = iSequencia + 1; } if (this._RefBancaria3 != "") { csBanco.FU_Insert("CLI_OBS", "CodSeq, CodCli, Obs", "" + iSequencia + "," + iCodigoCliente + ",'Ref. Bancaria III : " + this._RefBancaria3 + "'"); iSequencia = iSequencia + 1; } if (this._RefComercial != "") { csBanco.FU_Insert("CLI_OBS", "CodSeq, CodCli, Obs", "" + iSequencia + "," + iCodigoCliente + ",'Ref. Comercial : " + this._RefComercial + "'"); iSequencia = iSequencia + 1; } if (this._RefComercial2 != "") { csBanco.FU_Insert("CLI_OBS", "CodSeq, CodCli, Obs", "" + iSequencia + "," + iCodigoCliente + ",'Ref. Comercial II: " + this._RefComercial2 + "'"); iSequencia = iSequencia + 1; } if (this._RefComercial3 != "") { csBanco.FU_Insert("CLI_OBS", "CodSeq, CodCli, Obs", "" + iSequencia + "," + iCodigoCliente + ",'Ref. Comercial III : " + this._RefComercial3 + "'"); iSequencia = iSequencia + 1; } if (this._RefContador != "") { csBanco.FU_Insert("CLI_OBS", "CodSeq, CodCli, Obs", "" + iSequencia + "," + iCodigoCliente + ",'Ref. Contador : " + this._RefContador + "'"); iSequencia = iSequencia + 1; } if (this._RefContador2 != "") { csBanco.FU_Insert("CLI_OBS", "CodSeq, CodCli, Obs", "" + iSequencia + "," + iCodigoCliente + ",'Ref. Contador II : " + this._RefContador2 + "'"); iSequencia = iSequencia + 1; } if (this._RefContador3 != "") { csBanco.FU_Insert("CLI_OBS", "CodSeq, CodCli, Obs", "" + iSequencia + "," + iCodigoCliente + ",'Ref. Contador III : " + this._RefContador3 + "'"); iSequencia = iSequencia + 1; } //Insere cliente if (csBanco.FU_Insert("CLIENTE", sCampos, sValores) == 1) { return true; } else { return false; } }