/// <summary>
/// 新增柜员
/// </summary>
/// <param name="m_TellerNo">工号</param>
/// <param name="m_TellerName">姓名</param>
/// <param name="m_TellerId">身份证号</param>
/// <param name="m_TellerUnit">部门</param>
/// <param name="m_TellerRole">角色</param>
/// <returns>
/// -1 链接失败
/// -2 添加失败
/// 2 存在数据
/// 1 添加成功
/// </returns>
public static int AddStaff(string m_TellerNo, string m_TellerName, string m_TellerId, string m_TellerUnit,
string m_TellerRole)
{
//验证柜员是否存在
var en = new TransEntity();
en.AddOperation(SQL.ISEXISTSTAFF, new[] { m_TellerNo, m_TellerId });
ExamHandle.TryGetData(en);
if (!en.ReceiveData.ExcuteIsComplete)
{
return(-1);
}
if (!en.ReceiveData.DataTables.Rows[0][0].ToString().Equals("0"))
{
return(2);
}
//插入柜员
en = new TransEntity();
string key = Guid.NewGuid().ToString();
en.AddOperation(SQL.ADDSTAFF, new[] { key, m_TellerNo, m_TellerName, m_TellerId, m_TellerUnit, m_TellerRole });
ExamHandle.Execute(en);
if (en.ReceiveData.ExcuteIsComplete)
{
return(1);
}
else
{
return(-2);
}
}
public static DataTable GetVariableQuestion(List <string> m_Keys)
{
string tmp = string.Empty;
for (int i = 0; i < m_Keys.Count; i++)
{
tmp += "?";
if (i != m_Keys.Count - 1)
{
tmp += ",";
}
}
string strSQL = SQL.GETVARIABLEQUESTIONS.Replace("?", tmp);
var en = new TransEntity();
en.AddOperation(strSQL, m_Keys.ToArray());
ExamHandle.TryGetData(en);
if (en.ReceiveData.ExcuteIsComplete)
{
return(en.ReceiveData.DataTables);
}
else
{
return(null);
}
}
/// <summary>
/// </summary>
/// <param name="m_Key"></param>
/// 1 成功
/// -1 通讯失败
/// -2 已被使用，不能删除
/// <returns></returns>
public static int DelMould(string m_Key)
{
var en = new TransEntity();
en.AddOperation(SQL.EXISTPAPER, new[] { m_Key });
ExamHandle.TryGetData(en);
if (!en.ReceiveData.ExcuteIsComplete)
{
return(-1);
}
if (!en.ReceiveData.DataTables.Rows[0][0].ToString().Equals("0"))
{
return(-2);
}
en = new TransEntity();
en.AddOperation(SQL.DELINTEGRANTQUESTION, new[] { m_Key });
en.AddOperation(SQL.DELMODULD, new[] { m_Key });
ExamHandle.Execute(en);
if (en.ReceiveData.ExcuteIsComplete)
{
return(1);
}
else
{
return(-1);
}
}
/// <summary>
/// 更新柜员信息
/// </summary>
/// <param name="m_Key">柜员Key</param>
/// <param name="m_TellerNo">工号</param>
/// <param name="m_TellerName">姓名</param>
/// <param name="m_TellerId">身份证号</param>
/// <param name="m_TellerUnit">部门</param>
/// <param name="m_TellerRole">角色</param>
/// <returns>
/// -1 链接失败
/// -2 添加失败
/// 2 存在数据
/// 1 添加成功
/// </returns>
public static int EditStaff(string m_Key, string m_TellerNo, string m_TellerName, string m_TellerId,
string m_TellerUnit, string m_TellerRole)
{
//验证柜员是否存在
var en = new TransEntity();
en.AddOperation(SQL.ISEXISTSTAFFEDIT, new[] { m_TellerNo, m_TellerId, m_Key });
ExamHandle.TryGetData(en);
if (!en.ReceiveData.ExcuteIsComplete)
{
return(-1);
}
if (!en.ReceiveData.DataTables.Rows[0][0].ToString().Equals("0"))
{
return(2);
}
//更新柜员
en.AddOperation(SQL.UPDATESTAFF,
new[] { m_TellerNo, m_TellerName, m_TellerId, m_TellerUnit, m_TellerRole, m_Key });
ExamHandle.Execute(en);
if (en.ReceiveData.ExcuteIsComplete)
{
return(1);
}
else
{
return(-2);
}
}
/// <summary>
/// 查询柜员
/// </summary>
/// <param name="m_TellerUnit">机构</param>
/// <param name="m_TellerRole">角色</param>
/// <param name="m_TellerNo">工号</param>
/// <returns></returns>
public static DataTable GetStaffs(string m_TellerUnit, string m_TellerRole, string m_TellerNo)
{
var str = new string[5];
if (m_TellerUnit != null)
{
str[0] = string.Format("{0}", m_TellerUnit);
str[1] = string.Format("{0}", m_TellerUnit);
}
if (m_TellerRole != null)
{
str[2] = string.Format("{0}", m_TellerRole);
str[3] = string.Format("{0}", m_TellerRole);
}
if (m_TellerNo != null)
{
str[4] = string.Format("%{0}%", m_TellerNo);
}
var en = new TransEntity();
en.AddOperation(SQL.GETSTAFFS, str);
ExamHandle.TryGetData(en);
if (en.ReceiveData.ExcuteIsComplete)
{
return(en.ReceiveData.DataTables);
}
else
{
return(null);
}
}
public void BuyStock(TransEntity data)
{
if (data.TranTime == DateTime.MinValue)
{
data.TranTime = DateTime.Now;
}
data.TranType = "Buy";
/*
* using var db = GetDatabase();
*/
var db = _db;
var stock = db.StocksMap.Where(x => x.Id == data.StockId).FirstOrDefault();
if (stock == null)
{
Console.WriteLine($"Can't found stockId:{data.StockId}");
return;
}
if (data.StockPrice <= 0)
{
Console.WriteLine($"Stock price:{data.StockPrice} ERROR");
return;
}
data.HandlingFee = Math.Round(data.StockPrice * data.NumberOfShare * stock.HandlingFee, 0,
MidpointRounding.AwayFromZero);
data.Balance = -(data.StockPrice * data.NumberOfShare + data.HandlingFee);
db.Trans.Add(data);
db.SaveChanges();
}
public static int DelExam(string m_Key)
{
//验证考试是否能删除
var en = new TransEntity();
en.AddOperation(@"select count(*) cou
from t_exam
where f_begin_datetime>sysdate
and f_key=?", new[] { m_Key });
ExamHandle.TryGetData(en);
if (!en.ReceiveData.ExcuteIsComplete || en.ReceiveData.DataTables == null)
{
return(-1);
}
if (en.ReceiveData.DataTables.Rows[0][0].ToString() == "0")
{
return(-2);
}
//删除考试
en = new TransEntity();
en.AddOperation(@"delete from t_paper where f_exam_key=?", new[] { m_Key });
en.AddOperation(@"delete from t_exam where f_key=?", new[] { m_Key });
ExamHandle.Execute(en);
if (en.ReceiveData.ExcuteIsComplete)
{
return(1);
}
else
{
return(-1);
}
}
public static bool AddExam(string m_ExamName, DateTime m_BeginDateTime, DateTime m_EndDateTime,
int m_ValidMinute, int m_ExamSpace, int m_ExamCount, string m_Description,
string m_AdminTellerNo, string m_AdminTellerId, List <string> m_Staffs,
List <string> m_Models)
{
string examguid = Guid.NewGuid().ToString();
var en = new TransEntity();
en.AddOperation(SQL.ADDEXAM,
new[]
{
examguid, m_ExamName, m_BeginDateTime.ToString("yyyy-MM-dd HH:mm:ss"),
m_EndDateTime.ToString("yyyy-MM-dd HH:mm:ss"), m_ValidMinute.ToString(),
m_ExamSpace.ToString(), m_ExamCount.ToString(), m_Description, m_AdminTellerNo,
m_AdminTellerId
});
for (int i = 0; i < m_Staffs.Count; i++)
{
string guid = Guid.NewGuid().ToString();
string modelid = m_Models[i % m_Models.Count];
en.AddOperation(SQL.ADDEXAMSTAFF, new[] { guid, modelid, examguid, m_Staffs[i] });
}
ExamHandle.Execute(en);
if (en.ReceiveData.ExcuteIsComplete)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除指定柜员
/// </summary>
/// <param name="m_TellerID">柜员ID</param>
/// <returns></returns>
public static bool DeleteStaff(string m_TellerID)
{
var en = new TransEntity();
en.AddOperation(SQL.DELETESTAFF, new[] { m_TellerID });
ExamHandle.Execute(en);
return(en.ReceiveData.ExcuteIsComplete);
}
/// <summary>
/// 清空白名单或黑名单
/// </summary>
/// <param name="m_WhiteList"></param>
/// <returns></returns>
public static bool ClearClient(bool m_WhiteList)
{
var en = new TransEntity();
string iswhite = m_WhiteList ? "1" : "0";
en.AddOperation(SQL.CLEARCLIENT, new[] { iswhite });
ExamHandle.Execute(en);
return(en.ReceiveData.ExcuteIsComplete);
}
public static bool ExportExamStaff(string m_Key, string m_Examname)
{
var stringbuilder = new StringBuilder();
var en = new TransEntity();
en.AddOperation(@"select f_teller_no, f_teller_name, f_teller_unit, f_teller_role
from t_paper
where f_exam_key =?", new[] { m_Key });
ExamHandle.TryGetData(en);
if (en.ReceiveData.ExcuteIsComplete)
{
var saveDialog = new SaveFileDialog();
saveDialog.Filter = "(*.csv)|*.csv";
saveDialog.FileName = m_Examname + "_柜员列表";
saveDialog.ShowDialog();
string outputFile = saveDialog.FileName;
if (en.ReceiveData.DataTables == null || en.ReceiveData.DataTables.Rows.Count == 0)
{
return(false);
}
stringbuilder.Append("工号,姓名,机构,角色\r\n");
for (int i = 0; i < en.ReceiveData.DataTables.Rows.Count; i++)
{
for (int j = 0; j < en.ReceiveData.DataTables.Columns.Count; j++)
{
stringbuilder.Append(en.ReceiveData.DataTables.Rows[i][j]);
if (j != en.ReceiveData.DataTables.Columns.Count - 1)
{
stringbuilder.Append(",");
}
}
if (i != en.ReceiveData.DataTables.Rows.Count - 1)
{
stringbuilder.Append("\r\n");
}
}
try
{
var filestream = new FileStream(outputFile, FileMode.Create);
var streamwriter = new StreamWriter(filestream, Encoding.GetEncoding("GB2312"));
streamwriter.Write(stringbuilder.ToString());
streamwriter.Close();
filestream.Close();
}
catch
{
return(false);
}
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// </summary>
/// <param name="m_ModeName"></param>
/// <param name="m_ScoreTotal"></param>
/// <param name="m_MouldQuestions"></param>
/// <returns>
/// 1 成功
/// -1 通讯失败
/// -2 变量信息不完整
/// </returns>
public static int AddTestPaper(string m_ModeName, string m_ScoreTotal, List <MouldQuestion> m_MouldQuestions)
{
var keys = new List <string>();
for (int i = 0; i < m_MouldQuestions.Count; i++)
{
keys.Add(m_MouldQuestions[i].QUESTIONKEY);
}
DataTable dtvariablequstion = GetVariableQuestion(keys);
if (dtvariablequstion == null)
{
return(-1);
}
for (int i = 0; i < dtvariablequstion.Rows.Count; i++)
{
string key = dtvariablequstion.Rows[i]["F_KEY"].ToString();
List <MouldQuestion> question = m_MouldQuestions.Where(p => p.QUESTIONKEY == key).ToList();
if (question[0].VARIABLE.Length == 0)
{
return(-2);
}
}
for (int i = 0; i < m_MouldQuestions.Count; i++)
{
if (m_MouldQuestions[i].VARIABLE.Length == 0)
{
m_MouldQuestions[i].VARIABLE = "|";
}
}
string guid = Guid.NewGuid().ToString();
var en = new TransEntity();
en.AddOperation(SQL.ADDTESTPAPER, new[] { guid, m_ModeName, m_ScoreTotal });
foreach (MouldQuestion item in m_MouldQuestions)
{
string questionguid = Guid.NewGuid().ToString();
en.AddOperation(SQL.AddINTEGRANTQUESTION,
new[] { questionguid, guid, item.QUESTIONKEY, item.SCORE, item.SORT, item.VARIABLE });
}
ExamHandle.Execute(en);
if (en.ReceiveData.ExcuteIsComplete)
{
return(1);
}
else
{
return(-1);
}
}
/// <summary>
/// 更新客户端，移入或移除白名单
/// </summary>
/// <param name="m_ClientIds"></param>
/// <returns></returns>
public static bool UpdateClient(List <string> m_ClientIds, bool m_IsWhite)
{
var en = new TransEntity();
string iswhite = m_IsWhite ? "1" : "0";
foreach (string item in m_ClientIds)
{
en.AddOperation(SQL.UPDATECLIENT, new[] { iswhite, item });
}
ExamHandle.Execute(en);
return(en.ReceiveData.ExcuteIsComplete);
}
public static string Exprot()
{
var saveDialog = new SaveFileDialog();
saveDialog.Filter = "(*.csv)|*.csv";
saveDialog.FileName = "柜员列表";
saveDialog.ShowDialog();
string outputFile = saveDialog.FileName;
var en = new TransEntity();
en.AddOperation(SQL.GETEXPORT, null);
ExamHandle.TryGetData(en);
if (!en.ReceiveData.ExcuteIsComplete || en.ReceiveData.DataTables == null)
{
return("-1");
}
DataTable result = en.ReceiveData.DataTables;
var stringbuilder = new StringBuilder();
stringbuilder.Append("工号,姓名,身份证号,部门,角色\r\n");
for (int i = 0; i < result.Rows.Count; i++)
{
for (int j = 0; j < result.Columns.Count; j++)
{
stringbuilder.Append(result.Rows[i][j]);
if (j != result.Columns.Count - 1)
{
stringbuilder.Append(",");
}
}
if (i != result.Rows.Count - 1)
{
stringbuilder.Append("\r\n");
}
}
try
{
var filestream = new FileStream(outputFile, FileMode.Create);
var streamwriter = new StreamWriter(filestream, Encoding.GetEncoding("GB2312"));
streamwriter.Write(stringbuilder.ToString());
streamwriter.Close();
filestream.Close();
}
catch (Exception e)
{
return(e.Message);
}
return("1");
}
//data = "2022/04/04,0050,10.0,1000"
void ProcessBuyStock(string dataText)
{
var tranDatePattern = RegexPattern.Group("tranDate", @"\d{4}/\d{2}/\d{2}");
var stockIdPattern = RegexPattern.Group("stockId", @"[^,]+");
var stockPricePattern = RegexPattern.Group("stockPrice", @"[^,]+");
var numberOfSharePattern = RegexPattern.Group("numberOfShare", @"[^,]+");
var rg = new Regex($"{tranDatePattern},{stockIdPattern},{stockPricePattern},{numberOfSharePattern}");
var m = rg.Match(dataText);
if (!m.Success)
{
Console.WriteLine("parse fail, please input 2022/04/04,0056,33.1,1000");
return;
}
var tranDateStr = m.Groups["tranDate"].Value;
if (!DateTime.TryParse(tranDateStr, out var tranDate))
{
Console.WriteLine($"parse '{tranDateStr}' fail, please input <2022/04/04>,0056,33.1,1000");
return;
}
var stockId = m.Groups["stockId"].Value;
var stockPriceStr = m.Groups["stockPrice"].Value;
if (!decimal.TryParse(stockPriceStr, out var stockPrice))
{
Console.WriteLine($"Parse '{stockPriceStr}' fail, please input 2022/04/04,0056,<33.1>,1000");
return;
}
var numberOfShareStr = m.Groups["numberOfShare"].Value;
if (!int.TryParse(numberOfShareStr, out var numberOfShare))
{
Console.WriteLine($"Parse '{numberOfShareStr}' fail, please input 2022/04/04,0056,33.1,<1000>");
return;
}
var db = _stockRepo;
var tranData = new TransEntity
{
TranTime = tranDate,
StockId = stockId,
StockPrice = stockPrice,
NumberOfShare = numberOfShare
};
db.BuyStock(tranData);
}
public static DataTable GetQuestion(string m_Key)
{
var en = new TransEntity();
en.AddOperation(SQL.GETQUESTION, new[] { m_Key });
if (en.ReceiveData.ExcuteIsComplete)
{
return(en.ReceiveData.DataTables);
}
else
{
return(null);
}
}
public static DataTable GetTradeValueSta(string m_Key)
{
var en = new TransEntity();
en.AddOperation(SQL.GETTRADEVALUESTA, new[] { m_Key });
if (en.ReceiveData.ExcuteIsComplete)
{
return(en.ReceiveData.DataTables);
}
else
{
return(null);
}
}
public override Task Run(string[] args)
{
var p = args.ParseArgs <TodayBuyStockTranCommandLine>();
var tranData = new TransEntity
{
TranTime = DateTime.Now.Date,
StockId = p.StockId,
StockPrice = p.StockPrice,
NumberOfShare = p.NumberOfShare
};
_stockRepo.BuyStock(tranData);
return(Task.CompletedTask);
}
/// <summary>
/// 获取白名单终端
/// </summary>
/// <returns></returns>
public static DataTable GetWhiteList()
{
var en = new TransEntity();
en.AddOperation(SQL.GETTERMINAL, new[] { "true" });
ExamHandle.TryGetData(en);
if (en.ReceiveData.ExcuteIsComplete)
{
return(en.ReceiveData.DataTables);
}
else
{
return(null);
}
}
public static DataTable GetStaff(string m_Key)
{
var en = new TransEntity();
en.AddOperation(SQL.GETSTAFF, new[] { m_Key });
ExamHandle.TryGetData(en);
if (en.ReceiveData.ExcuteIsComplete)
{
return(en.ReceiveData.DataTables);
}
else
{
return(null);
}
}
/// <summary>
/// 获取全部角色
/// </summary>
/// <returns></returns>
public static DataTable GetRole()
{
var en = new TransEntity();
en.AddOperation(SQL.GETROLE, null);
ExamHandle.TryGetData(en);
if (en.ReceiveData.ExcuteIsComplete)
{
return(en.ReceiveData.DataTables);
}
else
{
return(null);
}
}
public static DataTable GetVariableAnswer(string m_Key)
{
var en = new TransEntity();
en.AddOperation(SQL.GETVARIABLEANSWER, new[] { m_Key });
ExamHandle.TryGetData(en);
if (en.ReceiveData.ExcuteIsComplete)
{
return(en.ReceiveData.DataTables);
}
else
{
return(null);
}
}
/// <summary>
/// 获取客户端列表
/// </summary>
/// <param name="m_IsWhite"></param>
/// <returns></returns>
public static DataTable GetClient(bool m_IsWhite)
{
var en = new TransEntity();
en.AddOperation(SQL.GETCLIENT, new[] { m_IsWhite ? "1" : "0" });
ExamHandle.TryGetData(en);
if (en.ReceiveData.ExcuteIsComplete)
{
return(en.ReceiveData.DataTables);
}
else
{
return(null);
}
}
public static DataTable GetTestPapers(DateTime m_Start, DateTime m_End)
{
var en = new TransEntity();
en.AddOperation(SQL.GETTESTPAPER,
new[] { m_Start.ToString("yyyy-MM-dd HH:mm:ss"), m_End.ToString("yyyy-MM-dd HH:mm:ss") });
ExamHandle.TryGetData(en);
if (en.ReceiveData.ExcuteIsComplete)
{
return(en.ReceiveData.DataTables);
}
else
{
return(null);
}
}
private void Timer_Tick(object sender, EventArgs e)
{
// 加载登录柜员信息
Dispatcher.BeginInvoke(new Action(() =>
{
var te = new TransEntity();
te.AddOperation(
"SELECT F_KEY,F_MOULD_KEY,F_EXAM_KEY,F_TELLER_NO,F_TELLER_NAME,F_TELLER_ID,F_TELLER_UNIT,F_TELLER_ROLE,F_SCORE_TOTAL,F_TELLER_SCORE,F_BEGIN_TIME,F_END_TIME,F_QUESTION_TOTAL,F_NOW_QUESTION,F_VARIABLE_VALUE FROM T_PAPER WHERE F_EXAM_KEY=?"
, invigilate.Key);
ExamHandle.GetData(te);
if (invigilate.TellerCollection == null)
{
invigilate.TellerCollection = new ObservableCollection <Teller>();
}
for (int i = 0; i < te.ReceiveData.DataTables.Rows.Count; i++)
{
Teller[] n =
invigilate.TellerCollection.Where(
x => { return(x.Key == te.ReceiveData.DataTables.Rows[i]["F_KEY"].ToString()); })
.ToArray();
if (n.Length == 0)
{
var t = new Teller();
t.Key = te.ReceiveData.DataTables.Rows[i]["F_KEY"].ToString();
t.BeginDateTime =
DateTime.Parse(te.ReceiveData.DataTables.Rows[i]["F_BEGIN_TIME"].ToString());
t.TellerId = te.ReceiveData.DataTables.Rows[i]["F_TELLER_ID"].ToString();
t.TellerName = te.ReceiveData.DataTables.Rows[i]["F_TELLER_NAME"].ToString();
t.Role = te.ReceiveData.DataTables.Rows[i]["F_TELLER_ROLE"].ToString();
t.Unit = te.ReceiveData.DataTables.Rows[i]["F_TELLER_UNIT"].ToString();
invigilate.RealNumber++;
invigilate.TellerCollection.Add(t);
}
else if (n.Length == 1)
{
// 不等于空表示已经提交试卷了
if (invigilate.TellerCollection[i].EndDateTime.ToString() != "" &&
n[i].EndDateTime == DateTime.MinValue)
{
n[i].EndDateTime = DateTime.Parse(invigilate.TellerCollection[i].EndDateTime.ToString());
}
}
}
}), DispatcherPriority.Background);
}
public static DataTable GetExamModel(DateTime m_StartTime, DateTime m_EndTime)
{
var en = new TransEntity();
en.AddOperation(SQL.GETEXAMMODEL,
new[]
{ m_StartTime.ToString("yyyy-MM-dd HH:mm:ss"), m_EndTime.ToString("yyyy-MM-dd HH:mm:ss") });
ExamHandle.TryGetData(en);
if (en.ReceiveData.ExcuteIsComplete)
{
return(en.ReceiveData.DataTables);
}
else
{
return(null);
}
}
public static DataTable GetExamStaff(string m_No, string m_Name)
{
var en = new TransEntity();
m_No = "%" + m_No + "%";
m_Name = "%" + m_Name + "%";
en.AddOperation(SQL.GETEXAMSTAFF, new[] { m_No, m_Name });
ExamHandle.TryGetData(en);
if (en.ReceiveData.ExcuteIsComplete)
{
return(en.ReceiveData.DataTables);
}
else
{
return(null);
}
}
public static DataTable GetQuestions(DateTime m_StartTime, DateTime m_EndTime, string m_Level)
{
var en = new TransEntity();
en.AddOperation(SQL.GETQUESTIONS,
new[]
{
m_StartTime.ToString("yyyy-MM-dd HH:mm:ss"), m_EndTime.ToString("yyyy-MM-dd HH:mm:ss"),
m_Level, m_Level
});
ExamHandle.TryGetData(en);
if (en.ReceiveData.ExcuteIsComplete)
{
return(en.ReceiveData.DataTables);
}
else
{
return(null);
}
}
public static string Import()
{
try
{
var openDialog = new OpenFileDialog();
openDialog.Filter = "(*.csv)|*.csv";
openDialog.ShowDialog();
string outputFile = openDialog.FileName;
var filestream = new FileStream(outputFile, FileMode.Open);
var streamreader = new StreamReader(filestream, Encoding.GetEncoding("GB2312"));
var en = new TransEntity();
string strData = streamreader.ReadToEnd();
strData = strData.Replace("\r\n", "\n");
string[] datarow = strData.Split('\n');
en.AddOperation(SQL.CLEARSTAFF, null);
for (int i = 0; i < datarow.Length; i++)
{
string[] stritem = datarow[i].Split(',');
var strlist = new List <string>();
string guid = Guid.NewGuid().ToString();
strlist.Add(guid);
strlist.AddRange(stritem);
en.AddOperation(SQL.ADDSTAFF, strlist.ToArray());
}
ExamHandle.Execute(en);
if (en.ReceiveData.ExcuteIsComplete)
{
return("1");
}
else
{
return("-1");
}
}
catch (Exception e)
{
return(e.Message);
}
}
/// <summary>
/// 验证管理员是否存在
/// </summary>
/// <param name="m_UserID">用户名</param>
/// <param name="m_UserPwd">密码</param>
/// <returns></returns>
public static bool ExistsAdmin(string m_UserID, string m_UserPwd)
{
var en = new TransEntity();
en.AddOperation(SQL.AdminExists, new[] { m_UserID, m_UserPwd });
ExamHandle.TryGetData(en);
if (!en.ReceiveData.ExcuteIsComplete || en.ReceiveData.DataTables.Rows.Count == 0)
{
return(false);
}
string result = en.ReceiveData.DataTables.Rows[0][0].ToString();
if (!result.Equals("0"))
{
return(true);
}
else
{
return(false);
}
}
