using LYFZ.ComponentLibrary; using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; namespace LYFZ.Software.MainBusiness.Dresses.DressManagement.Rental { public partial class FrmSaleManagement : LYFZ.Software.UI.Dresses.DressManagement.Rental.FrmSaleManagement { private delegate void UpdateControl(); public FrmSaleManagement() { this.ucPagerEx1.EventPaging += ucPagerEx1_EventPaging; } #region 加载 protected override void FrmSaleManagement_Shown(object sender, EventArgs e) { try { bind(); #region 收款 if (LYFZ.BLL.BLL_ErpUser.GetRights(LYFZ.BLL.BLL_ErpUser.CurrentUserRights.DressManagement, CustomAttributes.OperatingAuthority.ReceivablesAll)) { btnReceivables.Enabled = true; } else { btnReceivables.Enabled = false; } #endregion } catch (Exception ex) { MessageBoxCustom.Show(ex.Message); } } #region 获取礼服订单 /// /// 获取礼服订单 /// public void bind() { this.ucPagerEx1.PageCurrent = 1; this.ucPagerEx1.PageSize = 100; this.ucPagerEx1.Bind(); } #endregion #endregion #region 查询 protected override void btnSlect_Click(object sender, EventArgs e) { try { bind(); } catch (Exception ex) { MessageBoxCustom.Show(ex.Message); } } #endregion #region 删除 protected override void btnDelete_Click(object sender, EventArgs e) { if (this.dgv.SelectedRows.Count == 0) { MessageBoxCustom.Show("请选中你要删除的数据!"); return; } if (MessageBoxCustom.Show("你确定要删除吗?", "删除提示", MessageBoxButtons.YesNo) == DialogResult.Yes) { LYFZ.BLL.BLL_ErpDressSaleRentalOrder bll = new BLL.BLL_ErpDressSaleRentalOrder(); string Dsro_Number = this.dgv.CurrentRow.Cells["Dsro_Number"].Value.ToString(); if (bll.DeleteLf(Dsro_Number) == 1) { #region 写入操作日志 string logsContent = "删除出售礼服编号:" + Dsro_Number; LYFZ.BLL.BLL_ErpSystemLogs.WriteSystemLog(LYFZ.EnumPublic.SystemLogsType.删除礼服, logsContent, LYFZ.BLL.BLL_ErpUser.UsersModel.User_EmployeeID, LYFZ.BLL.BLL_ErpUser.UsersModel.User_Name); //LYFZ.BLL.BLL_ErpSystemLogs systemLogsBll = new BLL.BLL_ErpSystemLogs(); //LYFZ.Model.Model_ErpSystemLogs systemLogsModel = new Model.Model_ErpSystemLogs(); //systemLogsModel.Slogs_Type = "user"; //systemLogsModel.Slogs_Topic = "删除出售礼服"; //systemLogsModel.Slogs_Content = "删除出售礼服编号:" + Dsro_Number; //systemLogsModel.Slogs_UserName = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_Name; //systemLogsModel.Slogs_IP = ""; //systemLogsModel.Slogs_CreateDatetime = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetServerDateTime(); //systemLogsModel.Slogs_CreateName = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_EmployeeID; //systemLogsBll.Add(systemLogsModel); #endregion MessageBoxCustom.Show("删除成功!"); bind(); } else { MessageBoxCustom.Show("删除失败!"); } } } #endregion #region 修改 protected override void btnUpdate_Click(object sender, EventArgs e) { if (dgv.SelectedRows.Count == 0) { MessageBoxCustom.Show("请选择你要修改的礼服订单"); return; } LYFZ.Software.MainBusiness.Dresses.DressManagement.FrmPreselectedUpdate set = new FrmPreselectedUpdate(); set.Dsro_Number = dgv.CurrentRow.Cells["Dsro_Number"].Value.ToString(); set.type = "0"; if (set.ShowDialog() == DialogResult.OK) { bind(); } } #endregion #region 收款 protected override void btnReceivables_Click(object sender, EventArgs e) { try { if (dgv.SelectedRows.Count == 0) { MessageBoxCustom.Show("请选择你要收款的数据!"); return; } LYFZ.Software.MainBusiness.Dresses.DressManagement.Rental.FrmPayment set = new FrmPayment(); set.StrOrderNumber = dgv.CurrentRow.Cells["Dsro_Number"].Value.ToString(); if (set.IsSaveed) { bind(); } } catch (Exception ex) { MessageBoxCustom.Show(ex.Message); } } #endregion #region 打印 protected override void btnPrint_Click(object sender, EventArgs e) { try { if (dgv.SelectedRows.Count == 0) { MessageBoxCustom.Show("请选择你要打印的数据!"); return; } LYFZ.Software.MainBusiness.ReportPrint.ReportFixedFormat.PrintFixedFormat(LYFZ.EnumPublic.PrintTypeEnum.礼服出售清单, this.dgv.CurrentRow.Cells["Dsro_Number"].Value); } catch (Exception ex) { MessageBoxCustom.Show(ex.Message); } } #endregion #region 画分页 /// /// 画分页 /// /// /// private int ucPagerEx1_EventPaging(UCPager.EventPagingArg e) { dgv.Rows.Clear(); DataTable dt = new DataTable(); string StrWhere = ""; if (!string.IsNullOrEmpty(txtkeyword.Text)) { StrWhere += " 1=1 and (Dsro_Number like '%" + txtkeyword.Text.Trim() + "%' or Cus_Name like '%" + txtkeyword.Text.Trim() + "%' or Cus_Telephone like '%" + txtkeyword.Text.Trim() + "%') and Dsro_Type='1'"; } else { StrWhere = " 1=1 and Dsro_Type='1'"; } LYFZ.UCPager.PageData pageData = new LYFZ.UCPager.PageData(); LYFZ.ComponentLibrary.FrmLoadHandling.LoadDoWorkMethod(delegate(object obj, BackgroundWorker backgroundWorker) { pageData.TableName = "View_DressSaleRentalOrder"; pageData.PageIndex = this.ucPagerEx1.PageCurrent; pageData.PageSize = this.ucPagerEx1.PageSize; pageData.QueryCondition = StrWhere.ToString(); pageData.QueryFieldName = " ID,Dsro_Number,Dsro_Type,Dsro_Amount,Dsro_MortgageAmount,Dsro_CustomerNumber,Dsro_TakeDressTime,Dsro_ReservationBackTime,Dsro_Remark,Dsro_CreateDateTime,Dsro_CreateName,Dsro_UpdateDateTime,Dsro_UpdateName,Cus_CustomerNumber,Cus_CustomizeNumber,Cus_Type,Cus_ServiceType,Cus_Grade,Cus_Name,Cus_Sex,Cus_Birthday,Cus_BirthdayLunar,Cus_DayForMarriage,Cus_DayForMarriageLunar,Cus_Relations,Cus_QQ,Cus_MicroSignal,Cus_Telephone,Cus_FixedPhone,Cus_Region,Cus_Address,Py_Cus_Name"; pageData.OrderStr = "ID desc"; pageData.OrderType = 1; DataSet da = pageData.QueryDataTable(); dt = da.Tables[0]; if (dt.Rows.Count > 0) { this.Invoke(new UpdateControl(delegate() { for (int t = 0; t < dt.Rows.Count; t++) { #region DataGridViewRow dgvr = new DataGridViewRow(); DataGridViewCell cell = null; cell = new DataGridViewTextBoxCell(); cell.Value = dt.Rows[t]["Dsro_Number"].ToString().Trim(); dgvr.Cells.Add(cell); cell = new DataGridViewTextBoxCell(); cell.Value = dt.Rows[t]["Dsro_Amount"].ToString().Trim(); dgvr.Cells.Add(cell); //已付 cell = new DataGridViewTextBoxCell(); decimal Paid; LYFZ.BLL.BLL_ErpPayment Paymentbll = new BLL.BLL_ErpPayment(); DataTable DaPayment = Paymentbll.GetSum(" Pay_OrdNumber='" + dt.Rows[t]["Dsro_Number"].ToString().Trim() + "'").Tables[0]; if (string.IsNullOrEmpty(DaPayment.Rows[0]["Pay_AmountOf"].ToString())) { Paid = 0.00m; } else { Paid = Convert.ToDecimal(DaPayment.Rows[0]["Pay_AmountOf"]); } cell.Value = Paid; dgvr.Cells.Add(cell); //欠款 cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToDecimal(dt.Rows[t]["Dsro_Amount"]) - Convert.ToDecimal(Paid); dgvr.Cells.Add(cell); //变色 decimal Arrears = Convert.ToDecimal(cell.Value); if (Arrears < 0 || Arrears > 0) { dgvr.DefaultCellStyle.ForeColor = Color.Red; } else { dgvr.DefaultCellStyle.ForeColor = Color.Blue; } cell = new DataGridViewTextBoxCell(); cell.Value = dt.Rows[t]["Cus_Name"].ToString().Trim(); dgvr.Cells.Add(cell); cell = new DataGridViewTextBoxCell(); cell.Value = dt.Rows[t]["Cus_Telephone"].ToString().Trim(); dgvr.Cells.Add(cell); cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToDateTime(dt.Rows[t]["Dsro_TakeDressTime"].ToString().Trim()).ToString("yyyy-MM-dd"); dgvr.Cells.Add(cell); cell = new DataGridViewTextBoxCell(); cell.Value = dt.Rows[t]["Dsro_Remark"].ToString().Trim(); dgvr.Cells.Add(cell); LYFZ.BLL.BLL_ErpUser UserBll = new BLL.BLL_ErpUser(); cell = new DataGridViewTextBoxCell(); cell.Value = UserBll.GetUserName(dt.Rows[t]["Dsro_CreateName"].ToString().Trim()); dgvr.Cells.Add(cell); cell = new DataGridViewTextBoxCell(); cell.Value = Convert.ToDateTime(dt.Rows[t]["Dsro_CreateDateTime"].ToString().Trim()).ToString("yyyy-MM-dd"); dgvr.Cells.Add(cell); this.dgv.Rows.Add(dgvr); dgv.ClearSelection(); #endregion } })); } }); try { this.ucPagerEx1.TbDataSource = dt; } catch { } return pageData.TotalCount; } #endregion } }