public System.Data.DataTable getStatusDevedor()
{
// [Tmk].[pro_setStatusDevedores] ( @tabelaStatusDevedores as Tmk.ttb_statusDevedores readonly )
string nomeFuncao = "TMK.getStatusDevedor";
try
{
tmkService.TmkServicosSoapClient servTMK = new tmkService.TmkServicosSoapClient();
tmkService.CarSystemStatusDevedor[] tabTMK;
System.Data.DataTable dtCarsystem = new System.Data.DataTable("tbl_CarSystem");
System.Data.DataRow drLinhaCarsystem;
dtCarsystem.Columns.Add("codigoCliente", typeof(int));
dtCarsystem.Columns.Add("codigoDevedor", typeof(int));
dtCarsystem.Columns.Add("Contrato", typeof(string));
dtCarsystem.Columns.Add("dataAcordo", typeof(DateTime));
dtCarsystem.Columns.Add("dataGera", typeof(DateTime));
dtCarsystem.Columns.Add("formaPagamento", typeof(string));
dtCarsystem.Columns.Add("observacao", typeof(string));
dtCarsystem.Columns.Add("statusAcordo", typeof(string));
dtCarsystem.Columns.Add("valotTotalAcordo", typeof(double));
dtCarsystem.Columns.Add("vencimentoAcordo", typeof(DateTime));
tabTMK = servTMK.GetCarSystem_StatusDevedor("tmk", "EB43CC31-609D-11D3-A9DC-0080C7AB1CA7", 1);
foreach (tmkService.CarSystemStatusDevedor Cliente in tabTMK)
{
drLinhaCarsystem = dtCarsystem.NewRow();
drLinhaCarsystem["codigoCliente"] = Cliente.CodCliente; //int
drLinhaCarsystem["codigoDevedor"] = Cliente.CodDevedor; //int
drLinhaCarsystem["Contrato"] = Cliente.Contrato; // string
drLinhaCarsystem["dataAcordo"] = Cliente.DtAcordo; //DateTime
drLinhaCarsystem["dataGera"] = Cliente.DtGera; //DateTime
drLinhaCarsystem["formaPagamento"] = Cliente.Forma; //string
drLinhaCarsystem["observacao"] = Cliente.Obs; //string
drLinhaCarsystem["statusAcordo"] = Cliente.Status; //string
drLinhaCarsystem["valotTotalAcordo"] = Cliente.ValTotalAcordo;; //double
drLinhaCarsystem["vencimentoAcordo"] = Cliente.VencAcordo; //DateTime
dtCarsystem.Rows.Add(drLinhaCarsystem);
}
return(dtCarsystem);
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show("(" + nomeFuncao + ")" + ex.Message);
}
return(null);
}
public System.Data.DataTable getBaixas()
{
string nomeFuncao = "TMK.getBaixas";
try
{
tmkService.TmkServicosSoapClient servTMK = new tmkService.TmkServicosSoapClient();
tmkService.CarSystemPC[] tabTMK;
System.Data.DataTable dtCarsystem = new System.Data.DataTable("tbl_CarSystem");
System.Data.DataRow drLinhaCarsystem;
dtCarsystem.Columns.Add("codigoEmpresa", typeof(int));
dtCarsystem.Columns.Add("Idparcela", typeof(int));
dtCarsystem.Columns.Add("tp_forma", typeof(int));
dtCarsystem.Columns.Add("Valor", typeof(double));
dtCarsystem.Columns.Add("Juros", typeof(double));
dtCarsystem.Columns.Add("Desconto", typeof(double));
dtCarsystem.Columns.Add("ValorPago", typeof(double));
tabTMK = servTMK.GetCarSystemPC("tmk", "EB43CC31-609D-11D3-A9DC-0080C7AB1CA7");
foreach (tmkService.CarSystemPC parcelaCliente in tabTMK)
{
drLinhaCarsystem = dtCarsystem.NewRow();
drLinhaCarsystem["codigoEmpresa"] = parcelaCliente.CdEmpresa;
drLinhaCarsystem["Idparcela"] = parcelaCliente.IdParcela;
drLinhaCarsystem["tp_forma"] = parcelaCliente.TpForma;
drLinhaCarsystem["Valor"] = parcelaCliente.Valor;
drLinhaCarsystem["Juros"] = parcelaCliente.ValorJuros;
drLinhaCarsystem["Desconto"] = parcelaCliente.ValorDesconto;
drLinhaCarsystem["ValorPago"] = parcelaCliente.TotalPago;
dtCarsystem.Rows.Add(drLinhaCarsystem);
}
return(dtCarsystem);
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show("(" + nomeFuncao + ")" + ex.Message);
}
return(null);
}
public bool setCargaOK()
{
string nomeFuncao = "TMK.setCargaOK";
try
{
tmkService.TmkServicosSoapClient servTMK = new tmkService.TmkServicosSoapClient();
servTMK.SetReadCarSystemPC("tmk", "EB43CC31-609D-11D3-A9DC-0080C7AB1CA7");
return(true);
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show("(" + nomeFuncao + ")" + ex.Message);
}
return(false);
}