/// <summary>
/// 批量插入数据
/// </summary>
/// <param name="modelList"></param>
/// <returns></returns>
public bool Insert(List <AntSdkContact_Depart> modelList)
{
#region 采用拼接方式
var sbSql = new StringBuilder();
sbSql.Append(
"INSERT OR REPLACE INTO C_DEPARTMENT(departName,departmentId,parentDepartId) values");
foreach (var list in modelList)
{
sbSql.Append("('" + list.departName + "','" + list.departmentId + "','" + list.parentDepartId + "'),");
}
var str = sbSql.ToString().Substring(0, sbSql.ToString().Length - 1);
return(AntSdkSqliteHelper.InsertBigData(str, AntSdkService.AntSdkConfigInfo.AntSdkCompanyCode,
AntSdkService.AntSdkCurrentUserInfo.userId));
#endregion
//var sqlList = new ArrayList();
//foreach (var sqlStr in modelList.Select(GetInsertSqlStr).Where(sqlStr => !string.IsNullOrEmpty(sqlStr)))
//{
// sqlList.Add(sqlStr);
//}
//if (sqlList.Count > 0)
//{
// return AntSdkSqliteHelper.ExecuteCommand(sqlList,
// $@"{AntSdkService.AntSdkConfigInfo.AntSdkDatabaseAddress}localData\{AntSdkService.AntSdkConfigInfo.AntSdkCompanyCode}\{AntSdkService.AntSdkLoginOutput.userId}\{AntSdkService.AntSdkLoginOutput.userId}.db");
//}
//return false;
}
/// <summary>
/// 批量插入数据
/// </summary>
/// <param name="modelList"></param>
/// <returns></returns>
public bool Insert(List <AntSdkGroupInfo> modelList)
{
#region 采用拼接方式
var sbSql = new StringBuilder();
sbSql.Append(
"INSERT OR REPLACE INTO C_GROUP(groupId,groupName,groupPicture,COMPANY_CODE,groupOwnerId) values");
foreach (var list in modelList)
{
sbSql.Append("('" + list.groupId + "','" + list.groupName + "','" + list.groupPicture + "','" + AntSdkService.AntSdkLoginOutput.companyCode + "','" + list.groupOwnerId + "'),");
}
var str = sbSql.ToString().Substring(0, sbSql.ToString().Length - 1);
return(AntSdkSqliteHelper.InsertBigData(str, AntSdkService.AntSdkConfigInfo.AntSdkCompanyCode,
AntSdkService.AntSdkCurrentUserInfo.userId));
#endregion
}
/// <summary>
/// 批量上传
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
public bool InsertBig(List <SDK.AntSdk.AntModels.AntSdkChatMsg.ChatBase> list)
{
StringBuilder sb = new StringBuilder();
sb.Append("insert into T_Chat_Message_Group(MTP,CHATINDEX,CONTENT,MESSAGEID,SENDTIME,SENDUSERID,SESSIONID,TARGETID,SENDORRECEIVE,SENDSUCESSORFAIL,uploadordownpath) values ");
foreach (var model in list)
{
if (model.sourceContent != null)
{
model.sourceContent = model.sourceContent.Replace("'", "''");
}
sb.Append("('" + (int)model.MsgType + "','" + model.chatIndex + "','" + model.sourceContent + "','" + model.messageId + "','" + AntSdkDataConverter.ConvertDateTimeToIntLong(DateTime.Now) + "','" + model.sendUserId + "','" + model.sessionId + "','" + model.targetId + "','" + model.SENDORRECEIVE + "','" + model.sendsucessorfail + "','" + model.uploadOrDownPath + "'),");
}
var str = sb.ToString().Substring(0, sb.ToString().Length - 1);
bool b = AntSdkSqliteHelper.InsertBigData(str, AntSdkService.AntSdkConfigInfo.AntSdkCompanyCode, AntSdkService.AntSdkCurrentUserInfo.userId);
return(b);
}
