private void AddtoRow(string ino, string bno, int qt, DateTime post, string sname, DateTime entry, string categ, string loc)
{
object[] array = new object[7];
QHMobile.App_Data.STModule module = new QHMobile.App_Data.STModule();
array[0] = module.ItemNo = ino;
array[1] = module.binNo = bno;
array[2] = module.qty = qt;
array[3] = module.postDate = post;
array[4] = module.staffName = sname;
//array[5] = module.entryDate = entry;
module.entryDate = entry;
array[5] = module.category = categ;
array[6] = module.loc = loc;
dt.Rows.Add(array);
lblCount.Text = dt.Rows.Count.ToString();
stmod.Add(module);
txtItemNo.Enabled = true;
txtBin.Enabled = true;
CompactSQL comsql = new CompactSQL();
comsql.InsertRecord("StockTakeEntry", array);
}
private void GetSQLData(SqlCeDataReader getdata)
{
dt.Clear();
stmod.Clear();
while (getdata.Read())
{
Object[] array = new Object[8];
QHMobile.App_Data.STModule mod = new QHMobile.App_Data.STModule();
array[0] = getdata["ItemNo"];
mod.ItemNo = getdata["ItemNo"].ToString();;
array[1] = getdata["BinCode"];
mod.binNo = getdata["BinCode"].ToString();
array[2] = getdata["Quantity"];
mod.qty = Convert.ToInt32(getdata["Quantity"]);
array[3] = getdata["PostDate"];
mod.postDate = Convert.ToDateTime(getdata["PostDate"]);
array[4] = getdata["StaffName"];
mod.staffName = getdata["StaffName"].ToString();
//array[5] = getdata["EntryDate"];
//if (!string.IsNullOrEmpty(getdata["EntryDate"].ToString()))
//{
// mod.entryDate = DateTime.Now;
//}
//else
//{
// mod.entryDate = Convert.ToDateTime(getdata["EntryDate"]);
//}
array[5] = getdata["Category"];
mod.category = getdata["Category"].ToString();
array[6] = getdata["Loc"];
mod.loc = getdata["Loc"].ToString();
array[7] = getdata["LineNo"];
mod.lineno = Convert.ToInt32(getdata["LineNo"].ToString());
dt.Rows.Add(array);
stmod.Add(mod);
}
dgGRNLine.DataSource = dt;
}
