private void btnDelete_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
waiting.ShowWaitForm();
if (gridItemDetail.FocusedRowHandle > -1)//duyệt từ dòng đầu tiên trên lưới
{
string code = gridItemDetail.GetFocusedRowCellValue(colOrderCode).ToString();
Class.clsListOrder cls = new Class.clsListOrder();
cls.OrderCode = code;
if (MessageBox.Show("Bạn có chắc chắn muốn xoá hay không ?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
cls.Delete();
MessageBox.Show("Xóa thành công");
tbOrder_GetList();
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
waiting.CloseWaitForm();
}
public frmListOrder_Update(string code)
{
InitializeComponent();
LoadListSupplier();
statusForm = false;
lbstatus = "Chỉnh sửa";
lblChoose.Text = "Tình trạng đang: <b>[" + lbstatus.ToString() + "]</b>";
Class.clsListOrder cls = new Class.clsListOrder();
cls.OrderCode = code;
DataTable dt = cls.tbOrder_Get();
if (dt.Rows.Count > 0) {
// txtOrderCode.Enabled = false;
txtOrderCode.Text = dt.Rows[0]["OrderCode"].ToString();
dateSuggestDate.DateTime = (DateTime)dt.Rows[0]["DateSuggest"];
cboFollowers.Text = dt.Rows[0]["Followers"].ToString();
dateDeliveryDate.DateTime = (DateTime)dt.Rows[0]["DeliveryDate"];
txtPlaceOfDelivery.Text = dt.Rows[0]["PlaceOfDelivery"].ToString();
txtPaymentConditions.Text = dt.Rows[0]["PaymentConditions"].ToString();
cboCurrencyUnit.Text = dt.Rows[0]["CurrencyUnit"].ToString();
cboSupplier.Text = dt.Rows[0]["SupplierCode"].ToString();
txtVAT.Text = dt.Rows[0]["VAT"].ToString();
LoadOrderDetails(dt.Rows[0]["OrderCode"].ToString());//load du lieu vao luoi chi tiet ddh dua vao OrderCode
}
this.Text = "Cập nhật đơn đặt hàng: " + dt.Rows[0]["OrderCode"].ToString();
}
private void btnDaDuyet_Click(object sender, EventArgs e)
{
string txt = "Đã duyệt";
Class.clsListOrder cls = new Class.clsListOrder();
string code = gridItemDetail.GetFocusedRowCellValue(colOrderCode).ToString();
cls.OrderCode = code;
cls.Status = txt;
cls.UpdateStatus();
tbOrder_GetList();
}
//Xử lý nút xóa
private void btnDelete_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (gridItemDetail.FocusedRowHandle > -1)
{
waiting.ShowWaitForm();
string code = gridItemDetail.GetFocusedRowCellValue(colSupplierCode).ToString();
Class.clsListSupplier cls = new Class.clsListSupplier();
cls.SupplierCode = code;
Class.clsListOrder clsorder = new Class.clsListOrder();
DataTable dt = new DataTable();
dt = clsorder.tbOrder_GetList();
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["SupplierCode"].ToString() == cls.SupplierCode)
{
MessageBox.Show("Nhà cung cấp này đang còn đơn hàng.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
}
if (MessageBox.Show("Bạn có chắc chắn muốn xoá hay không ?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
cls.Delete();
MessageBox.Show("Xóa thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
tbSupplier_GetList();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
waiting.CloseWaitForm();
}
//tao cot ma don hang tu dong
void AutoOrderCode()
{
Class.clsListOrder cls = new Class.clsListOrder();
cls.Year = DateTime.Now.Year;
DataTable dt = cls.tbOrder_GetAutocode();
if (dt.Rows.Count < 1)
{
txtOrderCode.Text = DateTime.Now.Year + "-0001";
}
else
{
string txt = dt.Rows[dt.Rows.Count - 1]["OrderCode"].ToString();
string codetemp = txt.Substring(5);
int number = int.Parse(codetemp);
number++;
if (number.ToString().Length == 3) {
txtOrderCode.Text = DateTime.Now.Year + "-0" + number.ToString();
}
if (number.ToString().Length == 2)
{
txtOrderCode.Text = DateTime.Now.Year + "-00" + number.ToString();
}
if (number.ToString().Length == 1)
{
txtOrderCode.Text = DateTime.Now.Year + "-000" + number.ToString();
}
if (number.ToString().Length == 4)
{
txtOrderCode.Text = DateTime.Now.Year + "-" + number.ToString();
}
}
}
void LoadOrderDetails(string Ordercode)
{
Class.clsListOrder cls = new Class.clsListOrder();
cls.OrderCode = Ordercode;
dtOrderDetail = cls.tbOrderDetails_GetByCode();
gridItem.DataSource = dtOrderDetail;
cls.OrderCode = "";
dtOrderDetailTemp = cls.tbOrderDetails_GetByCode();
}
void LoadOrderDetails()
{
Class.clsListOrder cls = new Class.clsListOrder();
cls.OrderCode = "";
dtOrderDetail = cls.tbOrderDetails_GetByCode();
gridItem.DataSource = dtOrderDetail;
dtOrderDetail.Clear();
}
private void btnSave_Click(object sender, EventArgs e)
{
//Ran buoc du lieu form
if (txtOrderCode.Text.Trim() == "")
{
MessageBox.Show("Bạn chưa nhập mã đơn đặt hàng");
txtOrderCode.Focus();
return;
}
if (cboSupplier.EditValue == null)
{
MessageBox.Show("Bạn chưa chọn nhà cung cấp");
cboSupplier.Focus();
return;
}
if (dtOrderDetail.Rows.Count < 1) {
MessageBox.Show("Vui lòng nhập chi tiết đơn hàng.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (statusForm)
{
Class.clsListOrder cls = new Class.clsListOrder();
cls.OrderCode = txtOrderCode.Text;
cls.DateSuggest = dateSuggestDate.DateTime;
DateTime date = Convert.ToDateTime(cls.DateSuggest);
if (date.Year != DateTime.Now.Year)
{
MessageBox.Show("Xoá không thành công.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
dateSuggestDate.Focus();
return;
}
cls.Followers = cboFollowers.Text;
cls.SupplierCode = cboSupplier.EditValue.ToString();
cls.DeliveryDate = dateDeliveryDate.DateTime;
cls.PlaceOfDelivery = txtPlaceOfDelivery.Text;
cls.PaymentConditions = txtPaymentConditions.Text;
cls.CurrencyUnit = cboCurrencyUnit.Text;
if (txtVAT.EditValue == null)
{
cls.VAT = 0;
}
else
{
cls.VAT = int.Parse(txtVAT.EditValue.ToString());
}
if (cls.Insert(dtOrderDetail))
{
MessageBox.Show("Thêm thành công");
this.Close();
}
else
{
MessageBox.Show("Thêm thất bại");
}
}
else
{
Class.clsListOrder cls = new Class.clsListOrder();
cls.OrderCode = txtOrderCode.Text;
cls.DateSuggest = dateSuggestDate.DateTime;
cls.Followers = cboFollowers.Text;
cls.SupplierCode = cboSupplier.EditValue.ToString();
cls.DeliveryDate = dateDeliveryDate.DateTime;
cls.PlaceOfDelivery = txtPlaceOfDelivery.Text;
cls.PaymentConditions = txtPaymentConditions.Text;
cls.VAT = int.Parse(txtVAT.EditValue.ToString());
cls.CurrencyUnit = cboCurrencyUnit.Text;
if (cls.Update(dtOrderDetail,dtOrderDetailTemp))
{
MessageBox.Show("Sửa thành công");
this.Close();
}
else
{
MessageBox.Show("Sửa thất bại");
}
}
}
//load Grid view
void tbOrder_GetList()
{
Class.clsListOrder cls = new Class.clsListOrder();
DataTable dt = cls.tbOrder_GetList();
gridItem.DataSource = dt;
}
//In đơn đặt hàng ra report
private void btnReport_Click(object sender, EventArgs e)
{
if (gridItemDetail.FocusedRowHandle > -1)
{
string code = gridItemDetail.GetFocusedRowCellValue(colOrderCode).ToString();//lấy Ordercode từ vị trí trên grid
// Create a report.
Reports.rptListOrder report = new Reports.rptListOrder();
Class.clsListOrder cls = new Class.clsListOrder();
cls.OrderCode=code;
DataTable dt = cls.tbOrderReport_GetByCode();
if (dt.Rows.Count < 1)
{
MessageBox.Show("Chi tiết đơn hàng chưa được nhập. vui lòng nhập chi tiết đơn hàng trước..");
return;
}
dt.Columns.Add("STT");
dt.Columns.Add("SubTotal", typeof(Double));
dt.Columns.Add("SubTotalAll", typeof(Double));
dt.Columns.Add("SubTotalByWord");
dt.Columns.Add("SubTotal_VAT", typeof(Double));
bool tienusd = false;
string txt = "";
Double _SubTotal = 0;
Double _vat = Double.Parse(dt.Rows[0]["VAT"].ToString());
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["STT"] = i + 1;
_SubTotal = _SubTotal + Double.Parse(dt.Rows[i]["Monetize"].ToString());
}
/// kiem tra tien le
for (int i = 0; i < dt.Rows.Count; i++)
{
txt = dt.Rows[0]["Monetize"].ToString(); //_TongTienAll.ToString("F");
if (txt.EndsWith(".00"))
{
tienusd = false;
}
else if (txt.IndexOf('.') < 0)
{
tienusd = false;
}
else if (txt == "0.0000")
{
tienusd = false;
}
else
{
tienusd = true;
break;
}
}
Double _SubTotalAll = _SubTotal + (_SubTotal * _vat) / 100;
string _MoneyByWord = SwitchToNumber(_SubTotalAll.ToString("F0")) + "đồng";
Double _SubTotal_VAT = (_SubTotal * _vat) / 100;
if (tienusd)
_MoneyByWord = "";
if (txt == "0.0000")
_MoneyByWord = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["SubTotal"] = _SubTotal;
dt.Rows[i]["SubTotalAll"] = _SubTotalAll;
dt.Rows[i]["SubTotalByWord"] = _MoneyByWord;
dt.Rows[i]["SubTotal_VAT"] = _SubTotal_VAT;
}
if (tienusd)
report= new Reports.rptListOrder("usd");
else
report = new Reports.rptListOrder();
report.DataSource = dt;
// Show the report's preview.;
// ReportPrintTool tool = new ReportPrintTool(report);
// tool.ShowPreview();
report.ShowPreview();
//report.ShowDesigner();
}
}
//xuat du lieu tu grid ra table file excel
private void btnExportFile_Click(object sender, EventArgs e)
{
try
{
if (gridItemDetail.SelectedRowsCount > 0)
{
int[] selectedRows = gridItemDetail.GetSelectedRows();
object[] result = new object[selectedRows.Length];
DataTable dt = new DataTable();
dt.Columns.Add("SoHD");
dt.Columns.Add("NgayDN");
dt.Columns.Add("NhaCC");
dt.Columns.Add("MoTa");
dt.Columns.Add("SoLuong");
dt.Columns.Add("DonVi");
dt.Columns.Add("Gia");
dt.Columns.Add("ThanhTien");
dt.Columns.Add("VAT");
for (int i = 0; i < selectedRows.Length; i++)
{
int rowHandle = selectedRows[i];
if (!gridItemDetail.IsGroupRow(rowHandle))
{
result[i] = gridItemDetail.GetRowCellValue(rowHandle, colOrderCode);
DataRow dr = dt.NewRow();
dr["SoHD"] = gridItemDetail.GetRowCellValue(rowHandle, colOrderCode);
dr["NgayDN"] = "'" + ((DateTime)gridItemDetail.GetRowCellValue(rowHandle, colDateSuggest)).ToString("dd/MM/yyyy");
dr["NhaCC"] = gridItemDetail.GetRowCellValue(rowHandle, colSupplierName);
Class.clsListOrder cls = new Class.clsListOrder();
//xu ly in cac chi tiet hoa don tu vi tri tren luoi dua vao ordercode
string code = gridItemDetail.GetRowCellValue(rowHandle, colOrderCode).ToString();
cls.OrderCode = code;
DataTable dtct = cls.tbOrderDetails_GetByCode();
if (dtct.Rows.Count > 0)
{
dr["MoTa"] = dtct.Rows[0]["Describe"].ToString();
dr["SoLuong"] = dtct.Rows[0]["Number"].ToString();
dr["DonVi"] = dtct.Rows[0]["Unit"].ToString();
dr["Gia"] = dtct.Rows[0]["Price"].ToString();
dr["ThanhTien"] = dtct.Rows[0]["Monetize"].ToString();
}
dr["VAT"] = gridItemDetail.GetRowCellValue(rowHandle, colVAT);
dt.Rows.Add(dr);
int soct = dtct.Rows.Count;
if (soct > 1)
{
for (int ii = 1; ii < soct; ii++)
{
DataRow dr1 = dt.NewRow();
dr1["MoTa"] = dtct.Rows[ii]["Describe"].ToString();
dr1["SoLuong"] = dtct.Rows[ii]["Number"].ToString();
dr1["DonVi"] = dtct.Rows[ii]["Unit"].ToString();
dr1["Gia"] = dtct.Rows[ii]["Price"].ToString();
dr1["ThanhTien"] = dtct.Rows[ii]["Monetize"].ToString();
dt.Rows.Add(dr1);
}
}
}
}
// xuat excel
SaveFileDialog saveFile = new SaveFileDialog();
saveFile.Filter = "Excel File|*.xls";
saveFile.Title = "Exprot to Excel File";
saveFile.ShowDialog();
if (saveFile.FileName != "")
{
Excel.Application xlApp;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
object misValue = System.Reflection.Missing.Value;
xlApp = new Excel.Application();
xlWorkBook = xlApp.Workbooks.Add(misValue);
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
xlWorkSheet.Cells[1, 1] = "Số HĐ";
xlWorkSheet.Cells[1, 2] = "Ngày đề nghị";
xlWorkSheet.Cells[1, 3] = "Nhà Cung cấp";
xlWorkSheet.Cells[1, 4] = "Mô tả";
xlWorkSheet.Cells[1, 5] = "Số lượng";
xlWorkSheet.Cells[1, 6] = "Đơn vị tính";
xlWorkSheet.Cells[1, 7] = "Đơn Giá";
xlWorkSheet.Cells[1, 8] = "Thành tiền";
xlWorkSheet.Cells[1, 9] = "VAT";
object[,] Array_Record;
Array_Record = new object[dt.Rows.Count, dt.Columns.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
for (int j = 0; j < dt.Columns.Count; j++)
{
Array_Record[i, j] = dt.Rows[i][j].ToString();
}
}
xlWorkSheet.get_Range("A2", "I" + (dt.Rows.Count + 1)).Value = Array_Record;
xlWorkBook.SaveAs(saveFile.FileName, Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
xlWorkBook.Close(true, misValue, misValue);
xlApp.Quit();
releaseObject(xlWorkSheet);
releaseObject(xlWorkBook);
releaseObject(xlApp);
MessageBox.Show("Xuất file thành công !..");
}
}
}
catch (Exception ex)
{
MessageBox.Show("Loi " + ex.ToString());
}
}
//In đơn đặt hàng ra report
private void btnReport_Click(object sender, EventArgs e)
{
if (gridItemDetail.FocusedRowHandle > -1)
{
string code = gridItemDetail.GetFocusedRowCellValue(colOrderCode).ToString();//lấy Ordercode từ vị trí trên grid
// Create a report.
Class.clsListOrder cls = new Class.clsListOrder();
Class.NumberToText clsNB = new Class.NumberToText();
cls.OrderCode=code;
DataTable dt = cls.tbOrderReport_GetByCode();
if (dt.Rows.Count < 1)
{
MessageBox.Show("Chi tiết đơn hàng chưa được nhập. vui lòng nhập chi tiết đơn hàng trước..");
return;
}
dt.Columns.Add("STT");
dt.Columns.Add("SubTotal", typeof(Double));
dt.Columns.Add("SubTotalAll", typeof(Double));
dt.Columns.Add("SubTotalByWord");
dt.Columns.Add("SubTotal_VAT", typeof(Double));
bool tienusd = false;
Double _SubTotal = 0;
Double _vat = Double.Parse(dt.Rows[0]["VAT"].ToString());
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["STT"] = i + 1;
_SubTotal = _SubTotal + Double.Parse(dt.Rows[i]["Monetize"].ToString());
}
/// kiem tra tien le
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// txt = dt.Rows[0]["Monetize"].ToString(); //_TongTienAll.ToString("F");
// if (txt.EndsWith(".00"))
// {
// tienusd = false;
// }
// else if (txt.IndexOf('.') < 0)
// {
// tienusd = false;
// }
// else if (txt == "0.0000")
// {
// tienusd = false;
// }
// else
// {
// tienusd = true;
// break;
// }
//}
if (dt.Rows[0]["CurrencyUnit"].ToString() == "USD")
tienusd = true;
else
tienusd = false;
Double _SubTotalAll = _SubTotal + (_SubTotal * _vat) / 100;
Double _SubTotal_VAT = (_SubTotal * _vat) / 100;
string _MoneyByWord;
Class.CurrencyTranslator tran = new Class.CurrencyTranslator();
if (tienusd)
//_MoneyByWord = "";
// _MoneyByWord = clsNB.Convert(Double.Parse(_SubTotalAll.ToString())) + " dollar";
_MoneyByWord = "US Dollars " + tran.TranslateCurrency(decimal.Parse(_SubTotalAll.ToString())) + " Only";
else
_MoneyByWord = SwitchToNumber(_SubTotalAll.ToString("F0")) + "đồng";
//if (txt == "0.0000")
// _MoneyByWord = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["SubTotal"] = _SubTotal;
dt.Rows[i]["SubTotalAll"] = _SubTotalAll;
dt.Rows[i]["SubTotalByWord"] = _MoneyByWord;
dt.Rows[i]["SubTotal_VAT"] = _SubTotal_VAT;
}
//In report font nho
if (dt.Rows.Count > 7)
{
Reports.rptListOrder_Font report = null;
if (tienusd)
report = new Reports.rptListOrder_Font("usd");
else
report = new Reports.rptListOrder_Font("");
report.DataSource = dt;
report.ShowPreview();
}
else
{
Reports.rptListOrder report = null;
if (tienusd)
report = new Reports.rptListOrder("usd");
else
report = new Reports.rptListOrder("");
report.DataSource = dt;
report.ShowPreview();
}
}
}
