public void VirtualDelRecord(int keyValue1, int keyValue2)
{
try
{
Record_typeEntity entity = new Record_typeEntity()
{
ITEMID = Convert.ToInt32(keyValue1),
XMID = Convert.ToInt32(keyValue2),
DEL_FLAG = "1"
};
var strSql = new StringBuilder();
strSql.Append("update ");
strSql.Append(" t_xt_item");
strSql.Append(" set DEL_FLAG='1'");
strSql.Append(" where ITEMID=@ITEMID and XMID=@XMID");
this.BaseRepository().ExecuteBySql(strSql.ToString(),
new { ITEMID = keyValue1, XMID = keyValue2 });
}
catch (Exception ex)
{
if (ex is ExceptionEx)
{
throw;
}
else
{
throw ExceptionEx.ThrowServiceException(ex);
}
}
}
public void SaveEntity(Record_typeEntity record_TypeEntity)
{
try
{
this.BaseRepository().Insert(record_TypeEntity);
}
catch (Exception ex)
{
if (ex is ExceptionEx)
{
throw;
}
else
{
throw ExceptionEx.ThrowServiceException(ex);
}
}
}
public void UpdateEntity(Record_typeEntity record_TypeEntity)
{
try
{
Record_typeEntity entity = new Record_typeEntity()
{
ITEMID = record_TypeEntity.ITEMID,
XMID = record_TypeEntity.XMID,
ORDERINDEX = record_TypeEntity.ORDERINDEX,
SCHEMEID = record_TypeEntity.SCHEMEID,
XMNAME = record_TypeEntity.XMNAME,
XMSM = record_TypeEntity.XMSM,
DEL_FLAG = "1"
};
var strSql = new StringBuilder();
strSql.Append("update ");
strSql.Append(" t_xt_item");
strSql.Append(string.Format(
@" set ORDERINDEX='{0}'
SCHEMEID='{1}',
XMNAME='{2}',
XMSM='{3}'",
entity.ORDERINDEX,
entity.SCHEMEID,
entity.XMNAME,
entity.XMSM
));
strSql.Append(" where ITEMID=@ITEMID and XMID=@XMID");
this.BaseRepository().ExecuteBySql(strSql.ToString(),
new { entity.ITEMID, entity.XMID });
}
catch (Exception ex)
{
if (ex is ExceptionEx)
{
throw;
}
else
{
throw ExceptionEx.ThrowServiceException(ex);
}
}
}
