/// <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); }