private void UpdatePayInfo(M_T_PAYMENT ety)
{
CRUD dbiz = new CRUD(DbVendor.Oracle, Runtime.OracleConnStrLocal, true);
try
{
dbiz.Update(ety, "paymentid");
dbiz.Commit();
}
catch (Exception)
{
dbiz.Abort();
throw;
}
}
private void Save2Log(Model.M_Sys_Log ety)
{
CRUD biz2 = new CRUD(DbVendor.Oracle, Runtime.OracleConnStrLocal, true);
try
{
biz2.Create(ety);
biz2.Commit();
}
catch (Exception err)
{
biz2.Abort();
throw err;
}
}
private void UpdateLoginAccount(DataRow dr)
{
CRUD biz = new CRUD(DbVendor.Oracle, Runtime.OracleConnStrLocal, true);
try
{
biz.Update <Model.M_Sys_Login_Account>(dr, "UserId");
biz.Commit();
}
catch (Exception err)
{
biz.Abort();
throw err;
}
}
private int UpdateLoginAcc(Model.M_Sys_Login_Account ety)
{
BLL.CRUD biz = new CRUD(DbVendor.Oracle, Runtime.OracleConnStrLocal, true);
try
{
int cnt = biz.Update(ety, "UserId");
biz.Commit();
return(cnt);
}
catch (Exception)
{
biz.Abort();
throw;
}
}
private DataTable GetPendingPay(string leaseNum)
{
string sql = "";
sql += " select ai.customer_number,";
sql += "ac.customer_name as customername,";
sql += "'' as shopname, ";
sql += "l.premise_name1 as premisename, ";
sql += "'' as shoparea, ";
sql += "0 as totalamount, ";
sql += " 0 as payinfonum, ";
//sql += "---- start payinfo detail ";
sql += "ai.invoice_number as transno, ";
sql += "ail.invoice_line_number as invoicelinenum,";
sql += "ail.charge_code as chargeitem, ";
sql += "ail.charge_description as descr, ";
sql += "ail.invoice_amount as amount, ";
sql += " ail.outstanding_amount as outstanding, ";
sql += " ai.payment_due_date as duedate ";
//sql += " ---- end payinfo detail ";
sql += "from ar_invoice ai, ar_invoice_line ail, ar_customer ac,lm_lease l,ar_customer_site acs ";
sql += " where 1 = 1 ";
sql += " and ai.invoice_number = ail.invoice_number ";
sql += " and Upper(SUBSTR(ail.PAY_STATUS, 1, 1)) in ('U', 'P') and ail.outstanding_amount > 0 ";
sql += " and ai.lease_number = trim(l.lease_number) and l.status = 'A' and l.active = 'A' ";
sql += " and ai.customer_number = ac.customer_number and ac.customer_number = acs.customer_number ";
sql += " and trim(l.site_number) = trim(acs.site_number) ";
sql += " and ai.lease_number ='" + leaseNum + "'";
CRUD biz = new CRUD(DbVendor.Oracle, Runtime.OracleConnStr, false);
try
{
DataTable dt = biz.ExecuteDataTable(sql);
dt.TableName = "PayInfo";
biz.Commit();
return(dt);
}
catch (Exception)
{
biz.Abort();
throw;
}
}
private M_Receipt CreateReceipt()
{
CRUD dbiz = new CRUD(DbVendor.Oracle, Runtime.OracleConnStr, true);
try
{
Receipt r = new Receipt(dbiz);
r.Create(this.req.data);
dbiz.Commit();
return(r.ety);
}
catch (Exception)
{
dbiz.Abort();
throw;
}
}
private List <Model.M_Sys_Login_Account> GetLogUser()
{
CRUD biz01 = new CRUD(DbVendor.Oracle, Runtime.OracleConnStrLocal, false);
try
{
Clause c = new Clause();
c.Add("trim(LoginName)", this.req.data.userid);
List <Model.M_Sys_Login_Account> etyLst = biz01.Retrieve <Model.M_Sys_Login_Account>(c.Get());
biz01.Commit();
return(etyLst);
}
catch (Exception err)
{
biz01.Abort();
throw err;
}
}
private DataTable GetUserInfo()
{
CRUD biz = new CRUD(DbVendor.Oracle, Runtime.OracleConnStrLocal, false);
try
{
Clause c = new Clause();
string sql = "";
switch (this.req.data.logintype) //判断登录用户类型
{
case "S":
sql += "select * from " + M_Sys_Login_System.TableName + " where 1=1 ";
sql += " and trim(LoginName)='" + req.data.username + "'";
break;
case "L":
sql += "select * from " + M_Sys_Login_Lease.TableName + " where 1=1 ";
sql += " and trim(LeaseNumber)='" + req.data.username + "'";
break;
case "E":
case "C":
c.Add("trim(LoginName)", req.data.username);
break;
default:
throw new Exception("Unknown login type!");
}
DataTable dt = biz.RetrieveDataTable <Model.M_Sys_Login_Account>(c.Get());
biz.Commit();
return(dt);
}
catch (Exception err)
{
biz.Abort();
throw err;
}
}
private void CreateDisribution(string reNum, string reType)
{
BLL.CRUD dbiz = new CRUD(DbVendor.Oracle, Runtime.OracleConnStr, true);
try
{
COA c = new COA(dbiz);
ArrayList al = c.Generate_Distribution(reNum, reType);
string strType = "R";
if (reType == "UD")
{
strType = "U";
}
dbiz.ExecuteNonQuery("delete from AR_Line_Distribution where TRANSACTION_NO='" + reNum + "' and TRANSACTION_TYPE='" + strType + "' and post_status<>'P'");
c.Insert_Distribution(al);
dbiz.Commit();
}
catch (Exception)
{
dbiz.Abort();
throw;
}
}
private List <string> GetGroupLease(int userid)
{
CRUD biz = new CRUD(DbVendor.Oracle, Runtime.OracleConnStrLocal, false);
try
{
string sql = "select trim(leasenumber) as leasenumber from SYS_USERS_GROUP_LEASE where UserId=" + userid.ToString();
DataTable dt = biz.ExecuteDataTable(sql);
biz.Commit();
List <string> leases = new List <string>();
for (int i = 0; i < dt.Rows.Count; i++)
{
leases.Add(dt.Rows[i][0].ToString());
}
return(leases);
}
catch (Exception)
{
biz.Abort();
throw;
}
}
/// <summary>
/// 创建receipt后保存支付信息
/// </summary>
private void Save()
{
BLL.CRUD biz = new CRUD(DbVendor.Oracle, Runtime.OracleConnStrLocal, true);
try
{
etyH = new M_T_PAYMENT();
etyH.paymentid = Bizhub.FetchPaymentId(biz) + 1;
etyH.amount = this.req.data.actualamount;
etyH.leasenumber = this.req.data.leasenum;
etyH.paydate = DateTime.Parse(this.req.data.actualpaydate);
etyH.paytype = this.req.data.actualpaytype;
etyH.status = "0"; // Status取值定义:0=本地保存完成;1=Receipt创建完成;2=分录创建完成。状态必须从0~2顺序转换。
biz.Create(etyH);
Model.Req35dataDtl detail = null;
etyD = new M_T_PAYMENT_INFO();
for (int i = 0; i < this.req.data.actualpayinfo.Count; i++)
{
detail = this.req.data.actualpayinfo[i];
etyD.actualpay = detail.actualpay;
etyD.amount = detail.amount;
etyD.chargecode = detail.chargecode;
etyD.invoicenumber = detail.transno;
etyD.invoicelinenum = detail.invoicelinenum;
etyD.paymentid = etyH.paymentid;
biz.Create(etyD);
}
biz.Commit();
}
catch (Exception err)
{
biz.Abort();
throw err;
}
}
public string InvokeRequest(string postStr)
{
Helper.LogWrite("SI31 Request:" + postStr);
Model.Rsp31 rsp = new Model.Rsp31();
this.req = Common.Helper.JsonDeserialize <Model.Req31>(postStr);
DataTable dtUser = this.GetUserInfo(); //取登录用户信息
if (dtUser.Rows.Count > 0)
{
string status = Helper.DbNull2Str(dtUser.Rows[0]["Status"]);
string pwd = Helper.DbNull2Str(dtUser.Rows[0]["PASSWORD"]);
if (this.req.data.password == pwd) // 如果密码正确
{
rsp.data.result = "100";
rsp.data.message = "验证成功";
rsp.data.lastlogin = dtUser.Rows[0]["updatedate"].ToString(); //上次登录
Common.Runtime.CurrentUser = this.req.data.username;
if (this.req.data.logintype == "C" || this.req.data.logintype == "E")
{
//取租约信息
rsp.data.leaseinfo = this.GetGroupLease(int.Parse(dtUser.Rows[0]["userid"].ToString()));
rsp.data.leasecount = rsp.data.leaseinfo.Count;
}
//更新最后登录时间
dtUser.Rows[0]["UpdateDate"] = DateTime.Now.ToString(); //本次登录更新
if (this.req.data.logintype != "E")
{
CRUD biz = new CRUD(DbVendor.Oracle, Runtime.OracleConnStrLocal, true);
int cnt = biz.Update <Model.M_Sys_Login_Account>(dtUser.Rows[0], "UserId");
biz.Commit();
}
}
else
{
rsp.data.result = "200";
rsp.data.message = "Wrong password!";
}
rsp.data.userid = Helper.DbNull2Int(dtUser.Rows[0]["UserId"]);
rsp.data.status = Helper.DbNull2Str(dtUser.Rows[0]["Status"]);
/// 判断用户状态
switch (status)
{
case "A":
case "F":
case "C":
break;
case "I":
rsp.data.result = "200";
rsp.data.message = "Forbidden User!";
break;
case "T":
if (this.req.data.password == Helper.DbNull2Str(dtUser.Rows[0]["TempPsw"]))
{
rsp.data.result = "100";
rsp.data.message = "Success!";
Runtime.CurrentUser = this.req.data.username;
dtUser.Rows[0]["TempPsw"] = "";
dtUser.Rows[0]["Status"] = "A";
UpdateLoginAccount(dtUser.Rows[0]);
}
break;
}
}
else
{
rsp.data.result = "200";
rsp.data.message = "User not exist!";
}
return(Common.Helper.JsonSerialize(rsp));
}
