public bool BulkInsertLog(LogModel log) { try { string conn = @"Data Source=.\localdb;Initial Catalog=workDB;UID=sa;PWD=123456;"; SqlConnection sqlcon = new SqlConnection(conn); Stopwatch stopWatch = new Stopwatch(); stopWatch.Start(); DataTable table = this.CreateDataTable(); this.AddModelToDataTable(table, log); sqlcon.Open(); using (SqlBulkCopy bulk = new SqlBulkCopy(conn)) { bulk.BatchSize = this.logModelList.Count; bulk.DestinationTableName = "CallInterfaceLog"; bulk.ColumnMappings.Add("ID", "ID"); bulk.ColumnMappings.Add("SoufunId", "SoufunId"); bulk.ColumnMappings.Add("OrderId", "OrderId"); bulk.ColumnMappings.Add("InterfaceName", "InterfaceName"); bulk.ColumnMappings.Add("ResponseStartTime", "ResponseStartTime"); bulk.ColumnMappings.Add("ResponseEndTime", "ResponseEndTime"); bulk.ColumnMappings.Add("Imei", "Imei"); bulk.ColumnMappings.Add("Appv", "Appv"); bulk.ColumnMappings.Add("AppType", "AppType"); bulk.ColumnMappings.Add("CreateTime", "CreateTime"); bulk.ColumnMappings.Add("InterfaceUrl", "InterfaceUrl"); bulk.ColumnMappings.Add("ParamsStr", "ParamsStr"); bulk.ColumnMappings.Add("IsDel", "IsDel"); bulk.ColumnMappings.Add("Status", "Status"); bulk.WriteToServer(table); } stopWatch.Stop(); TimeSpan ts = stopWatch.Elapsed; string elapsedTime = String.Format("{0:00}:{1:00}:{2:00}:{3:000}", ts.Hours, ts.Minutes, ts.Seconds, ts.Milliseconds); Console.WriteLine("RunTime " + elapsedTime); // table.Dispose(); sqlcon.Close(); sqlcon.Dispose(); } catch (Exception ex) { Console.WriteLine(ex.Message); } return true; }
public StringTest() { string str = "13851870675"; //Console.WriteLine(str.IsNullOrEmpty()); //Console.WriteLine(str.MaskPhoneNo()); //Console.WriteLine(str.Encrypt()); //Console.WriteLine(str.CreateSQLInsertNewEntity<BaseModel>()); //Console.WriteLine(str.CreateSQLUpdateById<BaseModel>()); object columnParam = new { Id=1,Name="名称",Age=10,Phone="13121135599"}; object conditionParam = new { Id = 1, Phone =11111}; Console.WriteLine(str.CreateSQLUpdateByProperties<BaseModel>(columnParam, conditionParam)); string s = "Hello World!"; this.RefStr(ref s); Console.WriteLine(s); this.OutStr(out s); Console.WriteLine(s); ToUTF8("EOP电商"); string score = "+5"; int ss = int.Parse(score); score = "-5"; ss = int.Parse(score); DateTime dd = DateTime.Parse("1900/1/1"); Console.WriteLine((decimal)ss); Console.WriteLine(dd.ToString("yyyy-MM-dd HH:mm")); byte[] a = new byte[2]; a[0] = 0x01; a[1] = 0x00; Type t = a.GetType(); LogModel log = new LogModel() { interfaceName =null }; Console.WriteLine(string.IsNullOrEmpty(log.interfaceUrl)); }
private LogModel ParseParamListToLogModel(Dictionary<string, string> paramDict) { LogModel logModel = new LogModel(); if (paramDict.ContainsKey("method")) { // 参数中Method logModel.interfaceUrl = paramDict["method"]; // 参数中Method(同interfaceUrl) logModel.interfaceName = paramDict["method"]; } if (paramDict.ContainsKey("RequestParamStr")) { // 请求参数get参数或post参数 logModel.paramsStr = paramDict["RequestParamStr"]; } if (paramDict.ContainsKey("timestamp")) { // 请求参数中timestamp logModel.createTime = paramDict["timestamp"]; } if (paramDict.ContainsKey("imei")) { // 参数中的imei logModel.imei = paramDict["imei"]; } if (paramDict.ContainsKey("appv")) { // 参数中的appv logModel.appv = paramDict["appv"]; } if (paramDict.ContainsKey("RequestSoufunId")) { // 参数中的appv logModel.appv = paramDict["RequestSoufunId"]; } return logModel; }
private void AddModelToDataTable(DataTable table, LogModel model) { DataRow row = table.NewRow(); //自增列 //row["ID"] = logModel; row["SoufunId"] = string.IsNullOrEmpty(model.soufunId) ? 0L : long.Parse(model.soufunId); //未知字段 //row["OrderId"] = logModel; row["InterfaceName"] = model.interfaceName; row["ResponseStartTime"] = DateTime.Now; row["ResponseEndTime"] = DateTime.Now; row["Imei"] = model.imei; row["Appv"] = model.appv; row["AppType"] = 1; row["CreateTime"] = string.IsNullOrEmpty(model.createTime) ? DateTime.Parse("1900/01/01") : DateTime.Parse(model.createTime.Replace("%2f", "/").Replace("%3a", ":").Replace("+", " ")); row["InterfaceUrl"] = model.interfaceUrl; row["ParamsStr"] = model.paramsStr; row["IsDel"] = 0; row["Status"] = 3; table.Rows.Add(row); }