private void BindData(int ChaseID)
{
DataTable dt = new DAL.Views.V_ChaseTasksTotal().Open("", "ID = " + ChaseID.ToString() + " and UserID=" + _User.ID.ToString(), "");
if ((dt == null) || (dt.Rows.Count < 1))
{
PF.GoError(ErrorNumber.DataReadWrite, "您还没有追号！", this.GetType().FullName);
return;
}
DataRow dr = dt.Rows[0];
labChase_id.Text = ChaseID.ToString();
Label1.Text = dr["LotteryName"].ToString();
Label3.Text = dr["Description"].ToString();
double IsuseMoney, SumMoney, BuyedMoney, QuashedMoney;;
int SumIsuseNum, BuyedIsuseNum, QuashedIsuseNum;
SumMoney = Shove._Convert.StrToDouble(dr["SumMoney"].ToString(), 0);
SumIsuseNum = Shove._Convert.StrToInt(dr["SumIsuseNum"].ToString(), 0);
BuyedIsuseNum = Shove._Convert.StrToInt(dr["BuyedIsuseNum"].ToString(), 0);
QuashedIsuseNum = Shove._Convert.StrToInt(dr["QuashedIsuseNum"].ToString(), 0);
BuyedMoney = Shove._Convert.StrToDouble(dr["BuyedMoney"].ToString(), 0);
QuashedMoney = Shove._Convert.StrToDouble(dr["QuashedMoney"].ToString(), 0);
try
{
IsuseMoney = SumMoney / SumIsuseNum;
}
catch
{
PF.GoError(ErrorNumber.DataReadWrite, "投注记录有错误", this.GetType().FullName);
return;
}
Label4.Text = "</font>共<font color=\'red\'>" + SumIsuseNum.ToString() + "</font>期<font color=\'red\'>" +
SumMoney.ToString("N") + "</font>元; 已完成<font color=\'red\'>" + BuyedIsuseNum.ToString() + "</font>期<font color=\'red\'>" + (BuyedMoney).ToString("N") + "</font>元; 已取消<font color=\'red\'>" +
QuashedIsuseNum.ToString() + "</font>期<font color=\'red\'>" + (QuashedMoney).ToString("N") + "</font>元。";
btnQuash.Enabled = (SumIsuseNum > (BuyedIsuseNum + QuashedIsuseNum));
//填充每期列表
dt = new DAL.Views.V_ChaseTaskDetails().Open("", "ChaseTaskID = " + ChaseID.ToString(), "[DateTime]");
if ((dt == null) || dt.Rows.Count < 1)
{
PF.GoError(ErrorNumber.DataReadWrite, "没有追号记录", this.GetType().FullName);
return;
}
LbPlayTypeName.Text = dt.Rows[0]["PlayTypeName"].ToString(); //买法类型
PF.DataGridBindData(g, dt);
}
private void BtnThongKeNhieuNgay_Click(object sender, EventArgs e)
{
if (cboKho.SelectedIndex == -1)
{
MessageBox.Show("Bạn chưa chọn kho", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
String fromTime = Convert.ToString(fromDateTimeInput.Value);
string[] fromDateTime = fromTime.Split(' ');
string[] fromDateArray = fromDateTime[0].Split('/');
string fromDateSearch = "";
fromDateSearch = fromDateArray[2] + "-" + fromDateArray[0] + "-" + fromDateArray[1];
String toTime = Convert.ToString(toDateTimeInput.Value);
string[] toDateTime = toTime.Split(' ');
string[] toDateArray = toDateTime[0].Split('/');
string toDateSearch = "";
toDateSearch = toDateArray[2] + "-" + toDateArray[0] + "-" + toDateArray[1];
SqlCommand cmd = new SqlCommand();
cmd.CommandText = @"select kx.MaPT as 'Mã phụ tùng', pt.TenPT as 'Tên phụ tùng', SUM(kx.SoLuong) as 'Tổng số lượng', pt.DonGia as 'Đơn giá', SUM(kx.SoLuong)*pt.DonGia as 'Tiền'
from dbo.KhoXuat kx inner join dbo.PhuTung pt on kx.MaPT = pt.MaPT WHERE kx.IdCongTy = @IdCongTy and pt.IdCongTy = @IdCongTy and pt.IdKho = @idkho and kx.IdKho = @idkho and
CONVERT(varchar(25),NgayXuat,126) between @tungay and @denngay group by kx.MaPT, pt.TenPT, pt.DonGia ";
cmd.Parameters.AddWithValue("@tungay", fromDateSearch + "%");
cmd.Parameters.AddWithValue("@denngay", toDateSearch + "%");
cmd.Parameters.AddWithValue("@IdCongTy", int.Parse(Class.CompanyInfo.idcongty.ToString()));
cmd.Parameters.AddWithValue("@idkho", cboKho.SelectedValue);
bangPhuTung = Class.datatabase.getData(cmd);
object SumMoney;
if (bangPhuTung.Rows.Count > 0)
{
SumMoney = bangPhuTung.Compute("Sum(Tiền)", "");
}
else
{
SumMoney = 0;
}
lbTongTien.Text = string.Format("{0:#,#.}", Decimal.Parse(SumMoney.ToString()));
dataGridViewX1.DataSource = bangPhuTung;
}
private void BtnSearch_Click(object sender, EventArgs e)
{
danhSachBienSo = new List <string>();
String dateTimeSearch = Convert.ToString(dateTimeInput.Value);
string[] dateSearch = dateTimeSearch.Split(' ');
string[] dateSearchArray = dateSearch[0].Split('/');
dateSearchReal = dateSearchArray[2] + "-" + dateSearchArray[0] + "-" + dateSearchArray[1];
using (SqlConnection myCon = new SqlConnection(Class.datatabase.connect))
{
if (myCon.State == ConnectionState.Closed)
{
myCon.Open();
}
SqlCommand cmd = new SqlCommand();
cmd.Connection = myCon;
SqlTransaction transaction;
transaction = myCon.BeginTransaction();
cmd.Transaction = transaction;
try
{
cmd.CommandText = @"select lsbd.TenXe as 'Tên xe', lsbd.BienSo as 'Biển số', pt.SoTienThu as 'Tiền' from dbo.LichSuBaoDuongXe lsbd inner join dbo.PhieuThu pt on lsbd.IdBaoDuong = pt.SoHoaDon where
lsbd.IdCongty = @IdCongTy and CONVERT(nvarchar(25),lsbd.NgayGiaoXe,126) like @NgayGiaoXe and pt.NgayHachToan like @NgayGiaoXe and pt.IdLoaiPhieuThu = 5";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@NgayGiaoXe", "%" + dateSearchReal.Trim() + "%");
cmd.Parameters.AddWithValue("@IdCongty", Class.CompanyInfo.idcongty);
SqlDataAdapter dataAdapter = new SqlDataAdapter(cmd);
DataTable bangPhuTung = new DataTable();
dgvDanhSachBaoDuong.DataSource = bangPhuTung;
dataAdapter.Fill(bangPhuTung);
object SumMoney;
if (bangPhuTung.Rows.Count > 0)
{
SumMoney = bangPhuTung.Compute("Sum(Tiền)", "");
}
else
{
SumMoney = 0;
}
lbTotalMoney.Text = string.Format("{0:#,#.}", Decimal.Parse(SumMoney.ToString()));
dgvDanhSachBaoDuong.DataSource = bangPhuTung;
for (int i = 0; i < dgvDanhSachBaoDuong.Rows.Count; i++)
{
dgvDanhSachBaoDuong.Rows[i].Cells[2].Value = string.Format("{0:#,#.}", Convert.ToString(dgvDanhSachBaoDuong.Rows[i].Cells[2].Value));
}
transaction.Commit();
//MessageBox.Show("Thống kê thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
lbSoLuong.Text = (dgvDanhSachBaoDuong.Rows.Count).ToString();
if (myCon.State == ConnectionState.Open)
{
myCon.Close();
}
}
catch (Exception ex)
{
transaction.Rollback();
if (myCon.State == ConnectionState.Open)
{
myCon.Close();
}
MessageBox.Show(ex.Message, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void FrmPhieuXuatKhoNgoai_Load(object sender, EventArgs e)
{
if (_trangThaiPhieu.Equals("dx"))
{
btnHuyPhieu.Enabled = false;
button1.Enabled = false;
cboSheet.Enabled = false;
btnXacNhanPhieu.Enabled = false;
btnTaiLaiPhieu.Enabled = false;
}
SqlCommand cmd = new SqlCommand();
cmd.CommandText = @"Select *from dbo.LichSuXuatKhoNgoai where IdXuatKho = @idxuatkho";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@idxuatkho", int.Parse(__idXuatKho));
DataTable trangthai = Class.datatabase.getData(cmd);
if (trangthai.Rows.Count > 0)
{
_idKho = trangthai.Rows[0]["IdKhoXuat"].ToString().Trim();
_idCongTy = trangthai.Rows[0]["IdCongTy"].ToString().Trim();
_idCuaHang = trangthai.Rows[0]["IdCuaHang"].ToString().Trim();
if (int.Parse(trangthai.Rows[0]["TrangThaiXuat"].ToString().Trim()) == 1)
{
label2.Text = "Phiếu này đã xuất";
}
else
{
label2.Text = "Phiếu này chưa xuất";
}
}
else
{
MessageBox.Show("Tải phiếu lỗi hoặc phiếu đã bị xóa\nHãy thao tác lại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
cmd.CommandText = @"SELECT ROW_NUMBER() OVER (ORDER BY MaPT) AS 'STT', MaPT, TenPT, SoLuong, DonGia, SoLuong*DonGia as 'TongTien',IdCongTy,IdKho From dbo.LichSuXuatKhoNgoaiChiTiet where IdXuatKho = @idxuatkho";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@idxuatkho", int.Parse(__idXuatKho));
DataTable dsPhuTung = Class.datatabase.getData(cmd);
object SumMoney;
if (dsPhuTung.Rows.Count > 0)
{
SumMoney = dsPhuTung.Compute("Sum(TongTien)", "");
}
else
{
SumMoney = 0;
}
string[] ngayGioXuatPhieu = trangthai.Rows[0]["NgayXuat"].ToString().Split(' ');
string[] ngayThangXuat = ngayGioXuatPhieu[0].Split('/');
if (_trangThaiPhieu.Equals("dx"))
{
Microsoft.Reporting.WinForms.ReportParameter[] rPrams = new Microsoft.Reporting.WinForms.ReportParameter[]
{
new Microsoft.Reporting.WinForms.ReportParameter("GioXuat", ngayGioXuatPhieu[1] + " " + ngayGioXuatPhieu[2]),
new Microsoft.Reporting.WinForms.ReportParameter("NgayXuat", ngayThangXuat[2]),
new Microsoft.Reporting.WinForms.ReportParameter("ThangXuat", ngayThangXuat[1]),
new Microsoft.Reporting.WinForms.ReportParameter("NamXuat", ngayThangXuat[0]),
new Microsoft.Reporting.WinForms.ReportParameter("KhoXuat", Class.CompanyInfo.tencongty),
new Microsoft.Reporting.WinForms.ReportParameter("KhoNhap", trangthai.Rows[0]["TenCongTyNhan"].ToString()),
new Microsoft.Reporting.WinForms.ReportParameter("TongTien", string.Format("{0:#,#.}", Decimal.Parse(SumMoney.ToString()))),
};
ReportDataSource reportDataSource = new ReportDataSource();
reportDataSource.Name = "DataSet1";
reportDataSource.Value = dsPhuTung;
reportViewer1.LocalReport.DataSources.Clear();
reportViewer1.LocalReport.SetParameters(rPrams);
reportViewer1.LocalReport.DataSources.Add(reportDataSource);
reportViewer1.RefreshReport();
this.reportViewer1.RefreshReport();
}
else
{
Microsoft.Reporting.WinForms.ReportParameter[] rPrams = new Microsoft.Reporting.WinForms.ReportParameter[]
{
new Microsoft.Reporting.WinForms.ReportParameter("GioXuat", DateTime.Now.ToString("HH:mm:ss")),
new Microsoft.Reporting.WinForms.ReportParameter("NgayXuat", DateTime.Now.ToString("dd")),
new Microsoft.Reporting.WinForms.ReportParameter("ThangXuat", DateTime.Now.ToString("MM")),
new Microsoft.Reporting.WinForms.ReportParameter("NamXuat", DateTime.Now.ToString("yyyy")),
new Microsoft.Reporting.WinForms.ReportParameter("KhoXuat", Class.CompanyInfo.tencongty),
new Microsoft.Reporting.WinForms.ReportParameter("KhoNhap", trangthai.Rows[0]["TenCongTyNhan"].ToString()),
new Microsoft.Reporting.WinForms.ReportParameter("TongTien", string.Format("{0:#,#.}", Decimal.Parse(SumMoney.ToString()))),
};
ReportDataSource reportDataSource = new ReportDataSource();
reportDataSource.Name = "DataSet1";
reportDataSource.Value = dsPhuTung;
reportViewer1.LocalReport.DataSources.Clear();
reportViewer1.LocalReport.SetParameters(rPrams);
reportViewer1.LocalReport.DataSources.Add(reportDataSource);
reportViewer1.RefreshReport();
this.reportViewer1.RefreshReport();
}
}
private void BtnTaiLaiPhieu_Click(object sender, EventArgs e)
{
btnTaiLaiPhieu.Enabled = false;
using (SqlConnection myCon = new SqlConnection(Class.datatabase.connect))
{
if (myCon.State == ConnectionState.Closed)
{
myCon.Open();
}
SqlCommand cmd = new SqlCommand();
cmd.Connection = myCon;
SqlTransaction transaction;
transaction = myCon.BeginTransaction();
cmd.Transaction = transaction;
try
{
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
cmd.CommandText = @"Select * from dbo.LichSuXuatKhoNgoaiChiTiet where MaPT = @MaPT and IdCongTy = @IdCongTy and IdKho = @IdKho and IdXuatKho = @idxuatkho";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@MaPT", dataGridView1.Rows[i].Cells[0].Value.ToString().Trim());
cmd.Parameters.AddWithValue("@IdCongTy", Class.CompanyInfo.idcongty);
cmd.Parameters.AddWithValue("@IdKho", int.Parse(_idKho));
cmd.Parameters.AddWithValue("@idxuatkho", int.Parse(__idXuatKho));
SqlDataAdapter adap = new SqlDataAdapter(cmd);
DataTable phuTungTemp = new DataTable();
adap.Fill(phuTungTemp);
if (phuTungTemp.Rows.Count > 0)
{
int soluongtruoc = 0;
int soLuongtru = 0;
int soLuongSau = 0;
soluongtruoc = Convert.ToInt32(phuTungTemp.Rows[0]["SoLuong"]);
soLuongtru = int.Parse(dataGridView1.Rows[i].Cells[2].Value.ToString().Trim());
soLuongSau = soluongtruoc + soLuongtru;
cmd.CommandText = @"Update dbo.LichSuXuatKhoNgoaiChiTiet SET SoLuong = @SoLuong where MaPT = @MaPT and IdCongTy = @IdCongTy and IdKho = @IdKho and IdXuatKho = @idxuatkho";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@SoLuong", soLuongSau);
cmd.Parameters.AddWithValue("@MaPT", dataGridView1.Rows[i].Cells[0].Value.ToString().Trim());
cmd.Parameters.AddWithValue("@IdCongTy", Class.CompanyInfo.idcongty);
cmd.Parameters.AddWithValue("@IdKho", int.Parse(_idKho));
cmd.Parameters.AddWithValue("@idxuatkho", int.Parse(__idXuatKho));
cmd.ExecuteNonQuery();
}
else
{
cmd.CommandText = @"insert into dbo.LichSuXuatKhoNgoaiChiTiet(IdXuatKho, MaPT, TenPT, SoLuong, DonGia, IdKho, IdCongTy) values
(@idxuatkho, @MaPT, @TenPT, @SoLuong, @dongia, @idkho, @idcongty)";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@idxuatkho", int.Parse(__idXuatKho));
cmd.Parameters.AddWithValue("@MaPT", dataGridView1.Rows[i].Cells[0].Value.ToString().Trim());
cmd.Parameters.AddWithValue("@TenPT", dataGridView1.Rows[i].Cells[1].Value.ToString().Trim());
cmd.Parameters.AddWithValue("@SoLuong", int.Parse(dataGridView1.Rows[i].Cells[2].Value.ToString().Trim()));
cmd.Parameters.AddWithValue("@dongia", int.Parse(dataGridView1.Rows[i].Cells[3].Value.ToString().Trim()));
cmd.Parameters.AddWithValue("@idkho", int.Parse(_idKho));
cmd.Parameters.AddWithValue("@idcongty", Class.CompanyInfo.idcongty);
cmd.ExecuteNonQuery();
}
}
cmd.CommandText = @"Select *from dbo.LichSuXuatKhoNgoai where IdXuatKho = @idxuatkho";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@idxuatkho", int.Parse(__idXuatKho));
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataTable trangthai = new DataTable();
adapter.Fill(trangthai);
if (trangthai.Rows.Count > 0)
{
}
else
{
MessageBox.Show("Tải phiếu lỗi hoặc phiếu đã bị xóa\nHãy thao tác lại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
cmd.CommandText = @"SELECT ROW_NUMBER() OVER (ORDER BY MaPT) AS 'STT', MaPT, TenPT, SoLuong, DonGia, SoLuong*DonGia as 'TongTien',IdCongTy,IdKho From dbo.LichSuXuatKhoNgoaiChiTiet where IdXuatKho = @idxuatkho";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@idxuatkho", int.Parse(__idXuatKho));
SqlDataAdapter ad = new SqlDataAdapter(cmd);
DataTable pt = new DataTable();
ad.Fill(pt);
object SumMoney;
if (pt.Rows.Count > 0)
{
SumMoney = pt.Compute("Sum(TongTien)", "");
}
else
{
SumMoney = 0;
}
Microsoft.Reporting.WinForms.ReportParameter[] rPrams = new Microsoft.Reporting.WinForms.ReportParameter[]
{
new Microsoft.Reporting.WinForms.ReportParameter("GioXuat", DateTime.Now.ToString("HH:mm:ss")),
new Microsoft.Reporting.WinForms.ReportParameter("NgayXuat", DateTime.Now.ToString("dd")),
new Microsoft.Reporting.WinForms.ReportParameter("ThangXuat", DateTime.Now.ToString("MM")),
new Microsoft.Reporting.WinForms.ReportParameter("NamXuat", DateTime.Now.ToString("yyyy")),
new Microsoft.Reporting.WinForms.ReportParameter("KhoXuat", Class.CompanyInfo.tencongty),
new Microsoft.Reporting.WinForms.ReportParameter("KhoNhap", trangthai.Rows[0]["TenCongTyNhan"].ToString()),
new Microsoft.Reporting.WinForms.ReportParameter("TongTien", string.Format("{0:#,#.}", Decimal.Parse(SumMoney.ToString()))),
};
ReportDataSource reportDataSource = new ReportDataSource();
reportDataSource.Name = "DataSet1";
reportDataSource.Value = pt;
reportViewer1.LocalReport.DataSources.Clear();
reportViewer1.LocalReport.SetParameters(rPrams);
reportViewer1.LocalReport.DataSources.Add(reportDataSource);
reportViewer1.RefreshReport();
this.reportViewer1.RefreshReport();
dataGridView1.DataSource = pt;
dataGridView1.Columns.Remove("STT");
dataGridView1.Columns.Remove("IdCongTy");
dataGridView1.Columns.Remove("IdKho");
transaction.Commit();
MessageBox.Show("Tải thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
transaction.Rollback();
MessageBox.Show(ex.Message);
}
finally { }
}
}
private void BindData(int ChaseID)
{
string Key = "Home_Room_ChaseExecutedSchemes_BindData_" + ChaseID.ToString();
DataTable dtChase = Shove._Web.Cache.GetCacheAsDataTable(Key);
StringBuilder sb = new StringBuilder();
if (dtChase == null || dtChase.Rows.Count == 0)
{
sb.Append("select Title,Name,IsuseCount,IsuseCount*Multiple*Nums*Price as SumMoney,Money,QuashStatus,ExecutedCount,ExecutedCount*Multiple*Nums*Price as ExcutedMoney,")
.Append("IsuseCount-ExecutedCount as NoExecutedCount,Title,StopTypeWhenWin,StopTypeWhenWinMoney from T_Chases a inner join T_Lotteries b ")
.Append("on a.LotteryID = b.ID and a.ID=" + ChaseID.ToString() + " ")
.Append("left join (select ChaseID,count(SchemeID) as ExecutedCount from T_ExecutedChases group by ChaseID)c on a.ID = c.ChaseID");
dtChase = Shove.Database.MSSQL.Select(sb.ToString());
if (dtChase == null || dtChase.Rows.Count == 0)
{
PF.GoError(ErrorNumber.DataReadWrite, "此记录不存在或已被删除！", this.GetType().FullName);
return;
}
Shove._Web.Cache.SetCache(Key, dtChase);
}
DataRow dr = dtChase.Rows[0];
lbLotteryName.Text = dr["Name"].ToString();
lbTitle.Text = dr["Title"].ToString();
if (dr["StopTypeWhenWin"].ToString() == "1")
{
lbStopCondition.Text = "完成方案";
}
else
{
lbStopCondition.Text = "单期中奖金额达到" + dr["StopTypeWhenWinMoney"].ToString();
}
double SumMoney, BuyedMoney, QuashedMoney;;
int SumIsuseNum, BuyedIsuseNum, QuashedIsuseNum;
SumMoney = Shove._Convert.StrToDouble(dr["SumMoney"].ToString(), 0);
SumIsuseNum = Shove._Convert.StrToInt(dr["IsuseCount"].ToString(), 0);
BuyedIsuseNum = Shove._Convert.StrToInt(dr["ExecutedCount"].ToString(), 0);
QuashedIsuseNum = Shove._Convert.StrToInt(dr["NoExecutedCount"].ToString(), 0);
BuyedMoney = Shove._Convert.StrToDouble(dr["ExcutedMoney"].ToString(), 0);
QuashedMoney = Shove._Convert.StrToDouble(dr["Money"].ToString(), 0);
lbDescription.Text = "</font>共<font color=\'red\'>" + SumIsuseNum.ToString() + "</font>期<font color=\'red\'>" +
SumMoney.ToString("N") + "</font>元; 已完成<font color=\'red\'>" + BuyedIsuseNum.ToString() + "</font>期<font color=\'red\'>" + (BuyedMoney).ToString("N") + "</font>元; 未执行<font color=\'red\'>" +
QuashedIsuseNum.ToString() + "</font>期<font color=\'red\'>" + (QuashedMoney).ToString("N") + "</font>元。";
//填充每期列表
Key = "Home_Room_ChaseExecutedSchemes_BindDataDetails_" + ChaseID.ToString();
DataTable dt = Shove._Web.Cache.GetCacheAsDataTable(Key);
sb = new StringBuilder();
if (dt == null)
{
sb.Append("select PlayTypeName,ID,IsuseName,LotteryNumber,Multiple,Money,QuashStatus,Buyed from T_ExecutedChases a inner join V_Schemes b ")
.Append("on a.SchemeID = b.ID and a.ChaseID =" + ChaseID.ToString() + " order by ID");
dt = Shove.Database.MSSQL.Select(sb.ToString());
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "您还没有追号！", this.GetType().FullName);
return;
}
Shove._Web.Cache.SetCache(Key, dt);
}
if (dt.Rows.Count > 0)
{
lbPlayTypeName.Text = dt.Rows[0]["PlayTypeName"].ToString(); //买法类型
}
PF.DataGridBindData(g, dt);
}
private void BindData(int ChaseID)
{
StringBuilder sb = new StringBuilder();
sb.Append("select Title,Name,IsuseCount,IsuseCount*Multiple*Nums*Price as SumMoney,Money,QuashStatus,ExecutedCount,ExecutedCount*Multiple*Nums*Price as ExcutedMoney,")
.Append("IsuseCount-ExecutedCount as NoExecutedCount,Title,StopTypeWhenWin,StopTypeWhenWinMoney from T_Chases a inner join T_Lotteries b ")
.Append("on a.LotteryID = b.ID and a.ID=" + ChaseID.ToString() + " ")
.Append("left join (select ChaseID,count(SchemeID) as ExecutedCount from T_ExecutedChases group by ChaseID)c on a.ID = c.ChaseID");
DataTable dtChase = Shove.Database.MSSQL.Select(sb.ToString());
if (dtChase == null || dtChase.Rows.Count == 0)
{
PF.GoError(ErrorNumber.DataReadWrite, "您还没有追号！", this.GetType().FullName);
return;
}
DataRow dr = dtChase.Rows[0];
lbLotteryName.Text = dr["Name"].ToString();
labTitle.Text = dr["Title"].ToString();
if (dr["StopTypeWhenWin"].ToString() == "1")
{
lbStopCondition.Text = "完成方案";
}
else
{
lbStopCondition.Text = "单期中奖金额达到" + dr["StopTypeWhenWinMoney"].ToString();
}
double SumMoney, BuyedMoney, QuashedMoney;;
int SumIsuseNum, BuyedIsuseNum, QuashedIsuseNum;
SumMoney = Shove._Convert.StrToDouble(dr["SumMoney"].ToString(), 0);
SumIsuseNum = Shove._Convert.StrToInt(dr["IsuseCount"].ToString(), 0);
BuyedIsuseNum = Shove._Convert.StrToInt(dr["ExecutedCount"].ToString(), 0);
QuashedIsuseNum = Shove._Convert.StrToInt(dr["NoExecutedCount"].ToString(), 0);
BuyedMoney = Shove._Convert.StrToDouble(dr["ExcutedMoney"].ToString(), 0);
QuashedMoney = Shove._Convert.StrToDouble(dr["Money"].ToString(), 0);
lbDescription.Text = "</font>共<font color=\'red\'>" + SumIsuseNum.ToString() + "</font>期<font color=\'red\'>" +
SumMoney.ToString("N") + "</font>元; 已完成<font color=\'red\'>" + BuyedIsuseNum.ToString() + "</font>期<font color=\'red\'>" + (BuyedMoney).ToString("N") + "</font>元; 未执行<font color=\'red\'>" +
QuashedIsuseNum.ToString() + "</font>期<font color=\'red\'>" + (QuashedMoney).ToString("N") + "</font>元。";
string sql = "select c.Name as PlayTypeName,b.ID,d.Name as IsuseName,LotteryNumber,Multiple,Money,QuashStatus,Buyed " +
"from T_ExecutedChases a inner join T_Schemes b on a.SchemeID = b.ID and a.ChaseID =@ChaseID " +
"inner join T_PlayTypes c on b.PlayTypeID = c.ID " +
"inner join T_Isuses d on b.IsuseID = d.ID";
//sb = new StringBuilder();
//sb.Append("select PlayTypeName,ID,IsuseName,LotteryNumber,Multiple,Money,QuashStatus,Buyed from T_ExecutedChases a inner join V_Schemes b ")
// .Append("on a.SchemeID = b.ID and a.ChaseID =" + ChaseID.ToString() + "");
DataTable dt = Shove.Database.MSSQL.Select(sql, new Shove.Database.MSSQL.Parameter("ChaseID", SqlDbType.BigInt, 0, ParameterDirection.Input, ChaseID.ToString()));
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "您还没有追号！", this.GetType().FullName);
return;
}
if (dt.Rows.Count > 0)
{
lbPlayTypeName.Text = dt.Rows[0]["PlayTypeName"].ToString(); //买法类型
}
PF.DataGridBindData(g, dt);
}
private void FrmPhieuXuatKhoNoiBoVietLong_Load(object sender, EventArgs e)
{
if (lichSu.Equals("ls"))
{
btnXacNhanXuatKho.Enabled = false;
btnHuyDon.Enabled = false;
}
else if (donCheck.Equals("dck"))
{
btnXacNhanXuatKho.Enabled = false;
}
else
{
btnHuyDon.Enabled = false;
}
SqlCommand cmd = new SqlCommand();
cmd.CommandText = @"Select TenCuaHang from CuaHang ch inner join LichSuDatPhuTung lsdpt on ch.IdCongTy = lsdpt.IdCongTyNhan where lsdpt.IdXuatKho = @idxuatkho and CONVERT(varchar(25),lsdpt.NgayDat,126) like @ngaydat";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@idxuatkho", int.Parse(idXuatKho));
cmd.Parameters.AddWithValue("@ngaydat", "%" + dateReal + "%");
DataTable tableName = Class.datatabase.getData(cmd);
cmd.CommandText = @"Select TenCuaHang from CuaHang ch inner join LichSuDatPhuTung lsdpt on ch.IdCongTy = lsdpt.IdCongTyXuat where lsdpt.IdXuatKho = @idxuatkho and CONVERT(varchar(25),lsdpt.NgayDat,126) like @ngaydat";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@idxuatkho", int.Parse(idXuatKho));
cmd.Parameters.AddWithValue("@ngaydat", "%" + dateReal + "%");
DataTable tableNameXuat = Class.datatabase.getData(cmd);
if (donCheck.Equals("dck"))
{
cmd.CommandText = @"SELECT ROW_NUMBER() OVER (ORDER BY MaPT) AS 'STT', * From dbo.LichSuDatPhuTungChiTiet where IdXuatKho = @idxuatkho";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@idxuatkho", int.Parse(idXuatKho));
}
else
{
cmd.CommandText = @"LayChiTietPhuTungTheoDonDat @idxuatkho,@idcongty";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@idxuatkho", int.Parse(idXuatKho));
cmd.Parameters.AddWithValue("@idcongty", Class.CompanyInfo.idcongty);
}
DataTable dsPhuTung = Class.datatabase.getData(cmd);
object SumMoney;
if (dsPhuTung.Rows.Count > 0)
{
SumMoney = dsPhuTung.Compute("Sum(TongTien)", "");
}
else
{
SumMoney = 0;
}
if (lichSu.Equals("ls"))
{
cmd.CommandText = @"select * from dbo.LichSuDatPhuTung where IdXuatKho = @idxuatkho and IdCongTyXuat = @idcongty";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@idxuatkho", int.Parse(idXuatKho));
cmd.Parameters.AddWithValue("@idcongty", Class.CompanyInfo.idcongty);
DataTable dsPhuTung1 = Class.datatabase.getData(cmd);
string ngayGioXuatKho = dsPhuTung1.Rows[0]["NgayXuat"].ToString().Trim();
string[] arrayNgayGioXuatKho = ngayGioXuatKho.Split(' ');
string[] arrayNgayXuatKho = arrayNgayGioXuatKho[0].Split('/');
Microsoft.Reporting.WinForms.ReportParameter[] rPrams = new Microsoft.Reporting.WinForms.ReportParameter[]
{
new Microsoft.Reporting.WinForms.ReportParameter("GioXuatKho", arrayNgayGioXuatKho[1].ToString()),
new Microsoft.Reporting.WinForms.ReportParameter("NgayXuatKho", arrayNgayXuatKho[2].ToString()),
new Microsoft.Reporting.WinForms.ReportParameter("ThangXuatKho", arrayNgayXuatKho[1].ToString()),
new Microsoft.Reporting.WinForms.ReportParameter("NamXuatKho", arrayNgayXuatKho[0].ToString()),
new Microsoft.Reporting.WinForms.ReportParameter("KhoXuat", tableNameXuat.Rows[0]["TenCuaHang"].ToString()),
new Microsoft.Reporting.WinForms.ReportParameter("KhoNhap", tableName.Rows[0]["TenCuaHang"].ToString()),
new Microsoft.Reporting.WinForms.ReportParameter("TongTien", string.Format("{0:#,#.}", Decimal.Parse(SumMoney.ToString()))),
};
ReportDataSource reportDataSource = new ReportDataSource();
reportDataSource.Name = "DataSet1";
reportDataSource.Value = dsPhuTung;
reportViewer1.LocalReport.DataSources.Clear();
reportViewer1.LocalReport.SetParameters(rPrams);
reportViewer1.LocalReport.DataSources.Add(reportDataSource);
reportViewer1.RefreshReport();
this.reportViewer1.RefreshReport();
}
else
{
Microsoft.Reporting.WinForms.ReportParameter[] rPrams = new Microsoft.Reporting.WinForms.ReportParameter[]
{
new Microsoft.Reporting.WinForms.ReportParameter("GioXuatKho", DateTime.Now.ToString("HH:mm:ss")),
new Microsoft.Reporting.WinForms.ReportParameter("NgayXuatKho", DateTime.Now.ToString("dd")),
new Microsoft.Reporting.WinForms.ReportParameter("ThangXuatKho", DateTime.Now.ToString("MM")),
new Microsoft.Reporting.WinForms.ReportParameter("NamXuatKho", DateTime.Now.ToString("yyyy")),
new Microsoft.Reporting.WinForms.ReportParameter("KhoXuat", tableNameXuat.Rows[0]["TenCuaHang"].ToString()),
new Microsoft.Reporting.WinForms.ReportParameter("KhoNhap", tableName.Rows[0]["TenCuaHang"].ToString()),
new Microsoft.Reporting.WinForms.ReportParameter("TongTien", string.Format("{0:#,#.}", Decimal.Parse(SumMoney.ToString()))),
};
ReportDataSource reportDataSource = new ReportDataSource();
reportDataSource.Name = "DataSet1";
reportDataSource.Value = dsPhuTung;
reportViewer1.LocalReport.DataSources.Clear();
reportViewer1.LocalReport.SetParameters(rPrams);
reportViewer1.LocalReport.DataSources.Add(reportDataSource);
reportViewer1.RefreshReport();
this.reportViewer1.RefreshReport();
}
}
