} //Хүлээн авсан хэрэгсэлд тайлбар оруулах
public Result Txn606009(ClientInfo ci, RequestInfo ri, DbConnections db, ref Log lg)
{
Result res = new Result();
try
{
#region Prepare parameters
object[] param = ri.ReceivedParam;
string salesno = Static.ToStr(param[0]);
decimal custno = Static.ToDecimal(param[1]);
string prodno = Static.ToStr(param[2]);
int itemno = Static.ToInt(param[3]);
#endregion
#region Prepare query
string sql = @"select damagetype,damagenote,losspaymentno,deliveruser,receiveruser
,rentstatus,trunc((rentendtime-rentstarttime)*1440) duration
from salesrent
where salesno=:1 and custno=:2 and prodno=:3 and itemno=:4";
#endregion
#region Execute query
param = new object[] { salesno, custno, prodno, itemno };
res = db.ExecuteQuery("core", sql, enumCommandType.SELECT, "Txn606008", param);
#endregion
return(res);
}
catch (Exception ex)
{
res.ResultNo = 9110001;
res.ResultDesc = "Датабааз руу хандахад алдаа гарлаа" + ex.Message;
return(res);
}
} //Эвдрэлийн мэдээлэл лавлах
public static Result DB203201(DbConnections pDB, long pLogID)
{
Result res = new Result();
try
{
string sql;
sql =
@"SELECT LOGID, TABLENAME, FIELDNAME, OLDVALUE, NEWVALUE
FROM LOGDETAIL
WHERE LOGID=:1 ORDER BY LOGID, TABLENAME, FIELDNAME";
res = pDB.ExecuteQuery("core", sql, enumCommandType.SELECT, "DB203201", pLogID);
return(res);
}
catch (Exception ex)
{
ISM.Lib.Static.WriteToLogFile("Error.log", ex.Message + ex.Source + ex.StackTrace);
res.ResultNo = 9110001;
res.ResultDesc = "Датабааз руу хандахад алдаа гарлаа" + ex.Message;
return(res);
}
}
object[] ProcessPLSQL(DbConnections db, long pkey, string PLSQLName)
{
object[] obj = new object[3];
try
{
OracleCommand cmd = new OracleCommand();
cmd.CommandText = PLSQLName;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("pID", OracleDbType.Decimal, ParameterDirection.Input);
cmd.Parameters.Add("rebateID", OracleDbType.Decimal, ParameterDirection.Output);
cmd.Parameters.Add("loyalID", OracleDbType.Decimal, ParameterDirection.Output);
cmd.Parameters.Add("pointID", OracleDbType.Decimal, ParameterDirection.Output);
cmd.Parameters["pID"].Value = pkey;
Result res = db.ExecuteQuery("core", cmd, enumCommandType.SELECT, "Txn50000x");
if (res.ResultNo != 0)
{
return(obj);
}
obj[0] = cmd.Parameters["rebateID"].Value;
obj[1] = cmd.Parameters["loyalID"].Value;
obj[2] = cmd.Parameters["pointID"].Value;
}
catch (Exception ex)
{
obj = null;
return(obj);
}
return(obj);
}
public Result Txn110105(ClientInfo ci, RequestInfo ri, DbConnections db, ref Log lg)
{
Result res = new Result();
int pagenumber = 1;
int pagecount = 1;
try
{
res = DBIO.DB203012(db, pagenumber, pagecount, ri.ReceivedParam); //Хэрэглэгчийн бүлгийн жагсаалт авах
return(res);
}
catch (Exception ex)
{
res.ResultNo = 9110002;
res.ResultDesc = "Програм руу нэвтрэхэд алдаа гарлаа" + ex.Message;
EServ.Shared.Static.WriteToLogFile("Error.log", ex.Message + ex.Source + ex.StackTrace);
return(res);
}
finally
{
lg.item.Desc = "Хэрэглэгчийн бүлгийн жагсаалт авах";
}
}
public Result Txn110110(ClientInfo ci, RequestInfo ri, DbConnections db, ref Log lg)
{
Result res = new Result();
int groupid = 0;
try
{
groupid = Static.ToInt(ri.ReceivedParam[0]); // GroupID
res = DBIO.DB203014(db, groupid); // Хэрэглэгчийн бүлэгийн сонгогдсон болон сонгогдоогүй гүйлгээнүүд
if (res.ResultNo != 0)
{
return(res);
}
res.Data.Tables[0].TableName = "GroupTxn";
return(res);
}
catch (Exception ex)
{
res.ResultNo = 9110002;
res.ResultDesc = "Програм руу нэвтрэхэд алдаа гарлаа" + ex.Message;
EServ.Shared.Static.WriteToLogFile("Error.log", ex.Message + ex.Source + ex.StackTrace);
return(res);
}
finally
{
lg.item.Desc = "Хэрэглэгчийн бүлэгийн гүйлгээний жагсаалт";
}
}
} //Бараа материал жагсаалт авах
public Result Txn000007(ClientInfo ci, RequestInfo ri, DbConnections db, ref Log lg)
{
Result res = new Result();
//int pagenumber = 1;
//int pagecount = 1;
try
{
res = IPos.DB.Main.DB201001(db, ri.PageIndex, ri.PageRows, ri.ReceivedParam);
return(res);
}
catch (Exception ex)
{
res.ResultNo = 9110002;
res.ResultDesc = "Програм руу нэвтрэхэд алдаа гарлаа" + ex.Message;
EServ.Shared.Static.WriteToLogFile("Error.log", ex.Message + ex.Source + ex.StackTrace);
return(res);
}
finally
{
lg.item.Desc = "Тайлангийн документ загварын жагсаалт авах";
}
} //Динамик тайлангийн жагсаалт авах
public Result Txn110112(ClientInfo ci, RequestInfo ri, DbConnections db, ref Log lg)
{
Result res = new Result();
try
{
int userno = Static.ToInt(ri.ReceivedParam[0]);
res = DBIO.DB203005(db, userno); // Хэрэглэгчийн зураг
EServ.Shared.Static.WriteToLogFile("Error.log", "Txn110112 userno=" + userno.ToString() + " " + res.ResultNo.ToString());
if (res.ResultNo != 0)
{
return(res);
}
res.Data.Tables[0].TableName = "UserPhoto";
return(res);
}
catch (Exception ex)
{
res.ResultNo = 9110002;
res.ResultDesc = "Програм руу нэвтрэхэд алдаа гарлаа" + ex.Message;
EServ.Shared.Static.WriteToLogFile("Error.log", ex.Message + ex.Source + ex.StackTrace);
return(res);
}
finally
{
lg.item.Desc = "Хэрэглэгчийн зурагын мэдээлэл засварлах";
}
}
public override Result Invoke(ClientInfo ci, RequestInfo ri, DbConnections db, ref Log lg)
{
Result r = null;
try
{
switch (ri.FunctionNo)
{
case 106001:
r = FN106001(ci, ri, db, ref lg);
break;
case 106002:
r = FN106002(ci, ri, db, ref lg);
break;
case 106003:
r = FN106003(ci, ri, db, ref lg);
break;
}
}
catch
{ }
return(r);
}
//PROCESS
#region [ DB213016 - SELECT PROCESS ]
public static Result DB213016(DbConnections pDB, object[] pParam)
{
Result res = new Result();
try
{
string sql =
@"
SELECT PID ,
DLLNAME ,
CLASSNAME ,
FUNCTIONNAME,
DESCRIPTION ,
STATUS ,
freq
FROM PROCESS
ORDER BY PID
";
res = pDB.ExecuteQuery("core", sql, enumCommandType.SELECT, "DB213016", null);
return(res);
}
catch (Exception ex)
{
ISM.Lib.Static.WriteToLogFile("Error.log", ex.Message + ex.Source + ex.StackTrace);
res.ResultNo = 9110001;
res.ResultDesc = "Датабааз руу хандахад алдаа гарлаа" + ex.Message;
return(res);
}
}
public static Result DB211037(DbConnections pDB, int pYear)
{
Result res = new Result();
try
{
string sql;
sql =
@"
insert into CHARTBALANCEDAILY(ACCOUNT,BRANCHNO,CURCODE,txndate,OPENBAL,EndBal,DTBAL, CTBAL)
select C.account, BR.branch, B.CURCODE, to_date(B.Year+1||'0101', 'yyyymmdd'), B.EndBal, B.EndBal,
(CASE WHEN B.EndBal>0 THEN B.EndBal ELSE 0 END),
(CASE WHEN B.EndBal<0 THEN B.EndBal ELSE 0 END)
from CHARTBALANce B
left join chart C on B.account=C.account
left join Currency Cur on CUR.CURRENCY=B.CurCode
right join branch BR on BR.branch=B.branchno
where B.EndBal<>0 and B.year=:1
";
res = pDB.ExecuteQuery("core", sql, enumCommandType.SELECT, "DB211037", pYear);
return(res);
}
catch (Exception ex)
{
EServ.Shared.Static.WriteToLogFile("Error.log", ex.Message + ex.Source + ex.StackTrace);
res.ResultNo = 9110001;
res.ResultDesc = "Датабааз руу хандахад алдаа гарлаа" + ex.Message;
return(res);
}
}
public static Result DB211038(DbConnections pDB)
{
Result res = new Result();
try
{
string sql =
@"update bacaccount
set TMPYEARBALANCE=balance, balance=0
where accountno in (
select a.accountno
from bacaccount a
left join bacproduct b on a.prodcode=b.prodcode
where b.type in (1,2)
and a.balance<>0)";
res = pDB.ExecuteQuery("core", sql, enumCommandType.UPDATE, "DB211038");
return(res);
}
catch (Exception ex)
{
ISM.Lib.Static.WriteToLogFile("Error.log", ex.Message + ex.Source + ex.StackTrace);
res.ResultNo = 9110001;
res.ResultDesc = "Датабааз руу хандахад алдаа гарлаа" + ex.Message;
return(res);
}
}
public static Result DB211035(DbConnections pDB, object[] pParam)
{
Result res = new Result();
try
{
string sql;
sql =
@"
update
GLProcessList
set
StartDate = :1,
EndDate = :2,
Status=:3,
ErrorDesc=:4
where
TxnDate=:5
and ProcessNo=:6";
res = pDB.ExecuteQuery("core", sql, enumCommandType.UPDATE, "DB211035", pParam);
return(res);
}
catch (Exception ex)
{
EServ.Shared.Static.WriteToLogFile("Error.log", ex.Message + ex.Source + ex.StackTrace);
res.ResultNo = 9110001;
res.ResultDesc = "Датабааз руу хандахад алдаа гарлаа" + ex.Message;
return(res);
}
}
public static Result DB211016(DbConnections pDB, object[] pParam)
{
Result res = new Result();
try
{
string sql;
sql =
@"select Account,BranchNo,CurCode,TxnDate,DTBal,CTBal,OpenBal, EndBal from ChartBalanceDaily
where TxnDate<:1 and branchNo=:2 and curcode=:3 and account=:4 and rownum<2
order by TxnDate desc";
res = pDB.ExecuteQuery("core", sql, enumCommandType.SELECT, "DB211016", pParam);
return(res);
}
catch (Exception ex)
{
EServ.Shared.Static.WriteToLogFile("Error.log", ex.Message + ex.Source + ex.StackTrace);
res.ResultNo = 9110001;
res.ResultDesc = "Датабааз руу хандахад алдаа гарлаа" + ex.Message;
return(res);
}
}
public static Result DB211027(DbConnections pDB, long pJrNo)
{
Result res = new Result();
try
{
string sql;
sql =
@"Update
ChartTxn
set
Corr=1
where
JrNo=:1";
res = pDB.ExecuteQuery("core", sql, enumCommandType.UPDATE, "DB211027", pJrNo);
return(res);
}
catch (Exception ex)
{
EServ.Shared.Static.WriteToLogFile("Error.log", ex.Message + ex.Source + ex.StackTrace);
res.ResultNo = 9110001;
res.ResultDesc = "Датабааз руу хандахад алдаа гарлаа" + ex.Message;
return(res);
}
}
public override Result Invoke(ClientInfo ci, RequestInfo ri, DbConnections db, ref Log lg)
{
Result res = null;
try
{
switch (ri.FunctionNo)
{
case 603001: //Захиалгын жагсаалт хайлт
res = Txn603001(ci, ri, db, ref lg);
break;
case 603002: //Захиалгад хамрагдсан үйлчлүүлэгчид
res = Txn603002(ci, ri, db, ref lg);
break;
case 603003: //Захиалгад хамрагдсан бараанууд
res = Txn603003(ci, ri, db, ref lg);
break;
default:
res = new Result(9110009, "Функц тодорхойлогдоогүй байна");
break;
}
return(res);
}
catch (Exception ex)
{
res = new Result(9110002, "Функц дуудахад алдаа гарлаа.\r\n" + ex.Message);
}
return(res);
}
public static Result DB213017(DbConnections pDB, object[] pParam)
{
Result res = new Result();
try
{
string sql =
@"UPDATE PROCESS SET DLLNAME=:2 ,
CLASSNAME=:3 ,
FUNCTIONNAME=:4,
DESCRIPTION=:5 ,
STATUS =:6,freq=:7
WHERE PID=:1";
res = pDB.ExecuteQuery("core", sql, enumCommandType.UPDATE, "DB213017", pParam);
res = F_Error(res);
return(res);
}
catch (Exception ex)
{
ISM.Lib.Static.WriteToLogFile("Error.log", ex.Message + ex.Source + ex.StackTrace);
res.ResultNo = 9110001;
res.ResultDesc = "Датабааз руу хандахад алдаа гарлаа" + ex.Message;
return(res);
}
}
} //Захиалгад хамрагдсан үйлчлүүлэгчид
public Result Txn603003(ClientInfo ci, RequestInfo ri, DbConnections db, ref Log lg)
{
Result res = null;
try
{
#region Prepare parameters
string orderno = Static.ToStr(ri.ReceivedParam[0]);
#endregion
#region Prepare query
string sql = @"select orderno,groupno,prodno,prodtype,qty from orderproduct where orderno=:1";
#endregion
#region Execute query
object[] param = new object[] { orderno };
res = db.ExecuteQuery("core", sql, enumCommandType.SELECT, "Txn603003", param);
#endregion
}
catch (Exception ex)
{
res = new Result(9110002, "Програм руу нэвтрэхэд алдаа гарлаа" + ex.Message);
}
return(res);
} //Захиалгад хамрагдсан бараанууд
public static Result DB213003(DbConnections pDB, DateTime pCurDate)
{
Result res = new Result();
try
{
string sql = "";
sql = @"MERGE INTO CurrencyHist b
USING (
SELECT Currency, :1 curdate, Rate, CashBuyRate, CashSellRate, NonCashBuyRate, NonCashSellRate, OLDRATE
FROM Currency
) e
ON (b.Currency = e.Currency and b.curdate = e.curdate)
WHEN MATCHED THEN
UPDATE SET b.Rate = e.Rate, b.CashBuyRate=e.CashBuyRate , b.CashSellRate=e.CashSellRate , b.NonCashBuyRate=e.NonCashBuyRate , b.NonCashSellRate=e.NonCashSellRate , b.OLDRATE=e.OLDRATE
WHEN NOT MATCHED THEN
insert (Currency, curdate, Rate, CashBuyRate, CashSellRate, NonCashBuyRate, NonCashSellRate, OLDRATE)
values (e.Currency, :1, e.Rate, e.CashBuyRate, e.CashSellRate, e.NonCashBuyRate, e.NonCashSellRate, e.OLDRATE)
";
res = pDB.ExecuteQuery("core", sql, enumCommandType.UPDATE, "DB213003", pCurDate);
return(res);
}
catch (Exception ex)
{
res.ResultNo = 9110001;
res.ResultDesc = "Датабааз руу хандахад алдаа гарлаа" + ex.Message;
return(res);
}
}
public Result Txn110111(ClientInfo ci, RequestInfo ri, DbConnections db, ref Log lg)
{
Result res = new Result();
try
{
byte[] image = (byte[])ri.ReceivedParam[1];
res = DBIO.DB203011(db, Static.ToInt(ri.ReceivedParam[0]), image);
return(res);
}
catch (Exception ex)
{
res.ResultNo = 9110002;
res.ResultDesc = "Програм руу нэвтрэхэд алдаа гарлаа" + ex.Message;
EServ.Shared.Static.WriteToLogFile("Error.log", ex.Message + ex.Source + ex.StackTrace);
return(res);
}
finally
{
lg.item.Desc = "Хэрэглэгчийн мэдээлэл засварлах";
}
}
public static Result DB213027(DbConnections pDB)
{
Result res = new Result();
try
{
string sql = @"
select SP.SalesNo, PD.PaymentType, PD.Amount, PD.PaymentFlag, PD.ContractNo,
decode(PD.PaymentFlag, 0, c.accountno, 1, p.SUSPACCOUNT) as accountno
from SALESPAYMENTDETAIL PD
left join SALESPAYMENT SP on SP.PaymentNo=PD.PaymentNo
left join papaytype p on pd.PAYMENTTYPE=p.TYPEID
left join contractmain c on pd.contractno=c.contractno
order by SalesNo, PaymentType
";
res = pDB.ExecuteQuery("core", sql, enumCommandType.SELECT, "DB213027", null);
return(res);
}
catch (Exception ex)
{
res.ResultNo = 9110001;
res.ResultDesc = "Датабааз руу хандахад алдаа гарлаа" + ex.Message;
return(res);
}
}
public Result Txn110114(ClientInfo ci, RequestInfo ri, DbConnections db, ref Log lg)
{
Result res = new Result();
try
{
res = DBIO.DB216002(db, (object[])ri.ReceivedParam[0]);
return(res);
}
catch (Exception ex)
{
res.ResultNo = 9110001;
res.ResultDesc = "Програм руу нэвтрэхэд алдаа гарлаа" + ex.Message;
EServ.Shared.Static.WriteToLogFile("Error.log", " " + res.ResultNo.ToString());
return(res);
}
finally
{
lg.item.Desc = "Нууц үгийн бүртгэлийг засварлах";
object[] fieldValue = (object[])ri.ReceivedParam[2];
object[] oldValue = (object[])ri.ReceivedParam[1];
object[] newValue = (object[])ri.ReceivedParam[0];
for (int i = 0; i < fieldValue.Length; i++)
{
if (oldValue[i].ToString() != newValue[i].ToString())
{
lg.AddDetail("PASSPOLICY", fieldValue[i].ToString(), oldValue[i].ToString(), newValue[i].ToString());
}
}
}
}
public static Result DB216001(DbConnections pDB)
{
Result res = new Result();
try
{
string sql;
sql =
@"SELECT MASKTYPE, MASKVALUE, MASKDESCRIPTION, DEFAULTPASS, CREATETYPE, VALIDDAY, WRONGCOUNT, HISTORYCOUNT, servername, serverport,
mailusername, mailuserpass, fromuser, isSendMail
FROM PASSPOLICY
WHERE ID=1";
res = pDB.ExecuteQuery("core", sql, enumCommandType.SELECT, "DB216001", null);
return(res);
}
catch (Exception ex)
{
ISM.Lib.Static.WriteToLogFile("Error.log", ex.Message + ex.Source + ex.StackTrace);
res.ResultNo = 9110001;
res.ResultDesc = "Датабааз руу хандахад алдаа гарлаа" + ex.Message;
return(res);
}
}
public Result Txn110108(ClientInfo ci, RequestInfo ri, DbConnections db, ref Log lg)
{
Result res = new Result();
int groupid = Static.ToInt(ri.ReceivedParam[0]);
try
{
res = DBIO.DB203017(db, groupid); // Хэрэглэгчийн бүлэг устгах
return(res);
}
catch (Exception ex)
{
res.ResultNo = 9110002;
res.ResultDesc = "Програм руу нэвтрэхэд алдаа гарлаа" + ex.Message;
EServ.Shared.Static.WriteToLogFile("Error.log", ex.Message + ex.Source + ex.StackTrace);
return(res);
}
finally
{
lg.item.Desc = "Хэрэглэгчийн бүлэг устгах";
//object[] fielvalue = (object[])ri.ReceivedParam[1];
object[] oldvalue = (object[])ri.ReceivedParam[1];
for (int i = 0; i < oldvalue.Length; i++)
{
if (groupid != 0)
{
lg.AddDetail("TXNGROUP", oldvalue[i].ToString(), "Хэрэглэгчийн бүлэг устгах", groupid.ToString());
}
}
}
}
} //Захиалга хайж жагсаалт авах
public Result Txn603002(ClientInfo ci, RequestInfo ri, DbConnections db, ref Log lg)
{
Result res = null;
try
{
#region Prepare parameters
string orderno = Static.ToStr(ri.ReceivedParam[0]);
#endregion
#region Prepare query
string sql = @"select p.custno,c.registerno
,decode(c.classcode,1,c.corporatename, c.lastname||' '||c.firstname) custname
,d.serialno,decode(p.custno,o.custno,1,0) owner
from orderperson p
left join orders o on o.orderno=p.orderno
left join customeriddevice d on d.custno=p.custno
left join customer c on c.customerno=p.custno
where p.orderno=:1";
#endregion
#region Execute query
object[] param = new object[] { orderno };
res = db.ExecuteQuery("core", sql, enumCommandType.SELECT, "Txn603002", param);
#endregion
}
catch (Exception ex)
{
res = new Result(9110002, "Програм руу нэвтрэхэд алдаа гарлаа" + ex.Message);
}
return(res);
} //Захиалгад хамрагдсан үйлчлүүлэгчид
public static Result DB228006(DbConnections pDB, int taskid, int userno, long sourceid, DateTime systemdate)
{
Result res = new Result();
try
{
string sql =
@"
merge into markedtask a
using (select :1 taskid,:2 userno,:3 sourceid,:4 checked from dual
) b
on (a.taskid=b.taskid and a.userno=b.userno and a.sourceid=b.sourceid)
when matched then
update set a.status=1,a.checked=b.checked
when not matched then
insert (taskid,userno,sourceid,checked,status)
values (b.taskid,b.userno,b.sourceid,b.checked,1)
";
res = pDB.ExecuteQuery("core", sql, enumCommandType.SELECT, "DB228006", taskid, userno, sourceid, systemdate);
return(res);
}
catch (Exception ex)
{
ISM.Lib.Static.WriteToLogFile("Error.log", ex.Message + ex.Source + ex.StackTrace);
res.ResultNo = 9110001;
res.ResultDesc = "Датабааз руу хандахад алдаа гарлаа" + ex.Message;
return(res);
}
}
} //Тагтай түрээсийн хэрэгслийн лавлагаа
public Result Txn606003(ClientInfo ci, RequestInfo ri, DbConnections db, ref Log lg)
{
Result res = null;
try
{
#region Prepare parameters
string serialno = Static.ToStr(ri.ReceivedParam[0]);
#endregion
#region Тагийн төлвийн шалгах
//Хүчингүй, танигдахгүй, эсвэл хураагдсан таг эсэхийг шалгах.
#endregion
#region Prepare sql
string sql = @"select cid.custno,cid.serialno
,decode(c.classcode,1,c.corporatename, c.lastname||' '||c.firstname) custname
,c.sex,c.membertype,cr.name ratename,c.mobile,c.telephone,c.homephone,c.height,c.foot
from customeriddevice cid
left join customer c on c.customerno=cid.custno
left join custrate cr on cr.ratecode=c.ratecode
where cid.serialno=:1";
#endregion
object[] param = new object[] { serialno };
res = db.ExecuteQuery("core", sql, enumCommandType.SELECT, "Txn606003", param);
}
catch (Exception ex)
{
res = new Result(9110001, "Датабааз руу хандахад алдаа гарлаа.\r\n" + ex.Message);
}
return(res);
} //Тагтай үйлчлүүлэгчдийн лавлагаа
public Result TxnUpdateMessage(ClientInfo ci, RequestInfo ri, DbConnections db, ref Log lg)
{
Result res = new Result();
try
{
#region [ SetValue ]
object[] UpdateParam = new object[5];
#endregion
#region [ Update DB ]
res = ISM.DB.Main.DB102003(db, UpdateParam);
#endregion
return(res);
}
catch (Exception ex)
{
res.ResultNo = 9110002;
res.ResultDesc = "Програм руу нэвтрэхэд алдаа гарлаа" + ex.Message;
EServ.Shared.Static.WriteToLogFile("Error.log", ex.Message + ex.Source + ex.StackTrace);
return(res);
}
finally
{
lg.item.Desc = "Message засварлах";
}
}
public Result TxnSelectMessage(ClientInfo ci, RequestInfo ri, DbConnections db, ref Log lg)
{
Result res = new Result();
try
{
#region [ SetValue ]
long MsgID = 0;
#endregion
#region [ Select DB ]
res = ISM.DB.Main.DB102001(db, MsgID);
#endregion
return(res);
}
catch (Exception ex)
{
res.ResultNo = 9110002;
res.ResultDesc = "Програм руу нэвтрэхэд алдаа гарлаа" + ex.Message;
EServ.Shared.Static.WriteToLogFile("Error.log", ex.Message + ex.Source + ex.StackTrace);
return(res);
}
finally
{
lg.item.Desc = "Message дэлгэрэнгүй мэдээлэл авах";
}
}
private Result GetTodayCustomer(ClientInfo ci, RequestInfo ri, DbConnections db, ref Log lg)
{
Result res = new Result();
string sql = "";
try
{
//-- Өнөөдөр нийт хэдэн харилцагч гүйлгээ хийсэнийг олж авах
sql = @"
SELECT CustNo
FROM glfile
WHERE Txndate = :1
GROUP BY CustNo";
res = db.ExecuteQuery("core", sql, enumCommandType.SELECT, "GetTodayCustomer", Static.ToDate(ri.ReceivedParam[0]));
return(res);
}
catch (Exception ex)
{
res.ResultNo = 9110002;
res.ResultDesc = "Програм руу нэвтрэхэд алдаа гарлаа" + ex.Message;
ISM.Lib.Static.WriteToLogFile("ProcessError.log", ex.Message + ex.Source + ex.StackTrace);
return(res);
}
return(res);
}
private Result GetTodayCashierTxn(ClientInfo ci, RequestInfo ri, DbConnections db, ref Log lg)
{
Result res = new Result();
string sql = "";
try
{
// Өнөөдөр хийгдсэн кассын илүүдэл дутагдлын гүйлгээ
// debt>0 Илүүдэл, -
sql = @"select T.Trandate, T.UserNo, U.DebitAcntNo, U.CreditAcntNo, T.Debt
From shift T
Left join hpuser U on u.userno=T.UserNo
where T.status=2 and T.Debt<>0 and T.TxnDate=:1";
res = db.ExecuteQuery("core", sql, enumCommandType.SELECT, "GetTodayCashierTxn", Static.ToDate(ri.ReceivedParam[0]));
return(res);
}
catch (Exception ex)
{
res.ResultNo = 9110002;
res.ResultDesc = "Програм руу нэвтрэхэд алдаа гарлаа" + ex.Message;
ISM.Lib.Static.WriteToLogFile("ProcessError.log", ex.Message + ex.Source + ex.StackTrace);
return(res);
}
return(res);
}
private DbConnections GetDbConnections(ConfigDatabase db)
{
DbConnections dbConns = new DbConnections();
dbConns.dbName = db.name;
string SQL = "SELECT * FROM master..sysprocesses where dbid=db_id('"+db.name+"') AND SPID >= 50";
using (SqlDataReader dataReader = Execute("master", db.conn, SQL, false))
{
while (dataReader.Read())
{
DbConnection dbConn = new DbConnection();
dbConn.spid = dataReader.GetInt16(dataReader.GetOrdinal("spid"));
dbConn.hostName = dataReader.GetString(dataReader.GetOrdinal("hostname")).Trim();
dbConn.program_name = dataReader.GetString(dataReader.GetOrdinal("program_name")).Trim();
dbConns.dbConnList.Add(dbConn);
}
}
return dbConns;
}
