public void Handle(FanUpdated message)
{
NotifyOfPropertyChange(() => Fans);
if (SelectedFan == null)
{
SelectedFan = Fans.FirstOrDefault();
}
}
public ActionResult DeleteConfirmed(int id)
{
Fans fans = db.Fans.Find(id);
db.Fans.Remove(fans);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public object DeleteFans(Fans fans)
{
if (fans == null || string.IsNullOrEmpty(fans.userid1) ||
string.IsNullOrEmpty(fans.userid2))
{
return(new ReturnResult <Fans>(-4, "传入参数错误!"));
}
return(_UsersService.DeleteFans(fans));
}
public void TestSoundSpectrum()
{
SelectInfo si = getSelectInfo();
Fans fanList = KrugerUtil.Select(si);
Fan f = fanList.Item(1);
KrugerUtil.SoundSpectrum(f);
}
public void TestSelectDrives()
{
SelectInfo si = getSelectInfo();
Fans fanList = KrugerUtil.Select(si);
Fan f = fanList.Item(1);
KrugerUtil.SelectDrives(f);
}
public static Fans Select(SelectInfo si)
{
//JavaScriptSerializer js = new JavaScriptSerializer();
//string json = js.Serialize(si);
//log.Debug(json);
CentSelect cs = new CentSelect();
Fans fanList = cs.Select(si);
return(fanList);
}
public ActionResult Edit([Bind(Include = "ID,FirstName,LastName,Gender,BirthDate,Seniority,Admin,LoginDetails")] Fans fans)
{
if (ModelState.IsValid)
{
db.Entry(fans).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(fans));
}
public ActionResult Edit([Bind(Include = "ID,Name,Birth,Age,Gender")] Fans fans)
{
if (ModelState.IsValid)
{
db.Entry(fans).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(fans));
}
public void TestCurvePoints()
{
SelectInfo si = getSelectInfo();
Fans fanList = KrugerUtil.Select(si);
Assert.AreEqual(1, fanList.Count);
Fan f = fanList.Item(1);
KrugerUtil.CurvePoints(f, 0);
}
public ActionResult Create([Bind(Include = "ID,FirstName,LastName,Gender,BirthDate,Seniority,Admin,LoginDetails")] Fans fans)
{
if (ModelState.IsValid)
{
db.Fans.Add(fans);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(fans));
}
public ActionResult Create([Bind(Include = "ID,Name,Birth,Age,Gender")] Fans fans)
{
if (ModelState.IsValid)
{
db.Fans.Add(fans);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(fans));
}
public void TestGenerateChart()
{
SelectInfo si = getSelectInfo();
Fans fanList = KrugerUtil.Select(si);
String outputPath = @".\pic\tmp.jpg";
int width = 350;
int height = 350;
Fan f = fanList.Item(1);
KrugerUtil.GenerateChart(f, outputPath, width, height, Kruger.eChartOutput.coGIF);
}
public object AddFans(Fans fans)
{
if (fans == null || string.IsNullOrEmpty(fans.userid1) ||
string.IsNullOrEmpty(fans.userid2))
{
return(new ReturnResult <Fans>(-4, "传入参数错误!"));
}
else if (fans.userid1 == fans.userid2)
{
return(new ReturnResult <Fans>(-4, "无需关注自己!"));
}
return(_UsersService.AddFans(fans));
}
public bool SetupFanReporting(Fans fans)
{
byte type = 16;
byte[] data = new byte[1];
if ((int)fans < (int)Fans.Fan1 || (int)(Fans.Fan1 | Fans.Fan2 | Fans.Fan3 | Fans.Fan4) < (int)fans)
{
throw new ArgumentOutOfRangeException("fans", "fan value out of range");
}
data[0] = (byte)fans;
return(SendReturnBool(type, 1, data));
}
// GET: Fans/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Fans fans = db.Fans.Find(id);
if (fans == null)
{
return(HttpNotFound());
}
return(View(fans));
}
public override int GetHashCode()
{
int hash = 1;
if (Id != 0)
{
hash ^= Id.GetHashCode();
}
if (ActType != 0)
{
hash ^= ActType.GetHashCode();
}
if (Pro != 0)
{
hash ^= Pro.GetHashCode();
}
if (Power != 0)
{
hash ^= Power.GetHashCode();
}
if (DepartmentLevel != 0)
{
hash ^= DepartmentLevel.GetHashCode();
}
if (Title.Length != 0)
{
hash ^= Title.GetHashCode();
}
if (NeedTime != 0)
{
hash ^= NeedTime.GetHashCode();
}
hash ^= Fans.GetHashCode();
hash ^= Consume.GetHashCode();
hash ^= awards_.GetHashCode();
if (RandomeFansNum != 0)
{
hash ^= RandomeFansNum.GetHashCode();
}
if (Order != 0)
{
hash ^= Order.GetHashCode();
}
if (MovieId != 0)
{
hash ^= MovieId.GetHashCode();
}
return(hash);
}
public FanControllerConfig AddNewFanController()
{
var controller = new FanController
{
Id = (Config.Max(c => int.Parse(c.Controller.Id)) + 1).ToString(),
Fan = Fans.First()
};
var config = new FanControllerConfig
{
Controller = controller,
};
Config.Add(config);
return(config);
}
/// <summary>
/// Creates a clone of this instance
/// </summary>
/// <returns>A clone of this instance</returns>
public object Clone()
{
return(new Tool
{
Number = Number,
Active = (float[])Active.Clone(),
Standby = (float[])Standby.Clone(),
Name = (Name != null) ? string.Copy(Name) : null,
Filament = (Filament != null) ? string.Copy(Filament) : null,
Fans = (int[])Fans.Clone(),
Heaters = (int[])Heaters.Clone(),
Mix = (float[])Mix.Clone(),
Spindle = Spindle,
Axes = Axes.Select(subAxes => (int[])subAxes.Clone()).ToList(),
Offsets = (float[])Offsets.Clone()
});
}
public ResponseItem MessageByIDs(WechatModel value)
{
var plt = User_Platforms_Wechat();
var f = new Fans(plt.Access_token);
String errMsg = String.Empty;
int errcode = 0;
foreach (var v in value.IDs)
{
JObject code = null;
if (value.Type.Equals("image"))
{
code = f.SendByImage(v, value.MaterialID);
}
if (value.Type.Equals("news"))
{
foreach (var vv in value.News)
{
if (string.IsNullOrEmpty(vv.url))
{
//根域名
vv.url = request.Url.Authority;
}
}
code = f.SendByNews(v, value.News);
}
else
{
code = f.SendMsg(v, value.Message);
}
if (code.Value <int>("errcode") != 0)
{
errcode = code.Value <int>("errcode");
errMsg += code.Value <String>("errmsg") + "，";
}
}
return(new ResponseItem(errcode, errMsg));
}
public List <FanModel> Select([FromBody] SelectInfoModel model)
{
SelectInfo si = new SelectInfo();
String path = String.Format("{0}\\{1}", System.AppDomain.CurrentDomain.BaseDirectory, "test\\Records\\");
si.RecordDirectory = path;
si.Volume = model.Volume;
si.Pressure = model.Pressure;
si.VolumeUnit = (VolumeUnit)model.VolumeUnit;
si.PressureUnit = (PressureUnit)model.PressureUnit;
si.PressureType = (PressureType)model.PressureType;
si.CallType = model.CallType;
si.Debug = model.Debug;
si.Hz = model.Hz;
si.Temperature = model.Temperature;
si.Altitude = model.Altitude;
si.ProductType = (Product)model.ProductType;
si.MinStyle = model.MinStyle;
si.MinClass = (FanClass)model.MinClass;
si.SoundCondition = (SoundCondition)model.SoundCondition;
si.FanCasing = (FanCasing)model.FanCasing;
si.FanWidth = model.FanWidth;
si.VelocityUnit = (VelocityUnit)model.VelocityUnit;
si.OutletType = (OutletType)model.OutletType;
si.ServiceFactor = model.ServiceFactor;
si.AltitudeUnit = (AltitudeUnit)model.AltitudeUnit;
si.SoundDistance = model.SoundDistance;
si.SoundDistanceUnit = (DistanceUnit)model.SoundDistanceUnit;
si.TemperatureUnit = (TemperatureUnit)model.TemperatureUnit;
log.Debug(si);
Fans fanList = KrugerUtil.Select(si);
List <FanModel> modelList = new List <FanModel>();
for (int i = 1; i < fanList.Count; i++)
{
Fan f = fanList.Item(i);
FanModel fModel = createFanModel(f);
modelList.Add(fModel);
}
return(modelList);
}
//追蹤他 資料表新增粉絲
public IHttpActionResult Post(string memid, string FoMemID)
{
FollowUp folw = new FollowUp();
folw.memId = FoMemID;
folw.FoMemId = memid;
Fans fan = new Fans();
fan.memId = FoMemID;
fan.fanMemId = memid;
db.FollowUp.Add(folw);
db.SaveChanges();
db.Fans.Add(fan);
db.SaveChanges();
return(Ok());
}
public Computer build()
{
Computer pc = new Computer();
ComputerCase pc_case = new ComputerCase("NZXT");
HDD hard_drive = new HDD("1TB");
Fans silent_fan = new Fans(1000);
CPU cpu = new CPU("Intel Pentium");
GPU graphics_card = new GPU("GT1030");
pc.component.Add(pc_case);
pc.component.Add(hard_drive);
pc.component.Add(silent_fan);
pc.component.Add(cpu);
pc.component.Add(graphics_card);
return(pc);
}
public void Save()
{
var content = File.ReadAllText(path);
var stripped = replacers
.CreateResult(content, (regex, result) => regex.Replace(result, string.Empty))
.Trim(Environment.NewLine.ToCharArray());
var fans = string.Join(Environment.NewLine, Fans.Select(f => $@"xxx Pwm {f.Id}
name={f.Name}
active={f.Active.ToString().ToLower()}
min={f.Min}
max={f.Max}
variate={f.Variate.ToString().ToLower()}
logged={f.Logged.ToString().ToLower()}
xxx end
"));
var controllers = string.Join(Environment.NewLine, Config.Select(fc => fc.Controller).Select(c => $@"xxx FanController {c.Id}
name={c.Name}
pwm={c.Fan.Id}
method={(int)c.Method}
enabled={c.Active.ToString().ToLower()}
xxx end
"));
var temps = string.Join(Environment.NewLine, Config.SelectMany(fc => fc.Curves.SelectMany(c => c.Temps.Select(t => $@"xxx FanControllerTemp from FanController {fc.Controller.Id}
temp={t.Temp.Id}
MinTemp={t.MinTemp}
MaxTemp={t.MaxTemp}
hysteresis={t.Hysteresis}
ControlPoints={c.Curve.RenderOutput()}
xxx end
")))
.ToList());
File.WriteAllText(path, $@"{stripped}
{fans}
{controllers}
{temps}");
}
public ActionResult RegisterFan(RegisterFanViewModel model)
{
if (ModelState.IsValid)
{
var sha256 = Crypto.SHA256(model.Password);
string ipAddress = Request.UserHostAddress;
var user = new Fans()
{
Password = sha256, Name = model.Name, IpAddress = ipAddress, Email = model.Email
};
bool notValid = false;
if (accountManager.IsDuplicateEmail(model.Email, true))
{
notValid = true;
ModelState.AddModelError("", "Użytkownik z podanym adresem e-mail istnieje");
}
if (accountManager.IsDuplicateName(model.Name, false, true))
{
notValid = true;
ModelState.AddModelError("", "Użytkownik o podanej nazwie istnieje");
}
if (accountManager.IsDuplicateIp(ipAddress))
{
notValid = true;
ModelState.AddModelError("", "Posiadasz już konto kibica");
}
if (!notValid)
{
accountManager.AddUser(user);
accountManager.SetLoginState(true);
accountManager.Authentication(user);
return(RedirectToAction("Index", "Home"));
}
}
return(View(model));
}
/// <summary>
/// Creates a duplicate of the full object model
/// </summary>
/// <returns>A clone of this model</returns>
public object Clone()
{
return(new MachineModel
{
Channels = (Channels)Channels.Clone(),
Electronics = (Electronics)Electronics.Clone(),
Fans = Fans.Select(fan => (Fan)fan.Clone()).ToList(),
Heat = (Heat)Heat.Clone(),
Job = (Job)Job.Clone(),
MessageBox = (MessageBox)MessageBox.Clone(),
Move = (Move)Move.Clone(),
Network = (Network)Network.Clone(),
Messages = Messages.Select(item => (Message)item.Clone()).ToList(),
Scanner = (Scanner)Scanner.Clone(),
Sensors = (Sensors)Sensors.Clone(),
Spindles = Spindles.Select(spindle => (Spindle)spindle.Clone()).ToList(),
State = (State)State.Clone(),
Storages = Storages.Select(storage => (Storage)storage.Clone()).ToList(),
Tools = Tools.Select(tool => (Tool)tool.Clone()).ToList()
});
}
/// <summary>
/// 关注用户
/// </summary>
/// <param name="userId">关注者ID</param>
/// <param name="focusUserId">被关注者ID</param>
/// <returns></returns>
public async Task FocusUser(Guid userId, Guid focusUserId)
{
int userFansCount;
int userFocusCount;
int focusUserFansCount;
int focusUserFocusCount;
using (IFanService fanSvc = new FanService())
{
Fans fans = new Fans
{
UserId = userId,
FocusUserId = focusUserId
};
await fanSvc.CreatAsync(fans);
userFocusCount = await fanSvc.GetAll().Where(m => m.UserId == userId).CountAsync(); //用户关注数量
focusUserFocusCount = await fanSvc.GetAll().Where(m => m.UserId == focusUserId).CountAsync(); //被关注者关注数量
userFansCount = await fanSvc.GetAll().Where(m => m.FocusUserId == userId).CountAsync(); //用户粉丝数量
focusUserFansCount = await fanSvc.GetAll().Where(m => m.FocusUserId == focusUserId).CountAsync(); //被关注者粉丝数量
}
using (IUserService userSve = new UserService())
{
User user = await userSve.GetOneByIdAsync(userId);
user.FansCount = userFansCount;
user.FocusCount = userFocusCount;
await userSve.EditAsync(user);
User focusUser = await userSve.GetOneByIdAsync(focusUserId);
focusUser.FansCount = focusUserFansCount;
focusUser.FocusCount = focusUserFocusCount;
await userSve.EditAsync(focusUser);
}
}
private Level(BinaryReader reader) : this()
{
ID = reader.ReadInt32();
var nameLength = reader.ReadInt32();
Name = Encoding.UTF8.GetString(reader.ReadBytes(nameLength));
SPlusTime = reader.ReadUInt16();
STime = reader.ReadUInt16();
ATime = reader.ReadUInt16();
BTime = reader.ReadUInt16();
CTime = reader.ReadUInt16();
CheckTime();
var prismsCount = reader.ReadInt16();
Size = new Size3D(reader);
#region Boring verifying
var temp = reader.ReadUInt16();
if (Temp1 != temp)
{
Warning.WriteLine(string.Format(Localization.LevelInvalidArgument, temp, Temp1, "unknown_ushort_1"));
}
temp = reader.ReadUInt16();
if (Temp2 != temp)
{
Warning.WriteLine(string.Format(Localization.LevelInvalidArgument, temp, Temp2, "unknown_ushort_2"));
}
ushort width = reader.ReadUInt16(), length = reader.ReadUInt16();
var legacyMinimapValid = true;
if (LegacyMinimapSize.Width != width)
{
Warning.WriteLine(string.Format(Localization.LevelInvalidArgument, width, LegacyMinimapSize.Width,
"unknown_ushort_3"));
legacyMinimapValid = false;
}
if (LegacyMinimapSize.Length != length)
{
Warning.WriteLine(string.Format(Localization.LevelInvalidArgument, width, LegacyMinimapSize.Length,
"unknown_ushort_4"));
legacyMinimapValid = false;
}
if (!legacyMinimapValid)
{
Warning.WriteLine(Localization.LevelLegacyMinimapMalformed);
}
var tempByte = reader.ReadByte();
if (tempByte != 10)
{
Warning.WriteLine(string.Format(Localization.LevelInvalidArgument, temp, 10, "unknown_byte_1"));
}
temp = reader.ReadUInt16();
if (Size.Length - 1 != temp)
{
Warning.WriteLine(string.Format
(Localization.LevelInvalidArgument, temp, Size.Length - 1, "unknown_ushort_5"));
}
temp = reader.ReadUInt16();
if (0 != temp)
{
Warning.WriteLine(string.Format(Localization.LevelInvalidArgument, temp, 0, "unknown_ushort_6"));
}
#endregion
if (legacyMinimapValid)
{
LegacyMinimap = new Flat(reader, LegacyMinimapSize);
}
else
{
LegacyMinimap = new Flat(LegacyMinimapSize);
reader.ReadBytes((width * length + 7) / 8);
}
CollisionMap = new Cube(reader, Size);
SpawnPoint = new Point3D16(reader);
Zoom = reader.ReadInt16();
if (Zoom < 0)
{
Value = reader.ReadInt16();
ValueIsAngle = reader.ReadBoolean();
}
ExitPoint = new Point3D16(reader);
var count = reader.ReadUInt16();
for (var i = 0; i < count; i++)
{
MovingPlatforms.Add(new MovingPlatform(MovingPlatforms, reader));
}
count = reader.ReadUInt16();
for (var i = 0; i < count; i++)
{
Bumpers.Add(new Bumper(Bumpers, reader));
}
count = reader.ReadUInt16();
for (var i = 0; i < count; i++)
{
FallingPlatforms.Add(new FallingPlatform(this, reader));
}
count = reader.ReadUInt16();
for (var i = 0; i < count; i++)
{
Checkpoints.Add(new Checkpoint(reader));
}
count = reader.ReadUInt16();
for (var i = 0; i < count; i++)
{
CameraTriggers.Add(new CameraTrigger(reader));
}
count = reader.ReadUInt16();
for (var i = 0; i < count; i++)
{
Prisms.Add(new Prism(reader));
}
if (count != prismsCount)
{
Warning.WriteLine(string.Format
(Localization.LevelInvalidArgument, prismsCount, count, "prisms_count"));
}
if ((count = reader.ReadUInt16()) > 0)
{
Warning.WriteLine(string.Format(Localization.DeprecatedElement, "Fan"));
}
for (var i = 0; i < count; i++)
{
Fans.Add(new Fan(reader));
}
Buttons = new Buttons(this, reader);
count = reader.ReadUInt16();
for (var i = 0; i < count; i++)
{
OtherCubes.Add(new OtherCube(this, reader));
}
count = reader.ReadUInt16();
for (var i = 0; i < count; i++)
{
Resizers.Add(new Resizer(this, reader));
}
if ((count = reader.ReadUInt16()) > 0)
{
Warning.WriteLine(string.Format(Localization.DeprecatedElement, "MiniBlock"));
}
for (var i = 0; i < count; i++)
{
MiniBlocks.Add(new MiniBlock(reader));
}
ModelTheme = Theme = reader.ReadByte();
MusicJava = reader.ReadByte();
Music = reader.ReadByte();
foreach (var button in Buttons)
{
if (button.IsMoving)
{
button.MovingPlatformID.Name.DoNothing();
}
foreach (var e in button.Events)
{
Buttons.BlockEvents[e].ID.Name.DoNothing();
}
}
foreach (var cube in OtherCubes)
{
cube.MovingBlockSync.Name.DoNothing();
cube.DarkCubeMovingBlockSync?.Name.DoNothing();
}
}
private Level(string path) : this()
{
var element = XHelper.Load(path + ".xml").GetElement("Level");
ID = element.GetAttributeValue <int>("ID");
Name = element.GetAttributeValueWithDefault("Name", string.Empty);
var thresholds = element.GetAttributeValueWithDefault("TimeThresholds", "1,2,3,4,5").Split(',')
.Select(str => ushort.Parse(str.Trim())).ToArray();
SPlusTime = thresholds[0];
STime = thresholds[1];
ATime = thresholds[2];
BTime = thresholds[3];
CTime = thresholds[4];
CheckTime();
Size = element.GetAttributeValue <Size3D>("Size");
LegacyMinimap = new Flat(path + ".png", LegacyMinimapSize);
CollisionMap = new Cube(path + ".{0}.png", Size);
SpawnPoint = element.GetAttributeValue <Point3D16>("SpawnPoint");
ExitPoint = element.GetAttributeValue <Point3D16>("ExitPoint");
Theme = element.GetAttributeValueWithDefault <byte>("Theme");
ModelTheme = element.GetAttributeValueWithDefault("ModelTheme", Theme);
MusicJava = element.GetAttributeValueWithDefault <byte>("MusicJava");
Music = element.GetAttributeValueWithDefault("Music", (byte)6);
Zoom = element.GetAttributeValueWithDefault("Zoom", (short)-1);
var advanced = true;
if (ValueIsAngle = element.AttributeCaseInsensitive("Angle") != null)
{
Value = element.GetAttributeValueWithDefault <short>("Angle", 22);
if (element.AttributeCaseInsensitive("FieldOfView") != null)
{
Warning.WriteLine(string.Format(Localization.FieldOfViewIgnored, "Level"));
}
}
else if (element.AttributeCaseInsensitive("FieldOfView") != null)
{
Value = element.GetAttributeValueWithDefault <short>("FieldOfView", 22);
}
else if (Zoom < 0)
{
Value = 22;
}
else
{
advanced = false;
}
if (Zoom >= 0 && advanced)
{
Warning.WriteLine(string.Format(Localization.AdvancedCameraModeDisabled,
"Level", "@Angle, @FieldOfView"));
}
Buttons = new Buttons(this);
foreach (var e in element.Elements())
{
switch (e.Name.LocalName.ToLower())
{
case "movingplatform":
MovingPlatforms.Add(new MovingPlatform(MovingPlatforms, e));
break;
case "bumper":
Bumpers.Add(new Bumper(Bumpers, e));
break;
case "fallingplatform":
FallingPlatforms.Add(new FallingPlatform(this, e));
break;
case "checkpoint":
Checkpoints.Add(new Checkpoint(e));
break;
case "cameratrigger":
CameraTriggers.Add(new CameraTrigger(e));
break;
case "prism":
Prisms.Add(new Prism(e));
break;
case "fan":
Fans.Add(new Fan(e));
Warning.WriteLine(string.Format(Localization.DeprecatedElement, "Fan"));
break;
case "button":
case "buttonsequence":
// ReSharper disable once ObjectCreationAsStatement
new Button(Buttons, e);
break;
case "othercube":
case "darkcube":
OtherCubes.Add(new OtherCube(this, e));
break;
case "resizergrow":
case "resizershrink":
Resizers.Add(new Resizer(this, e));
break;
case "miniblock":
MiniBlocks.Add(new MiniBlock(e));
Warning.WriteLine(string.Format(Localization.DeprecatedElement, "MiniBlock"));
break;
default:
Warning.WriteLine(string.Format(Localization.UnrecognizedChildElement, e.Name, "Level"));
break;
}
}
}
public bool Equals(EncourageActRulePB other)
{
if (ReferenceEquals(other, null))
{
return(false);
}
if (ReferenceEquals(other, this))
{
return(true);
}
if (Id != other.Id)
{
return(false);
}
if (ActType != other.ActType)
{
return(false);
}
if (Pro != other.Pro)
{
return(false);
}
if (Power != other.Power)
{
return(false);
}
if (DepartmentLevel != other.DepartmentLevel)
{
return(false);
}
if (Title != other.Title)
{
return(false);
}
if (NeedTime != other.NeedTime)
{
return(false);
}
if (!Fans.Equals(other.Fans))
{
return(false);
}
if (!Consume.Equals(other.Consume))
{
return(false);
}
if (!awards_.Equals(other.awards_))
{
return(false);
}
if (RandomeFansNum != other.RandomeFansNum)
{
return(false);
}
if (Order != other.Order)
{
return(false);
}
if (MovieId != other.MovieId)
{
return(false);
}
return(true);
}
public void ReceiveCompleted(String body)
{
if (String.IsNullOrEmpty(body))
{
return;
}
var UserID = long.Parse(body);
var plt = DB.yy_Platforms.Where(x => x.UserID == UserID && x.Code == 11).FirstOrDefault();
if (plt == null)
{
return;
}
freshToken(plt);
var f = new Fans(plt.Access_token);
#region TB
var TB = new DataTable()
{
TableName = "yy_Fans_Wechat"
};
TB.Columns.Add("ID", typeof(long));
TB.Columns.Add("UserID", typeof(long));
TB.Columns.Add("openid", typeof(string));
TB.Columns.Add("nickname", typeof(string));
TB.Columns.Add("language", typeof(string));
TB.Columns.Add("sex", typeof(long));
TB.Columns.Add("province", typeof(string));
TB.Columns.Add("city", typeof(string));
TB.Columns.Add("country", typeof(string));
TB.Columns.Add("headimgurl", typeof(string));
TB.Columns.Add("Latitude", typeof(string));
TB.Columns.Add("Longitude", typeof(string));
TB.Columns.Add("Precision", typeof(string));
TB.Columns.Add("remark", typeof(string));
TB.Columns.Add("unionid", typeof(string));
TB.Columns.Add("LOCATIONUpdateTime", typeof(DateTime));
TB.Columns.Add("CreateDate", typeof(DateTime));
#endregion
var next_openid = String.Empty;
while (true)
{
var fs = f.Batch_Get(next_openid);
if (fs.count < 1)
{
break;
}
foreach (var v in fs.data.openid)
{
var HasOpenID = SqlHelper.ExecuteScalar(DB.Database.Connection.ConnectionString, CommandType.Text, "SELECT ID FROM yy_Fans_Wechat WITH(NOLOCK) WHERE UserID = " + UserID + " AND openid='" + v + "'");
if (HasOpenID != null)
{
continue;
}
var d = f.Detail(v);
TB.Rows.Add(
null,
UserID,
d.openid,
d.nickname,
d.language,
d.sex,
d.province,
d.city,
d.country,
d.headimgurl,
d.language,
"",
"",
"",
"",
DateTime.Now,
DateTime.Now);
}
next_openid = fs.next_openid;
if (String.IsNullOrEmpty(next_openid))
{
break;
}
Thread.Sleep(1);
}
if (TB.Rows.Count > 0)
{
SqlHelper.TableValuedToDB(DB.Database.Connection.ConnectionString, TB);
}
}
