/// <summary>
///
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
public void dataBind(int pageIndex = 1, int pageSize = 10, string startTime = null, string endTime = null)
{
PetaPoco.Sql sql = new PetaPoco.Sql();
sql.Select("m.[description] as name,a.*").From("t_MachineStop_rd a");
sql.LeftJoin("Point_Machine_Map m").On("m.pointname=a.pointname");
if (!String.IsNullOrEmpty(startTime))
{
sql.Where("a.starttime>@0", startTime);
}
if (!String.IsNullOrEmpty(endTime))
{
sql.Where("a.starttime<@0", endTime);
}
List<int> machineids = new List<int>();
for (int i = 0; i < chkboxlist.Items.Count; i++)
{
if (chkboxlist.Items[i].Selected)
{
machineids.Add(int.Parse(chkboxlist.Items[i].Value));
}
}
if (machineids.Count > 1)
sql.Where("m.machineid in (@0)", machineids);
else if (machineids.Count == 1)
sql.Where("m.machineid=@0", machineids[0]);
sql.OrderBy("a.starttime desc");
var db = new PetaPoco.Database("dbconn");
PetaPoco.Page<BootRecordSelect> pageitems = db.Page<BootRecordSelect>(pageIndex, pageSize, sql);
rpt_RulelogS_Des.DataSource = pageitems.Items;
rpt_RulelogS_Des.DataBind();
AspNetPager1.RecordCount = (int)pageitems.TotalItems;
}
public override bool Add()
{
try
{
PetaPoco.Sql query = PetaPoco.Sql.Builder
.Append("SELECT * FROM Students")
.Append("WHERE FirstName=@0 AND LastName=@1", FirstName, LastName);
var a = db.Fetch <Student>(query);
if (a.Count > 0)
{
//If so, return false and state the error
// this.Error = "Duplicates not allowed.";
return(false);
}
//Try to insert
using (var scope = db.GetTransaction())
{
db.Insert("Students", "StudentId", this);
scope.Complete();
}
}
catch
{
// this.Error = "Opened database, but couldn't save.";
return(false);
}
return(true);
}
public ActionResult Bill(int id, ItemTypesEnum ite)
{
ViewBag.Order = db.Single <OrderTicket>(id);
PetaPoco.Sql sq = new PetaPoco.Sql("Select od.*, ItemName from orderTicketDetails od, Items i where od.itemId=i.ItemId and OTID=@0", id);
switch (ite)
{
case ItemTypesEnum.DrinksNAlc:
{
sq.Append(" and i.itemTypeId <>@0", ItemTypesEnum.DrinksAlc);
break;
}
case ItemTypesEnum.DrinksAlc:
{
sq.Append(" and i.itemTypeId =@0", ItemTypesEnum.DrinksAlc);
break;
}
default:
break;
}
ViewBag.orderDetails = db.Query <OrderDetailsVw>(sq);
return(View());
}
// GET: Reports
public ActionResult Index(int?VehicleId, int?ticketno, int?SupplierId, int?MaterialId)
{
ViewBag.MaterialId = new SelectList(db.Fetch <Material>("Select MaterialId,MaterialName from Material"), "MaterialId", "MaterialName");
ViewBag.SupplierId = new SelectList(db.Fetch <Supplier>("Select SupplierId,SupplierName from Supplier"), "SupplierId", "SupplierName");
ViewBag.VehicleId = new SelectList(db.Fetch <VeichleEntry>("Select VeichleId,VeichleNumber from VeichleEntry"), "VeichleId", "VeichleNumber");
PetaPoco.Sql sq = new PetaPoco.Sql("Select t.TicketNo,u.UnitId,u.UnitName,vc.VeichleId,vc.VeichleNumber, " +
"t.LoadedWeight,t.EmptyWeight,t.NetWeight,t.RecievedAmt,t.Tdate,su.SupplierId,su.SupplierName,mt.MaterialId,mt.MaterialName from Transactions t " +
"inner join Units u on u.UnitId=t.UnitId " +
"inner join VeichleEntry vc on vc.VeichleId=t.VeichleId " +
"inner join Supplier su on su.SupplierId=t.SupplierId " +
"inner join Material mt on mt.MaterialId=t.MaterialId where 1=1");
if (VehicleId != null)
{
sq.Append($" and vc.VeichleId = {VehicleId}");
}
if (ticketno != null)
{
sq.Append($" and t.TicketNo = {ticketno}");
}
if (SupplierId != null)
{
sq.Append($" and su.SupplierId = {SupplierId}");
}
if (MaterialId != null)
{
sq.Append($" and mt.MaterialId = {MaterialId}");
}
var rs = db.Query <Transactionvw>(sq);
return(View("Index", rs));
}
public DataTable getEx_Data(int Pl_Code, IList <CRMTreeDatabase.EX_Param> eps)
{
try
{
CT_Reports Report = RP.GetReprot_Chat(ChartType.List, Pl_Code);
var db = CRMTreeDatabase.DBCRMTree.GetInstance();
PetaPoco.Sql _s = BL_Reports.GetReportSql(Report.RP_Code, eps);
var qData = new object();
if (_s.SQL.IndexOf(";Exec", StringComparison.OrdinalIgnoreCase) >= 0)
{
qData = db.Query <dynamic>(_s);
}
else
{
var pSql = PetaPoco.Sql.Builder;
pSql.Append("select * from(" + _s.SQL, _s.Arguments);
pSql.Append(") as dt");
qData = db.Query <dynamic>(pSql);
}
//Report.RP_Query = _s.SQL;
//DataTable dt = BL_Reports.GetReportSqlWithTemplate(Report.RP_Query);
//return dt;
string _j_d = JsonConvert.SerializeObject(qData);
DataTable _d = ToDataTable(_j_d);
return(_d);
}
catch
{
return(null);
}
}
private long Count(string clientName, bool completed, DateTime?clientStartTime)
{
var parameters = new QueryParameters();
parameters.Fields.Add(new QueryField {
Name = QueryFieldName.Name, Type = QueryFieldType.Equal, Value = clientName
});
parameters.Fields.Add(new QueryField
{
Name = QueryFieldName.Result,
Type = completed ? QueryFieldType.Equal : QueryFieldType.NotEqual,
Value = (int)WorkUnitResult.FinishedUnit
});
if (clientStartTime.HasValue)
{
parameters.Fields.Add(new QueryField
{
Name = completed ? QueryFieldName.CompletionDateTime : QueryFieldName.DownloadDateTime,
Type = QueryFieldType.GreaterThan,
Value = clientStartTime.Value
});
}
PetaPoco.Sql where = WhereBuilder.Execute(parameters);
var countSql = PetaPoco.Sql.Builder.Select("ID", "InstanceName", "DownloadDateTime", "CompletionDateTime", "Result", "COUNT(*)")
.From("WuHistory")
.Append(where);
using (var table = Select(countSql.SQL, countSql.Arguments))
{
return((long)table.Rows[0][5]);
}
}
public PartialViewResult RelationFieldSelectPanelMulti(int fieldid, string value = "", int id = 0, string filter = "", int height = 310, string page = "list")
{
ViewBag.ID = id;
ViewBag.Value = value;
ViewBag.WhereSql = filter;
ViewBag.SelectValue = new List <RelationEntityField>();
Repository <RelationEntityField> crmRepository = new Repository <RelationEntityField>();
var entity = fieldService.Get(fieldid).Data;
ViewBag.Field = entity.Name;
var RelationEntityID = SystemSetService.Entity.GetEntityID(entity.RelationEntity);
ViewBag.EntityID = RelationEntityID;
ViewBag.RelationEntity = entity.RelationEntity;
var ViewObj = SystemSetService.View.GetViewByTypeEntityID(RelationEntityID, ViewTypeEnum.弹框视图.ToString());
ViewBag.Columns = ViewObj.FieldList;
ViewBag.ViewID = ViewObj.ID;
ViewBag.page = page;
ViewBag.SearchField = SystemSetService.Search.GetDialogSearchFields(RelationEntityID);
if (!string.IsNullOrEmpty(value))
{
var sql = new PetaPoco.Sql("SELECT ID,Name FROM " + entity.RelationEntity);
sql.Where("ID IN(" + value + ")");
ViewBag.SelectValue = crmRepository.GetList <RelationEntityField>(sql);
}
ViewBag.height = height;
return(PartialView());
}
public int UndoUpdate(LogMySqlDataModel LogToUpdate)
{
try
{
using (AsignioDatabase db = new AsignioDatabase(ConnectionStringName))
{
string sqlFormattedTimeStamp = LogToUpdate.DateTimeStamp.ToString("yyyy-MM-dd HH:mm:ss");
PetaPoco.Sql sql = new PetaPoco.Sql();
string nullString = "null";
sql.Append("SET SQL_SAFE_UPDATES = 0; ");
sql.Append(string.Format("UPDATE logmysql SET Important = {0} ", nullString));
string where = string.Format("WHERE DateTimeStamp = \"{0}\" AND logmysql.Function = \"{1}\" AND Message = \"{2}\" AND Type = \"{3}\"; ",
sqlFormattedTimeStamp, LogToUpdate.Function, LogToUpdate.Message, LogToUpdate.Type);
sql.Append(where);
sql.Append("SET SQL_SAFE_UPDATES = 1; ");
db.Execute(sql);
return(1);
}
}
catch (Exception ex)
{
string errorMessage = ex.Message;
return(0);
}
finally { }
}
public int UndoUpdate(CombinedLogDataModel LogToUpdate)
{
try
{
using (AsignioDatabase db = new AsignioDatabase(ConnectionStringName))
{
string sqlFormattedTimeStamp = LogToUpdate.TimeStamp.ToString("yyyy-MM-dd HH:mm:ss");
PetaPoco.Sql sql = new PetaPoco.Sql();
string nullString = "null";
sql.Append("SET SQL_SAFE_UPDATES = 0; ");
sql.Append(string.Format("UPDATE log SET Important = {0} ", nullString));
string where = string.Format("WHERE TimeStamp = \"{0}\" AND LogID = GuidToBinary(\"{1}\") AND Level = \"{2}\" AND Source = \"{3}\" ; ",
sqlFormattedTimeStamp, LogToUpdate.LogID, LogToUpdate.Level, LogToUpdate.Source);
sql.Append(where);
sql.Append("SET SQL_SAFE_UPDATES = 1; ");
db.Execute(sql);
return(1);
}
}
catch (Exception ex)
{
string errorMessage = ex.Message;
return(0);
}
finally { }
}
public IEnumerable <Theatre> GetTheatres(int id)
{
using var db = new PetaPoco.Database(ConnectionString, providerName);
var cmd = new PetaPoco.Sql(";EXEC BookMyShowDb1.dbo.GetTheatres @@movieId = @0", id);
var Theatres = db.Fetch <Theatre>(cmd);
return(Theatres);
}
/// <summary>
/// wraps up the process of starting an IDatabase instace, executing the query, and closing out the IDatabase instance
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="sql"></param>
/// <returns></returns>
protected IEnumerable <T> Query <T>(PetaPoco.Sql sql)
{
using (var db = this.GetDatabase())
{
return(db.Query <T>(sql)
.ToList());
}
}
/// <summary>
/// Select文の結果をDataTableで返します
/// （DataTableをそのまんまWCFで返すのはやめよう）
/// </summary>
/// <param name="sql">SQL object</param>
/// <returns>SELECT文の結果</returns>
public DataTable GetDataTable(PetaPoco.Sql sql)
{
if (sql == null)
{
throw new ArgumentNullException(nameof(sql));
}
return(GetDataTable(sql.SQL, sql.Arguments.ToArray()));
}
void HandleSpawnIdlerCommand(string msg, SteamID sender)
{
string[] args = msg.Split(' ');
if (args.Length != 2)
{
SteamFriends.SendChatMessage(sender, EChatEntryType.ChatMsg,
"Invalid arguments.");
return;
}
int id = 0;
if (!int.TryParse(args[1], out id))
{
SteamFriends.SendChatMessage(sender, EChatEntryType.ChatMsg,
"Invalid idler id.");
return;
}
#if DATABASE
var sql = new PetaPoco.Sql().Select("*").From("account")
.Where("id = @0", id);
var accounts = Database.Query <IdleAccount>(sql);
foreach (var account in accounts)
{
var credentials = new BotCredentials()
{
Username = account.username,
Password = account.password,
IdlerId = account.id
};
SteamFriends.SendChatMessage(sender, EChatEntryType.ChatMsg,
string.Format("Spawning idler bot: id {0} {1}", account.id,
account.username));
var logger = new SteamLogger()
{
Id = sender,
SteamFriends = SteamFriends
};
var idlebot = new Bot(logger, ItemsSchema, credentials);
idlebot.OnWebLoggedOn += (b) =>
{
b.SteamFriends.SetPersonaState(EPersonaState.Online);
};
idlebot.Initialize(useUDP: true);
idlebot.Connect();
IdlerBots.Add(idlebot);
}
#endif
}
public List <TicketViewModel> GetAllTickets()
{
using (var db = new PetaPoco.Database(ConnectionString, providerName))
{
var cmd = new PetaPoco.Sql(";EXEC BookMyShowDb1.dbo.GetAllTickets");
List <TicketViewModel> Tickets = db.Fetch <TicketViewModel>(cmd);
return(Tickets);
}
}
public IEnumerable <TicketViewModel> GetTickets(string userid)
{
using (var db = new PetaPoco.Database(ConnectionString, providerName))
{
var cmd = new PetaPoco.Sql(";EXEC BookMyShowDb1.dbo.GetUserTickets @@userid = @0", userid);
var Tickets = db.Fetch <TicketViewModel>(cmd);
return(Tickets);
}
}
public void Join_GivenTable()
{
_sql = PetaPoco.Sql.Builder
.Select("*")
.From("articles")
.LeftJoin("comments").On("articles.article_id=comments.article_id");
Assert.Equal("SELECT *\r\nFROM articles\r\nLEFT JOIN comments\r\nON articles.article_id=comments.article_id", _sql.SQL);
}
public void Append_GivenConsecutiveSets()
{
_sql = new PetaPoco.Sql()
.Append("UPDATE blah");
_sql.Append("SET a = 1");
_sql.Append("SET b = 2");
Assert.Equal("UPDATE blah\r\nSET a = 1\r\n, b = 2", _sql.SQL);
}
public void Append_GivenConsecutiveWheres()
{
_sql = new PetaPoco.Sql()
.Append("SELECT * FROM blah");
_sql.Append("WHERE x");
_sql.Append("WHERE y");
Assert.Equal("SELECT * FROM blah\r\nWHERE x\r\nAND y", _sql.SQL);
}
public void Append_GivenArray()
{
_sql = PetaPoco.Sql.Builder.Append("IN (@numbers)", new { numbers = (new[] { 10, 20, 30 }) });
Assert.Equal("IN (@0,@1,@2)", _sql.SQL);
Assert.Equal(3, _sql.Arguments.Count);
Assert.Equal(10, _sql.Arguments[0]);
Assert.Equal(20, _sql.Arguments[1]);
Assert.Equal(30, _sql.Arguments[2]);
}
public void Append_GivenConsecutiveOrderBys()
{
_sql = new PetaPoco.Sql()
.Append("SELECT * FROM blah");
_sql.Append("ORDER BY x");
_sql.Append("ORDER BY y");
Assert.Equal("SELECT * FROM blah\r\nORDER BY x\r\n, y", _sql.SQL);
}
private Database queryForDatabase()
{
var sql = new PetaPoco.Sql(@"SELECT DatabaseName
, ObjectId
, EP.value AS [Description]
FROM
( SELECT DB_NAME() AS DatabaseName, DB_ID() AS ObjectId ) AS DbInfo
LEFT OUTER JOIN sys.extended_properties AS EP
ON ( EP.class = 0 AND EP.[name] = 'MS_Description' );");
return this.peta.FirstOrDefault<Database>(sql);
}
private Database queryForDatabase()
{
var sql = new PetaPoco.Sql(@"SELECT DatabaseName
, ObjectId
, EP.value AS [Description]
FROM
( SELECT DB_NAME() AS DatabaseName, DB_ID() AS ObjectId ) AS DbInfo
LEFT OUTER JOIN sys.extended_properties AS EP
ON ( EP.class = 0 AND EP.[name] = 'MS_Description' );" );
return(this.peta.FirstOrDefault <Database>(sql));
}
public void Append_GivenConsecutiveSetsAndWheres()
{
_sql = new PetaPoco.Sql()
.Append("UPDATE blah");
_sql.Append("SET a = 1");
_sql.Append("SET b = 2");
_sql.Append("WHERE x");
_sql.Append("WHERE y");
Assert.Equal("UPDATE blah\r\nSET a = 1\r\n, b = 2\r\nWHERE x\r\nAND y", _sql.SQL);
}
public void Append_GivenArrayString()
{
var keys = new string[] { "10", "20", "30" };
//_sql = PetaPoco.Sql.Builder.Append("IN (@0)", keys); ←これはダメ。エラーになっちゃう
_sql = PetaPoco.Sql.Builder.Append("IN (@1)", null, keys);
Assert.Equal("IN (@0,@1,@2)", _sql.SQL);
Assert.Equal(3, _sql.Arguments.Count);
Assert.Equal("10", _sql.Arguments[0]);
Assert.Equal("20", _sql.Arguments[1]);
Assert.Equal("30", _sql.Arguments[2]);
}
public void Append_GivenArrayAndValue()
{
// Simple collection parameter expansion
_sql = PetaPoco.Sql.Builder.Append("@0 IN (@1) @2", 20, new int[] { 1, 2, 3 }, 30);
Assert.Equal("@0 IN (@1,@2,@3) @4", _sql.SQL);
Assert.Equal(5, _sql.Arguments.Count);
Assert.Equal(20, _sql.Arguments[0]);
Assert.Equal(1, _sql.Arguments[1]);
Assert.Equal(2, _sql.Arguments[2]);
Assert.Equal(3, _sql.Arguments[3]);
Assert.Equal(30, _sql.Arguments[4]);
}
public JsonResult GetCarBikeList(DTParameters parameters)
{
var columnSearch = parameters.Columns.Select(s => s.Search.Value).Take(CarBikeColumns.Count()).ToList();
//XMLPath uses nested queries so to avoid that we construct these 4 filters ourselves
string geos = "";
if (columnSearch[2]?.Length > 0)
{
geos = columnSearch[2]; columnSearch[2] = null;
}
var sql = new PetaPoco.Sql($"Select distinct c.*,Substring(Description,1,100) as Description from CarBike c");
var fromsql = new PetaPoco.Sql();
var wheresql = new PetaPoco.Sql("where c.CarBikeID >0 ");
if (geos.Length > 0)
{
fromsql.Append(", Geotree g");
wheresql.Append($"and g.GeoTreeID=a.GeoTreeID and geoname like '%{geos}%'");
}
wheresql.Append($"{GetWhereWithOrClauseFromColumns(CarBikeColumns, columnSearch)}");
sql.Append(fromsql);
sql.Append(wheresql);
try
{
var res = db.Query <CarBikeDets>(sql).Skip(parameters.Start).Take(parameters.Length).ToList();
res.ForEach(r =>
{
r.GeoName = String.Join(", ", db.Query <string>("Select GeoName from GeoTree where GeoTreeID=@0", r.GeoTreeID));
});
var dataTableResult = new DTResult <CarBikeDets>
{
draw = parameters.Draw,
data = res,
recordsFiltered = 10,
recordsTotal = res.Count()
};
return(Json(dataTableResult, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
throw ex;
}
}
void HandleListIdlersCommand(string msg, SteamID sender)
{
#if DATABASE
var sql = new PetaPoco.Sql().Select("*").From("idle_account");
string order = "id";
string[] args = msg.Split(' ');
if (args.Length == 2)
{
if (args[1].StartsWith("w"))
{
order = "weapon_count";
}
else if (args[1].StartsWith("i"))
{
order = "item_count";
}
else if (args[1].StartsWith("h"))
{
order = "hat_count";
}
else if (args[1].StartsWith("t"))
{
order = "weapon_count";
}
else if (args[1].StartsWith("c"))
{
order = "crate_count";
}
}
sql = sql.OrderBy(order);
var accounts = Database.Query <IdleAccount>(sql);
var sb = new StringBuilder();
sb.AppendLine("Idlers:");
foreach (var account in accounts)
{
sb.AppendLine(string.Format("{0} {1} | {2} weapons",
account.id, account.username, account.weapon_count));
}
SteamFriends.SendChatMessage(sender, EChatEntryType.ChatMsg,
sb.ToString());
#else
SteamFriends.SendChatMessage(sender, EChatEntryType.ChatMsg,
"No database support in this build.");
#endif
}
private static PetaPoco.Sql BuildWhereCondition(PetaPoco.Sql sql, WorkUnitQueryParameter parameter)
{
string format = "[{0}] {1} @0";
if (parameter.Column.Equals(WorkUnitRowColumn.Assigned) ||
parameter.Column.Equals(WorkUnitRowColumn.Finished))
{
format = "datetime([{0}]) {1} datetime(@0)";
}
sql = sql.Append(String.Format(CultureInfo.InvariantCulture, format,
ColumnNameOverrides.ContainsKey(parameter.Column) ? ColumnNameOverrides[parameter.Column] : parameter.Column.ToString(),
parameter.GetOperatorString()), parameter.Value);
return(sql);
}
public void Append_GivenListString()
{
var keys = new List <string> {
"い", "ろ", "は",
};
_sql = PetaPoco.Sql.Builder.Append("IN (@0)", keys);
Assert.Equal("IN (@0,@1,@2)", _sql.SQL);
Assert.Equal(3, _sql.Arguments.Count);
Assert.Equal("い", _sql.Arguments[0]);
Assert.Equal("ろ", _sql.Arguments[1]);
Assert.Equal("は", _sql.Arguments[2]);
}
public int Update(CombinedLogControllerActionDataModel LogToUpdate, string username)
{
try
{
using (AsignioDatabase db = new AsignioDatabase(ConnectionStringName))
{
Byte[] bytes = new Byte[16];
Guid allZeros = new Guid(bytes);
Guid UserID = GetUserIDFromUsername(username);
if (UserID != allZeros)
{
if (username.Contains("@")) //format email
{
string[] sections = username.Split(new[] { '@' });
sections[1] = sections[1].Insert(0, "@@");
username = string.Join("", sections);
}
string sqlFormattedTimeStamp = LogToUpdate.TimeStamp.ToString("yyyy-MM-dd HH:mm:ss");
PetaPoco.Sql sql = new PetaPoco.Sql();
username = string.Format("\"{0}\"", username);
sql.Append("SET SQL_SAFE_UPDATES = 0; ");
sql.Append(string.Format("UPDATE logcontrolleraction SET Important = {0} ", username));
string where = string.Format("WHERE TimeStamp = \"{0}\" AND WebRequestID = GuidToBinary(\"{1}\") AND ControllerName = \"{2}\" AND ActionName = \"{3}\" AND UserID = GuidToBinary(\"{4}\"); ",
sqlFormattedTimeStamp, LogToUpdate.WebRequestID, LogToUpdate.ControllerName, LogToUpdate.ActionName, LogToUpdate.UserID);
sql.Append(where);
sql.Append("SET SQL_SAFE_UPDATES = 1; ");
db.Execute(sql);
return(1);
}
else
{
return(0);
}
}
}
catch (Exception ex)
{
string errorMessage = ex.Message;
}
finally { }
return(0);
}
public void Append_GivenTwoArrays()
{
// Out of order expansion
_sql = PetaPoco.Sql.Builder.Append("IN (@3) (@1)", null, new[] { 10, 20, 30 }, null, new[] { 40, 50, 60 });
Assert.Equal("IN (@0,@1,@2) (@3,@4,@5)", _sql.SQL);
Assert.Equal(6, _sql.Arguments.Count);
Assert.Equal(40, _sql.Arguments[0]);
Assert.Equal(50, _sql.Arguments[1]);
Assert.Equal(60, _sql.Arguments[2]);
Assert.Equal(10, _sql.Arguments[3]);
Assert.Equal(20, _sql.Arguments[4]);
Assert.Equal(30, _sql.Arguments[5]);
}
private static PetaPoco.Sql BuildWhereCondition(PetaPoco.Sql sql, QueryField queryField)
{
string format = "[{0}] {1} @0";
if (queryField.Name.Equals(QueryFieldName.DownloadDateTime) ||
queryField.Name.Equals(QueryFieldName.CompletionDateTime))
{
format = "datetime([{0}]) {1} datetime(@0)";
}
sql = sql.Append(String.Format(CultureInfo.InvariantCulture, format,
ColumnNameOverides.ContainsKey(queryField.Name) ? ColumnNameOverides[queryField.Name] : queryField.Name.ToString(),
queryField.Operator), queryField.Value);
return(sql);
}
// POST api/<controller>
public BootRecord Post(EditBootRecord editbootRecord)
{
string tbname = "";
if (editbootRecord.typeid== 1)
tbname = "t_MachineStop_rd";
else if(editbootRecord.typeid == 0)
tbname = "t_AsyncSCR_rd";
PetaPoco.Sql sql = new PetaPoco.Sql();
sql.Select("*").From(tbname);
sql.Where("id=@0", editbootRecord.id);
BootRecord BootRecords = db.Fetch<BootRecord>(sql).FirstOrDefault();
if (editbootRecord != null && BootRecords != null)
{
PetaPoco.Sql updateSql = new PetaPoco.Sql();
BootRecords.description = editbootRecord.description;
db.Update(tbname, "id", BootRecords);
}
return BootRecords;
}
private PetaPoco.Page<HistoryEntry> PageInternal(long page, long itemsPerPage, QueryParameters parameters, BonusCalculationType bonusCalculation)
{
Debug.Assert(TableExists(SqlTable.WuHistory));
var select = new PetaPoco.Sql(SqlTableCommandDictionary[SqlTable.WuHistory].SelectSql);
select.Append(WhereBuilder.Execute(parameters));
GetProduction.BonusCalculation = bonusCalculation;
using (var connection = new SQLiteConnection(ConnectionString))
{
connection.Open();
using (var database = new PetaPoco.Database(connection))
{
PetaPoco.Page<HistoryEntry> query = database.Page<HistoryEntry>(page, itemsPerPage, select);
Debug.Assert(query != null);
return query;
}
}
}
private IList<HistoryEntry> FetchInternal(QueryParameters parameters, BonusCalculationType bonusCalculation)
{
Debug.Assert(TableExists(SqlTable.WuHistory));
var select = new PetaPoco.Sql(SqlTableCommandDictionary[SqlTable.WuHistory].SelectSql);
select.Append(WhereBuilder.Execute(parameters));
GetProduction.BonusCalculation = bonusCalculation;
using (var connection = new SQLiteConnection(ConnectionString))
{
connection.Open();
using (var database = new PetaPoco.Database(connection))
{
List<HistoryEntry> query = database.Fetch<HistoryEntry>(select);
return query;
}
}
}
