private void SetOrderInfo(Express.Model.OrderInfo model) { for (int i = 0; i < gvInfo.Rows.Count; i++) { if (gvInfo.Rows[i].Cells[0].Value.ToString() == model.Id.ToString()) { TotalProcessRecord++; gvInfo.Rows[i].Cells[6].Value = model.Reciver; gvInfo.Rows[i].Cells[7].Value = model.Tel; gvInfo.Rows[i].Cells[8].Value = model.Provice; gvInfo.Rows[i].Cells[9].Value = model.City; gvInfo.Rows[i].Cells[10].Value = model.Area; gvInfo.Rows[i].Cells[11].Value = model.Address; gvInfo.Rows[i].Cells[12].Value = model.Remark; Color foreColor = Color.Black; gvInfo.Rows[i].Cells[13].Value = ConvertOrderState(model.OState, ref foreColor); gvInfo.Rows[i].Cells[14].Value = model.OState; if (model.OState > 0 && model.OState < 3) { gvInfo.Rows[i].Cells[15].Value = model.Contractdate.Value; gvInfo.Rows[i].Cells[16].Value = model.Contractor; } gvInfo.Rows[i].Cells[17].Value = GetORSate(model.ORState); this.gvInfo.Rows[i].DefaultCellStyle.ForeColor = foreColor; if (preRow != null) { preRow.Selected = false; } gvInfo.Rows[i].Selected = true; preRow = gvInfo.Rows[i]; gvInfo.FirstDisplayedScrollingRowIndex = i; Express.Model.SendOrderInfo newModel = new Express.BLL.SendOrderInfo().GetModel(model.Id); newModel.Tel = model.Tel; newModel.Provice = model.Provice; newModel.City = model.City; newModel.Area = model.Area; newModel.Address = model.Address; newModel.Reciver = model.Reciver; newModel.Remark = model.Remark; newModel.OState = model.OState; newModel.ORState = model.ORState; newModel.Merchandiser = model.Merchandiser; if (model.OState > 0 && model.OState < 3) { newModel.Contractor = model.Contractor; newModel.Contractdate = model.Contractdate; } new Express.BLL.SendOrderInfo().Update(newModel); break; } } if (anpageinfo.PageIndex == int.Parse(anpageinfo.Tag.ToString()) && RowIndex == gvInfo.Rows.Count && btnQuickSearch.Tag.ToString() == "1") { StopAutoCheck(); } }
private void tsmiUpdateDate_Click(object sender, EventArgs e) { if (DateSelectForm.ThisForm.ShowDialog() == System.Windows.Forms.DialogResult.OK) { bool isUpdate = new Express.BLL.SendOrderInfo().UpdateDateInfo(Convert.ToDateTime(DateSelectForm.ThisForm.Tag), " id in(" + SeletedValues + ")"); string msg = isUpdate ? "修改信息成功!" : "修改信息失败!"; MessageBox.Show(msg, "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); LoadData(); } }
private void tsmiDel_Click(object sender, EventArgs e) { if (MessageBox.Show("确认要删除当前选中的单号吗?", "系统提升", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.OK) { bool issuc = new Express.BLL.SendOrderInfo().DeleteList(SeletedValues); string msg = issuc ? "删除信息成功!" : "删除信息失败!"; MessageBox.Show(msg, "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); LoadPage(); LoadData(); } }
private void ProcessData() { Import_dtInfo = new Express.BLL.SendOrderInfo().GetList(" 0=1").Tables[0]; for (int i = 1; i < dtImportInfo.Rows.Count; i++) { ///过滤无用的单号信息 //if (new Express.BLL.OrderInfo().GetRecordCount(string.Format(" orderno='{0}' and Daterecived=#{1}#", dtImportInfo.Rows[i][0].ToString(),dtReciveDate.Date)) <= 0) //{ if (!string.IsNullOrEmpty(dtImportInfo.Rows[i][0].ToString()) && dtImportInfo.Rows[i][0].ToString().Length > 6) { DataRow newrow = Import_dtInfo.NewRow(); newrow["OrderNo"] = dtImportInfo.Rows[i][0].ToString(); newrow["CustomerID"] = cid; newrow["SalesmanID"] = sid; newrow["Daterecived"] = dtReciveDate.Date; newrow["Contractdate"] = dtReciveDate.Date; newrow["OperUser"] = ClientInfo.Sys_UserInfo.username; newrow["UserDate"] = DateTime.Now; newrow["OState"] = 0; newrow["ORState"] = 0; Import_dtInfo.Rows.Add(newrow); } //Express.Model.OrderInfo orderInfo = new Express.Model.OrderInfo(); //orderInfo.CustomerID = cid; //orderInfo.SalesmanID = sid; //orderInfo.OrderNo = dtImportInfo.Rows[i][0].ToString(); //orderInfo.Daterecived = dtReciveDate.Date; //orderInfo.Contractdate = orderInfo.Daterecived; //orderInfo.OperUser = ClientInfo.Sys_UserInfo.username; //orderInfo.UserDate = DateTime.Now; //new Express.BLL.OrderInfo().Add(orderInfo); //} //RefreshClient(); } bool sucess = new Express.BLL.SendOrderInfo().AddByGroup(Import_dtInfo); MessageBox.Show("导入数据完成!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); btnImport.Enabled = true; }