/// /// 插入一个DOCTORINTRODUCTION实体到数据库。 /// /// 将要插入的实体 public int InsertEntity(DataSetDOCTORINTRODUCTION entity) { CheckData(entity); int iRtn = 0; bool isExistTrans = db.IsInTransaction(); if (!isExistTrans) { db.BeginTrans(); } try { foreach (DataRow row in entity.Tables["YWAPP_DOCTOR_INTRODUCTION"].Rows) { int j = db.exeSql(new SS_DOCTORINTRODUCTION_InsertYWAPP_DOCTOR_INTRODUCTION(), row); iRtn = iRtn + j; } if (!isExistTrans) { db.CommitTrans(); } return(iRtn); } catch (Exception e) { if (!isExistTrans) { db.RollbackTrans(); } throw e; } }
///////////// #endregion //// 2006-09-11 public DataSetDOCTORINTRODUCTION GetDataSet(SqlClass sC, string sTableName) { DataSetDOCTORINTRODUCTION ds = new DataSetDOCTORINTRODUCTION(); db.FillDataSet(sC, ds, sTableName); return(ds); }
/// /// 检查给定的实体是否有更改,如果有把更改的行提交到数据库。 注意:提交过程是按先提交Deleted的行,再提交Modified的行,最后提交Added的行。 /// /// 要检验的实体 public void CommitDOCTORINTRODUCTIONChanges(DataSetDOCTORINTRODUCTION entity, ArrayList alUpdateColumn, ArrayList alUpdateControl) { using (DOCTORINTRODUCTIONBaseDAO dao = new DOCTORINTRODUCTIONBaseDAO()) { dao.CommitChanges(entity, alUpdateColumn, alUpdateControl); } }
/// /// 检查给定的实体是否有更改,如果有把更改的行提交到数据库。 注意:提交过程是按先提交Deleted的行,再提交Modified的行,最后提交Added的行。 /// /// 要检验的实体 public void CommitDOCTORINTRODUCTIONChanges(DataSetDOCTORINTRODUCTION entity) { using (DOCTORINTRODUCTIONBaseDAO dao = new DOCTORINTRODUCTIONBaseDAO()) { dao.CommitChanges(entity); } }
/// /// 更新DOCTORINTRODUCTION实体。 /// /// DOCTORINTRODUCTION实体 public void UpdateDOCTORINTRODUCTION(DataSetDOCTORINTRODUCTION entity) { using (DOCTORINTRODUCTIONBaseDAO dao = new DOCTORINTRODUCTIONBaseDAO()) { dao.UpdateEntity(entity); } }
/*实体DOCTORINTRODUCTION的基本规则*/ /// /// 插入DOCTORINTRODUCTION实体。 /// /// DOCTORINTRODUCTION实体 public void InsertDOCTORINTRODUCTION(DataSetDOCTORINTRODUCTION entity) { using (DOCTORINTRODUCTIONBaseDAO dao = new DOCTORINTRODUCTIONBaseDAO()) { dao.InsertEntity(entity); } }
private void button7_Click(object sender, EventArgs e) { DataSetDOCTORINTRODUCTION ds = hyApp.Rules.hyAppStaticRules.GetDOCTORINTRODUCTION_SelectALl("vstaffcode=436"); RowYWAPP_DOCTOR_INTRODUCTION row = ds.YWAPP_DOCTOR_INTRODUCTION[0]; string str = Convert.ToBase64String(row.PHOTO); }
} // Data_SelectByIDYWAPP_DOCTOR_INTRODUCTION #endregion #region Data_DOCTORINTRODUCTION_SelectALl /// /// 对于SelectALl的类的实现(数据库操作)。 /// public DataSetDOCTORINTRODUCTION Data_DOCTORINTRODUCTION_SelectALl(string sTj) { DataSetDOCTORINTRODUCTION ds = new DataSetDOCTORINTRODUCTION(); SS_DOCTORINTRODUCTION_SelectALl ss = new SS_DOCTORINTRODUCTION_SelectALl(); ss.SqlString = ss.SqlString.Replace("1=1", sTj); db.FillDataSet(ss, ds, "YWAPP_DOCTOR_INTRODUCTION"); return(ds); } // Data_SelectALl
//wuqb modify 2007-03-27 //强名DataSet #region Data_DOCTORINTRODUCTION_SelectByIDYWAPP_DOCTOR_INTRODUCTION /// /// 对于SelectByIDYWAPP_DOCTOR_INTRODUCTION的类的实现(数据库操作)。 /// public DataSetDOCTORINTRODUCTION Data_DOCTORINTRODUCTION_SelectByIDYWAPP_DOCTOR_INTRODUCTION(System.String ID) { DataSetDOCTORINTRODUCTION ds = new DataSetDOCTORINTRODUCTION(); SS_DOCTORINTRODUCTION_SelectByIDYWAPP_DOCTOR_INTRODUCTION ss = new SS_DOCTORINTRODUCTION_SelectByIDYWAPP_DOCTOR_INTRODUCTION(); ss.ID = ID; db.FillDataSet(ss, ds, "YWAPP_DOCTOR_INTRODUCTION"); return(ds); } // Data_SelectByIDYWAPP_DOCTOR_INTRODUCTION
/// /// 检查给定的实体是否有给定状态的更改,如果有把更改的行提交到数据库。 /// /// 要检验的实体 /// 要检查更改的状态 /// 2006-05-21 public int CommitChanges(DataSetDOCTORINTRODUCTION 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); }
/// /// 按照DOCTORINTRODUCTION实体的主表的主键查询数据。 /// /// 主键的值 public DataSetDOCTORINTRODUCTION FindByPrimaryKey(object KeyValue) { DataSetDOCTORINTRODUCTION entity = new DataSetDOCTORINTRODUCTION(); SS_DOCTORINTRODUCTION_SelectByIDYWAPP_DOCTOR_INTRODUCTION ss = new SS_DOCTORINTRODUCTION_SelectByIDYWAPP_DOCTOR_INTRODUCTION(); ss.Params[0].Value = KeyValue; db.FillDataSet(ss, entity, "YWAPP_DOCTOR_INTRODUCTION"); return(entity); }
///////////////// public int CommitChanges(DataSetDOCTORINTRODUCTION 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(DataSetDOCTORINTRODUCTION 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(DataSetDOCTORINTRODUCTION entity) { //在这里可以加入操作之前所需要对实体检验的代码 }
/// 2006-05-21 /// public int CommitChanges(DataSetDOCTORINTRODUCTION entity, ArrayList alUpdateColumn, ArrayList alUpdateControl) { this.alUpdateColumn = alUpdateColumn; this.alUpdateControl = alUpdateControl; return(CommitChanges(entity)); }