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(); } }