/// /// 插入一个PAYMENT实体到数据库。 /// /// 将要插入的实体 public int InsertEntity(DataSetPAYMENT entity) { CheckData(entity); int iRtn = 0; bool isExistTrans = db.IsInTransaction(); if (!isExistTrans) { db.BeginTrans(); } try { foreach (DataRow row in entity.Tables["PAYMENT"].Rows) { int j = db.exeSql(new SS_PAYMENT_InsertPAYMENT(), row); iRtn = iRtn + j; } if (!isExistTrans) { db.CommitTrans(); } return(iRtn); } catch (Exception e) { if (!isExistTrans) { db.RollbackTrans(); } throw e; } }
private void button1_Click(object sender, EventArgs e) { string id = "oRrdQt6gB6cEbIZETSL9_YkaAN24"; string time = "30"; PhoenixDataBaseOperate.IDataBaseOperate operate = PhoenixDataBaseConnect.GenerateFactory.GenerateConnect(); string strSql = @"select * from ywapp.jzhz_relation a where a.vglid='{0}'"; strSql = string.Format(strSql, id); DataTable dt = operate.ExecDataSql(strSql); var sfzhs = dt.AsEnumerable().Select(a => a["VSFZH"].ToString()); string stj = "nvl(ndel,0)=0 and NDDLX=1 and VSFZH in (" + string.Join(",", sfzhs.Select(a => "'" + a + "'")) + ")"; DataSetPAYMENT ds = HYHISAPP.Rules.HYHISAPPStaticRules.GetPAYMENT_SelectAll(stj); var aa = ds.PAYMENT.Cast <RowPAYMENT>(); var r = ds.PAYMENT.Cast <RowPAYMENT>().Select(a => { string ztmc = ""; short nstate = a.NSTATE; if (a.NSTATE == 0) { if ((DateTime.Now - a.DDDRQ).TotalMinutes >= Convert.ToInt32(time)) { ztmc = "超时取消"; nstate = 2; } else { ztmc = "未支付"; } } else if (a.NSTATE == 1) { ztmc = "已支付"; } return(new { VDDLSH = a.VDDLSH, VCLINICNO = a.VCLINICNO, VNAME = a.VNAME, NCOSTS = a.NCOSTS.ToString("0.00"), NSTATE = nstate,//0未支付,1已支付,2超时取消 ZTMC = ztmc, DJZRQ = a.IsDJZRQNull() ? "" : a.DJZRQ.ToString("yyyy-MM-dd"), DDDRQ = a.IsDDDRQNull() ? "" : a.DDDRQ.ToString("yyyy-MM-dd HH:mm:ss"), VAPPTIME = a.VAPPTIME, VDEPT = a.VDEPT, VDOCTOR = a.VDOCTOR, VHAOBIE = a.VHAOBIE, NGHF = a.NGHF, NZLF = a.NZLF }); }).OrderByDescending(a => a.DDDRQ).ToList <object>(); }
///////////// #endregion //// 2006-09-11 public DataSetPAYMENT GetDataSet(SqlClass sC, string sTableName) { DataSetPAYMENT ds = new DataSetPAYMENT(); db.FillDataSet(sC, ds, sTableName); return(ds); }
} // Data_SelectByIDPAYMENT #endregion #region Data_PAYMENT_SelectAll /// /// 对于SelectAll的类的实现(数据库操作)。 /// public DataSetPAYMENT Data_PAYMENT_SelectAll(string sTj) { DataSetPAYMENT ds = new DataSetPAYMENT(); SS_PAYMENT_SelectAll ss = new SS_PAYMENT_SelectAll(); ss.SqlString = ss.SqlString.Replace("1=1", sTj); db.FillDataSet(ss, ds, "PAYMENT"); return(ds); } // Data_SelectAll
//wuqb modify 2007-03-27 //强名DataSet #region Data_PAYMENT_SelectByIDPAYMENT /// /// 对于SelectByIDPAYMENT的类的实现(数据库操作)。 /// public DataSetPAYMENT Data_PAYMENT_SelectByIDPAYMENT(System.String VDDLSH) { DataSetPAYMENT ds = new DataSetPAYMENT(); SS_PAYMENT_SelectByIDPAYMENT ss = new SS_PAYMENT_SelectByIDPAYMENT(); ss.VDDLSH = VDDLSH; db.FillDataSet(ss, ds, "PAYMENT"); return(ds); } // Data_SelectByIDPAYMENT
/// /// 检查给定的实体是否有给定状态的更改,如果有把更改的行提交到数据库。 /// /// 要检验的实体 /// 要检查更改的状态 /// 2006-05-21 public int CommitChanges(DataSetPAYMENT entity, DataRowState drs, ArrayList alUpdateColumn, ArrayList alUpdateControl) { db.SetUpdateControl(alUpdateControl); db.SetUpdateColumn(alUpdateColumn); int iRet = CommitChanges(entity, drs); db.SetUpdateControl(null); db.SetUpdateColumn(null); return(iRet); }
/// /// 按照PAYMENT实体的主表的主键查询数据。 /// /// 主键的值 public DataSetPAYMENT FindByPrimaryKey(object KeyValue) { DataSetPAYMENT entity = new DataSetPAYMENT(); SS_PAYMENT_SelectByIDPAYMENT ss = new SS_PAYMENT_SelectByIDPAYMENT(); ss.Params[0].Value = KeyValue; db.FillDataSet(ss, entity, "PAYMENT"); return(entity); }
///////////////// public int CommitChanges(DataSetPAYMENT entity, DataRowState drs) { int iRtn = 0; if (!entity.HasChanges(drs)) { return(iRtn); } CheckData(entity); bool isExistTrans = db.IsInTransaction(); if (!isExistTrans) { db.BeginTrans(); } try { if (drs == DataRowState.Deleted) { iRtn += DeleteEntity(entity.GetChangesEntity(drs)); } else if (drs == DataRowState.Modified) { iRtn += UpdateEntity(entity.GetChangesEntity(drs)); } else if (drs == DataRowState.Added) { iRtn += InsertEntity(entity.GetChangesEntity(drs)); } if (!isExistTrans) { db.CommitTrans(); } return(iRtn); } catch (Exception e) { if (isExistTrans) { db.RollbackTrans(); } throw e; } }
/// /// 检查给定的实体是否有更改,如果有把更改的行提交到数据库。 /// /// 要检验的实体 public int CommitChanges(DataSetPAYMENT entity) { int iRtn = 0; if (!entity.HasChanges()) { return(iRtn); } CheckData(entity); bool isExistTrans = db.IsInTransaction(); if (!isExistTrans) { db.BeginTrans(); } try { //CommitChanges(entity, DataRowState.Deleted); //CommitChanges(entity, DataRowState.Modified); //CommitChanges(entity, DataRowState.Added); ////////// 2006-05-21 iRtn += CommitChanges(entity, DataRowState.Deleted, null, null); iRtn += CommitChanges(entity, DataRowState.Modified, alUpdateColumn, alUpdateControl); iRtn += CommitChanges(entity, DataRowState.Added, null, null); ///////////// if (!isExistTrans) { db.CommitTrans(); } return(iRtn); } catch (Exception e) { if (isExistTrans) { db.RollbackTrans(); } throw e; } }
/// /// 校验数据输入的有效性。 /// /// 要检验的实体 protected void CheckData(DataSetPAYMENT entity) { //在这里可以加入操作之前所需要对实体检验的代码 }
/// 2006-05-21 /// public int CommitChanges(DataSetPAYMENT entity, ArrayList alUpdateColumn, ArrayList alUpdateControl) { this.alUpdateColumn = alUpdateColumn; this.alUpdateControl = alUpdateControl; return(CommitChanges(entity)); }