public override void FillFromDataRow(System.Data.DataRow dr)
{
this.Id = DbConvert.ToString(dr, "Id");
this.Active = DbConvert.ToBool(dr, "Active");
this.OddIncreaseDecrease = DbConvert.ToDecimal(dr, "OddIncreaseDecrease");
this.Markets = DbConvert.ToString(dr, "Markets");
}
/// <summary>
/// 分页查询
/// </summary>
/// <typeparam name="T"></typeparam>
/// <typeparam name="whereCols">查询条件</typeparam>
/// <param name="t"></param>
/// <returns></returns>
public PageInfo <T> SelectPage <T>(PageInfo <T> pageInfo, string cols, string whereCols, WhereType whereType)
{
SqlModel selectModel = CreateSqlHelper.SelectSqlByPage(pageInfo, cols, whereCols, whereType);
DataTable dataTable = SQLiteHelper.ExecuteDataTable(selectModel.Sql, false, selectModel.SqlParameters);
List <T> lists = DbConvert.TableToList <T>(dataTable);
SqlModel selectCountModel = CreateSqlHelper.SelectCount(pageInfo.ParamsSearch, whereCols, whereType);
object result = SQLiteHelper.ExecuteScalar(selectCountModel.Sql, false, selectCountModel.SqlParameters);
int total = Convert.ToInt32(result);
int totalPage = 0;
if (total % pageInfo.PageSize == 0)
{
totalPage = total / pageInfo.PageSize;
}
else
{
totalPage = total / pageInfo.PageSize + 1;
}
pageInfo.TotalPage = totalPage;
pageInfo.Records = lists;
pageInfo.CurrentCount = total;
//lists.Count;
return(pageInfo);
}
private void ShowPreviousVersionDocLink()
{
if (doc.PreviousVersionId < 1)
{
PanPreviousVersionDocView.Visible = false;
}
else
{
ArrayList docEnum = new ArrayList();
docEnum.Add(doc.PreviousVersionId);
DataTable tab = DocumentEnt.FindEnum(docEnum);
if (tab == null || tab.Rows.Count < 1)
{
PanPreviousVersionDocView.Visible = false;
}
else
{
PanPreviousVersionDocView.Visible = true;
string sid = DbConvert.ToString(tab.Rows[0]["Id"]);
PanPreviousVersionDocInfo.Rows[0].Cells[1].InnerHtml =
"<a href='javascript:ViewDoc(" + sid + ")' >" +
HttpUtility.HtmlEncode(DbConvert.ToString(tab.Rows[0]["Header"])) +
"</a>";
}
}
}
public override void FillFromDataRow(System.Data.DataRow dr)
{
this.ResourceId = DbConvert.ToInt64(dr, "ResourceId");
this.ResourceType = (eResourceType)Enum.Parse(typeof(eResourceType), DbConvert.ToString(dr, "ResourceType"));
this.MimeType = DbConvert.ToString(dr, "MimeType");
this.Data = DbConvert.ToString(dr, "Data");
}
/// <summary>
/// sqlite 查询数据库所有表
/// </summary>
/// <param name="dbConnect"></param>
/// <param name="dbName"></param>
/// <param name="tableName"></param>
/// <returns></returns>
public static List <TableInfo> SelectTableNameBySqlite(string dbConnect, string dbName, string tableKeyword)
{
List <TableInfo> lists = new List <TableInfo>();
try
{
string sqlAllTable = "SELECT name as TABLE_NAME FROM sqlite_master WHERE type='table' and name!='sqlite_sequence' ";
if (!string.IsNullOrEmpty(tableKeyword))
{
sqlAllTable += $" and name like '%{tableKeyword}%'";
}
sqlAllTable += " ORDER BY name";
SQLiteHelper.connectionString = dbConnect;
DataTable dataTable = SQLiteHelper.ExecuteDataTable(sqlAllTable, false, null);
lists = DbConvert.TableToList <TableInfo>(dataTable);
}
catch (Exception)
{
throw;
}
finally
{
SQLiteHelper.connectionString = $@"data source={AppDomain.CurrentDomain.BaseDirectory}{ConfigurationManager.AppSettings["dbRootFolder"].ToString()}\{ConfigurationManager.AppSettings["dbName"].ToString()}";
}
return(lists);
}
/// <summary>
/// 获取指定 供应商/客户 、 仓库 、商品的相关单据明细列表
/// </summary>
/// <param name="shType"></param>
/// <param name="typeId"></param>
/// <param name="id"></param>
/// <returns></returns>
public List <SheetGoodsInfoModel> GetSheetGoodsInfoList(int shType, int typeId, int id)
{
DataTable dt = GetSheetGoodsInfoDt(shType, typeId, id);
string cols = "Id,SheetId,SheetNo,ShType,IsChecked,CreateTime,UnitId,UnitName,Count,Price,Amount,DealPerson,Creator,CheckPerson,CheckTime,StoreId,StoreName,GoodsId,GoodsNo,GoodsName,GUnit";
return(DbConvert.DataTableToList <SheetGoodsInfoModel>(dt, cols));
}
//clob字段单独获取
public string GetLayoutValue(string logid)
{
//string sqlString = " select * from fg_layoutlog where logid=" + DbConvert.ToSqlString(logid);
string sqlString = " select value from fg_layoutlog where logid=" + DbConvert.ToSqlString(logid);
return(DbHelper.GetString(sqlString));
}
/// <summary>
/// 删除数据
/// </summary>
/// <param name="primaryKey"></param>
/// <returns></returns>
public int DeleteLayoutLogInfo(string primaryKey)
{
//需要修改 parmaryKey 为自己的主键
string Sql = string.Format("delete from fg_layoutlog where gid ={0}", DbConvert.ToSqlString(primaryKey));
return(DbHelper.ExecuteNonQuery(Sql));
}
public override void FillFromDataRow(System.Data.DataRow dr)
{
this.ResourceId = DbConvert.ToInt64(dr, "ResourceId");
this.ResourceType = (eAssignmentType)Enum.Parse(typeof(eAssignmentType), DbConvert.ToString(dr, "ObjectClass"));
this.ObjectId = DbConvert.ToInt64(dr, "ObjectId");
this.Active = DbConvert.ToBool(dr, "Active");
}
/// <summary>
/// 保存用户查询数据
/// </summary>
/// <param name="PageId"></param>
/// <param name="ClientJsonString"></param>
/// <returns></returns>
public int SetQueryPanelData(string PageId, string ClientJsonString)
{
string sqlWhere = " pageid=" + DbConvert.ToSqlString(PageId) + " and userid=" + DbConvert.ToSqlString(NG3.AppInfoBase.LoginID) + " and cboo=" + DbConvert.ToSqlString(NG3.AppInfoBase.OCode);
string query = DataConverterHelper.ConvertQueryString(ClientJsonString);
//目前是直接删除后创建 这样的话，guid的主从明细表就查不到明细数据了
//若存在 则更新，否则 删除后创建
DataTable tmpDT = DbHelper.GetDataTable("select * from c_sys_search_def_master where " + sqlWhere);
if (tmpDT.Rows.Count == 0)
{
DataRow dr = tmpDT.NewRow();
dr["id"] = Guid.NewGuid().ToString();
dr["pageid"] = PageId;
dr["userid"] = NG3.AppInfoBase.LoginID;
dr["cboo"] = NG3.AppInfoBase.OCode;
dr["isdefault"] = 0;
dr["ismember"] = 0;
dr["remeberstr"] = ClientJsonString;
dr["reembersql"] = query;
tmpDT.Rows.Add(dr);
return(DbHelper.Update(tmpDT, "select * from c_sys_search_def_master"));
}
else
{
tmpDT.Rows[0]["isdefault"] = 0;
tmpDT.Rows[0]["ismember"] = 0;
tmpDT.Rows[0]["remeberstr"] = ClientJsonString;
tmpDT.Rows[0]["reembersql"] = query;
return(DbHelper.Update(tmpDT, "select * from c_sys_search_def_master where " + sqlWhere));
}
}
public override void FillFromDataRow(DataRow dr)
{
this.MatchId = DbConvert.ToInt64(dr, "MatchId");
this.GroupId = DbConvert.ToInt64(dr, "GroupId");
this.Type = DbConvert.ToString(dr, "Type");
this.Sort = DbConvert.ToInt32(dr, "Sort");
this.UpdateId = DbConvert.ToInt64(dr, "UpdateId");
}
public const string BETDOMAIN_MULTISTRING_GROUP = "BETDOMAIN_MSG"; // BetDomain
public override void FillFromDataRow(DataRow dr)
{
this.MultiStringGroupID = DbConvert.ToInt64(dr, "MultiStringGroupID");
this.MultiStringGroupTag = DbConvert.ToString(dr, "MultiStringGroupTag");
this.Comment = DbConvert.ToString(dr, "Comment");
this.LastModified = DbConvert.ToDateTime(dr, "LastModified");
this.SvrMultiStringGroupID = DbConvert.ToInt64(dr, "SvrMultiStringGroupID");
}
public override void FillFromDataRow(System.Data.DataRow dr)
{
this.MatchInfoId = DbConvert.ToInt64(dr, "matchinfoid");
this.LastModified = DbConvert.ToDateTime(dr, "LastModified");
MatchInfosValuesExternalState obj = LineSerializeHelper.StringToObject <MatchInfosValuesExternalState>(DbConvert.ToString(dr, "external_state"));
this.external_state.StatisticValues = obj.StatisticValues;
}
public override void FillFromDataRow(DataRow dr)
{
this.CategoryID = DbConvert.ToInt64(dr, "CategoryID");
this.SvrCategoryID = DbConvert.ToInt64(dr, "SvrCategoryID");
this.MultiStringID = DbConvert.ToInt64(dr, "MultiStringID");
this.DefaultName = DbConvert.ToString(dr, "DefaultName");
this.Sort = DbConvert.ToInt32(dr, "Sort");
this.LastModified = DbConvert.ToDateTime(dr, "LastModified");
}
public override void FillFromDataRow(DataRow dr)
{
this.SportID = DbConvert.ToInt64(dr, "SportID");
this.SvrSportID = DbConvert.ToInt64(dr, "SvrSportID");
this.BtrSportID = DbConvert.ToNullableInt64(dr, "BtrSportID");
this.DefaultName = DbConvert.ToString(dr, "DefaultName");
this.MultiStringID = DbConvert.ToInt64(dr, "MultiStringID");
this.LastModified = DbConvert.ToDateTime(dr, "LastModified");
}
public override void FillFromDataRow(System.Data.DataRow dr)
{
this.TournamentInfoId = DbConvert.ToInt64(dr, "tournamentinfoid");
this.LastModified = DbConvert.ToDateTime(dr, "LastModified");
TournamentInfosValuesExternalState obj = LineSerializeHelper.StringToObject <TournamentInfosValuesExternalState>(DbConvert.ToString(dr, "external_state"));
this.external_state.CompetitorsContainer = obj.CompetitorsContainer;
}
/// <summary>
/// Compare two FieldTest entities
/// </summary>
/// <param name="expected"></param>
/// <param name="actual"></param>
public static void Compare(FieldTest expected, FieldTest actual)
{
// Check for nulls
if (expected == null && actual == null)
{
return;
}
if (expected == null)
{
Assert.Fail("Expected null, got FieldTest");
}
if (actual == null)
{
Assert.Fail("Expected FieldTest, got null");
}
// Compare simple properties
Assert.AreEqual(expected.Id, actual.Id, "FieldTest.Id not equal");
Assert.AreEqual(expected.IntField, actual.IntField, "FieldTest.IntField not equal");
Assert.AreEqual(expected.IntFieldNullable, actual.IntFieldNullable, "FieldTest.IntFieldNullable not equal");
Assert.AreEqual(expected.DecimalField, actual.DecimalField, "FieldTest.DecimalField not equal");
Assert.AreEqual(expected.DecimalFieldNullable, actual.DecimalFieldNullable, "FieldTest.DecimalFieldNullable not equal");
Assert.AreEqual(expected.StringField, actual.StringField, "FieldTest.StringField not equal");
Assert.AreEqual(expected.StringFieldNullable, actual.StringFieldNullable, "FieldTest.StringFieldNullable not equal");
Assert.AreEqual(expected.TextField, actual.TextField, "FieldTest.TextField not equal");
Assert.AreEqual(expected.TextFieldNullable, actual.TextFieldNullable, "FieldTest.TextFieldNullable not equal");
Compare(expected.DatetimeField, actual.DatetimeField, "FieldTest.DatetimeField");
Compare(expected.DatetimeFieldNullable, actual.DatetimeFieldNullable, "FieldTest.DatetimeFieldNullable");
Assert.AreEqual(expected.TinyintField, actual.TinyintField, "FieldTest.TinyintField not equal");
Assert.AreEqual(expected.TinyintFieldNullable, actual.TinyintFieldNullable, "FieldTest.TinyintFieldNullable not equal");
Compare(expected.TimestampField, actual.TimestampField, "FieldTest.TimestampField");
Compare(expected.TimestampFieldNullable, actual.TimestampFieldNullable, "FieldTest.TimestampFieldNullable");
Assert.AreEqual(expected.EnumField, actual.EnumField, "FieldTest.EnumField not equal");
Assert.AreEqual(expected.EnumFieldNullable, actual.EnumFieldNullable, "FieldTest.EnumFieldNullable not equal");
Assert.AreEqual(expected.ForeignKeyField, actual.ForeignKeyField, "FieldTest.ForeignKeyField not equal");
Assert.AreEqual(expected.ForeignKeyFieldNullable, actual.ForeignKeyFieldNullable, "FieldTest.ForeignKeyFieldNullable not equal");
Assert.AreEqual(DbConvert.ToDateInt(expected.IntDateField), DbConvert.ToDateInt(actual.IntDateField), "FieldTest.IntDateField not equal");
Assert.AreEqual(DbConvert.ToDateInt(expected.IntDateFieldNullable), DbConvert.ToDateInt(actual.IntDateFieldNullable), "FieldTest.IntDateFieldNullable not equal");
Assert.AreEqual(expected.IndexedField, actual.IndexedField, "FieldTest.IndexedField not equal");
Assert.AreEqual(expected.IndexedFieldNullable, actual.IndexedFieldNullable, "FieldTest.IndexedFieldNullable not equal");
Assert.AreEqual(expected.NodeIdField, actual.NodeIdField, "FieldTest.NodeIdField not equal");
Assert.AreEqual(expected.NodeIdFieldNullable, actual.NodeIdFieldNullable, "FieldTest.NodeIdFieldNullable not equal");
Assert.AreEqual(expected.DefaultValueIsTwo, actual.DefaultValueIsTwo, "FieldTest.DefaultValueIsTwo not equal");
// Compare ForeignKeyFieldWidget
if (expected.ForeignKeyFieldWidgetPopulated && actual.ForeignKeyFieldWidgetPopulated)
{
WidgetComparer.Compare(expected.ForeignKeyFieldWidget, actual.ForeignKeyFieldWidget);
}
// Compare ForeignKeyFieldNullableWidget
if (expected.ForeignKeyFieldNullableWidgetPopulated && actual.ForeignKeyFieldNullableWidgetPopulated)
{
WidgetComparer.Compare(expected.ForeignKeyFieldNullableWidget, actual.ForeignKeyFieldNullableWidget);
}
}
/// <summary>
/// 查询
/// </summary>
/// <typeparam name="T"></typeparam>
/// <typeparam name="whereCols">查询条件</typeparam>
/// <param name="t"></param>
/// <returns></returns>
public List <T> SelectPage <T>(T t, string cols, string whereCols, WhereType whereType)
{
SqlModel insertModel = CreateSqlHelper.SelectSql(t, cols, whereCols, whereType);
DataTable dataTable = SQLiteHelper.ExecuteDataTable(insertModel.Sql, false, insertModel.SqlParameters);
List <T> lists = DbConvert.TableToList <T>(dataTable);
return(lists);
}
public override void FillFromDataRow(DataRow dr)
{
this.LanguageID = DbConvert.ToInt64(dr, "LanguageID");
this.ShortName = DbConvert.ToString(dr, "ShortName");
this.MultiStringID = DbConvert.ToInt64(dr, "MultiStringID");
this.Priority = DbConvert.ToNullableInt32(dr, "Priority");
this.LastModified = DbConvert.ToDateTime(dr, "LastModified");
this.SvrLanguageId = DbConvert.ToInt64(dr, "SvrLanguageId");
this.IsTerminalLanguage = DbConvert.ToInt32(dr, "IsTerminalLanguage");
}
public override void FillFromDataRow(DataRow dr)
{
this.CompetitorId = DbConvert.ToInt64(dr, "CompetitorId");
this.BtrCompetitorId = DbConvert.ToInt64(dr, "BtrCompetitorId");
this.UpdateId = DbConvert.ToInt64(dr, "UpdateId");
this.ExternalState = DbConvert.ToString(dr, "ExternalState");
this.Base64Image = DbConvert.ToString(dr, "Base64Image");
EnsureExternalObjects();
}
public override void FillFromDataRow(DataRow dr)
{
this.match2competitorid = DbConvert.ToInt64(dr, "competitor_to_outright_id");
this.CompetitorId = DbConvert.ToInt64(dr, "competitor_id");
this.MatchId = DbConvert.ToInt64(dr, "match_id");
this.hometeam = DbConvert.ToInt64(dr, "position");
this.ExtendedId = DbConvert.ToInt32(dr, "extended_id");
this.ExtendedState = DbConvert.ToString(dr, "extended_state");
this.UpdateId = DbConvert.ToInt64(dr, "update_id");
}
public override void FillFromDataRow(DataRow dr)
{
this.MatchId = DbConvert.ToInt64(dr, "MatchId");
this.ExpiryDate.Value = DbConvert.ToDateTimeSr(dr, "ExpiryDate");
this.UpdateId = DbConvert.ToInt64(dr, "UpdateId");
this.MatchMinute.Value = DbConvert.ToInt32(dr, "MatchMinute");
this.PeriodInfo.Value = IntToPeriodInfo(DbConvert.ToInt32(dr, "PeriodInfo"));
this.Status.Value = IntToMatchStatus(DbConvert.ToInt32(dr, "Status"));
this.Score.Value = DbConvert.ToString(dr, "Score");
}
public override void FillFromDataRow(DataRow dr)
{
this.StringId = DbConvert.ToInt64(dr, "string_id");
this.Category = DbConvert.ToString(dr, "category");
this.Tag = DbConvert.ToString(dr, "tag");
this.Language = DbConvert.ToString(dr, "language");
this.UpdateId = DbConvert.ToInt64(dr, "update_id");
this.ObjectId = DbConvert.ToNullableInt64(dr, "object_id");
this.Text = DbConvert.ToString(dr, "Text");
}
public override void FillFromDataRow(DataRow dr)
{
this.UpdateFileID = DbConvert.ToInt64(dr, "UpdateFileID");
//this.UpdateId = DbConvert.ToInt64(dr, "UpdateId");
this.DataSyncCacheID = DbConvert.ToInt64(dr, "DataSyncCacheID");
this.DataSyncCacheType = DbConvert.ToString(dr, "DataSyncCacheType");
this.FileName = DbConvert.ToString(dr, "FileName");
this.Description = DbConvert.ToString(dr, "Description");
this.CreateDate = DbConvert.ToDateTime(dr, "CreateDate");
}
public override void FillFromDataRow(DataRow dr)
{
this.LanguageStringID = DbConvert.ToInt64(dr, "LanguageStringId");
this.Text = DbConvert.ToString(dr, "Text");
this.MultiStringID = DbConvert.ToInt64(dr, "MultiStringID");
this.LanguageID = DbConvert.ToInt64(dr, "LanguageID");
this.LastModified = DbConvert.ToDateTime(dr, "LastModified");
this.SvrLanguageStringID = DbConvert.ToInt64(dr, "SvrLanguageStringID");
this.IsLiveBet = DbConvert.ToBool(dr, "IsLiveBet");
}
/// <summary>
/// 将DataSet 转换为PageModel<S> 针对分页查询得到的DataSet
/// </summary>
/// <typeparam name="S"></typeparam>
/// <param name="ds"></param>
/// <param name="cols"></param>
/// <returns></returns>
public PageModel <S> DsToPageModel <S>(DataSet ds, string cols)
{
int total = (int)ds.Tables[0].Rows[0][0];
List <S> list = DbConvert.DataTableToList <S>(ds.Tables[1], cols);
return(new PageModel <S>()
{
TotalCount = total, ReList = list
});
}
/// <summary>
/// 读取可空Guid值
/// </summary>
/// <param name="row">数据行</param>
/// <param name="columns">列集合</param>
/// <param name="columnName">列名称</param>
/// <returns>Guid结果</returns>
protected Guid?LoadNullableGuid(DataRow row, DataColumnCollection columns, String columnName)
{
if (columns.Contains(columnName) && !Convert.IsDBNull(row[columnName]))
{
return(DbConvert.ToGuid(row[columnName]));
}
else
{
return(null);
}
}
/// <summary>
/// 获取实体
/// </summary>
/// <param name="table">数据表</param>
/// <returns>数据表实体</returns>
internal T GetEntity(DataTable table)
{
if (!DbConvert.IsDataTableNullOrEmpty(table))
{
return(this.GetEntity(table.Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 读取指定类型数据
/// </summary>
/// <param name="row">数据行</param>
/// <param name="columns">列集合</param>
/// <param name="columnName">列名称</param>
/// <param name="dbType">数据类型</param>
/// <typeparam name="TValue">指定类型</typeparam>
/// <returns>指定类型数据</returns>
protected Nullable <TValue> LoadNullableValue <TValue>(DataRow row, DataColumnCollection columns, String columnName, DbType dbType) where TValue : struct
{
if (columns.Contains(columnName) && !Convert.IsDBNull(row[columnName]))
{
return((TValue)DbConvert.ToValue(row[columnName], dbType));
}
else
{
return(null);
}
}
/// <summary>
/// 读取指定类型数据
/// </summary>
/// <param name="row">数据行</param>
/// <param name="columns">列集合</param>
/// <param name="columnName">列名称</param>
/// <param name="dbType">数据类型</param>
/// <returns>指定类型数据</returns>
protected Object LoadNullableValue(DataRow row, DataColumnCollection columns, String columnName, DbType dbType)
{
if (columns.Contains(columnName) && !Convert.IsDBNull(row[columnName]))
{
return(DbConvert.ToValue(row[columnName], dbType));
}
else
{
return(null);
}
}
