/// <summary>
/// 获取追号计划
/// </summary>
/// <param name="orderId">订单号</param>
/// <returns>追号计划对象</returns>
public virtual TTChasePlan Get(string orderId)
{
TTChasePlan ttChasePlan = null;
try
{
string strSQL = "select * from TTChasePlan where orderId=@orderId";
Param param = new Param();
param.Clear();
param.Add("@orderId", orderId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
ttChasePlan = ReadData(dr);
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(ttChasePlan);
}
/// <summary>
/// 获取UKey信息
/// <param name="uKeyId">加密狗编号</param>
/// </summary>
/// <returns>UKey信息对象</returns>
public TBUKey Get(string uKeyId)
{
TBUKey tbUKey = null;
try
{
string strSQL = "select * from TBUKey where uKeyId=:uKeyId";
Param param = new Param();
param.Clear();
param.Add(":uKeyId", uKeyId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tbUKey = ReadData(dr);
}
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tbUKey);
}
/// <summary>
/// 获取客户账户交易
/// </summary>
/// <param name="tradeId">交易流水</param>
/// <returns>客户账户交易对象</returns>
public virtual TTClientTrade Get(string tradeId)
{
TTClientTrade ttClientTrade = null;
try
{
string strSQL = "select * from TTClientTrade where tradeId=@tradeId";
Param param = new Param();
param.Clear();
param.Add("@tradeId", tradeId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
ttClientTrade = ReadData(dr);
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(ttClientTrade);
}
/// <summary>
/// 获取彩票玩法
/// </summary>
/// <param name="code">玩法代码</param>
/// <returns>彩票玩法对象</returns>
public virtual TBPlayMode Get(string code)
{
TBPlayMode tbPlayMode = null;
try
{
string strSQL = "select * from TBPlayMode where code=@code";
Param param = new Param();
param.Clear();
param.Add("@code", code);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tbPlayMode = ReadData(dr);
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tbPlayMode);
}
/// <summary>
/// 获取彩票奖期
/// <param name="lotteryType">彩种</param>
/// </summary>
/// <returns>彩票奖期对象</returns>
public TBLotteryPeriod Get(string lotteryType)
{
TBLotteryPeriod tbLotteryPeriod = null;
try
{
string strSQL = "select * from TBLotteryPeriod where lotteryType=:lotteryType";
Param param = new Param();
param.Clear();
param.Add(":lotteryType", lotteryType);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tbLotteryPeriod = ReadData(dr);
}
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tbLotteryPeriod);
}
/// <summary>
/// 获取游戏类型
/// </summary>
/// <param name="gameId">游戏编号</param>
/// <returns>游戏类型对象</returns>
public virtual TBGame Get(string gameId)
{
TBGame tbGame = null;
try
{
string strSQL = "select * from TBGame where gameId=@gameId";
Param param = new Param();
param.Clear();
param.Add("@gameId", gameId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tbGame = ReadData(dr);
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tbGame);
}
public void OnlyLoadCaseCarNoAndStationName(string caseId)
{
chufashu01 chufa = null;
Param param = new Param();
string strSQL = " select top 1 * from TBCase where CaseId=@caseId ";
param.Add("@caseId", caseId);
try
{
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
chufa = ReadDataOnlyCaseCarNoAndStationName(dr);
}
WebJson.ToJson(context, chufa);
}
catch (Exception)
{
throw;
}
finally
{
db.Close();
}
// string str = db.DataGridTemp(strSQL, param);
}
public bool IsExist(string caseId)
{
Param param = new Param();
string strSQL = " select count(*) from TB_Chufajuedingshu31 where CaseId=@caseId ";
param.Add("@caseId", caseId);
try
{
db.Open();
object str = db.ExecuteScalar(CommandType.Text, strSQL, param);
int count;
if (int.TryParse(str.ToString(), out count))
{
if (count > 0)
{
return(true);
}
}
}
catch
{
}
finally
{
db.Close();
}
return(false);
}
/// <summary>
/// 获取接口服务账号
/// </summary>
/// <param name="ConncetId">连接端编号</param>
/// <returns>接口服务账号对象</returns>
public virtual TSConnect Get(string ConncetId)
{
TSConnect tsConnect = null;
try
{
string strSQL = "select * from TSConnect where ConncetId=@ConncetId";
Param param = new Param();
param.Clear();
param.Add("@ConncetId", ConncetId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tsConnect = ReadData(dr);
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tsConnect);
}
/// <summary>
/// 获取客户积分明细
/// </summary>
/// <param name="flowId">流水号</param>
/// <returns>客户积分明细对象</returns>
public virtual TTClientPoint Get(long flowId)
{
TTClientPoint ttClientPoint = null;
try
{
string strSQL = "select * from TTClientPoint where flowId=@flowId";
Param param = new Param();
param.Clear();
param.Add("@flowId", flowId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
ttClientPoint = ReadData(dr);
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(ttClientPoint);
}
private void UpdateScoreData()
{
Where where = new Where();
where.Equal("Name", inDate);
Backend.GameSchemaInfo.Get("Score", where, 1, callback1 =>
{
if (callback1.IsSuccess())
{
Param where1 = new Param();
where1.Add("Name", inDate);
Param param = new Param();
param.Add("HighScore", BestScore);
Backend.GameSchemaInfo.Update("Score", where1, param, (callback) =>
{
if (callback.IsSuccess())
{
Debug.Log("점수 갱신 완료");
}
else
{
Debug.Log(callback1);
}
});
}
});
}
/// <summary>
/// 获取快开厅员工
/// <param name="staffId">员工编号</param>
/// </summary>
/// <returns>快开厅员工对象</returns>
public TBStaffClon GetClon(string staffId)
{
TBStaffClon tbStaffClon = null;
try
{
string strSQL = "select a.*,b.roleId,b.userCode from TBStaff a,TSAgentUser b where a.staffId=b.userId and b.roleId!='001' and a.staffId=:staffId";
Param param = new Param();
param.Clear();
param.Add(":staffId", staffId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tbStaffClon = ReadDataClon(dr);
}
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tbStaffClon);
}
/// <summary>
/// 获取系统角色
/// <param name="roleId">角色编号</param>
/// </summary>
/// <returns>系统角色对象</returns>
public TSRole Get(string roleId)
{
TSRole tsRole = null;
try
{
string strSQL = "select * from TSRole where roleId=:roleId";
Param param = new Param();
param.Clear();
param.Add(":roleId", roleId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tsRole = ReadData(dr);
}
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tsRole);
}
/// <summary>
/// 获取列表(代理快开厅用户)
/// <param name="field">字段名</param>
/// <param name="value">字段值</param>
/// </summary>
/// <returns>代理快开厅用户列表对象</returns>
public List <TSAgentUser> GetList(string field, string value)
{
List <TSAgentUser> list = new List <TSAgentUser>();
try
{
string strSQL = "select * from TSAgentUser where " + field + "=:field";
Param param = new Param();
param.Clear();
param.Add(":field", value);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
while (dr.Read())
{
list.Add(ReadData(dr));
}
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(list);
}
/// <summary>
/// 获取快开厅员工
/// <param name="staffId">员工编号</param>
/// </summary>
/// <returns>快开厅员工对象</returns>
public TBStaff Get(string staffId)
{
TBStaff tbStaff = null;
try
{
string strSQL = "select * from TBStaff where staffId=:staffId";
Param param = new Param();
param.Clear();
param.Add(":staffId", staffId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tbStaff = ReadData(dr);
}
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tbStaff);
}
/// <summary>
/// 获取最大值表
/// <param name="tabName">表名</param>
/// </summary>
/// <returns>最大值表对象</returns>
public TSMax Get(string tabName)
{
TSMax tsMax = null;
try
{
string strSQL = "select * from TSMax where tabName=:tabName";
Param param = new Param();
param.Clear();
param.Add(":tabName", tabName);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tsMax = ReadData(dr);
}
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tsMax);
}
/// <summary>
/// 获取代理快开厅用户
/// <param name="userCode">用户帐号</param>
/// </summary>
/// <returns>代理快开厅用户对象</returns>
public TSAgentUser Get(string userId)
{
TSAgentUser tsAgentUser = null;
try
{
string strSQL = "select * from TSAgentUser where userId=:userId";
Param param = new Param();
param.Clear();
param.Add(":userId", userId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tsAgentUser = ReadData(dr);
}
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tsAgentUser);
}
/// <summary>
/// 获取客户账户明细
/// <param name="flowId">编号</param>
/// </summary>
/// <returns>客户账户明细对象</returns>
public TTClientAccDetail Get(long flowId)
{
TTClientAccDetail ttClientAccDetail = null;
try
{
string strSQL = "select * from TTClientAccDetail where flowId=:flowId";
Param param = new Param();
param.Clear();
param.Add(":flowId", flowId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
ttClientAccDetail = ReadData(dr);
}
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(ttClientAccDetail);
}
/// <summary>
/// 获取列表(代理佣金结算)
/// <param name="field">字段名</param>
/// <param name="value">字段值</param>
/// </summary>
/// <returns>代理佣金结算列表对象</returns>
public virtual List <TTClientRecharge3> GetList(string field, string value)
{
List <TTClientRecharge3> list = new List <TTClientRecharge3>();
try
{
string strSQL = "select * from TTClientRecharge3 where " + field + "=@field";
Param param = new Param();
param.Clear();
param.Add("@field", value);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
while (dr.Read())
{
list.Add(ReadData(dr));
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(list);
}
/// <summary>
/// 根据卡号获取客户信息
/// <param name="cardId">客户卡号</param>
/// </summary>
/// <returns>客户信息对象</returns>
public TBClient GetByCard(long cardId)
{
TBClient tbClient = null;
try
{
string strSQL = "select * from TBClient where status='0' and cardId=@cardId";
Param param = new Param();
param.Clear();
param.Add("@cardId", cardId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tbClient = ReadData(dr);
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tbClient);
}
public void Test()
{
Param param = new Param();
param.Add("Tutorial02", true);
BackendGameInfo.instance.PrivateTableUpdate("UserInfo", param);
}
protected DataAccess db = new DataAccess(DataAccess.DBConn);//数据库连接
/// <summary>
/// 新增文案类型
/// </summary>
/// <param name="data"></param>
/// <param name="tbEnforcementName"></param>
public virtual void Add(DataAccess data, TBEnforcementName tbEnforcementName)
{
string strSQL = "insert into TBEnForcementName (EnforcementNameId,EnforcementTypeId,EnforcementName,IsEmpty,EnforcementTemplateId) values(@EnforcementNameId,@EnforcementTypeId,@EnforcementName,@IsEmpty,@EnforcementTemplateId)";
Param param = new Param();
param.Clear();
param.Add("@EnforcementNameId", tbEnforcementName.EnforcementNameId); //文书类型编号
param.Add("@EnforcementTypeId", tbEnforcementName.EnforcementTypeId); //文书类型名称
param.Add("@EnforcementName", tbEnforcementName.EnforcementName);
param.Add("@IsEmpty", tbEnforcementName.IsEmpty);
param.Add("@EnforcementTemplateId", tbEnforcementName.EnforcementTemplateId);
//param.Add("@FillingPerson", tbEnforcementName.FillingPerson);
//param.Add("@FillingTime", tbEnforcementName.FillingTime);
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
public void SaveScore()
{
//백그라운드 비동기통신 (프라이베잇으로 테이블네임을 가져오는데 그걸 유저데이터에 저장)
BackendAsyncClass.BackendAsync(Backend.GameInfo.GetPrivateContents, "Score", UserDataBro =>
{
if (UserDataBro.IsSuccess()) //성공시
{
Param data = new Param(); //키값처리
data.Add("Scores", score);
if (UserDataBro.GetReturnValuetoJSON()["rows"].Count > 0) //가져온 데이터의 개수를 세서 0보다 많다 = 이미 데이터가 들어가있다
{
string t_Indate = UserDataBro.GetReturnValuetoJSON()["rows"][0]["inDate"]["S"].ToString(); //수정할 식별값 가져오기
BackendAsyncClass.BackendAsync(Backend.GameInfo.Update, "Score", t_Indate, data, (t_callback) => //데이터로 수정해서 콜백으로 받아옴
{
});
}
else //데이터 없으니 새로 만듬
{
BackendAsyncClass.BackendAsync(Backend.GameInfo.Insert, "Score", data, (t_callback) =>
{
});
}
}
});
}
/// <summary>
/// 获取系统用户
/// </summary>
/// <param name="userId">用户登录名</param>
/// <returns>系统用户对象</returns>
public virtual TSUser GetTSUser(string USERCODE)
{
TSUser tsUser = null;
try
{
string strSQL = "select * from TSUser where USERCODE=@USERCODE";
Param param = new Param();
param.Clear();
param.Add("@USERCODE", USERCODE);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tsUser = ReadData(dr);
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tsUser);
}
/// <summary>
/// 获取代理商信息
/// </summary>
/// <param name="agentId">代理商编号</param>
/// <returns>代理商信息对象</returns>
public virtual TBAgent Get(string agentId)
{
TBAgent tbAgent = null;
try
{
string strSQL = "select * from TBAgent where agentId=@agentId";
Param param = new Param();
param.Clear();
param.Add("@agentId", agentId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tbAgent = ReadData(dr);
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tbAgent);
}
/// <summary>
/// 获取系统日志
/// </summary>
/// <param name="logId">日志编号</param>
/// <returns>系统日志对象</returns>
public virtual TSLog Get(long logId)
{
TSLog tsLog = null;
try
{
string strSQL = "select * from TSLog where logId=@logId";
Param param = new Param();
param.Clear();
param.Add("@logId", logId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tsLog = ReadData(dr);
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tsLog);
}
/// <summary>
/// 获取代理佣金结算
/// <param name="Column_1">Column_1</param>
/// </summary>
/// <returns>代理佣金结算对象</returns>
public virtual TTClientRecharge3 Get(string Column_1)
{
TTClientRecharge3 ttClientRecharge3 = null;
try
{
string strSQL = "select * from TTClientRecharge3 where Column_1=@Column_1";
Param param = new Param();
param.Clear();
param.Add("@Column_1", Column_1);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
ttClientRecharge3 = ReadData(dr);
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(ttClientRecharge3);
}
/// <summary>
/// 获取终端
/// <param name="terminalId">终端编号</param>
/// </summary>
/// <returns>终端对象</returns>
public TBTerminal Get(string terminalId)
{
TBTerminal tbTerminal = null;
try
{
string strSQL = "select * from TBTerminal where terminalId=:terminalId";
Param param = new Param();
param.Clear();
param.Add(":terminalId", terminalId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tbTerminal = ReadData(dr);
}
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tbTerminal);
}
/// <summary>
/// 文书名称信息
/// </summary>
/// <param name="siteId">门店编号</param>
/// <returns>门店信息对象</returns>
public virtual TBEnforcementName Get(string EnforcementNameId)
{
TBEnforcementName tbSite = null;
try
{
string strSQL = string.Format(@"select n.EnforcementName,n.IsEmpty,n.F1,
t.EnforcementTypeName from TBEnforcementName n ,TBEnforcementType t
where n.statu=1 and t.statu=1 and t.EnforcementTypeId=n.EnforcementTypeId
and n.EnforcementNameId=@EnforcementNameId");
Param param = new Param();
param.Clear();
param.Add("@EnforcementNameId", EnforcementNameId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tbSite = ReadData(dr);
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tbSite);
}
/// <summary>
/// 删除退款明细
/// <param name="data">数据库连接</param>
/// <param name="Column_1">Column_1</param>
/// </summary>
public virtual void Delete(DataAccess data,string Column_1)
{
string strSQL = "delete from TTClientRecharge2 where Column_1=@Column_1";
Param param = new Param();
param.Clear();
param.Add("@Column_1", Column_1);//Column_1
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
