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
}
}