///
/// 插入一个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));
}
