public int InsertTables(TablesModel TablesModel)
{
int result = 0;
using (SqlConnection con = new SqlConnection(_ConnectionString.Value.ConnectionString))
{
TablesModel.Status = (TablesModel.Status == 0) ? null : TablesModel.Status;
CommonRepository commonRepository = new CommonRepository(_ConnectionString);
int MaxId = commonRepository.GetMaxId("Tables");
con.Open();
SqlTransaction sqltrans = con.BeginTransaction();
var query = "INSERT INTO Tables (Id,TableName,OutletId,PersonCapacity,TableIcon,Status,IsActive)" +
"VALUES ( " + MaxId +
",@TableName,@OutletId,@PersonCapacity,@TableIcon,@Status,@IsActive);" +
" SELECT CAST(SCOPE_IDENTITY() as INT);";
result = con.Execute(query, TablesModel, sqltrans, 0, System.Data.CommandType.Text);
if (result > 0)
{
sqltrans.Commit();
string output = commonRepository.SyncTableStatus("Tables");
}
else
{
sqltrans.Rollback();
}
}
return(result);
}
protected void FillTablesTree()
{
var query = from n in DataContext.LP_Tables
where n.DateDeleted == null
select n;
if (!String.IsNullOrWhiteSpace(tbxKeyword.Text))
{
query = from n in query
where n.Name.Contains(tbxKeyword.Text.Trim())
select n;
}
var entities = query.OrderByDescending(n => n.DateCreated).ToList();
var converter = new TableEntityModelConverter(DataContext);
var models = (from n in entities
let m = converter.Convert(n)
select m);
var model = new TablesModel();
model.List = models.ToList();
tablesControl.Model = model;
}
public int UpdateTables(TablesModel TablesModel)
{
int result = 0;
using (SqlConnection con = new SqlConnection(_ConnectionString.Value.ConnectionString))
{
CommonRepository commonRepository = new CommonRepository(_ConnectionString);
con.Open();
SqlTransaction sqltrans = con.BeginTransaction();
var query = "UPDATE Tables SET TableName=@TableName,OutletId=@OutletId," +
"PersonCapacity=@PersonCapacity,TableIcon=@TableIcon,Status=@Status,IsActive=@IsActive " +
"WHERE Id = @Id;";
result = con.Execute(query, TablesModel, sqltrans, 0, System.Data.CommandType.Text);
if (result > 0)
{
sqltrans.Commit();
string output = commonRepository.SyncTableStatus("Tables");
}
else
{
sqltrans.Rollback();
}
}
return(result);
}
public IActionResult Tables()
{
TablesModel model = new TablesModel();
model.TablesList = SQLiteUtility.GetTables(connectionString);
return(View(model));
}
public ActionResult Tables(TablesModel tableModel, string submitButton)
{
tableModel.OutletList = _iDropDownService.GetOutletList();
if (!ModelState.IsValid)
{
string errorString = this.ValidationTables(tableModel);
if (!string.IsNullOrEmpty(errorString))
{
ViewBag.Validate = errorString;
return(View(tableModel));
}
}
if (tableModel.Id > 0)
{
var result = _iTablesService.UpdateTables(tableModel);
ViewBag.Result = _locService.GetLocalizedHtmlString("EditSuccss");
}
else
{
var result = _iTablesService.InsertTables(tableModel);
ViewBag.Result = _locService.GetLocalizedHtmlString("SaveSuccess");
}
return(RedirectToAction("Index", "Tables"));
}
public TableModel ExcelTableLoader(string ExcelPath, string TableName)
{
TableModel LoadedTable = new TableModel();
MemoryStream inMemoryCopy = new MemoryStream();
try
{
using (FileStream fs = File.OpenRead(ExcelPath))
{
fs.CopyTo(inMemoryCopy);
}
TablesModel Tables = new TablesModel();
ExcelPackage excelPackage = new ExcelPackage(inMemoryCopy);
var package = excelPackage;
Tables = Parse(package, false);
LoadedTable = FetchTableByName(Tables, TableName);
var count = LoadedTable.Body.Count;
Debug.WriteLine("Row Count: " + count);
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
return(null);
}
return(LoadedTable);
}
private void lvModels_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
TablesModel test = (TablesModel)((ListView)sender).SelectedItem;
// gvData.DataContext = sender;
gvData.DataContext = test;
}
public static void exmpl03()
{
//Явная загрузка
db.Database.Log = Console.Write;
TablesModel model = db.TablesModel.Find(1);
db.Entry(model).Collection(c => c.TablesSNPrefix).Load();
}
static void Main(string[] args)
{
MCSEntities1 db = new MCSEntities1();
db.Database.Log = Console.Write;
#region //Явная загрузка
TablesModel model = db.TablesModels.Find(1);
foreach (var source in db.TablesSNPrefixes.Where(w => w.intModelID == model.intModelID))
{
model.TablesSNPrefixes.Add(source);
}
//db.Entry(model)
// .Collection(c => c.TablesSNPrefixes)
// .Load();
#endregion
return;
#region //Отложенная(ленивая) загрузка
foreach (var tablesModel in db.TablesModels.Take(5))
{
Console.WriteLine(tablesModel.strName);
foreach (var tablesSnPrefix in tablesModel.TablesSNPrefixes)
{
Console.WriteLine(" - " + tablesSnPrefix.strPrefix);
}
}
#endregion
return;
#region//Прямая загрузка
List <newEquipment> qeuipments =
db.newEquipments
.Include(d => d.TablesLocation)
.Include(d => d.TablesModel)
.Include(d => d.TablesModel.TablesSNPrefixes)
.ToList();
Console.WriteLine("--------------------------------------------------------------");
foreach (var newEquipment in qeuipments)
{
Console.WriteLine(newEquipment.intGarageRoom);
foreach (var pref in newEquipment.TablesModel.TablesSNPrefixes)
{
Console.WriteLine("-> " + pref.strPrefix);
}
}
Console.WriteLine("--------------------------------------------------------------");
#endregion
}
//添加餐桌
private void btnAddMeal_Click(object sender, EventArgs e)
{
TablesModel tables = new TablesModel();
tables.RTID1 = -1;
TheTableEditorForm tableEditor = new TheTableEditorForm(tables);
tableEditor.Show();
}
public static TableModel FetchTableByName(TablesModel Tables, string tableName)
{
foreach (var table in Tables.Tables)
{
if (table.Name == tableName)
{
return(table);
}
}
return(null);
}
//修改餐桌
private void btnUpdateMeal_Click(object sender, EventArgs e)
{
int index = Convert.ToInt32(dataGridView2.Rows[dataGridView2.CurrentRow.Index].Cells[0].Value);
string name = dataGridView2.Rows[dataGridView2.CurrentRow.Index].Cells[1].Value.ToString();
string area = dataGridView2.Rows[dataGridView2.CurrentRow.Index].Cells[3].Value.ToString();
int start = 0;
TablesModel tables = new TablesModel(index, name, 0, area, start);
TheTableEditorForm tableEditor = new TheTableEditorForm(tables);
tableEditor.Show();
}
public ActionResult tables()
{
List <PeopleModel> peopleList = peopleCollection.AsQueryable <PeopleModel>().ToList();
List <OrdersModel> ordersList = ordersCollection.AsQueryable <OrdersModel>().ToList();
TablesModel tdata = new TablesModel();
tdata.tPeopleList = peopleList;
tdata.tOrdersList = ordersList;
return(View(tdata));
}
private void 顾客开单ToolStripMenuItem_Click(object sender, EventArgs e)
{
DataTable dt = RommBLL.getTableMeal(name);
if (dt.Rows[0]["餐台状态"].ToString() == "可用")
{
TablesModel tables = new TablesModel();
tables.TableName1 = name;
tables.TableID1 = id;
BillingForm bf = new BillingForm(tables, 6);
bf.Show();
}
}
private void btnCreate_Click(object sender, RoutedEventArgs e)
{
TablesModel tmodel = new TablesModel();
tmodel.strName = strName.Text;
tmodel.intManufacturerID = Int32.Parse(intManufacturerID.Text);
tmodel.intSMCSFamilyID = Int32.Parse(intSMCSFamilyID.Text);
tmodel.strImage = strImage.Text;
db.TablesModel.Add(tmodel);
db.SaveChanges();
lvManuf.ItemsSource = db.TablesModel.ToList();
}
private void BillingForm_Load(object sender, EventArgs e)
{
//标题
this.Text = "顾客开单";
TablesModel tables2 = new TablesModel();
tables2.TableName1 = tables.TableName1;
DataTable dt = RommBLL.getTableKD(tables2);
lblType.Text = tables.TableName1;
lblRoomType.Text = dt.Rows[0]["RTName"].ToString();
lblMinMoney.Text = dt.Rows[0]["RTConsume"].ToString();
}
private void lvManuf_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
TablesModel tmodel = (TablesModel)lvManuf.SelectedItem;
if (tmodel != null)
{
intModelID.Text = tmodel.intModelID.ToString();
strName.Text = tmodel.strName;
intManufacturerID.Text = tmodel.intManufacturerID.ToString();
intSMCSFamilyID.Text = tmodel.intSMCSFamilyID.ToString();
strImage.Text = tmodel.strImage;
}
}
void lv_DoubleClick(object sender, EventArgs e)
{
ListView listV = sender as ListView;
string name = listV.SelectedItems[0].Tag.ToString();
DataTable dt = RommBLL.getTableMeal(name);
if (dt.Rows[0]["餐台状态"].ToString() == "可用")
{
TablesModel tables = new TablesModel();
tables.TableName1 = name;
tables.TableID1 = id;
BillingForm bf = new BillingForm(tables, 6);
bf.Show();
}
}
private void btnDelete_Click(object sender, RoutedEventArgs e)
{
TablesModel tmodel = (TablesModel)lvManuf.SelectedItem;
if (tmodel != null)
{
db.TablesModel.Remove(tmodel);
db.SaveChanges();
lvManuf.ItemsSource = db.TablesModel.ToList();
}
else
{
MessageBox.Show("Please select the item you want to delete");
}
}
static void Main(string[] args)
{
db.Database.Log = Console.Write;
//Явная загрузка
TablesModel model = db.TablesModel.Find(1);
db.Entry(model).Collection(c => c.TablesSNPrefix).Load();
return;
//Lazy load
foreach (var tablesModel in db.TablesModel.Take(5))
{
Console.WriteLine(tablesModel.strName);
foreach (var tablesSnPrefix in tablesModel.TablesSNPrefix)
{
Console.WriteLine(" -" + tablesSnPrefix.strPrefix);
}
}
return;
//Прямая загрузка
List <newEquipment> equipList = db.newEquipment
//.Include(d => d.TablesLocation)
//.Include(d => d.TablesModel)
//.Include(d => d.TablesModel.TablesSNPrefix)
.ToList();
Console.WriteLine("------------------------------------------------");
foreach (var newEquipment in equipList)
{
Console.WriteLine(newEquipment.intGarageRoom);
foreach (var pref in newEquipment.TablesModel.TablesSNPrefix)
{
//Console.WriteLine("->" + pref.strPrefix);
}
}
Console.WriteLine("--------------------------------------------------");
}
//删除餐桌
private void btnDeleteMeal_Click(object sender, EventArgs e)
{
int index = Convert.ToInt32(dataGridView2.Rows[dataGridView2.CurrentRow.Index].Cells[0].Value);
TablesModel tables = new TablesModel();
tables.TableID1 = index;
int result = RommBLL.getDeleteMeal(tables);
if (result > 0)
{
MessageBox.Show("OK");
}
else
{
MessageBox.Show("NO");
}
}
private string ValidationTables(TablesModel tablesModel)
{
string ErrorString = string.Empty;
if (string.IsNullOrEmpty(tablesModel.TableName))
{
ErrorString = _locService.GetLocalizedHtmlString("ValidAddOnesName");
return(ErrorString);
}
//if (string.IsNullOrEmpty(tablesModel.Price.ToString()) || tablesModel.Price == 0)
//{
// ErrorString = _locService.GetLocalizedHtmlString("ValidPrice");
// return ErrorString;
//}
return(ErrorString);
}
//增加消费
private void Insert_Click(object sender, EventArgs e)
{
TablesModel tables = new TablesModel();
tables.TableID1 = id;
tables.TableName1 = name;
//查询出当前餐桌得编号
ConsumerBillModel cbm = new ConsumerBillModel();
cbm.TableID1 = id;
cbm.CBClose1 = 0;
DataTable dt = ConsumerBillBLL.getNo(cbm);
cbm.CBID1 = dt.Rows[0]["账单编号"].ToString();
AddForm af = new AddForm(tables, cbm);
af.Show();
}
//结账
private void 宾客结账ToolStripMenuItem_Click(object sender, EventArgs e)
{
TablesModel tables = new TablesModel();
tables.TableID1 = id;
tables.TableName1 = name;
//查询出当前餐桌得编号
ConsumerBillModel cbm = new ConsumerBillModel();
cbm.TableID1 = id;
cbm.CBClose1 = 0;
DataTable dt = ConsumerBillBLL.getNo(cbm);
cbm.CBID1 = dt.Rows[0]["账单编号"].ToString();
AccountsForm1 af = new AccountsForm1(cbm, tables);
af.Show();
}
public ActionResult Tables(int?id)
{
TablesModel tableModel = new TablesModel();
if (UserRolePermissionForPage.Add == true || UserRolePermissionForPage.Edit == true)
{
if (id > 0)
{
int tableId = Convert.ToInt32(id);
tableModel = _iTablesService.GetTablesById(tableId);
}
tableModel.OutletList = _iDropDownService.GetOutletList();
return(View(tableModel));
}
else
{
return(RedirectToAction("NotFound", "Error"));
}
}
public RowsModel ExcelTableLoader(string ExcelPath, string TableName, bool RowModelFlag)
{
RowsModel LoadedRowTable = new RowsModel();
MemoryStream inMemoryCopy = new MemoryStream();
try
{
using (FileStream fs = File.OpenRead(ExcelPath))
{
fs.CopyTo(inMemoryCopy);
}
TablesModel Tables = new TablesModel();
ExcelPackage excelPackage = new ExcelPackage(inMemoryCopy);
var package = excelPackage;
Tables = Parse(package, false);
var Result = FetchTableByName(Tables, TableName);
RowsModel rowsModel = new RowsModel();
foreach (var row in Result.Body)
{
RowsModel.RowModel row2 = new RowsModel.RowModel();
int cell2 = 0;
foreach (var cell in row.Cells)
{
row2.Cells[cell2].Value = cell.Value;
cell2 += 1;
}
rowsModel.Rows.Add(row2);
}
LoadedRowTable = rowsModel;
var count = LoadedRowTable.Rows.Count;
Debug.WriteLine("Row Count: " + count);
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
return(null);
}
return(LoadedRowTable);
}
/*DB Crawler */
public ActionResult ListTables()
{
var metadata = ((IObjectContextAdapter)db).ObjectContext.MetadataWorkspace;
var tables = metadata.GetItemCollection(DataSpace.SSpace)
.GetItems <EntityContainer>()
.Single()
.BaseEntitySets
.OfType <EntitySet>()
.Where(s => !s.MetadataProperties.Contains("Type") ||
s.MetadataProperties["Type"].ToString() == "Tables");
TablesModel tableModel = new TablesModel();
List <TablesModel> tableModels = new List <TablesModel>();
foreach (var t in tables)
{
tableModel.TableName = t.Name;
tableModels.Add(tableModel);
}
return(View("TablesList", tableModels));
}
private void btnOK_Click(object sender, EventArgs e)
{
if (tables.RTID1 == -1)
{
//增加
string name = txtName.Text.Trim();
int type = cmdType.SelectedIndex + 1;
string area = txtAdrees.Text.Trim();
int start = 0;
TablesModel tables2 = new TablesModel(name, type, area, start);
int result = RommBLL.getAddMeal(tables2);
if (result > 0)
{
MessageBox.Show("OK");
}
else
{
MessageBox.Show("NO");
}
}
else
{
//修改
string name = txtName.Text.Trim();
int type = cmdType.SelectedIndex + 1;
string area = txtAdrees.Text.Trim();
int start = 0;
TablesModel tables2 = new TablesModel(tables.TableID1, name, type, area, start);
int result = RommBLL.getUpdateMeal(tables2);
if (result > 0)
{
MessageBox.Show("OK");
}
else
{
MessageBox.Show("NO");
}
}
}
private void brnOK_Click(object sender, EventArgs e)
{
TablesModel tables2 = new TablesModel();
tables2.TableName1 = tables.TableName1;
tables2.TableState1 = 1;
int result = RommBLL.getUpdateZT(tables2);
string count = txtCount.Text.Trim();
if (result > 0)
{
MessageBox.Show("OK");
if (cb.Checked)
{
string no = "ZD" + DateTime.Now.ToString("yyyyMMddhhmm");
string time = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
ConsumerBillModel cbm = new ConsumerBillModel(no, tables.TableID1, count, "-1", "1", time, "", admin, Convert.ToDouble("0"), 0);
ConsumerBillBLL.getInsert(cbm);
AddForm af = new AddForm(tables, cbm);
af.Show();
}
else
{
string no = "ZD" + DateTime.Now.ToString("yyyyMMddhhmm");
string time = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
ConsumerBillModel cbm = new ConsumerBillModel(no, tables.TableID1, count, "-1", "1", time, "", admin, Convert.ToDouble("0"), 0);
ConsumerBillBLL.getInsert(cbm);
}
FunctionForm ff = new FunctionForm();
ff.FunctionForm_Load(null, null);
this.Close();
}
else
{
MessageBox.Show("NO");
}
}
private void btnUpdate_Click(object sender, RoutedEventArgs e)
{
if (lvManuf.SelectedIndex >= 0)
{
TablesModel tmodel = (TablesModel)lvManuf.SelectedItem;
foreach (var item in db.TablesModel)
{
if (item.intManufacturerID == tmodel.intManufacturerID)
{
item.intManufacturerID = Int32.Parse(intManufacturerID.Text);
item.strName = strName.Text;
item.intSMCSFamilyID = Int32.Parse(intSMCSFamilyID.Text);
item.strImage = strImage.Text;
break;
}
}
db.SaveChanges();
lvManuf.ItemsSource = db.TablesModel.ToList();
}
else
{
MessageBox.Show("Please select the item you want to update");
}
}
