/// <summary>
/// 填充下拉框：经手人
/// </summary>
private void FillIssuedByList()
{
cbIssuedBy.DisplayMember = "UserName";
cbIssuedBy.ValueMember = "UserId";
cbIssuedBy.DataSource = VoucherBatchManage.DirectGetIssued();
}
/// <summary>
/// 填充下拉框：客户
/// </summary>
private void FillCustomerList()
{
cbCustomerName.DisplayMember = "CustomerName";
cbCustomerName.ValueMember = "CustomerId";
cbCustomerName.DataSource = VoucherBatchManage.DirectGetCustomer();
}
/// <summary>
/// 填充下拉框：票券类型
/// </summary>
private void FillVoucherTypeByList()
{
cbVoucherTypeId.DisplayMember = "VoucherTypeName";
cbVoucherTypeId.ValueMember = "VoucherTypeId";
cbVoucherTypeId.DataSource = VoucherBatchManage.DirectGetVoucherType();
}
/// <summary>
/// 数据显示格式处理
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvList_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
DataGridView dgv = (DataGridView)sender;
if (dgv.Columns[e.ColumnIndex].Name.Contains("Quantity"))
{
try
{
e.Value = decimal.Round(Convert.ToDecimal(e.Value)).ToString() + "张";
}
catch
{
}
}
if (dgv.Columns[e.ColumnIndex].Name.Contains("Price"))
{
try
{
e.Value = decimal.Round(Convert.ToDecimal(e.Value), 2).ToString("0.00") + "元";
}
catch
{
}
}
if (dgv.Columns[e.ColumnIndex].Name == "VoucherTypeId")
{
int?nId;
nId = Convert.ToInt32(e.Value);
try
{
e.Value = VoucherBatchManage.GetVoucherTypeName(Convert.ToInt32(nId));
}
catch { }
}
if (dgvList.Columns[e.ColumnIndex].Name == "CustomerId")
{
int?nId;
nId = Convert.ToInt32(e.Value);
try
{
e.Value = VoucherBatchManage.GetCustomerName(Convert.ToInt32(nId));
}
catch { }
}
if (dgvList.Columns[e.ColumnIndex].Name == "IssuedBy")
{
int?nId;
nId = Convert.ToInt32(e.Value);
try
{
e.Value = VoucherBatchManage.GetSueName(Convert.ToInt32(nId));
}
catch { }
}
}
public frmVoucherBatchManage()
{
InitializeComponent();
dataManager = new VoucherBatchManage();
dataBindingSource = new BindingSource();
this.dataGridViewColumnInfoList = dataManager.ColumnInfoList;
dgvList.CellFormatting += new DataGridViewCellFormattingEventHandler(DataGridView_CellFormatting);
this.Load += new EventHandler(frmFilmInfoManage_Load);
}
/// <summary>
/// 填充下拉框：票券类型
/// </summary>
private void FillVoucherTypeByList()
{
List <VoucherType> voucherTypeList = new List <VoucherType>();
cbVoucherTypeId.DisplayMember = "VoucherTypeName";
cbVoucherTypeId.ValueMember = "VoucherTypeId";
voucherTypeList = VoucherBatchManage.DirectGetVoucherType();
if (voucherTypeList != null || voucherTypeList.Count <= 0)
{
VoucherType vt = new VoucherType();
vt.VoucherTypeName = "全部";
vt.VoucherTypeId = 10000;
voucherTypeList.Add(vt);
}
cbVoucherTypeId.DataSource = voucherTypeList;
}
/// <summary>
/// 填充下拉框cbVoucherId
/// </summary>
public void FillcbVoucherId()
{
List <VoucherBatch> voucherBatchList = new List <VoucherBatch>();
cbVoucherId.DisplayMember = "VoucherBatchId";
cbVoucherId.ValueMember = "VoucherBatchId";
VoucherBatchManage dataManager = new VoucherBatchManage();
voucherBatchList = dataManager.GetDataList();
if (voucherBatchList.Count > 0 || voucherBatchList != null)
{
VoucherBatch vBatch = new VoucherBatch();
vBatch.VoucherName = "全部";
vBatch.VoucherBatchId = "全部";
voucherBatchList.Add(vBatch);
cbVoucherId.DataSource = voucherBatchList;
}
}
private void txtQuantity_Validating(object sender, CancelEventArgs e)
{
if (txtQuantity.Text != "")
{
txtQuantity.Text = (txtQuantity.Text).Replace("张", string.Empty);
if (VoucherBatchManage.IsIntegerNumber(txtQuantity.Text) == false)
{
MessageBox.Show("请输入整数", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtQuantity.DataBindings.Clear();
txtQuantity.DataBindings.Add("Text", dataBindingSource, "Quantity", true);
txtQuantity.DataBindings["Text"].Format += TextBox_Currency_Format;
txtQuantity.DataBindings["Text"].Parse += TextBox_Currency_Parse;
txtQuantity.Clear();
txtQuantity.Focus();
return;
}
}
else
{
txtQuantity.Text = "0";
}
}
private void txtTotalPrice_Validating(object sender, CancelEventArgs e)
{
if (txtTotalPrice.Text != "")
{
txtTotalPrice.Text = txtTotalPrice.Text.Replace("元", string.Empty);
if (VoucherBatchManage.IsNumber(txtTotalPrice.Text) == false)
{
MessageBox.Show("请输入符合的数字", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtTotalPrice.DataBindings.Clear();
txtTotalPrice.DataBindings.Add("Text", dataBindingSource, "TotalPrice", true);
txtTotalPrice.DataBindings["Text"].Format += TextBox_Currency_Format1;
txtTotalPrice.DataBindings["Text"].Parse += TextBox_Currency_Parse1;
txtTotalPrice.Clear();
txtTotalPrice.Focus();
return;
}
}
else
{
txtTotalPrice.Text = "0";
}
}
private void btnEnter_Click(object sender, EventArgs e)
{
try
{
List <VoucherBatch> voucherBatchList = new List <VoucherBatch>();
VoucherBatchManage voucherBatchDataManager = new VoucherBatchManage();
if (chbSearchByNo.Checked && cbVoucherId.SelectedValue != null)
{
if (cbVoucherId.SelectedValue.ToString() == "全部")
{
//var obj = voucherBatchDataManager.GetDataList();
var tmp = voucherBatchDataManager.GetDataList();
if (tmp != null || tmp.Count > 0)
{
foreach (var tmpobj in tmp)
{
var objList = voucherBatchDataManager.GetSearchList("VoucherBatchId", tmpobj.VoucherBatchId);
VoucherBatch obj;
if (dataManage.IsSale(tmpobj.VoucherBatchId.ToString()))
{
obj = objList.Find(p => p.VoucherBatchId == tmpobj.VoucherBatchId);
if (obj != null)
{
obj.Description = "是";
}
}
else
{
obj = objList.Find(p => p.VoucherBatchId == tmpobj.VoucherBatchId);
if (obj != null)
{
obj.Description = "否";
}
}
if (objList != null && objList.Count > 0)
{
voucherBatchList.AddRange(objList);
}
}
dgvList.DataSource = voucherBatchList;
}
}
else
{
var objList = voucherBatchDataManager.GetSearchList("VoucherBatchId", cbVoucherId.SelectedValue.ToString());
if (objList != null && objList.Count > 0)
{
VoucherBatch obj;
if (dataManage.IsSale(cbVoucherId.SelectedValue.ToString()))
{
obj = objList.Find(p => p.VoucherBatchId == cbVoucherId.SelectedValue.ToString());
if (obj != null)
{
obj.Description = "是";
}
}
else
{
obj = objList.Find(p => p.VoucherBatchId == cbVoucherId.SelectedValue.ToString());
if (obj != null)
{
obj.Description = "否";
}
}
}
if (objList != null && objList.Count > 0)
{
voucherBatchList.AddRange(objList);
}
dgvList.DataSource = voucherBatchList;
}
}
else
{
if (cbVoucherTypeId.SelectedValue.ToString() == "10000")
{
dgvList.DataSource = dataManage.dgvSearch(dateTimeFrom.Value, dateTimeTo.Value);
}
else
{
dgvList.DataSource = dataManage.dgvSearch(dateTimeFrom.Value, dateTimeTo.Value, Convert.ToInt32(cbVoucherTypeId.SelectedValue));
}
}
}
catch (Exception ex)
{
MessageBox.Show("没有您要查询的数据!", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}