/// <summary>
/// 保存
/// </summary>
/// <param name="p_BE">要删除的实体</param>
/// <param name="sqlTrans">事务类</param>
public void RSave(BaseEntity[] p_BE, BaseEntity[] p_BESub, string p_OPID, IDBTransAccess sqlTrans)
{
try
{
string sql = "DELETE FROM Data_OPWinList WHERE OPID=" + SysString.ToDBString(p_OPID);
sqlTrans.ExecuteNonQuery(sql);
sql = "DELETE FROM Data_OPWinListSub WHERE OPID=" + SysString.ToDBString(p_OPID);
sqlTrans.ExecuteNonQuery(sql);
for (int i = 0; i < p_BE.Length; i++)
{
this.RAdd(p_BE[i], sqlTrans);
}
OPWinListSubRule rule = new OPWinListSubRule();
for (int i = 0; i < p_BESub.Length; i++)
{
rule.RAdd(p_BESub[i], sqlTrans);
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 批量保存
/// </summary>
/// <param name="p_BE">要删除的实体</param>
/// <param name="sqlTrans">事务类</param>
public void RAllSave(BaseEntity[] p_BE, BaseEntity[] p_BESub, IDBTransAccess sqlTrans)
{
try
{
string sql = "DELETE FROM Data_OPWinList WHERE 1=1";
sqlTrans.ExecuteNonQuery(sql);
sql = "DELETE FROM Data_OPWinListSub WHERE 1=1";
sqlTrans.ExecuteNonQuery(sql);
sql = " SELECT OPID FROM Data_OP WHERE ISNULL(DefaultFlag,0)=0 AND ISNULL(UseableFlag,0)=1";
DataTable dt = sqlTrans.Fill(sql);
if (dt.Rows.Count != 0)
{
for (int j = 0; j < dt.Rows.Count; j++)
{
for (int i = 0; i < p_BE.Length; i++)
{
OPWinList entity = (OPWinList)p_BE[i];
entity.OPID = dt.Rows[j]["OPID"].ToString();
this.RAdd(entity, sqlTrans);
}
OPWinListSubRule rule = new OPWinListSubRule();
for (int i = 0; i < p_BESub.Length; i++)
{
OPWinListSub entitySub = (OPWinListSub)p_BESub[i];
entitySub.OPID = dt.Rows[j]["OPID"].ToString();
rule.RAdd(entitySub, sqlTrans);
}
}
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}