/// <summary>
/// 批量新增DownloadLog信息
/// </summary>
/// <param name="entities">实体集合</param>
/// <param name="trans">事物对象</param>
public void AddDownloadlogList(List <DownloadLogDO> entities, DbTransaction trans = null)
{
var cmd = new ComplexParams
{
new ComplexParameter
{
Key = "@model_list",
DbType = DbType.Xml,
Value = ConvertUtils.ConvertModelListToXML("e", entities)
}
};
var sql = string.Format(@"INSERT INTO {0} SELECT
T.ts.value('@LogId', 'uniqueidentifier') as LogId,
CASE WHEN T.ts.value('@Message', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Message', 'uniqueidentifier') END as Message,
CASE WHEN T.ts.value('@Level', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Level', 'int') END as Level,
T.ts.value('@SortValue', 'nvarchar(36)') as SortValue,
CASE WHEN T.ts.value('@Disabled', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Disabled', 'int') END as Disabled,
CASE WHEN T.ts.value('@Rec_CreateBy', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Rec_CreateBy', 'uniqueidentifier') END as Rec_CreateBy,
CASE WHEN T.ts.value('@Rec_CreateTime', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Rec_CreateTime', 'datetime') END as Rec_CreateTime,
CASE WHEN T.ts.value('@Rec_ModifyBy', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Rec_ModifyBy', 'uniqueidentifier') END as Rec_ModifyBy,
CASE WHEN T.ts.value('@Rec_ModifyTime', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Rec_ModifyTime', 'datetime') END as Rec_ModifyTime
FROM @model_list.nodes('/es/e') T(ts)" , GetTableName(DownloadLogDO.TableName));
if (trans == null)
{
using (DbConnection conn = GetConn())
{
DBTools.ExecuteNonQuery(conn, sql, cmd);
}
}
else
{
DBTools.ExecuteNonQuery(trans.Connection, trans, sql, cmd);
}
}
public void MergeFrom(PayloadConfig other)
{
if (other == null)
{
return;
}
switch (other.PayloadCase)
{
case PayloadOneofCase.BytebufParams:
if (BytebufParams == null)
{
BytebufParams = new global::Grpc.Testing.ByteBufferParams();
}
BytebufParams.MergeFrom(other.BytebufParams);
break;
case PayloadOneofCase.SimpleParams:
if (SimpleParams == null)
{
SimpleParams = new global::Grpc.Testing.SimpleProtoParams();
}
SimpleParams.MergeFrom(other.SimpleParams);
break;
case PayloadOneofCase.ComplexParams:
if (ComplexParams == null)
{
ComplexParams = new global::Grpc.Testing.ComplexProtoParams();
}
ComplexParams.MergeFrom(other.ComplexParams);
break;
}
_unknownFields = pb::UnknownFieldSet.MergeFrom(_unknownFields, other._unknownFields);
}
/// <summary>
/// 批量更新DownloadLog信息
/// </summary>
/// <param name="entities">实体集合</param>
/// <param name="trans">事物对象</param>
public void UpdateDownloadlogList(List <DownloadLogDO> entities, DbTransaction trans = null)
{
var cmd = new ComplexParams
{
new ComplexParameter
{
Key = "@model_list",
DbType = DbType.Xml,
Value = ConvertUtils.ConvertModelListToXML("e", entities)
}
};
var sql = string.Format(@"DECLARE @TBL TABLE(
[LogId] uniqueidentifier NOT NULL ,
[Message] uniqueidentifier NULL ,
[Level] int NULL ,
[SortValue] nvarchar(36) NULL ,
[Disabled] int NULL ,
[Rec_CreateBy] uniqueidentifier NULL ,
[Rec_CreateTime] datetime NULL ,
[Rec_ModifyBy] uniqueidentifier NULL ,
[Rec_ModifyTime] datetime NULL )
INSERT INTO @TBL SELECT
T.ts.value('@LogId', 'uniqueidentifier') as LogId,
CASE WHEN T.ts.value('@Message', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Message', 'uniqueidentifier') END as Message,
CASE WHEN T.ts.value('@Level', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Level', 'int') END as Level,
T.ts.value('@SortValue', 'nvarchar(36)') as SortValue,
CASE WHEN T.ts.value('@Disabled', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Disabled', 'int') END as Disabled,
CASE WHEN T.ts.value('@Rec_CreateBy', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Rec_CreateBy', 'uniqueidentifier') END as Rec_CreateBy,
CASE WHEN T.ts.value('@Rec_CreateTime', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Rec_CreateTime', 'datetime') END as Rec_CreateTime,
CASE WHEN T.ts.value('@Rec_ModifyBy', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Rec_ModifyBy', 'uniqueidentifier') END as Rec_ModifyBy,
CASE WHEN T.ts.value('@Rec_ModifyTime', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Rec_ModifyTime', 'datetime') END as Rec_ModifyTime
FROM @model_list.nodes('/es/e') T(ts);
UPDATE {0} SET
[Message] = B.Message,
[Level] = B.Level,
[SortValue] = B.SortValue,
[Disabled] = B.Disabled,
[Rec_CreateBy] = B.Rec_CreateBy,
[Rec_CreateTime] = B.Rec_CreateTime,
[Rec_ModifyBy] = B.Rec_ModifyBy,
[Rec_ModifyTime] = B.Rec_ModifyTime
FROM {0} A,@TBL B WHERE A.LogId=B.LogId " , GetTableName(DownloadLogDO.TableName));
if (trans == null)
{
using (DbConnection conn = GetConn())
{
DBTools.ExecuteNonQuery(conn, sql, cmd);
}
}
else
{
DBTools.ExecuteNonQuery(trans.Connection, trans, sql, cmd);
}
}
public override int GetHashCode()
{
int hash = 1;
if (payloadCase_ == PayloadOneofCase.BytebufParams)
{
hash ^= BytebufParams.GetHashCode();
}
if (payloadCase_ == PayloadOneofCase.SimpleParams)
{
hash ^= SimpleParams.GetHashCode();
}
if (payloadCase_ == PayloadOneofCase.ComplexParams)
{
hash ^= ComplexParams.GetHashCode();
}
return(hash);
}
/// <summary>
/// 批量新增Media信息
/// </summary>
/// <param name="entities">实体集合</param>
/// <param name="trans">事物对象</param>
public void AddMediaList(List <MediaDO> entities, DbTransaction trans = null)
{
var cmd = new ComplexParams
{
new ComplexParameter
{
Key = "@model_list",
DbType = DbType.Xml,
Value = ConvertUtils.ConvertModelListToXML("e", entities)
}
};
var sql = string.Format(@"INSERT INTO {0} SELECT
T.ts.value('@MediaID', 'uniqueidentifier') as MediaID,
T.ts.value('@MediaCode', 'nvarchar(100)') as MediaCode,
T.ts.value('@MediaName', 'nvarchar(200)') as MediaName,
CASE WHEN T.ts.value('@TagId', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@TagId', 'uniqueidentifier') END as TagId,
CASE WHEN T.ts.value('@FromInsUser', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@FromInsUser', 'uniqueidentifier') END as FromInsUser,
T.ts.value('@Url', 'varchar(1000)') as Url,
T.ts.value('@RelativeAddress', 'varchar(1000)') as RelativeAddress,
T.ts.value('@PhycialAddress', 'varchar(1000)') as PhycialAddress,
CASE WHEN T.ts.value('@Size', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Size', 'bigint') END as Size,
CASE WHEN T.ts.value('@Download_Start', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Download_Start', 'datetime') END as Download_Start,
CASE WHEN T.ts.value('@Download_End', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Download_End', 'datetime') END as Download_End,
CASE WHEN T.ts.value('@Download_Ok', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Download_Ok', 'int') END as Download_Ok,
T.ts.value('@SortValue', 'nvarchar(36)') as SortValue,
CASE WHEN T.ts.value('@Disabled', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Disabled', 'int') END as Disabled,
CASE WHEN T.ts.value('@Rec_CreateBy', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Rec_CreateBy', 'uniqueidentifier') END as Rec_CreateBy,
CASE WHEN T.ts.value('@Rec_CreateTime', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Rec_CreateTime', 'datetime') END as Rec_CreateTime,
CASE WHEN T.ts.value('@Rec_ModifyBy', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Rec_ModifyBy', 'uniqueidentifier') END as Rec_ModifyBy,
CASE WHEN T.ts.value('@Rec_ModifyTime', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Rec_ModifyTime', 'datetime') END as Rec_ModifyTime
FROM @model_list.nodes('/es/e') T(ts)" , GetTableName(MediaDO.TableName));
if (trans == null)
{
using (DbConnection conn = GetConn())
{
DBTools.ExecuteNonQuery(conn, sql, cmd);
}
}
else
{
DBTools.ExecuteNonQuery(trans.Connection, trans, sql, cmd);
}
}
public override int GetHashCode()
{
int hash = 1;
if (payloadCase_ == PayloadOneofCase.BytebufParams)
{
hash ^= BytebufParams.GetHashCode();
}
if (payloadCase_ == PayloadOneofCase.SimpleParams)
{
hash ^= SimpleParams.GetHashCode();
}
if (payloadCase_ == PayloadOneofCase.ComplexParams)
{
hash ^= ComplexParams.GetHashCode();
}
hash ^= (int)payloadCase_;
if (_unknownFields != null)
{
hash ^= _unknownFields.GetHashCode();
}
return(hash);
}
/// <summary>
/// 批量新增MediaTask信息
/// </summary>
/// <param name="entities">实体集合</param>
/// <param name="trans">事物对象</param>
public void AddMediataskList(List <MediaTaskDO> entities, DbTransaction trans = null)
{
var cmd = new ComplexParams
{
new ComplexParameter
{
Key = "@model_list",
DbType = DbType.Xml,
Value = ConvertUtils.ConvertModelListToXML("e", entities)
}
};
var sql = string.Format(@"INSERT INTO {0} SELECT
T.ts.value('@MediaTaskId', 'uniqueidentifier') as MediaTaskId,
T.ts.value('@Url', 'nvarchar(200)') as Url,
T.ts.value('@FileFullName', 'nvarchar(200)') as FileFullName,
T.ts.value('@MetaTypeList', 'nvarchar(200)') as MetaTypeList,
T.ts.value('@RegexList', 'nvarchar(200)') as RegexList,
CASE WHEN T.ts.value('@Disabled', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Disabled', 'int') END as Disabled,
CASE WHEN T.ts.value('@Rec_CreateBy', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Rec_CreateBy', 'uniqueidentifier') END as Rec_CreateBy,
CASE WHEN T.ts.value('@Rec_CreateTime', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Rec_CreateTime', 'datetime') END as Rec_CreateTime,
CASE WHEN T.ts.value('@Rec_ModifyBy', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Rec_ModifyBy', 'uniqueidentifier') END as Rec_ModifyBy,
CASE WHEN T.ts.value('@Rec_ModifyTime', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Rec_ModifyTime', 'datetime') END as Rec_ModifyTime
FROM @model_list.nodes('/es/e') T(ts)" , GetTableName(MediaTaskDO.TableName));
if (trans == null)
{
using (DbConnection conn = GetConn())
{
DBTools.ExecuteNonQuery(conn, sql, cmd);
}
}
else
{
DBTools.ExecuteNonQuery(trans.Connection, trans, sql, cmd);
}
}
/// <summary>
/// 批量更新MediaTask信息
/// </summary>
/// <param name="entities">实体集合</param>
/// <param name="trans">事物对象</param>
public void UpdateMediataskList(List <MediaTaskDO> entities, DbTransaction trans = null)
{
var cmd = new ComplexParams
{
new ComplexParameter
{
Key = "@model_list",
DbType = DbType.Xml,
Value = ConvertUtils.ConvertModelListToXML("e", entities)
}
};
var sql = string.Format(@"DECLARE @TBL TABLE(
[MediaTaskId] uniqueidentifier NOT NULL ,
[Url] nvarchar(200) NULL ,
[FileFullName] nvarchar(200) NULL ,
[MetaTypeList] nvarchar(200) NULL ,
[RegexList] nvarchar(200) NULL ,
[Disabled] int NULL ,
[Rec_CreateBy] uniqueidentifier NULL ,
[Rec_CreateTime] datetime NULL ,
[Rec_ModifyBy] uniqueidentifier NULL ,
[Rec_ModifyTime] datetime NULL )
INSERT INTO @TBL SELECT
T.ts.value('@MediaTaskId', 'uniqueidentifier') as MediaTaskId,
T.ts.value('@Url', 'nvarchar(200)') as Url,
T.ts.value('@FileFullName', 'nvarchar(200)') as FileFullName,
T.ts.value('@MetaTypeList', 'nvarchar(200)') as MetaTypeList,
T.ts.value('@RegexList', 'nvarchar(200)') as RegexList,
CASE WHEN T.ts.value('@Disabled', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Disabled', 'int') END as Disabled,
CASE WHEN T.ts.value('@Rec_CreateBy', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Rec_CreateBy', 'uniqueidentifier') END as Rec_CreateBy,
CASE WHEN T.ts.value('@Rec_CreateTime', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Rec_CreateTime', 'datetime') END as Rec_CreateTime,
CASE WHEN T.ts.value('@Rec_ModifyBy', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Rec_ModifyBy', 'uniqueidentifier') END as Rec_ModifyBy,
CASE WHEN T.ts.value('@Rec_ModifyTime', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Rec_ModifyTime', 'datetime') END as Rec_ModifyTime
FROM @model_list.nodes('/es/e') T(ts);
UPDATE {0} SET
[Url] = B.Url,
[FileFullName] = B.FileFullName,
[MetaTypeList] = B.MetaTypeList,
[RegexList] = B.RegexList,
[Disabled] = B.Disabled,
[Rec_CreateBy] = B.Rec_CreateBy,
[Rec_CreateTime] = B.Rec_CreateTime,
[Rec_ModifyBy] = B.Rec_ModifyBy,
[Rec_ModifyTime] = B.Rec_ModifyTime
FROM {0} A,@TBL B WHERE A.MediaTaskId=B.MediaTaskId " , GetTableName(MediaTaskDO.TableName));
if (trans == null)
{
using (DbConnection conn = GetConn())
{
DBTools.ExecuteNonQuery(conn, sql, cmd);
}
}
else
{
DBTools.ExecuteNonQuery(trans.Connection, trans, sql, cmd);
}
}
/// <summary>
/// 批量更新Media信息
/// </summary>
/// <param name="entities">实体集合</param>
/// <param name="trans">事物对象</param>
public void UpdateMediaList(List <MediaDO> entities, DbTransaction trans = null)
{
var cmd = new ComplexParams
{
new ComplexParameter
{
Key = "@model_list",
DbType = DbType.Xml,
Value = ConvertUtils.ConvertModelListToXML("e", entities)
}
};
var sql = string.Format(@"DECLARE @TBL TABLE(
[MediaID] uniqueidentifier NOT NULL ,
[MediaCode] nvarchar(100) NULL ,
[MediaName] nvarchar(200) NULL ,
[TagId] uniqueidentifier NULL ,
[FromInsUser] uniqueidentifier NULL ,
[Url] varchar(1000) NULL ,
[RelativeAddress] varchar(1000) NULL ,
[PhycialAddress] varchar(1000) NULL ,
[Size] bigint NULL ,
[Download_Start] datetime NULL ,
[Download_End] datetime NULL ,
[Download_Ok] int NULL ,
[SortValue] nvarchar(36) NULL ,
[Disabled] int NULL ,
[Rec_CreateBy] uniqueidentifier NULL ,
[Rec_CreateTime] datetime NULL ,
[Rec_ModifyBy] uniqueidentifier NULL ,
[Rec_ModifyTime] datetime NULL )
INSERT INTO @TBL SELECT
T.ts.value('@MediaID', 'uniqueidentifier') as MediaID,
T.ts.value('@MediaCode', 'nvarchar(100)') as MediaCode,
T.ts.value('@MediaName', 'nvarchar(200)') as MediaName,
CASE WHEN T.ts.value('@TagId', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@TagId', 'uniqueidentifier') END as TagId,
CASE WHEN T.ts.value('@FromInsUser', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@FromInsUser', 'uniqueidentifier') END as FromInsUser,
T.ts.value('@Url', 'varchar(1000)') as Url,
T.ts.value('@RelativeAddress', 'varchar(1000)') as RelativeAddress,
T.ts.value('@PhycialAddress', 'varchar(1000)') as PhycialAddress,
CASE WHEN T.ts.value('@Size', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Size', 'bigint') END as Size,
CASE WHEN T.ts.value('@Download_Start', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Download_Start', 'datetime') END as Download_Start,
CASE WHEN T.ts.value('@Download_End', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Download_End', 'datetime') END as Download_End,
CASE WHEN T.ts.value('@Download_Ok', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Download_Ok', 'int') END as Download_Ok,
T.ts.value('@SortValue', 'nvarchar(36)') as SortValue,
CASE WHEN T.ts.value('@Disabled', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Disabled', 'int') END as Disabled,
CASE WHEN T.ts.value('@Rec_CreateBy', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Rec_CreateBy', 'uniqueidentifier') END as Rec_CreateBy,
CASE WHEN T.ts.value('@Rec_CreateTime', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Rec_CreateTime', 'datetime') END as Rec_CreateTime,
CASE WHEN T.ts.value('@Rec_ModifyBy', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Rec_ModifyBy', 'uniqueidentifier') END as Rec_ModifyBy,
CASE WHEN T.ts.value('@Rec_ModifyTime', 'varchar(1)')='' THEN NULL ELSE T.ts.value('@Rec_ModifyTime', 'datetime') END as Rec_ModifyTime
FROM @model_list.nodes('/es/e') T(ts);
UPDATE {0} SET
[MediaCode] = B.MediaCode,
[MediaName] = B.MediaName,
[TagId] = B.TagId,
[FromInsUser] = B.FromInsUser,
[Url] = B.Url,
[RelativeAddress] = B.RelativeAddress,
[PhycialAddress] = B.PhycialAddress,
[Size] = B.Size,
[Download_Start] = B.Download_Start,
[Download_End] = B.Download_End,
[Download_Ok] = B.Download_Ok,
[SortValue] = B.SortValue,
[Disabled] = B.Disabled,
[Rec_CreateBy] = B.Rec_CreateBy,
[Rec_CreateTime] = B.Rec_CreateTime,
[Rec_ModifyBy] = B.Rec_ModifyBy,
[Rec_ModifyTime] = B.Rec_ModifyTime
FROM {0} A,@TBL B WHERE A.MediaID=B.MediaID " , GetTableName(MediaDO.TableName));
if (trans == null)
{
using (DbConnection conn = GetConn())
{
DBTools.ExecuteNonQuery(conn, sql, cmd);
}
}
else
{
DBTools.ExecuteNonQuery(trans.Connection, trans, sql, cmd);
}
}
