private void BindProcessForm()
{
if (!IsBeginTask)
{
ProcessForm processForm = _formService.GetByInstanceId(IncidentId);
FaArchiveTranfer entity = _faProcessService.GetFaArchiveTranferByFormId(processForm.Id);
ShenQingrenName.Text = entity.ShenQingRenName;
ShenQingrenAccount.Value = entity.ShenQingrenAccount;
ShenQingrenDeptName.Text = entity.ShenQingRenBumenName;
ShenQingrenId.Value = entity.ShenQingRenId.ToString();
ShenQingrenDeptId.Value = entity.ShenQingRenBumenId.ToString();
ShenQingRiqi.Text = FormatHelper.GetIsoDateString(entity.ShenQingRiqi);
JieyueYuanyin.InnerText = entity.JieyueYuanyin;
List <FaProcess> faProcesses = _faProcessService.GetFaProcesslstByTranferId(entity.Id);
faArchiveInfoData.Value = _faReportInfoJsonService.GetArchiveInfosJson(faProcesses);
}
else
{
ShenQingrenName.Text = EDoc2Helper.GetCurrentUserRealName();
ShenQingrenAccount.Value = EDoc2Helper.GetCurrentUserAccount();
ShenQingrenId.Value = EDoc2Helper.GetCurrentUserId().ToString();
ShenQingRiqi.Text = DateTime.Now.ToString("yyyy-MM-dd");
ShenQingrenDeptName.Text = EDoc2Helper.GetCurrentUserDeptName();
ShenQingrenDeptId.Value = EDoc2Helper.GetCurrentUserDeptId().ToString();
}
List <long> archiveIds = _faProcessService.GetAllJieyueArchiveIds();
jieyueIds.Value = _faReportInfoJsonService.GetGetAllJieyueArchiveIdsJson(archiveIds);
FaReportDetailsControl.JieyueIds = jieyueIds.Value;
}
public void SearchBttn2_Click(object sender, EventArgs e)
{
ProcessForm form3 = new ProcessForm();
form3.DataSent += Form3_DataSent;
form3.ShowDialog(this);
}
// Calling this form from where these checked states will be processed...
// Let's suppose we have to click a button to launch the process, for instance...
private void btnLaunchProcess(object sender, EventArgs e) {
ProcessForm f = new ProcessForm();
f.Parent = this;
if (DialogResult.OK == f.ShowDialog()) {
// Process accordingly if desired, otherwise let it blank...
}
}
protected void StartProcessButton_Click(object sender, EventArgs e)
{
try
{
string incidentId = IncidentId;
FaArchiveTranfer faArchiveTranfer = Master.GetFaArchiveTranfer();
IList <FaProcess> faProcesses = Master.GetFaProcess();
ProcessForm processForm = ProcessFormService.GetNewProcessForm(ProcessId, incidentId);
processForm.FaArchiveTranfers.Add(faArchiveTranfer);
faArchiveTranfer.FaProcesses.AddRange(faProcesses);
ProcessFormService.Save(processForm);
Hashtable taskVariation = new Hashtable();
if (EDoc2Helper.IsUserInUserGroup(EDoc2Helper.GetCurrentUserId(), WebConfig.ManagerGroup))
{
taskVariation.Add("fenzhizouxiang", "是");
}
else
{
taskVariation.Add("fenzhizouxiang", "否");
}
StartFa(ProcessId, incidentId, taskVariation);
}
catch (Exception ex)
{
Edoc2LogHelper.WriteProcessSubmitExceptionLog(ex);
Dialog("出现异常,请联系管理员。");
}
}
/// <summary>
/// 进度条2
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button14_Click(object sender, EventArgs e)
{
this.backgroundWorker1.RunWorkerAsync(); // 运行 backgroundWorker 组件
ProcessForm form = new ProcessForm(this.backgroundWorker1); // 显示进度条窗体
form.ShowDialog(this);
form.Close();
}
private void Process_Initialize(ProcessForm processForm)
{
SaveConfigFormInfo();
processForm.EndProcessForm();
this.DialogResult = DialogResult.OK;
this.Close();
}
public ActionResult Save(ProcessForm formData)
{
if (SaveProcessForm(ref formData))
{
ProcessFormInitialize(ref formData);
ModelState.Clear();
}
return(View(ViewForm, formData));
}
private ProcessForm _processForm; //进度条窗体
public ProcessOperator()
{
_backgroundWorker = new BackgroundWorker();
_processForm = new ProcessForm();
_backgroundWorker.DoWork += new DoWorkEventHandler(_backgroundWorker_DoWork);
_backgroundWorker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(_backgroundWorker_RunWorkerCompleted);
}
public ActionResult New(int taskId, ProcessType processType = ProcessType.Process, int conditionId = 0)
{
var processForm = new ProcessForm();
processForm.TaskId = taskId;
processForm.ProcessType = processType;
processForm.ConditionId = conditionId;
ProcessFormInitialize(ref processForm);
return(View(ViewForm, processForm));
}
public ActionResult SaveClose(ProcessForm formData)
{
if (SaveProcessForm(ref formData))
{
return(RedirectToAction("Index", new { taskId = formData.TaskId }).WithMessage(this, string.Format("{0} Saved Successfully.", formData.Name), MessageType.Success));
}
else
{
//ProcessFormInitialize(ref formData);
return(View(ViewForm, formData));
}
}
private void LoadNewDocument()
{
if (this.FolderBrowserDialog.ShowDialog() != DialogResult.OK)
{
return;
}
else
{
m_strSelectedPath = this.FolderBrowserDialog.SelectedPath;
ProcessForm.StartProcessForm(Process_LoadNewDocument);
}
}
public static T ToProcess <T>(this ProcessForm formData) where T : Process
{
Process dto = Mapper.Map <ProcessForm, T>(formData);
//Belgeler şablon ve analiz olarak ikiye ayrılmıştı. Birleştirilecek.
if (formData.AnalysisFileList != null && formData.TemplateFileList != null)
{
dto.DocumentList = formData.AnalysisFileList.FileList.Concat(formData.TemplateFileList.FileList).ToList();
}
return((T)dto);
}
public ProcessForm ProcessFormLoad(ProcessForm formData)
{
var process = _unitOfWork.Repository <Process>().Get(x => x.Id == formData.Id, x => x.DocumentList);
if (process != null)
{
formData.TemplateFileList = new FileUpload(process.DocumentList, FileType.ProcessTemplateFile, process.Id);
formData.AnalysisFileList = new FileUpload(process.DocumentList, FileType.AnalysisFile, process.Id);
formData.ProcessUniqueCode = process.ProcessUniqueCode;
}
return(formData);
}
private void Process_Initialize(ProcessForm processForm)
{
if (GlobalSetting.LoadGlobalSetting() == true)
{
ReloadOptionFormInfo();
}
else
{
MainForm.ShowPopupMessage("读取配置文件失败！", "可能文件不存在或格式错误。。。");
}
processForm.EndProcessForm();
}
public void ProcessFormInitialize(ref ProcessForm formData)
{
if (formData.Id != 0)
{
Process process = _workFlowService.GetProcess(formData.Id);
Mapper.Map(process, formData);
}
var mainProcessList = _workFlowService.GetMainProcessList(formData.TaskId);
formData.MainProcessList = (mainProcessList != null ? new SelectList(mainProcessList, "Id", "Name") : null);
if (formData.ProcessType == ProcessType.DecisionPoint)
{
formData.DecisionMethodList = new SelectList(_workFlowService.GetDecisionMethodList(formData.TaskId), "Id", "MethodName");
formData.RepetitionHourList = new SelectList(Enumerable.Range(1, 24));
}
else if (formData.ProcessType == ProcessType.Process)
{
formData.FormViewList = new SelectList(_workFlowService.GetFormViewList(formData.TaskId), "Id", "FormName");
}
if (formData.ProcessType == ProcessType.OptionList || formData.ProcessType == ProcessType.Process || formData.ProcessType == ProcessType.SubProcess)
{
var monitoringList = formData.MonitoringRoleList;
formData.MonitoringRoleList = Global.GetAllRoles().Select(rol => new MonitoringRoleCheckbox
{
ProjectRole = rol,
IsChecked = monitoringList != null ? monitoringList.Where(x => x.IsChecked == true).Any(t => t.ProjectRole == rol) : false
}).ToList();
}
if (formData.ConditionId != null && formData.ConditionId != 0)
{
var condition = _unitOfWork.Repository <Condition>().Get((int)formData.ConditionId);
if (condition != null)
{
formData.ConditionName = condition.Name;
formData.AssignedRole = condition.AssignedRole;
}
}
else
{
if (formData.Id == 0)
{
formData.AssignedRole = (formData.ProcessType == ProcessType.DecisionPoint || formData.ProcessType == ProcessType.SubProcess ? ProjectRole.System : ProjectRole.Officer);
}
}
formData = ProcessFormLoad(formData);
}
private void MainForm_Load(object sender, EventArgs eventArgs)
{
this.Left = (Screen.PrimaryScreen.Bounds.Width - this.Width) / 2;
this.Top = (Screen.PrimaryScreen.Bounds.Height - this.Height) / 2;
this.m_AxCommandBars.ActiveMenuBar.Visible = false;
MSFL.MSFL1_Initialize("MSFL Main Form", "H.Q.Cai", MSFL.MSFL_DLL_INTERFACE_VERSION);
this.InitPopupControl();
this.InitPopupMessageControl();
ProcessForm.StartProcessForm(Process_Initialize);
}
public ProcessForm SaveEntity()
{
var faProcessService = new FaProcessService();
ProcessForm processForm = ProcessFormService.GetByInstanceId(IncidentId);
FaArchiveTranfer faArchiveTranferentitynewEntity = GetFaArchiveTranfer();
IList <FaProcess> newFaprocess = GetFaProcess();
FaArchiveTranfer faArchiveTranferentity = faProcessService.GetFaArchiveTranferByFormId(processForm.Id);
faArchiveTranferentity.JieyueYuanyin = faArchiveTranferentitynewEntity.JieyueYuanyin;
faArchiveTranferentity.FaProcesses.Clear();
faArchiveTranferentity.FaProcesses.AddRange(newFaprocess);
faProcessService.SaveFaArchiveTranfer(faArchiveTranferentity);
return(processForm);
}
private void LaunchButton_Click(object sender, EventArgs e)
{
string errorMessage = CollectSourceData(out var data);
if (String.IsNullOrEmpty(errorMessage))
{
ProcessForm processForm = new ProcessForm(data);
processForm.Show();
processForm.StartCalculation();
}
else
{
MessageBox.Show(errorMessage);
}
}
protected void AbortProcessButton_Click(object sender, EventArgs e)
{
try
{
ProcessForm processForm = ProcessFormService.GetByInstanceId(IncidentId);
FaArchiveTranfer faArchiveTranfer = FaProcessService.GetFaArchiveTranferByFormId(processForm.Id);
_faProcessService.UpdateLiuchengzhuangtai(faArchiveTranfer, LiuchengZhuangtaiEnum.YiChexiao);
AbortIncident();
}
catch (Exception ex)
{
Edoc2LogHelper.WriteProcessSubmitExceptionLog(ex);
Dialog("出现异常,请联系管理员。");
}
}
public ActionResult Edit(int processId)
{
if (processId == 0)
{
return(HttpNotFound());
}
ProcessForm formData = new ProcessForm()
{
Id = processId
};
ProcessFormInitialize(ref formData);
return(View(ViewForm, formData));
}
public void Save(ProcessForm entity)
{
try
{
entity.LastUpdated = DateTime.Now;
if (entity.Id == 0)
{
entity.CreateTime = DateTime.Now;
DataContext.ProcessForms.InsertOnSubmit(entity);
}
DataContext.SubmitChanges();
}
catch (Exception ex)
{
DataContext.Dispose();
throw new Exception(ex.Message);
}
}
public bool Run()
{
using (ProcessForm form = new ProcessForm())
{
form.Data = _data;
form.Control = GetView();
if (form.ShowDialog() == DialogResult.Cancel)
{
return(false);
}
ProcessSalaryDataObject processSalaryDataObject = _data as ProcessSalaryDataObject;
if (processSalaryDataObject != null)
{
processSalaryDataObject.FinalSalary = form.KostylFinalMoney;
}
return(true);
}
}
protected void SubmitProcessButton_Click(object sender, EventArgs e)
{
try
{
ProcessForm processForm = ProcessFormService.GetByInstanceId(IncidentId);
FaArchiveTranfer faArchiveTranfer = FaProcessService.GetFaArchiveTranferByFormId(processForm.Id);
IList <Jieyue> jieyues = Master.GetJieyues(faArchiveTranfer);
_faProcessService.UpdateLiuchengzhuangtai(faArchiveTranfer, LiuchengZhuangtaiEnum.YiShenpi);
_faProcessService.SaveJieyueInfo(jieyues);
string desc = descText.Value;
Submit(desc);
}
catch (Exception ex)
{
Edoc2LogHelper.WriteProcessSubmitExceptionLog(ex);
Dialog("出现异常,请联系管理员。");
}
}
public bool SaveProcessForm(ref ProcessForm formData)
{
if (formData.Id != 0)
{
formData = ProcessFormLoad(formData);
}
bool result = ValidationHelper.Validate(formData, new ProcessFormValidator(_unitOfWork), ModelState);
if (result == false)
{
ProcessFormInitialize(ref formData);
return(result);
}
_workFlowService.AddOrUpdate(formData);
return(result);
}
public static ProcessForm ToProcessForm(this Process process, IEnumerable <Process> mainProcessList, IEnumerable <DecisionMethod> decisionMethodList, IEnumerable <FormView> formViewList)
{
var roleList = ProjectRole.Admin.GetAllValues().Where(x => x != ProjectRole.Sistem).ToList();
ProcessForm dto = Mapper.Map <Process, ProcessForm>(process);
foreach (var rol in roleList)
{
if (!dto.MonitoringRoleList.Any(x => x.ProjectRole == rol))
{
dto.MonitoringRoleList.Add(new MonitoringRoleCheckbox {
IsChecked = false, ProjectRole = rol
});
}
}
if (process.GetType() == typeof(ConditionOption))
{
dto.ProcessType = ProcessType.OptionList;
}
else if (process.GetType() == typeof(DecisionPoint))
{
dto.ProcessType = ProcessType.DecisionPoint;
dto.DecisionMethodList = new SelectList(decisionMethodList, "Id", "MethodName");
dto.RepetitionHourList = new SelectList(Enumerable.Range(1, 24));
}
else if (process.GetType() == typeof(Condition))
{
dto.ProcessType = ProcessType.Condition;
}
else
{
dto.ProcessType = ProcessType.Process;
dto.FormViewList = new SelectList(formViewList, "Id", "FormName");
}
dto.MainProcessList = (mainProcessList != null ? new SelectList(mainProcessList, "Id", "Name") : null);
dto.TemplateFileList = new FileUpload(process.DocumentList, FileType.ProcessTemplateFile, process.Id);
dto.AnalysisFileList = new FileUpload(process.DocumentList, FileType.AnalysisFile, process.Id);
return(dto);
}
protected void StartProcessButton_Click(object sender, EventArgs e)
{
try
{
string incidentId = IncidentId;
FaArchiveTranfer faArchiveTranfer = Master.GetFaArchiveTranfer();
IList <FaProcess> faProcesses = Master.GetFaProcess();
ProcessForm processForm = ProcessFormService.GetNewProcessForm(ProcessId, incidentId);
processForm.FaArchiveTranfers.Add(faArchiveTranfer);
faArchiveTranfer.FaProcesses.AddRange(faProcesses);
ProcessFormService.Save(processForm);
StartFa(ProcessId, incidentId, null);
}
catch (Exception ex)
{
Edoc2LogHelper.WriteProcessSubmitExceptionLog(ex);
Dialog("出现异常,请联系管理员。");
}
}
private void SettingControl_SetConfigFile()
{
if (GlobalSetting.IsLoadGlobalSetting == false)
{
MainForm.ShowPopupMessage("正在初始化数据", "请稍等片刻。。。");
ProcessForm.StartProcessForm(Process_InitializeLoad);
}
if (m_ConfigForm.ShowDialog() == DialogResult.OK)
{
if (GlobalSetting.LoadGlobalSetting() == false)
{
MainForm.ShowPopupMessage("读取配置文件失败！", "可能文件不存在或格式错误。。。");
return;
}
ProcessForm.StartProcessForm(Process_Initialize);
}
}
public void AddOrUpdate(ProcessForm formData)
{
int processId = 0;
if (formData.ProcessType == ProcessType.Process)
{
var process = Mapper.Map <ProcessForm, Process>(formData);
processId = AddOrUpdate(process);
}
else if (formData.ProcessType == ProcessType.Condition)
{
var process = Mapper.Map <ProcessForm, Condition>(formData);
processId = AddOrUpdate(process);
}
else if (formData.ProcessType == ProcessType.OptionList)
{
var process = Mapper.Map <ProcessForm, ConditionOption>(formData);
processId = AddOrUpdate(process);
}
else if (formData.ProcessType == ProcessType.DecisionPoint)
{
var process = Mapper.Map <ProcessForm, DecisionPoint>(formData);
processId = AddOrUpdate(process);
}
else if (formData.ProcessType == ProcessType.SubProcess)
{
var process = Mapper.Map <ProcessForm, SubProcess>(formData);
processId = AddOrUpdate(process);
}
if (formData.Id == 0 && processId != 0)
{
formData.Id = processId;
if (formData.ProcessType == ProcessType.Process || formData.ProcessType == ProcessType.Condition)
{
SetStartingProcess(formData.TaskId);
}
}
SetWorkFlowDiagram(formData.TaskId);
}
private void btnUploadData_Click(object sender, EventArgs e)
{
if (_worker.IsBusy)
{
return;
}
if (PersonInfoList.Count == 0)
{
return;
}
if (MessageBox.Show("真的要上传吗？", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
ProcessFormObj = new ProcessForm();
ProcessFormObj.Show();
ProcessFormObj.BringToFront();
btnUploadData.Enabled = false;
_worker.RunWorkerAsync();
}
}
private void Process_Initialize(ProcessForm processForm)
{
GlobalSetting.LoadGlobalRegistry();
if (GlobalSetting.IsAutoLoadConfigSetting == true)
{
if (GlobalSetting.LoadGlobalSetting() == false)
{
MainForm.ShowPopupMessage("读取配置文件失败！", "可能文件不存在或格式错误。。。", "请点击<主选项>的<设置配置文件>");
}
}
this.m_OptionForm.Initialize();
this.m_U50Form.Initialize();
this.m_D50Form.Initialize();
this.m_NotifyIcon.Visible = true;
if (GlobalSetting.IsPopStartupInfo == true)
{
this.m_NotifyIcon.ShowBalloonTip(1000);
}
processForm.EndProcessForm();
}
public void IntegraFaturamento()
{
ProcessForm processForm = new ProcessForm("", layout);
processForm.Show();
List<Faturamento> lFaturamento = new List<Faturamento>();
IEnumerable<String> streamRead = File.ReadLines(System.Environment.CurrentDirectory.ToString() + "\\config.txt");
var connection = streamRead.First();
using (OleDbConnection con = new OleDbConnection(connection))
{
try
{
con.Open();
using (OleDbCommand commandCount = new OleDbCommand("SELECT COUNT(*) FROM FATURAMENTO ", con))
using (OleDbDataReader readerCount = commandCount.ExecuteReader())
{
while (readerCount.Read())
{
countRegister = readerCount.GetValue(0).ToString();
}
}
try
{
using (OleDbCommand command = new OleDbCommand("SELECT SKU_PRODUTO,ID_CLIENTE,ID_DISTRIBUIDOR,ID_FV,ID_FORMA_PAGAMENTO,ID_END_ENTREGA,ID_END_COBRANCA,QTD_ITEM_NF_FATURA,VALOR_UNITARIO_ITEM_NF_FATURA,VALOR_TOTAL_NF_FATURA,VALOR_BRUTO_ITEM_NF_FATURA,VALOR_DESCONTO_ITEM_NF_FATURA,VALOR_TOTAL_ITEM_NF_FATURA,VALOR_LIQUIDO_ITEM_NF_FATURA,VALOR_CUSTO_ITEM_NF_FATURA,QTD_LITROS_ITEM_NF_FATURA,NUM_NF_FATURA,SERIE_NF_FATURA,ITEM_NF_FATURA,CFOP_NF_FATURA,NATUREZA_OPERACAO_NF_FATURA,OBSERVACAO_NF_FATURA,DATA_NF_FATURA,FLAG_ITEM_CANCELADO,DATA_CANCELAMENTO,QUANTIDADE_CANCELADO,VALOR_FRETE_NF,VALOR_IPI_ITEM,VALOR_PIS_ITEM,VALOR_COFINS_ITEM,VALOR_ICMS_ITEM,VALOR_ICMS_ST_ITEM,VALOR_SEGURO_ITEM,VALOR_DESPESAS_EXTRA_ITEM,FLAG_FATURAMENTO_TP_ENTREGA FROM FATURAMENTO", con))
using (OleDbDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Faturamento faturamento = new Faturamento();
Validator valid = new Validator();
for(int i = reader.FieldCount-1; i>=0; i--){
if (!(i == 34 || i == 33 || i == 32 || i == 25 || i == 24 || i == 21))
{
if (reader.IsDBNull(i))
{
MessageBox.Show(i.ToString(), "Advetisament", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
}
faturamento.produtoId = reader.GetValue(0).ToString();
faturamento.clienteId = reader.GetString(1);
faturamento.distribuidorId = reader.GetString(2);
faturamento.forcaDeVendaId = reader.GetString(3);
faturamento.formaDePagamentoId = reader.GetString(4);
faturamento.enderecoEntregaId = reader.GetString(5);
faturamento.enderecoCobrancaId = reader.GetString(6);
faturamento.quantidadeItem = reader.GetString(7);
faturamento.valorUnitarioItem = reader.GetString(8);
faturamento.valorTotalFatura = reader.GetString(9);
faturamento.valorBrutoItem = reader.GetString(10);
faturamento.valorDescontoItem = reader.GetString(11);
faturamento.valorTotalItem = reader.GetString(12);
faturamento.valorLiquidoItem = reader.GetString(13);
faturamento.valorCustoItem = reader.GetString(14);
faturamento.quantidadeLitrosItem = reader.GetString(15);
faturamento.numeroFatura = reader.GetString(16);
faturamento.serieFatura = reader.GetString(17);
faturamento.itemFatura = reader.GetString(18);
faturamento.CFOP = reader.GetString(19);
faturamento.naturezaOpercao = reader.GetString(20);
if(reader.IsDBNull(21))
{
faturamento.observacaoFatura = valid.ValidaString();
}else{
faturamento.observacaoFatura = reader.GetString(21);
}
faturamento.dataFatura = reader.GetString(22);
faturamento.flagItemCancelado = (reader.GetString(23));
if (reader.IsDBNull(24))
{
faturamento.dataItemCancelado = valid.ValidaString();
}
else
{
faturamento.dataItemCancelado = reader.GetString(24);
}
if (reader.IsDBNull(25))
{
faturamento.quantidadeItemCancelado = valid.ValidaString();
}
else
{
faturamento.quantidadeItemCancelado = reader.GetString(25);
}
faturamento.valorFrete = reader.GetString(26);
faturamento.valorIpi = reader.GetString(27);
faturamento.valorPis = reader.GetString(28);
faturamento.valorConfins = reader.GetString(29);
faturamento.valorIcms = reader.GetString(30);
faturamento.valorIcmsSt = reader.GetString(31);
if (reader.IsDBNull(32))
{
faturamento.valorSeguro = valid.ValidaString();
}
else
{
faturamento.valorSeguro = (reader.GetValue(32).ToString());
}
if (reader.IsDBNull(33))
{
faturamento.valorDespesaExtra = valid.ValidaString();
}
else
{
faturamento.valorDespesaExtra = reader.GetString(33);
}
if (reader.IsDBNull(34))
{
faturamento.flagTipoEntrega = valid.ValidaString();
}
else
{
faturamento.flagTipoEntrega = reader.GetString(34);
}
PostFaturamento(faturamento);
string msg = "Foram inseridos: " + lFaturamento.Count().ToString() + " de " + countRegister + " registros";
processForm.writeMessage(msg);
processForm.Enabled = false;
processForm.Enabled = true;
lFaturamento.Add(faturamento);
}
}
con.Dispose();
}
catch (Exception ex)
{
logErro.EscreverLog(layout, ex.Message.ToString());
//MessageBox.Show(ex.Message.ToString(), "Advetisament", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
catch (Exception ex)
{
logErro.EscreverLog(layout, ex.Message.ToString());
//MessageBox.Show(ex.Message.ToString(), "Advetisament", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
int countWrite = lFaturamento.Count();
//MessageBox.Show("Foram inseridos "+countWrite.ToString()+" registros", "Advetisament", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
processForm.Close();
}
public void IntegraProduto()
{
ProcessForm processForm = new ProcessForm("", layout);
processForm.Show();
List<Produto> lProduto = new List<Produto>();
IEnumerable<String> streamRead = File.ReadLines(System.Environment.CurrentDirectory.ToString() + "\\config.txt");
var connection = streamRead.First();
using (OleDbConnection con = new OleDbConnection(connection))
{
try
{
con.Open();
using (OleDbCommand commandCount = new OleDbCommand("SELECT COUNT(*) FROM PRODUTOS", con))
using (OleDbDataReader readerCount = commandCount.ExecuteReader())
{
while (readerCount.Read())
{
countRegister = readerCount.GetValue(0).ToString();
}
}
try{
using (OleDbCommand command = new OleDbCommand("SELECT SKU_PRODUTO,NOME_PRODUTO,ID_DISTRIBUIDOR,MARCA,PRODUTO,TIER,CLASSE_PRODUTO,SKU_CHEVRON,DESC_SKU_CHEVRON,COD_PRODUTO_EAN13,NCM_PRODUTO,EMBALAGEM,VOLUME_UNITARIO_PRODUTO,FLAG_ATIVO_PRODUTO FROM PRODUTOS", con))
using (OleDbDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Produto produto = new Produto();
produto.id = reader.GetString(0);
produto.nome = reader.GetString(1);
produto.distribuidorId = reader.GetString(2);
produto.marca = reader.GetString(3);
produto.produto = reader.GetString(4);
produto.tier = reader.GetString(5);
produto.classe = reader.GetString(6);
produto.chevronId = reader.GetString(7);
produto.chevronDescricao = reader.GetString(8);
produto.ean13 = reader.GetString(9);
produto.ncm = reader.GetString(10);
produto.embalagem = reader.GetString(11);
produto.volumeUnitario = reader.GetString(12);
produto.flagAtivo = reader.GetString(13);
PostProduto(produto);
string msg = "Foram inseridos: " + lProduto.Count().ToString() + " de " + countRegister + " registros";
processForm.writeMessage(msg);
processForm.Enabled = false;
processForm.Enabled = true;
lProduto.Add(produto);
}
}
con.Dispose();
}
catch (Exception ex)
{
logErro.EscreverLog(layout, ex.Message.ToString());
//MessageBox.Show(ex.Message.ToString(), "Advetisament", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
catch (Exception ex)
{
logErro.EscreverLog(layout, ex.Message.ToString());
//MessageBox.Show(ex.Message.ToString(), "Advetisament", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
int countWrite = lProduto.Count();
//MessageBox.Show("Foram inseridos "+countWrite.ToString()+" registros", "Advetisament", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
processForm.Close();
}
public void IntegraEnderecoCliente()
{
ProcessForm processForm = new ProcessForm("0", layout);
processForm.Show();
List<EnderecoCliente> lEnderecoCliente = new List<EnderecoCliente>();
IEnumerable<String> streamRead = File.ReadLines(System.Environment.CurrentDirectory.ToString() + "\\config.txt");
var connection = streamRead.First();
using (OleDbConnection con = new OleDbConnection(connection))
{
try
{
con.Open();
using (OleDbCommand commandCount = new OleDbCommand("SELECT COUNT(*) FROM ENDERECO_CLIENTES ", con))
using (OleDbDataReader readerCount = commandCount.ExecuteReader())
{
while (readerCount.Read())
{
countRegister = readerCount.GetValue(0).ToString();
}
}
try{
using (OleDbCommand command = new OleDbCommand("SELECT ID_END_CLIENTE,ID_DISTRIBUIDOR,ID_CLIENTE,COD_MUNICIPIO_IBGE_CLIENTE,RUA_END_CLIENTE,NUMERO_END_CLIENTE,COMPLEMENTO_END_CLIENTE,CEP_END_CLIENTE,BAIRRO_END_CLIENTE,MUNICIPIO_END_CLIENTE,UF_END_CLIENTE,TEL_END_CLIENTE,EMAIL_END_CLIENTE FROM ENDERECO_CLIENTES", con))
using (OleDbDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
EnderecoCliente enderecoCliente = new EnderecoCliente();
enderecoCliente.id = reader.GetString(0);
enderecoCliente.distribuidorId = reader.GetString(1);
enderecoCliente.clienteId = reader.GetString(2);
enderecoCliente.codigoMunicipioIBGE = reader.GetString(3);
enderecoCliente.cep = reader.GetString(4);
enderecoCliente.bairro = reader.GetString(5);
enderecoCliente.municipio = reader.GetString(6);
enderecoCliente.uf = reader.GetString(7);
enderecoCliente.telefone = reader.GetString(8);
enderecoCliente.email = reader.GetString(9);
PostEnderecoCliente(enderecoCliente);
string msg = "Foram inseridos: " + lEnderecoCliente.Count().ToString() + " de " + countRegister + " registros";
processForm.writeMessage(msg);
processForm.Enabled = false;
processForm.Enabled = true;
lEnderecoCliente.Add(enderecoCliente);
}
}
con.Dispose();
}
catch (Exception ex)
{
logErro.EscreverLog(layout, ex.Message.ToString());
//MessageBox.Show(ex.Message.ToString(), "Advetisament", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
catch (Exception ex)
{
logErro.EscreverLog(layout, ex.Message.ToString());
//MessageBox.Show(ex.Message.ToString(), "Advetisament", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
int countWrite = lEnderecoCliente.Count();
//MessageBox.Show("Foram inseridos "+countWrite.ToString()+" registros", "Advetisament", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
processForm.Close();
}
public JsonResult Submit(string json)
{
AjaxResult ajaxResult = new AjaxResult()
{
Result = DoResult.Failed,
PromptMsg = "操作失败"
};
ProcessForm processForm = null;
try
{
string processDefID = Request.Form["processDefID"];
string entry = Request.Form["Entry"];
string processInstID = Request.Form["processInstID"];
string workItemID = Request.Form["workItemID"];
UnitOfWork.ExecuteWithTrans<ProcessDef>(() =>
{
if (!string.IsNullOrEmpty(processDefID) && entry.EqualIgnoreCase("StartProcess"))
{
processInstID = workflowEngine.CreateAProcess(processDefID);// string.Empty; // TODO: Initialize to an appropriate value
workflowEngine.StartAProcess(processInstID, null);
WorkItem wi = repository.Query<WorkItem>().FirstOrDefault(w => w.ProcessInstID == processInstID);
workItemID = wi.ID;
AddActionLog(wi, DoResult.Success, string.Format("启动流程实像{0}", processInstID));
}
Dictionary<string, object> formValues = JsonConvert.DeserializeObject<Dictionary<string, object>>(json);
string table = Request.Form["DataSource"];
string cmdText = string.Empty;
processForm = repository.Query<ProcessForm>().FirstOrDefault(pf => pf.ProcessInstID == processInstID);
if (processForm != null)
{
StringBuilder sbUpdateValues = new StringBuilder();
foreach (var item in formValues)
{
if (sbUpdateValues.Length > 0)
sbUpdateValues.Append(",");
sbUpdateValues.AppendFormat("{0} = :{0}", item.Key);
}
cmdText = string.Format("update {0} set {1} where ID ='{2}'", table, sbUpdateValues.ToString(), processForm.BizID);
}
else
{
formValues.SafeAdd("ID", IdGenerator.NewComb().ToSafeString());
formValues.SafeAdd("Applicant", workContext.User.ID);
formValues.SafeAdd("ApplicantName", workContext.User.Name);
formValues.SafeAdd("ApplyTime", DateTime.Now);
StringBuilder sbFields = new StringBuilder();
StringBuilder sbValues = new StringBuilder();
foreach (var item in formValues)
{
sbFields.Append(item.Key).Append(",");
sbValues.Append(":").Append(item.Key).Append(",");
}
processForm = new ProcessForm()
{
ID = IdGenerator.NewComb().ToString(),
BizID = formValues.GetSafeValue<string>("ID"),
BizTable = table,
CreateTime = DateTime.Now,
Creator = workContext.User.ID,
ProcessInstID = processInstID,
KeyWord = sbValues.ToString()
};
cmdText = string.Format("insert into {0}({1}) values({2})", table, sbFields.ToString().TrimEnd(','), sbValues.ToString().TrimEnd(','));
}
workflowEngine.Persistence.Repository.ExecuteSql<WorkItem>(cmdText, formValues);
workflowEngine.Persistence.Repository.SaveOrUpdate(processForm);
workflowEngine.CompleteWorkItem(workItemID, formValues);
});
ajaxResult.Result = DoResult.Success;
ajaxResult.RetValue = processForm.BizID;
ajaxResult.PromptMsg = string.Format("完成工作流实例{0}工作项{1}", processForm.ProcessInstID, workItemID);
//记录操作日志
AddActionLog(processForm, ajaxResult.Result, ajaxResult.PromptMsg);
}
catch (Exception ex)
{
ajaxResult.Result = DoResult.Failed;
//记录操作日志
AddActionLog(processForm, ajaxResult.Result, string.Format("完成工作流实例{0}工作项失败", processForm.ProcessInstID));
log.Error(ex);
}
return Json(ajaxResult);
}
public void IntegraForcaDeVenda()
{
ProcessForm processForm = new ProcessForm("", layout);
processForm.Show();
List<ForcaDeVenda> lForcaDeVenda = new List<ForcaDeVenda>();
IEnumerable<String> streamRead = File.ReadLines(System.Environment.CurrentDirectory.ToString() + "\\config.txt");
var connection = streamRead.First();
using (OleDbConnection con = new OleDbConnection(connection))
{
try
{
con.Open();
using (OleDbCommand commandCount = new OleDbCommand("SELECT COUNT(*) FROM FORCA_VENDAS", con))
using (OleDbDataReader readerCount = commandCount.ExecuteReader())
{
while (readerCount.Read())
{
countRegister = readerCount.GetValue(0).ToString();
}
}
try{
using (OleDbCommand command = new OleDbCommand("SELECT ID_FV,ID_DISTRIBUIDOR,AREA_ATUACAO_FV,TIPO_FV,NOME_FV,EMAIL_FV,TEL_FV FROM FORCA_VENDAS", con))
using (OleDbDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
ForcaDeVenda forcaDeVenda = new ForcaDeVenda();
forcaDeVenda.id = reader.GetString(0);
forcaDeVenda.distribuidorId = reader.GetString(1);
forcaDeVenda.areaAtuacao = reader.GetString(2);
forcaDeVenda.tipo = reader.GetString(3);
forcaDeVenda.nome = reader.GetString(4);
forcaDeVenda.email = reader.GetString(5);
forcaDeVenda.telefone = reader.GetString(6);
PostForcaDeVenda(forcaDeVenda);
string msg = "Foram inseridos: " + lForcaDeVenda.Count().ToString() +" de "+countRegister+ " registros";
processForm.writeMessage(msg);
processForm.Enabled = false;
processForm.Enabled = true;
lForcaDeVenda.Add(forcaDeVenda);
}
}
con.Dispose();
}
catch (Exception ex)
{
logErro.EscreverLog(layout, ex.Message.ToString());
//MessageBox.Show(ex.Message.ToString(), "Advetisament", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
catch (Exception ex)
{
logErro.EscreverLog(layout, ex.Message.ToString());
//MessageBox.Show(ex.Message.ToString(), "Advetisament", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
int countWrite = lForcaDeVenda.Count();
//MessageBox.Show("Foram inseridos "+countWrite.ToString()+" registros", "Advetisament", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
processForm.Close();
}
public void IntegraPedido()
{
ProcessForm processForm = new ProcessForm("", layout);
processForm.Show();
List<Pedido> lPedido = new List<Pedido>();
IEnumerable<String> streamRead = File.ReadLines(System.Environment.CurrentDirectory.ToString() + "\\config.txt");
var connection = streamRead.First();
//int index = 0;
using (OleDbConnection con = new OleDbConnection(connection))
{
try
{
con.Open();
using (OleDbCommand commandCount = new OleDbCommand("SELECT COUNT(*) FROM PEDIDOS ", con))
using (OleDbDataReader readerCount = commandCount.ExecuteReader())
{
while (readerCount.Read())
{
countRegister = readerCount.GetValue(0).ToString();
}
}
try
{
using (OleDbCommand command = new OleDbCommand("SELECT SKU_PRODUTO,ID_CLIENTE,ID_DISTRIBUIDOR,ID_FV,ID_FORMA_PAGAMENTO,NUMERO_PEDIDO,DATA_PEDIDO,QUANTIDADE_ITEM_PEDIDO,VALOR_UNITARIO_PEDIDO,VALOR_TOTAL_ITEM_PEDIDO,CFOP_PEDIDO,NATUREZA_OPERACAO_NF,FLAG_PEDIDO_ITEM_CANCELADO,DATA_PEDIDO_ITEM_CANCELADO FROM PEDIDOS", con))
using (OleDbDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Pedido pedido = new Pedido();
pedido.produtoId = reader.GetString(0);
pedido.clienteId= reader.GetString(1);
pedido.distribuidorId = reader.GetString(2);
pedido.forcaDeVendaId=reader.GetString(3);
pedido.formaDePagamentoId = reader.GetString(4);
pedido.numeroPedido = reader.GetString(5);
pedido.data = reader.GetString(6);
pedido.quantidadeItens = reader.GetString(7);
pedido.valorUnitario = reader.GetString(8);
pedido.valorTotalItens = reader.GetString(9);
pedido.cfop = reader.GetString(10);
pedido.naturezaOperacaoNF = reader.GetString(11);
pedido.flagItemCancelado = reader.GetString(12);
pedido.dataItemCancelado = reader.GetString(13);
PostPedido(pedido);
string msg = "Foram inseridos: " + lPedido.Count().ToString() +" de "+countRegister+ " registros";
processForm.writeMessage(msg);
processForm.Enabled = false;
processForm.Enabled = true;
lPedido.Add(pedido);
//index++;
}
}
con.Dispose();
}
catch (Exception ex)
{
logErro.EscreverLog(layout, ex.Message.ToString());
//MessageBox.Show(ex.Message.ToString(), "Advetisament", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
catch (Exception ex)
{
logErro.EscreverLog(layout, ex.Message.ToString());
//MessageBox.Show(ex.Message.ToString(), "Advetisament", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
int countWrite = lPedido.Count();
//MessageBox.Show("Foram inseridos "+countWrite.ToString()+" registros", "Advetisament", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
processForm.Close();
//return index;
}
public void IntegraCarteiraCliente()
{
ProcessForm processForm = new ProcessForm("", layout);
processForm.Show();
List<CarteiraCliente> lCarteiraCliente = new List<CarteiraCliente>();
IEnumerable<String> streamRead = File.ReadLines(System.Environment.CurrentDirectory.ToString() + "\\config.txt");
var connection = streamRead.First();
using (OleDbConnection con = new OleDbConnection(connection))
{
try
{
con.Open();
using (OleDbCommand commandCount = new OleDbCommand("SELECT COUNT(*) FROM CARTEIRA_CLIENTES ", con))
using (OleDbDataReader readerCount = commandCount.ExecuteReader())
{
while (readerCount.Read())
{
countRegister = readerCount.GetValue(0).ToString();
}
}
try
{
using (OleDbCommand command = new OleDbCommand("SELECT ID_DISTRIBUIDOR,ID_FV,ID_CLIENTE,DATA_PRIMEIRO_ATENDIMENTO,DATA_ULTIMO_ATENDIMENTO,VALOR_ULTIMA_VENDA,VALOR_PRIMEIRA_VENDA FROM CARTEIRA_CLIENTES ", con))
using (OleDbDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
CarteiraCliente carteiraCliente = new CarteiraCliente();
carteiraCliente.distribuidorId = reader.GetString(0);
carteiraCliente.forcaDeVendaId = reader.GetString(1);
carteiraCliente.clienteId = reader.GetString(2);
carteiraCliente.dataPrimeiroAtendimento = reader.GetString(3);
carteiraCliente.dataUltimoAtendimento = reader.GetString(4);
carteiraCliente.ValorUltimaVenda = reader.GetString(5);
carteiraCliente.valorPrimeiraVenda = reader.GetString(6);
PostCarteiraCLiente(carteiraCliente);
string msg = "Foram inseridos: " + lCarteiraCliente.Count().ToString() + " de " + countRegister + " registros";
processForm.writeMessage(msg);
processForm.Enabled = false;
processForm.Enabled = true;
lCarteiraCliente.Add(carteiraCliente);
}
}
con.Dispose();
}
catch (Exception ex)
{
logErro.EscreverLog(layout, ex.Message.ToString());
// MessageBox.Show(ex.Message.ToString(), "Advetisament", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
catch (Exception ex)
{
logErro.EscreverLog(layout, ex.Message.ToString());
// MessageBox.Show(ex.Message.ToString(), "Advetisament", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
int countWrite = lCarteiraCliente.Count();
//MessageBox.Show("Foram inseridos " + countWrite.ToString() + " registros", "Advetisament", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
processForm.Close();
}
}
public void IntegraEstoque()
{
ProcessForm processForm = new ProcessForm("", layout);
processForm.Show();
List<Estoque> lEstoque = new List<Estoque>();
IEnumerable<String> streamRead = File.ReadLines(System.Environment.CurrentDirectory.ToString() + "\\config.txt");
var connection = streamRead.First();
using (OleDbConnection con = new OleDbConnection(connection))
{
try
{
con.Open();
using (OleDbCommand commandCount = new OleDbCommand("SELECT COUNT(*) FROM ESTOQUE ", con))
using (OleDbDataReader readerCount = commandCount.ExecuteReader())
{
while (readerCount.Read())
{
countRegister = readerCount.GetValue(0).ToString();
}
}
try
{
using (OleDbCommand command = new OleDbCommand("SELECT SKU_PRODUTO,ID_DISTRIBUIDOR,QUANTIDADE_ATUAL_ESTOQUE,QUANTIDADE_ULTIMA_COMPRA,QUANTIDADE_ULTIMA_VENDA,DATA_PRIMEIRA_COMPRA,DATA_ULTIMA_COMPRA,DATA_ULTIMA_VENDA,VALOR_CUSTO_UNITARIO_ESTOQUE,VALOR_CUSTO_TOTAL_ESTOQUE FROM ESTOQUE", con))
using (OleDbDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Estoque estoque = new Estoque();
Validator valid = new Validator();
estoque.produtoId = reader.GetString(0);
estoque.distribuidorId = reader.GetString(1);
estoque.quantidadeAtualEstoque = reader.GetString(2);
estoque.quantidadeUltimaCompra = reader.GetString(3);
estoque.quantidadeUltimaVenda = reader.GetString(4);
if (reader.IsDBNull(5))
{
estoque.dataPrimeiraCompra = valid.ValidaString();
}
else
{
estoque.dataPrimeiraCompra = (reader.GetString(5));
}
if (reader.IsDBNull(6))
{
estoque.dataUltimaCompra = valid.ValidaString();
}
else
{
estoque.dataUltimaCompra = (reader.GetString(6));
}
if (reader.IsDBNull(7))
{
estoque.dataUltimaVenda = valid.ValidaString();
}
else
{
estoque.dataUltimaVenda = (reader.GetString(7));
}
estoque.valorCustoUnitarioEstoque = reader.GetString(8);
estoque.valorCustoTotalEstoque = reader.GetString(9);
PostEstoque(estoque);
string msg = "Foram inseridos: " + lEstoque.Count().ToString() + " de " + countRegister + " registros";
processForm.writeMessage(msg);
processForm.Enabled = false;
processForm.Enabled = true;
lEstoque.Add(estoque);
}
}
con.Dispose();
}
catch (Exception ex)
{
logErro.EscreverLog(layout, ex.Message.ToString());
//MessageBox.Show(ex.Message.ToString(), "Advetisament", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
catch (Exception ex)
{
logErro.EscreverLog(layout, ex.Message.ToString());
//MessageBox.Show(ex.Message.ToString(), "Advetisament", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
int countWrite = lEstoque.Count();
//MessageBox.Show("Foram inseridos "+countWrite.ToString()+" registros", "Advetisament", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
processForm.Close();
}
}
public void IntegraFormaDePagamento()
{
ProcessForm processForm = new ProcessForm("", layout);
processForm.Show();
List<FormaDePagamento> lFormaDePagamento = new List<FormaDePagamento>();
IEnumerable<String> streamRead = File.ReadLines(System.Environment.CurrentDirectory.ToString() + "\\config.txt");
var connection = streamRead.First();
using (OleDbConnection con = new OleDbConnection(connection))
{
try
{
con.Open();
using (OleDbCommand commandCount = new OleDbCommand("SELECT COUNT(*) FROM FORMA_PAGAMENTO ", con))
using (OleDbDataReader readerCount = commandCount.ExecuteReader())
{
while (readerCount.Read())
{
countRegister = readerCount.GetValue(0).ToString();
}
}
try{
using (OleDbCommand command = new OleDbCommand("SELECT ID_FORMA_PAGAMENTO,ID_DISTRIBUIDOR,DESC_FORMA_PAGAMENTO,FLAG_ATIVO_FORMA_PAGAMENTO FROM FORMA_PAGAMENTO", con))
using (OleDbDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
FormaDePagamento formaDePagamento = new FormaDePagamento();
formaDePagamento.id = reader.GetString(0);
formaDePagamento.distribuidorId = reader.GetString(1);
formaDePagamento.formaDePagamento = reader.GetString(2);
formaDePagamento.flagAtivo = reader.GetString(3);
PostFormaDePagamento(formaDePagamento);
string msg = "Foram inseridos: " + lFormaDePagamento.Count().ToString() + " de "+countRegister+" registros";
processForm.writeMessage(msg);
processForm.Enabled = false;
processForm.Enabled = true;
lFormaDePagamento.Add(formaDePagamento);
}
}
con.Dispose();
}
catch (Exception ex)
{
logErro.EscreverLog(layout, ex.Message.ToString());
//MessageBox.Show(ex.Message.ToString(), "Advetisament", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
catch (Exception ex)
{
logErro.EscreverLog(layout, ex.Message.ToString());
//MessageBox.Show(ex.Message.ToString(), "Advetisament", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
int countWrite = lFormaDePagamento.Count();
//MessageBox.Show("Foram inseridos "+countWrite.ToString()+" registros", "Advetisament", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
processForm.Close();
}
public void IntegraTabelaPreço()
{
ProcessForm processForm = new ProcessForm("", layout);
processForm.Show();
List<TabelaPreco> lTabelaPreco = new List<TabelaPreco>();
IEnumerable<String> streamRead = File.ReadLines(System.Environment.CurrentDirectory.ToString() + "\\config.txt");
var connection = streamRead.First();
using (OleDbConnection con = new OleDbConnection(connection))
{
try
{
con.Open();
using (OleDbCommand commandCount = new OleDbCommand("SELECT COUNT(*) FROM TABELA_PRECO ", con))
using (OleDbDataReader readerCount = commandCount.ExecuteReader())
{
while (readerCount.Read())
{
countRegister = readerCount.GetValue(0).ToString();
}
}
try{
using (OleDbCommand command = new OleDbCommand("SELECT ID_DISTRIBUIDOR,SKU_PRODUTO,NOME_TABELA_PRECO,PREÇO_UNITARIO,QUANTIDADE_INICIAL,PREÇO_ESCALONADO FROM TABELA_PRECO", con))
using (OleDbDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
TabelaPreco tabelaPreco = new TabelaPreco();
tabelaPreco.distribuidorId = reader.GetString(0);
tabelaPreco.produtoId = reader.GetString(1);
tabelaPreco.nomeTabelaPreco = reader.GetString(2);
tabelaPreco.precoUnitario = reader.GetString(3);
tabelaPreco.quantidadeInicial = reader.GetString(4);
tabelaPreco.precoEscalonado = reader.GetString(5);
PostTabelaPreco(tabelaPreco);
string msg = "Foram inseridos: " + lTabelaPreco.Count().ToString() + " de " + countRegister + " registros";
processForm.writeMessage(msg);
processForm.Enabled = false;
processForm.Enabled = true;
lTabelaPreco.Add(tabelaPreco);
}
}
con.Dispose();
}
catch (Exception ex)
{
logErro.EscreverLog(layout, ex.Message.ToString());
//MessageBox.Show(ex.Message.ToString(), "Advetisament", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
catch (Exception ex)
{
logErro.EscreverLog(layout, ex.Message.ToString());
// MessageBox.Show(ex.Message.ToString(), "Advetisament", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
int countWrite = lTabelaPreco.Count();
//MessageBox.Show("Foram inseridos "+countWrite.ToString()+" registros", "Advetisament", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
processForm.Close();
}
public string Save(string argument)
{
AjaxResult ajaxResult = new AjaxResult();
string errorMsg = string.Empty;
DoResult actionResult = DoResult.Failed;
string actionMessage = string.Empty;
string processInstID = Request.QueryString["processInstID"];
ProcessForm processForm;
try
{
Dictionary<string, object> formValues = JsonConvert.DeserializeObject<Dictionary<string, object>>(argument);
string table = Request.Form["DataSource"];
StringBuilder sbFields = new StringBuilder();
StringBuilder sbValues = new StringBuilder();
string cmdText = string.Empty;
StringBuilder sbUpdateValues = new StringBuilder();
IDictionary<string, object> parameters = new Dictionary<string, object>();
parameters.SafeAdd("ProcessInstID", processInstID);
processForm = engine.Persistence.Repository.FindOne<ProcessForm>(parameters);
if (processForm != null)
{
foreach (var item in formValues)
{
if (sbUpdateValues.Length > 0)
sbUpdateValues.Append(",");
sbUpdateValues.AppendFormat("{0} = :{0}", item.Key);
}
cmdText = string.Format("update {0} set {1} where ID ='{2}'", table, sbUpdateValues.ToString(), processForm.BizID);
}
else
{
string bizID = IdGenerator.NewComb().ToString();
formValues.SafeAdd("ID", bizID);
foreach (var item in formValues)
{
sbFields.Append(item.Key).Append(",");
sbValues.Append(":").Append(item.Key).Append(",");
}
processForm = new ProcessForm()
{
ID = IdGenerator.NewComb().ToString(),
BizID = bizID,
BizTable = table,
CreateTime = DateTime.Now,
Creator = User.ID,
ProcessInstID = processInstID,
KeyWord = sbValues.ToString()
};
cmdText = string.Format("insert into {0}({1}) values({2})", table, sbFields.ToString().TrimEnd(','), sbValues.ToString().TrimEnd(','));
}
string workItemID = Request.QueryString["workItemID"];
UnitOfWork.ExecuteWithTrans<WorkItem>(() =>
{
engine.Persistence.Repository.ExecuteSql<WorkItem>(cmdText, formValues);
engine.Persistence.Repository.SaveOrUpdate(processForm);
engine.CompleteWorkItem(workItemID, formValues);
});
actionResult = DoResult.Success;
//获取提示信息
actionMessage = string.Format("启动工作流实例{0}工作项{1}", processForm.ProcessInstID, workItemID);
//记录操作日志
AddActionLog(processForm, actionResult, actionMessage);
ajaxResult.Result = actionResult;
ajaxResult.RetValue = processForm.BizID;
ajaxResult.PromptMsg = actionMessage;
}
catch (Exception ex)
{
actionMessage = RemarkAttribute.GetEnumRemark(actionResult);
log.Error(actionMessage, ex);
}
return JsonConvert.SerializeObject(ajaxResult);
}
public int IntegraCliente()
{
ProcessForm processForm = new ProcessForm("", layout);
processForm.Show();
List<Cliente> lCliente = new List<Cliente>();
IEnumerable<String> streamRead = File.ReadLines(System.Environment.CurrentDirectory.ToString()+"\\config.txt");
var connection = streamRead.First();
int index = 0;
using (OleDbConnection con = new OleDbConnection(connection))
{
try
{
con.Open();
using (OleDbCommand commandCount = new OleDbCommand("SELECT COUNT(*) FROM CLIENTES ", con))
using (OleDbDataReader readerCount = commandCount.ExecuteReader())
{
while (readerCount.Read())
{
countRegister = readerCount.GetValue(0).ToString();
}
}
try
{
using (OleDbCommand command = new OleDbCommand("SELECT ID_CLIENTE,ID_DISTRIBUIDOR,RAZAO_SOCIAL_CLIENTE,NOME_FANTASIA_CLIENTE,CNPJ_CPF_CLIENTE,COD_MUNICIPIO_IBGE_MATRIZ,RUA_END_MATRIZ_CLIENTE,NUMERO_END_MATRIZ_CLIENTE,COMPLEMENTO_END_MATRIZ_CLIENTE,CEP_END_MATRIZ_CLIENTE,BAIRRO_END_MATRIZ_CLIENTE,MUNICIPIO_END_MATRIZ_CLIENTE,UF_END_MATRIZ_CLIENTE,TEL_END_MATRIZ_CLIENTE,EMAIL_END_MATRIZ_CLIENTE,PESSOA_CONTATO,RAMO_NEGOCIO_CLIENTE,SUB_RAMO_NEGOCIO_CLIENTE,CURVA_ABC_CLIENTE,STATUS_FINANCEIRO_CLIENTE,DATA_CADASTRO_CLIENTE,DATA_DESATIVACAO_CLIENTE,FLAG_ATIVO_CLIENTE,GRUPO_ECONOMICO_CLIENTE FROM CLIENTES ", con))
using (OleDbDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Cliente cliente = new Cliente();
Validator valid = new Validator();
cliente.id = reader.GetString(0);
cliente.distribuidorId = reader.GetString(1);
cliente.razaoSocial = reader.GetString(2);
cliente.nomeFantasia = reader.GetString(3);
cliente.cnpjCpf = reader.GetString(4);
if (reader.IsDBNull(5))
{
cliente.codigoMunicipio = valid.ValidaString();
}
else
{
cliente.codigoMunicipio = reader.GetString(5);
}
//cliente.codigoMunicipio = reader.GetString(5);
if (reader.IsDBNull(6))
{
cliente.enderecoLogradouro = valid.ValidaString();
}
else
{
cliente.enderecoLogradouro = reader.GetString(6);
}
//cliente.enderecoLogradouro = reader.GetString(6);
if (reader.IsDBNull(7))
{
cliente.enderecoNumero = valid.ValidaString();
}
else
{
cliente.enderecoNumero = reader.GetString(7);
}
//cliente.enderecoNumero = reader.GetString(7);
if (reader.IsDBNull(8))
{
cliente.enderecoComplemento = valid.ValidaString();
}
else
{
cliente.enderecoComplemento = reader.GetString(8);
}
//cliente.enderecoComplemento = reader.GetString(8);
if (reader.IsDBNull(9))
{
cliente.enderecoCep = valid.ValidaString();
}
else
{
cliente.enderecoCep = reader.GetString(9);
}
//cliente.enderecoCep = reader.GetString(9);
if (reader.IsDBNull(10))
{
cliente.enderecoBairro = valid.ValidaString();
}
else
{
cliente.enderecoBairro = reader.GetString(10);
}
//cliente.enderecoBairro = reader.GetString(10);
if (reader.IsDBNull(11))
{
cliente.enderecoMunicipio = valid.ValidaString();
}
else
{
cliente.enderecoMunicipio = reader.GetString(11);
}
//cliente.enderecoMunicipio = reader.GetString(11);
if (reader.IsDBNull(12))
{
cliente.enderecoEstado = valid.ValidaString();
}
else
{
cliente.enderecoEstado = reader.GetString(12);
}
//cliente.enderecoEstado = reader.GetString(12);
if (reader.IsDBNull(13))
{
cliente.telefone = valid.ValidaString();
}
else
{
cliente.telefone = reader.GetString(13);
}
//cliente.telefone = reader.GetString(13);
if (reader.IsDBNull(14))
{
cliente.email = valid.ValidaString();
}
else
{
cliente.email = reader.GetString(14);
}
//cliente.email = reader.GetString(14);
if (reader.IsDBNull(15))
{
cliente.pessoaContato = valid.ValidaString();
}
else
{
cliente.pessoaContato = reader.GetString(15);
}
//cliente.pessoaContato = reader.GetString(15);
if (reader.IsDBNull(16))
{
cliente.ramoNegocio = valid.ValidaString();
}
else
{
cliente.ramoNegocio = reader.GetString(16);
}
//cliente.ramoNegocio = reader.GetString(16);
if (reader.IsDBNull(17))
{
cliente.subRamoNegocio = valid.ValidaString();
}
else
{
cliente.subRamoNegocio = reader.GetString(17);
}
//cliente.subRamoNegocio = reader.GetString(17);
if (reader.IsDBNull(18))
{
cliente.curvaABC = valid.ValidaString();
}
else
{
cliente.curvaABC = reader.GetString(18);
}
if (reader.IsDBNull(19)||reader.GetValue(19).ToString()=="")
{
cliente.statusFinanceiro = valid.ValidaString();
}
else
{
cliente.statusFinanceiro = reader.GetString(19);
}
if ((reader.IsDBNull(20) || (reader.GetValue(20).ToString() == "") || (reader.GetValue(20) == null)))
{
cliente.dataCadastro = valid.ValidaString();
}
else
{
cliente.dataCadastro = (reader.GetValue(20).ToString());
}
if ((reader.IsDBNull(21)) || (reader.GetValue(21).ToString() == "") || (reader.GetValue(21)==null))
{
cliente.dataDesativacao = valid.ValidaString();
}
else
{
try
{
cliente.dataDesativacao = reader.GetString(20);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "Advetisament", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
//cliente.ativo = (reader.GetString(22));
if ((reader.IsDBNull(22) || (reader.GetValue(22).ToString() == "") || (reader.GetValue(22) == null)))
{
cliente.ativo = valid.ValidaString();
}
else
{
cliente.ativo = reader.GetString(22);
}
if ((reader.IsDBNull(23) || (reader.GetValue(23).ToString() == "") || (reader.GetValue(23) == null)))
{
cliente.grupoEconomico = valid.ValidaString();
}
else
{
cliente.grupoEconomico = reader.GetString(23);
}
PostCliente(cliente);
string msg = "Foram inseridos: " + lCliente.Count().ToString() +" de "+countRegister+" registros";
processForm.writeMessage(msg);
processForm.Enabled = false;
processForm.Enabled = true;
lCliente.Add(cliente);
index++;
}
}
con.Dispose();
//MessageBox.Show("Advetisament","Fim da execução de cliente",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);
}
catch (Exception ex)
{
logErro.EscreverLog(layout, ex.Message.ToString()+ex.ToString());
//MessageBox.Show(ex.Message.ToString(), "Advetisament", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
catch (Exception ex)
{
//MessageBox.Show(ex.Message.ToString(), "Falha ao abrir a conexao", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
logErro.EscreverLog(layout, ex.Message.ToString());
}
int countWrite = lCliente.Count();
//MessageBox.Show("Foram inseridos " + countWrite.ToString() + " registros", "Advetisament", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
processForm.Close();
return index;
}
}
