private bool NewNotice()
{
DbHelper db = new DbHelper(Common.OracleConnStrLocal, true);
try
{
M_T_Notice ety = new M_T_Notice();
ety.LeaseNumber = this.req.data.userid;
ety.ImgUrlLarge = this.req.data.imgurl;
ety.Detail = this.req.data.detail;
ety.Title = this.req.data.title;
ety.Type = this.req.data.type;
ety.NoticeId = Common.DbNull2Int(Common.GetSingleValue("select max(noticeid) from t_notice", db)) + 1;
ety.Approve = "A";
ety.CreateDate = DateTime.Now;
ety.EndDate = DateTime.Parse(this.req.data.enddate);
ety.StartDate = DateTime.Parse(this.req.data.startdate);
ety.Status = "A";
ety.CreateBy = Common.CurrentUser;
ety.UpdateBy = Common.CurrentUser;
ety.UpdateDate = DateTime.Now;
Common.Insert <M_T_Notice>(ety, db);
db.Commit();
return(true);
}
catch (Exception err)
{
db.Abort();
throw err;
}
}
private List <M_T_Feedback_Res> Select(Criteria c)
{
DbHelper db = new DbHelper(Common.OracleConnStrLocal, false);
try
{
string sql = "select * from t_feedback_res where 1=1 ";
if (c.leaseNumber != "")
{
sql += " and LeaseNum='" + c.leaseNumber + "' ";
}
if (c.feedbackId != 0)
{
sql += " and feedbackId=" + c.feedbackId.ToString();
}
List <M_T_Feedback_Res> etyList = db.ExecuteList <M_T_Feedback_Res>(sql, null);
db.Commit();
return(etyList);
}
catch (Exception err)
{
db.Abort();
throw err;
}
}
public override string InvokeRequest()
{
Resp39 resp = new Resp39();
DbHelper db = new DbHelper(Common.OracleConnStrLocal, true);
try
{
M_T_Feedback ety = new M_T_Feedback();
ety.CreateBy = Common.CurrentUser;
ety.CreateDate = DateTime.Now;
ety.Title = this.req.data.title;
ety.Type = Common.DbNull2Int(this.req.data.type);
ety.Detail = this.req.data.detail;
ety.FeedbackId = Common.DbNull2Int(Common.GetSingleValue("select max(feedbackid) from t_feedback", db)) + 1;
ety.LeaseNumber = this.req.data.leasenum;
ety.Status = "100";
ety.PropertyCode = "<None>";
Common.Insert <M_T_Feedback>(ety, db);
db.Commit();
}
catch (Exception err)
{
db.Abort();
resp.code = "200";
resp.msg = "接口调用失败";
resp.status = "false";
resp.time = Common.Today;
resp.data.result = "200";
resp.data.message = err.Message;
}
return(Common.Serialize <Resp39>(resp));
}
private DataTable DAL_Select(Criteria c)
{
DbHelper db = new DbHelper(Common.OracleConnStrLocal, false);
try
{
string sql = "";
sql += "select * from t_payment where 1=1 ";
if (c.startDate != "")
{
sql += " and paydate>=to_date('" + c.startDate + "','yyyy-mm-dd')";
}
if (c.endDate != "")
{
sql += " and paydate<=to_date('" + c.endDate + "','yyyy-mm-dd')";
}
if (c.leaseNumber != "")
{
sql += " and leasenumber='" + c.leaseNumber + "'";
}
DataTable dt = db.ExecuteDT(sql, null);
db.Commit();
return(dt);
}
catch (Exception err)
{
db.Abort();
throw err;
}
}
public override string InvokeRequest()
{
int cnt = 0;
Resp313B resp = new Resp313B();
DbHelper db = new DbHelper(Common.OracleConnStrLocal, true);
try
{
Criteria c = new Criteria();
c.userid = this.req.data.userid;
c.noticeId = this.req.data.noticeid;
List <M_T_Notice> etyList = BHelper.FetchNotice(c, db);
List <string> parameters = new List <string>();
parameters.Add("NoticeId");
for (int i = 0; i < etyList.Count; i++)
{
cnt += Common.Delete <M_T_Notice>(etyList[i], db, parameters);
}
db.Commit();
resp.data.result = "100";
resp.data.message = "接口操作完成(处理了" + cnt.ToString() + "条数据)";
}
catch (Exception err)
{
db.Abort();
resp.data.result = "200";
resp.data.message = err.Message;
}
return(Common.Serialize <Resp313B>(resp));
}
/// <summary>
/// 创建分录
/// </summary>
/// <param name="reNum"></param>
/// <param name="reType"></param>
private void CreateDistribution(string reNum, string reType)
{
DbHelper db = new DbHelper(true);
try
{
COA c = new COA(db);
ArrayList al = c.Generate_Distribution(reNum, reType);
string strType = "R";
if (reType == "UD")
{
strType = "U";
}
db.ExecuteNonQuery("delete from AR_Line_Distribution where TRANSACTION_NO='" + reNum + "' and TRANSACTION_TYPE='" + strType + "' and post_status<>'P'");
c.Insert_Distribution(al);
db.Commit();
}
catch (Exception err)
{
db.Abort();
throw err;
}
}
/// <summary>
/// 发起处理请求
/// </summary>
/// <returns></returns>
public override string InvokeRequest()
{
Resp35 resp = new Resp35(); //定义返回数据实体
M_T_PAYMENT etyTmp = null; //定义支付表实体.
DbHelper db = new DbHelper(true);
Receipt r = null;
try
{
/// 0 在本地保存支付信息
this.DAL_Insert_Pay();
/// 1 创建receipt
r = new Receipt(db);
r.Create(req.data); //创建receipt
db.Commit();
etyTmp = this.DAL_Select_PayById(etyH.paymentid);
etyTmp.status = "1"; //创建receipt完成后，状态位置1
this.DAL_Update_Pay(etyTmp);
}
catch (Exception err)
{
db.Abort();
resp.status = "false";
resp.time = Common.Today;
resp.code = "200";
resp.msg = "接口操作失败!" + err.Message;
return(Common.Serialize <Resp35>(resp));
}
/// 2 创建distribution
try
{
this.CreateDistribution(r.EtyReceipt.RECEIPT_NUMBER, r.EtyReceipt.RECEIPT_TYPE);
etyTmp = this.DAL_Select_PayById(etyH.paymentid);
etyTmp.status = "2";
this.DAL_Update_Pay(etyTmp);
}
catch (Exception err)
{
resp.status = "false";
resp.time = Common.Today;
resp.code = "200";
resp.msg = "Receipt创建成功！但Distribution创建失败!" + err.Message;
return(Common.Serialize <Resp35>(resp));
}
resp.status = "true";
resp.time = Common.Today;
resp.code = "100";
resp.msg = "接口操作成功!";
resp.data.result = "100";
resp.data.message = "Receipt创建成功!";
return(Common.Serialize <Resp35>(resp));
}
private void Insert(M_T_Feedback_Res ety)
{
DbHelper db = new DbHelper(Common.OracleConnStrLocal, true);
try
{
ety.Id = Common.DbNull2Int(Common.GetSingleValue("select max(id) from T_Feedback_Res", db)) + 1;
Common.Insert <M_T_Feedback_Res>(ety, db);
db.Commit();
}
catch (Exception err)
{
db.Abort();
throw err;
}
}
private bool UpdateNotice()
{
DbHelper db = new DbHelper(Common.OracleConnStrLocal, true);
try
{
Criteria c = new Criteria();
c.noticeId = this.req.data.noticeid;
List <M_T_Notice> etyList = BHelper.FetchNotice(c, db);
if (etyList.Count > 0)
{
etyList[0].StartDate = DateTime.Parse(this.req.data.startdate);
etyList[0].EndDate = DateTime.Parse(this.req.data.enddate);
etyList[0].Detail = this.req.data.detail;
etyList[0].Title = this.req.data.title;
etyList[0].ImgUrlLarge = this.req.data.imgurl;
etyList[0].LeaseNumber = this.req.data.userid;
etyList[0].UpdateBy = this.req.data.userid;
List <string> keys = new List <string>();
keys.Add("NoticeId");
if (Common.Update <M_T_Notice>(etyList[0], db, keys) > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
catch (Exception err)
{
db.Abort();
throw err;
}
finally
{
db.Commit();
}
}
private void DAL_Update_Pay(M_T_PAYMENT etyH)
{
DbHelper db = new DbHelper(Common.OracleConnStrLocal, true);
try
{
List <string> keys = new List <string>();
keys.Add("paymentid");
Common.Update <M_T_PAYMENT>("T_Payment", etyH, db, keys);
db.Commit();
}
catch (Exception err)
{
db.Abort();
throw err;
}
}
private void DAL_Update_PWD(string pwd)
{
DbHelper db = new DbHelper(Common.OracleConnStrLocal, true);
try
{
string sql = "";
sql += "update sys_users set password='******' where 1=1 ";
sql += " and loginname='" + req.data.username + "'";
db.ExecuteNonQuery(sql);
db.Commit();
}
catch (Exception err)
{
db.Abort();
throw err;
}
}
private DataTable DAL_Select()
{
DbHelper db = new DbHelper(Common.OracleConnStrLocal, false);
try
{
string sql = "select * from SYS_USERS t where 1=1 ";
sql += " and loginname='" + this.req.data.username + "'";
DataTable dt = db.ExecuteDT(sql);
db.Commit();
return(dt);
}
catch (Exception err)
{
db.Abort();
throw err;
}
}
private M_T_PAYMENT DAL_Select_PayById(int id)
{
DbHelper db = new DbHelper(Common.OracleConnStrLocal, false);
try
{
string sql = "select * from T_Payment where 1=1 ";
sql += " and paymentid=" + id.ToString();
List <M_T_PAYMENT> etyList = db.ExecuteList <M_T_PAYMENT>(sql, null);
db.Commit();
return(etyList[0]);
}
catch (Oracle.DataAccess.Client.OracleException err)
{
db.Abort();
throw err;
}
}
/// <summary>
/// 创建receipt后保存支付信息
/// </summary>
private void DAL_Insert_Pay()
{
DbHelper db = new DbHelper(Common.OracleConnStrLocal, true);
try
{
etyH = new M_T_PAYMENT();
etyH.paymentid = BHelper.FetchPaymentId(db) + 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顺序转换。
Common.Insert <M_T_PAYMENT>(etyH, db);
Req35_2 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;
Common.Insert <M_T_PAYMENT_INFO>(etyD, db);
}
db.Commit();
}
catch (Exception err)
{
db.Abort();
throw err;
}
}
private List <M_T_Notice> Select(Criteria c)
{
DbHelper db = new DbHelper(Common.OracleConnStrLocal, false);
try
{
string sql = "select * from " + M_T_Notice.TableName + " where 1=1 ";
if (c.startDate != "")
{
sql += " and startdate>=to_date('" + c.startDate + "','yyyy-mm-dd')";
}
if (c.endDate != "")
{
sql += " and enddate<=to_date('" + c.endDate + "','yyyy-mm-dd')";
}
if (c.userid != "")
{
sql += " and leaseNumber='" + c.userid + "'";
}
if (c.noticeType != "")
{
sql += " and type='" + c.noticeType + "'";
}
return(db.ExecuteList <M_T_Notice>(sql, null));
}
catch (Exception err)
{
db.Abort();
throw err;
}
finally
{
db.Commit();
}
}
