/// <summary>
/// Get the ResultsField associated with a PivotGridField
/// </summary>
/// <param name="Rf"></param>
/// <param name="f0"></param>
/// <returns></returns>
internal ResultsField GetPivotGridFieldResultsField(
PivotGridField pgf)
{
Query q = Rf.Query;
string[] sa = pgf.UnboundFieldName.Split('.');
if (sa.Length < 2)
{
return(null);
}
QueryTable qt = q.GetTableByName(sa[0]);
if (qt == null)
{
return(null);
}
QueryColumn qc = qt.GetQueryColumnByName(sa[1]);
if (qc == null)
{
return(null);
}
ResultsField rfld = Rf.GetResultsField(qc);
return(rfld);
}
static void TraerPorCatego(VentaRepuestos E)
{
Validaciones V = new Validaciones();
ConsolaHelper H = new ConsolaHelper();
try
{
string _srtCodigoC;
int _codigoC = 0;
bool _flag1;
do
{
_srtCodigoC = H.PedirCodigo("categoria");
_flag1 = V.ValidarCodigoRepuesto(_srtCodigoC, ref _codigoC);
} while (!_flag1);
if (E.TraerPorCategoria(_codigoC).Count == 0)
{
throw new ListaVaciaCategoriaException();
}
else
{
foreach (Repuesto Rf in E.TraerPorCategoria(_codigoC))
{
H.MostrarMensaje(Rf.ToString());
}
}
}
catch (ListaVaciaCategoriaException e)
{
H.MostrarMensaje(e.Message);
}
}
/// <summary>
/// Sets the cell san pham With SanPhamModel from outsite
/// We need to save it to model of ChiTietHoaDon
/// One HoaDon complete - create and pham
/// </summary>
/// <param name="value">The value.</param>
public void SetCellSanPham(SanPhamModel value)
{
if (dataGridView != null)
{
if (dataGridView.Rows.Count > 0)
{
if (currentRowSelected != -1)
{
if (currentRowSelected < dataGridView.Rows.Count)
{
dataGridView.Rows[currentRowSelected].Selected = true;
}
else
{
currentRowSelected = 0;
}
}
dataGridView.Rows[currentRowSelected].Cells[Rf.Name <ChiTietHdnModel>(c => c.MaGiayDep)].Value = (value == null) ? "-1" : value.MaGiayDep;
if (value != null)
{
var m = dataGridView.Rows[currentRowSelected].Cells;
for (int i = 0; i < currentListDataTable.Count; i++)
{
if (currentListDataTable.ElementAt(i).IDModel == m[Rf.Name <ChiTietHdnModel>(c => c.IDModel)].Value.ToString())
{
currentListDataTable.ElementAt(i).SanPham = value.ToEntity();
}
}
}
}
}
}
public static void Stop()
{
Trans?.Stop();
TileLifter?.Stop();
Ferry?.Stop();
Carrier?.Stop();
Rf?.Stop();
TrafficControl?.Stop();
}
/// <summary>
/// Handles the Click event of the bntXoa control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="EventArgs" /> instance containing the event data.</param>
private void bntXoa_Click(object sender, EventArgs e)
{
List <DataGridViewRow> selectedRows = (from row in dataGridView.Rows.Cast <DataGridViewRow>()
where Convert.ToBoolean(row.Cells["CB"].Value)
select row).ToList();
if (
MessageBox.Show(string.Format("Bạn có chắc chắn xóa {0} đơn hàng này không?", selectedRows.Count),
Resources.View_Confirm,
MessageBoxButtons.YesNo) == DialogResult.Yes)
{
var s = (from row in dataGridView.Rows.Cast <DataGridViewRow>()
where Convert.ToBoolean(row.Cells["CB"].Value)
select row.Index).ToList();
if (s.Count == 0)
{
return;
}
for (int k = s.Count - 1; k >= 0; k--)
{
var i = s.ElementAt(k);
var mx = dataGridView.Rows[i].Cells;
for (int j = 0; j < currentListDataTable.Count; j++)
{
var m = currentListDataTable.ElementAt(j);
if (m.IDModel == mx[Rf.Name <ChiTietHdbModel>(c => c.IDModel)].Value)
{
currentListDataTable.RemoveAt(j); break;
}
}
dataSourceDataTable.Rows.RemoveAt(i);
}
//var dt = (DataTable) dataBindingSource.DataSource;
//dataGridView.Rows.RemoveAt();
//dataGridView.Rows.Clear();
//controller.Delete(string.Join(",", s.ToArray()));
//controller.ReviewGrid();
}
if (dataSourceDataTable.Rows.Count == 0)
{
bntXoa.Enabled = false;
bntLuaChon.Enabled = false;
//bntLuu.Enabled = false;
//bntTaoMoi.Enabled = true;
}
}
private static void CheckAndStart()
{
while (!PubMaster.IsReady)
{
Thread.Sleep(2000);
}
TileLifter?.Start();
Ferry?.Start();
Carrier?.Start();
Trans?.Start();
Rf?.Start();
TrafficControl?.Start();
}
internal void FindNames()
{
Tables = new Hashtable();
try
{
var mainTag = ReadStandardString(4);
if (!mainTag.Equals("ttcf"))
{
throw new DocumentException(FileName + " is not a valid TTC file.");
}
Rf.SkipBytes(4);
var dirCount = Rf.ReadInt();
names = new string[dirCount];
var dirPos = Rf.FilePointer;
for (var dirIdx = 0; dirIdx < dirCount; ++dirIdx)
{
Tables.Clear();
Rf.Seek(dirPos);
Rf.SkipBytes(dirIdx * 4);
DirectoryOffset = Rf.ReadInt();
Rf.Seek(DirectoryOffset);
if (Rf.ReadInt() != 0x00010000)
{
throw new DocumentException(FileName + " is not a valid TTF file.");
}
var numTables = Rf.ReadUnsignedShort();
Rf.SkipBytes(6);
for (var k = 0; k < numTables; ++k)
{
var tag = ReadStandardString(4);
Rf.SkipBytes(4);
var tableLocation = new int[2];
tableLocation[0] = Rf.ReadInt();
tableLocation[1] = Rf.ReadInt();
Tables[tag] = tableLocation;
}
names[dirIdx] = BaseFont;
}
}
finally
{
if (Rf != null)
{
Rf.Close();
}
}
}
/// <summary>
/// Adds the new template.
/// </summary>
/// <param name="table">The table.</param>
public void AddNewTemplate(DataTable table)
{
var m = table.NewRow();
var a = TemplateNew();
//todo: check now
currentListDataTable.Add(a);
m[Rf.Name <ChiTietHdnModel>(c => c.ID)] = a.ID;
m[Rf.Name <ChiTietHdnModel>(c => c.DonGia)] = a.DonGia;
m[Rf.Name <ChiTietHdnModel>(c => c.GiamGia)] = a.GiamGia;
m[Rf.Name <ChiTietHdnModel>(c => c.SoLuong)] = a.SoLuong;
m[Rf.Name <ChiTietHdnModel>(c => c.MaGiayDep)] = a.MaGiayDep;
m[Rf.Name <ChiTietHdnModel>(c => c.ThanhTien)] = a.ThanhTien;
m[Rf.Name <ChiTietHdnModel>(c => c.IDModel)] = a.IDModel;
table.Rows.Add(m);
//table.AcceptChanges();
}
//Събиране и изваждане
private void SiI()
{
instr.text = " ";
int x = Random.Range(2000, 9999);
int y = Random.Range(2000, 9999);
int c = Random.Range(0, 2);
int d = Random.Range(0, 2);
int z = Random.Range(1, 4);
if (c == 0)
{
int Rf;
int R;
do
{
y = Random.Range(900, 1000);
R = x - y;
Rf = Random.Range(R - 100, R + 100);
}while (y > x && Rf <= 0);
quest.text = x + "-" + y + "= ?";
tr.text = R.ToString();
fal.text = Rf.ToString();
}
quest.text = x + "+" + y + "= ?";
int S = x + y;
double Sf1 = S - Mathf.Pow(10, z);;
double Sf2 = S + Mathf.Pow(10, z);;
tr.text = S.ToString();
if (d == 0)
{
fal.text = Sf1.ToString();
}
fal.text = Sf2.ToString();
}
/// <summary>
/// Handles the Click event of the bntTaoMoi control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param>
private void bntTaoMoi_Click(object sender, EventArgs e)
{
bntLuu.Enabled = true;
bntTaoMoi.Enabled = true;
bntXoa.Enabled = true;
bntLuaChon.Enabled = true;
currentListDataTable = currentListDataTable ?? new List <ChiTietHdnModel>
{
TemplateNew()
};
if (dataGridView.Rows.Count == 0)
{
dataSourceDataTable = currentListDataTable.ToDataTable();
dataSourceDataTable.AcceptChanges();
dataBindingSource.DataSource = dataSourceDataTable;
dataGridView.DataSource = dataBindingSource;
dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.ID)].Display(false);
dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.SanPhamID)].Display(false);
dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.SanPham)].Display(false);
dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.HoaDonNhapID)].Display(false);
dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.HoaDonNhap)].Display(false);
dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.SoHDN)].Display(false);
dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.IDModel)].Display(false);
if (dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.MaGiayDep)] != null)
{
dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.MaGiayDep)].DisplayIndex = 1;
}
}
else
{
AddNewTemplate((DataTable)dataBindingSource.DataSource);
}
}
//Събиране и изваждане
private void SiI()
{
instr.text = " ";
int x = Random.Range(10000, 99999);
int y = Random.Range(10000, 99999);
int c = Random.Range(0, 2);
int d = Random.Range(0, 2);
int z = Random.Range(1, 5);
if (c == 0)
{
do
{
y = Random.Range(10000, 100000);
}while (y > x);
int R = x - y;
int Rf;
do
{
Rf = Random.Range(0, R + 100);
}while (Rf == R);
quest.text = x + "-" + y + "= ?";
tr.text = R.ToString();
fal.text = Rf.ToString();
}
quest.text = x + "+" + y + "= ?";
int S = x + y;
int Sf1 = S - 10 * z;
int Sf2 = S + 10 * z;
tr.text = S.ToString();
if (d == 0)
{
fal.text = Sf1.ToString();
}
fal.text = Sf2.ToString();
}
public override bool Start()
{
string su = "", ipbstrResult, strSQL, ProductCode, IA_SetValue;
bool dada;
//string ExtraInfo = "Produkt ma przypisaną wartość atrybutu SET";
//ipbstrResult = null;
//System.Data.DataSet ds;
//ProductCode = "393260 SETX";
//IA_SetValue = null;
this.FormFile = "set\\Set22IAProductSelect.xml";
Rf.PushScreen();
//this.Rf.ClearScreen();
//this.Rf.PopScreen();
//Rf.ReadBufferByLine=true;
/*Rf. = true;
* Rf.DisplayText("HELLO ", 5, 1);
* Rf.ReadString(ref su);*/
/*RFControlText rFControlText = new RFControlText
* {
* Visible = true,
* Status = "kod",
* InputSize = 15,
* Size = 15,
* Message = "Skanuj kod produktu",
* Required = true,
* Reverse=false,
* IgnorePrevious=false,
* ControlType = Mantis.LVision.RFApi.enmControlType.ALFANUMERIC,
* OriginalValue="test"
* };
* //rFControlText.Value = "";
* Rf.ReadText(rFControlText, ref su);*/
Routines dbr = new Routines();
//Rf.DisplayMessage(ExtraInfo);
Mantis.LVision.RFTools.frmGetValue frmVal = new Mantis.LVision.RFTools.frmGetValue
{
// frmVal.Application = this.Application;
//frmVal.Parameters = this.Parameters;
//frmVal.Rf = this.Rf;
//frmVal.SessionID = this.SessionID;
TitleMessage = "Zeskanuj ",
Message = "kod produktu:",
Size = 15,
X = 1,
Y = 1,
Required = true,
ControlType = Mantis.LVision.RFApi.enmControlType.ALFANUMERIC,
Caption1_Visible = true,
Parent = this.Parent
};
frmVal.ClearScreen();
dada = frmVal.Show();
frmVal.PushScreen();
//frmVal.ShowForm(m_Form);
if (frmVal.Value == null || frmVal.Value == "")
{
Rf.DisplayError("zeskanuj kod produktu!!");
}
//strSQL = "select '1' id, 'TAK' rep UNION ALL select '2' id, 'NIE' rep";
//ds = dbr.SelectTable(strSQL, m_Form, null);
//su = m_Form.Rf.DisplayCombo(1, 1, "Produkt: "+ProductCode+(char)13+"Typ SET: " + IA_SetValue.ToString(), "Zmiana? : ", ref ipbstrResult, ds.Tables[0], "id", "id", "rep", eEchoMode.ECHO_ON, null, true, false, "1", true);
return(false);
}
/// <summary>
/// DGV_s the cell click.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The <see cref="DataGridViewCellEventArgs" /> instance containing the event data.</param>
private void dataGridView1_ChangedValue(Object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex < 0)
{
return;
}
int row = e.RowIndex;
int col = e.ColumnIndex;
currentRowSelected = row;
// from 1 no 0
var m = dataGridView.Rows[currentRowSelected].Cells;
if (col > 0)
{
if (dataGridView.Columns[col].Name == Rf.Name <ChiTietHdnModel>(c => c.MaGiayDep))
{
var id = m[Rf.Name <ChiTietHdnModel>(c => c.MaGiayDep)].Value.ToString();
if (id != "-1" && id != "")
{
var RowIDs = (from rowx in dataGridView.Rows.Cast <DataGridViewRow>() where (rowx.Cells[Rf.Name <ChiTietHdnModel>(c => c.MaGiayDep)].Value.ToString() == id) select rowx).ToList();
if (RowIDs.Count() > 1)
{
MessageBox.Show("Mã sản phẩm đã tồn tại!");
m[Rf.Name <ChiTietHdnModel>(c => c.MaGiayDep)].Value = "-1";
return;
}
var noex = controller.CheckMaFromSanPham(id);
if (noex == null)
{
if (MyDialogs.Question("Mã sản phẩm chưa tồn tại, bạn muốn khai báo không?") == false)
{
m[Rf.Name <ChiTietHdnModel>(c => c.MaGiayDep)].Value = "-1";
}
else
{
controller.ShowSanPhamViewToCreate(id);
}
}
else
{
// get back đơn giá nhập!
dataGridView.Rows[currentRowSelected].Cells[Rf.Name <ChiTietHdnModel>(c => c.DonGia)].Value = noex.DonGiaNhap;
}
}
}
var a = m[Rf.Name <ChiTietHdnModel>(c => c.SoLuong)].Value.ToInt32();
var b = m[Rf.Name <ChiTietHdnModel>(c => c.DonGia)].Value.ToDecimal();
var d = m[Rf.Name <ChiTietHdnModel>(c => c.GiamGia)].Value.ToDecimal();
if (d > b)
{
m[Rf.Name <ChiTietHdnModel>(c => c.GiamGia)].Value = d;
}
var total = a * (b - d);
m[Rf.Name <ChiTietHdnModel>(c => c.ThanhTien)].Value = total;
}
var sum = (from r in dataGridView.Rows.Cast <DataGridViewRow>() select r.Cells[Rf.Name <ChiTietHdnModel>(c => c.ThanhTien)].Value.ToDecimal()).Sum(c => c);
txtTongTien.Text = sum.ToString(CultureInfo.InvariantCulture);
if (currentListDataTable != null)
{
for (int i = 0; i < currentListDataTable.Count; i++)
{
if (currentListDataTable.ElementAt(i).IDModel ==
m[Rf.Name <ChiTietHdnModel>(c => c.IDModel)].Value.ToString())
{
currentListDataTable.ElementAt(i).DonGia =
m[Rf.Name <ChiTietHdnModel>(c => c.DonGia)].Value.ToDecimal();
currentListDataTable.ElementAt(i).GiamGia =
m[Rf.Name <ChiTietHdnModel>(c => c.GiamGia)].Value.ToDecimal();
currentListDataTable.ElementAt(i).SoLuong =
m[Rf.Name <ChiTietHdnModel>(c => c.SoLuong)].Value.ToInt32();
currentListDataTable.ElementAt(i).MaGiayDep =
m[Rf.Name <ChiTietHdnModel>(c => c.MaGiayDep)].Value.ToString();
currentListDataTable.ElementAt(i).ThanhTien =
m[Rf.Name <ChiTietHdnModel>(c => c.ThanhTien)].Value.ToDecimal();
}
}
currentHoaDonNhapModel.TongTien = txtTongTien.Text.ToDecimal();
currentHoaDonNhapModel.ChiTietHDNModel = currentListDataTable;
}
}
/// <summary>
/// Posts the view.
/// </summary>
/// <param name="value">The value.</param>
public void PostView(HoaDonNhapModel value)
{
currentHoaDonNhapModel = value;
currentListDataTable = null;
dataGridView.Columns.Clear();
var g = new DataGridViewCheckBoxColumn {
Name = "CB", HeaderText = "", Width = 24, AutoSizeMode = DataGridViewAutoSizeColumnMode.None, ReadOnly = true
};
dataGridView.Columns.Add(g);
dataSourceDataTable = value.ChiTietHDNModel.ToDataTable();
dataSourceDataTable.AcceptChanges();
dataBindingSource.DataSource = dataSourceDataTable;
dataGridView.DataSource = dataBindingSource;
//dataGridView.DataSource = new BindingSource { DataSource = value.ChiTietHDNModel };
dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.ID)].Display(false);
dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.SanPhamID)].Display(false);
dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.SanPham)].Display(false);
dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.HoaDonNhapID)].Display(false);
dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.HoaDonNhap)].Display(false);
dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.SoHDN)].Display(false);
dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.IDModel)].Display(false);
if (dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.MaGiayDep)] != null)
{
dataGridView.Columns[Rf.Name <ChiTietHdnModel>(c => c.MaGiayDep)].DisplayIndex = 1;
}
if (value != null)
{
if (value.SoHDN != null)
{
txtMaHoaDon.Text = value.SoHDN;
}
if (value.MaNV != null)
{
txtMaNhanVien.Text = value.MaNV;
}
if (value.MaNCC != null)
{
txtMaNCC.Text = value.MaNCC;
}
if (value.NgayNhap != null)
{
txtNgayNhap.Text = value.NgayNhap.ToDateString();
}
if (value.TongTien != null)
{
txtTongTien.Text = value.TongTien.ToString();
}
}
txtMaNhanVien.Text = AppMediator.MANHANVIEN;
dataGridView.ClearSelection();
dataGridView.CurrentCell = null;
if (isEditMode)
{
bntLuu.Enabled = false;
bntTaoMoi.Enabled = true;
bntXoa.Enabled = false;
bntLuaChon.Enabled = false;
txtMaHoaDon.Focus();
}
else
{
bntLuu.Enabled = false;
bntTaoMoi.Enabled = false;
bntXoa.Enabled = false;
}
currentModel = null;
}
