private List <SuperDog> QuerySuperDog(string sql)
{
if (!Open())
{
return(null);
}
var superDogList = new List <SuperDog>();
try
{
var reader = ExecuteReader(sql);
if (reader.HasRows)
{
while (reader.Read())
{
var superDog = new SuperDog
{
Id = !reader.IsDBNull(0) ? reader.GetInt32(0) : 0,
SuperDogGuid = !reader.IsDBNull(1) ? reader.GetString(1) : "",
SuperDogType = !reader.IsDBNull(2) ? reader.GetInt32(2) : 0,
MachineCode = !reader.IsDBNull(3) ? reader.GetString(3) : "",
CreateDate = !reader.IsDBNull(4) ? reader.GetString(4) : "",
UpdateDate = !reader.IsDBNull(5) ? reader.GetString(5) : "",
ExpireDate = !reader.IsDBNull(6) ? reader.GetString(6) : "",
ManufacturerId = !reader.IsDBNull(7) ? reader.GetInt32(7) : 0,
User = !reader.IsDBNull(8) ? reader.GetString(8) : "",
Remark = !reader.IsDBNull(9) ? reader.GetString(9) : ""
};
superDogList.Add(superDog);
}
}
return(superDogList);
}
catch
{
return(null);
}
finally
{
Close();
}
}
public SuperDog AddSuperDog(SuperDog superDog)
{
try
{
var parameters = new SQLiteParameter[3];
const string sql = @"INSERT INTO SuperDog(SuperDogGuid,CreateDate,UpdateDate) VALUES(@SuperDogGuid,@CreateDate,@UpdateDate)";
var parameter = new SQLiteParameter
{
DbType = DbType.String,
ParameterName = "@SuperDogGuid",
Value = superDog.SuperDogGuid
};
parameters[0] = parameter;
parameter = new SQLiteParameter
{
DbType = DbType.String,
ParameterName = "@CreateDate",
Value = superDog.CreateDate
};
parameters[1] = parameter;
parameter = new SQLiteParameter
{
DbType = DbType.String,
ParameterName = "@UpdateDate",
Value = superDog.UpdateDate
};
parameters[2] = parameter;
if (ExecuteNonQurey(sql, parameters) > 0)
{
var superDogList = QuerySuperDog("SELECT * FROM SuperDog WHERE Id = (SELECT MAX(id) FROM SuperDog)");
return(superDogList != null && superDogList.Count > 0 ? superDogList[0] : null);
}
return(null);
}
catch
{
return(null);
}
}
public SuperDog ModifySuperDog(SuperDog superDog)
{
try
{
var parameters = new SQLiteParameter[8];
const string sql = @"UPDATE SuperDog SET SuperDogType = @SuperDogType,
MachineCode = @MachineCode,
UpdateDate = @UpdateDate,
ExpireDate = @ExpireDate,
ManufacturerId = @ManufacturerId,
User = @User,
Remark = @Remark
WHERE SuperDogGuid = @SuperDogGuid";
var parameter = new SQLiteParameter
{
DbType = DbType.Int32,
ParameterName = "@SuperDogType",
Value = superDog.SuperDogType
};
parameters[0] = parameter;
parameter = new SQLiteParameter
{
DbType = DbType.String,
ParameterName = "@MachineCode",
Value = superDog.MachineCode
};
parameters[1] = parameter;
parameter = new SQLiteParameter
{
DbType = DbType.String,
ParameterName = "@UpdateDate",
Value = superDog.UpdateDate
};
parameters[2] = parameter;
parameter = new SQLiteParameter
{
DbType = DbType.String,
ParameterName = "@ExpireDate",
Value = superDog.ExpireDate
};
parameters[3] = parameter;
parameter = new SQLiteParameter
{
DbType = DbType.Int32,
ParameterName = "@ManufacturerId",
Value = superDog.ManufacturerId
};
parameters[4] = parameter;
parameter = new SQLiteParameter
{
DbType = DbType.String,
ParameterName = "@User",
Value = superDog.User
};
parameters[5] = parameter;
parameter = new SQLiteParameter
{
DbType = DbType.String,
ParameterName = "@Remark",
Value = superDog.Remark
};
parameters[6] = parameter;
parameter = new SQLiteParameter
{
DbType = DbType.String,
ParameterName = "@SuperDogGuid",
Value = superDog.SuperDogGuid
};
parameters[7] = parameter;
if (ExecuteNonQurey(sql, parameters) > 0)
{
return(GetSuperDog(superDog.SuperDogGuid));
}
return(null);
}
catch
{
return(null);
}
}
private void SuperDogFormat()
{
var message = _licenseHandler.CheckMaster();
if (!string.IsNullOrEmpty(message))
{
MessageBox.Show(message);
return;
}
message = _licenseHandler.Check();
if (!string.IsNullOrEmpty(message))
{
MessageBox.Show(message);
return;
}
if (MessageBox.Show("确定将超级狗恢复出厂状态导入初始许可？", "", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
ClearViewModel();
var oldSuperDogGuid = _licenseHandler.GetSuperDogGuid();
if (!string.IsNullOrEmpty(oldSuperDogGuid))
{
_superDogDb.RemoveSuperDog(oldSuperDogGuid);
}
if (_licenseHandler.Format(out message))
{
string newSuperDogGuid;
do
{
newSuperDogGuid = Guid.NewGuid().ToString().Replace("-", "");
Thread.Sleep(200);
} while (_superDogDb.GetSuperDog(newSuperDogGuid) != null);
if (_licenseHandler.SetSuperDogGuid(newSuperDogGuid))
{
_keyWriterViewModel.SuperDogGuid = newSuperDogGuid;
var superDogDate = _licenseHandler.GetSuperDogDate();
var superDog = new SuperDog
{
SuperDogGuid = newSuperDogGuid,
CreateDate = superDogDate.ToString("yyyy-MM-dd"),
UpdateDate = superDogDate.ToString("yyyy-MM-dd")
};
superDog = _superDogDb.AddSuperDog(superDog);
_keyWriterViewModel.CreateDate = superDog.CreateDate;
_keyWriterViewModel.UpdateDate = superDog.UpdateDate;
}
else
{
message = "超级狗唯一标识写入失败，格式化未完成";
}
}
MessageBox.Show(message);
}
}
private void SuperDogWrite()
{
if (string.IsNullOrEmpty(_keyWriterViewModel.SuperDogGuid))
{
MessageBox.Show("尚未读取超级狗信息");
return;
}
var superDogType = 0;
foreach (var each in _keyWriterViewModel.DogTypes)
{
if (each.IsIncluded)
{
superDogType += each.TypeValue;
}
}
if (superDogType == 0)
{
MessageBox.Show("尚未设置超级狗类型");
return;
}
if (string.IsNullOrEmpty(_keyWriterViewModel.MachineCode))
{
MessageBox.Show("尚未设置机器特征码");
return;
}
if (string.IsNullOrEmpty(_keyWriterViewModel.ExpireDate))
{
MessageBox.Show("尚未设置过期日期");
return;
}
if (MessageBox.Show("确定将信息写入超级狗？", "", MessageBoxButton.YesNo) != MessageBoxResult.Yes)
{
return;
}
try
{
Manufacturer manufacturer = null;
if (CbxManufacturer.SelectedIndex == -1 && !string.IsNullOrEmpty(CbxManufacturer.Text))
{
manufacturer = _superDogDb.AddManufacturer(new Manufacturer {
Name = CbxManufacturer.Text
});
if (manufacturer != null)
{
_keyWriterViewModel.Manufacturers.Add(new ManufacturerViewModel(manufacturer.Id, manufacturer.Name));
_keyWriterViewModel.ManufacturerId = manufacturer.Id;
}
}
var flagSetSuperDogType = _licenseHandler.SetSuperDogType(superDogType);
var flagSetMachineCode = _licenseHandler.SetMachineCode(_keyWriterViewModel.MachineCode);
var flagSetExpireDate = _licenseHandler.SetExpireDate(Convert.ToDateTime(_keyWriterViewModel.ExpireDate));
var flagSetManufacturerId = _licenseHandler.SetManufacturerId(manufacturer != null ? manufacturer.Id : 0);
if (!flagSetSuperDogType)
{
MessageBox.Show("写入超级狗类型发生错误");
}
if (!flagSetMachineCode)
{
MessageBox.Show("写入机器特征码发生错误");
}
if (!flagSetExpireDate)
{
MessageBox.Show("写入过期日期发生错误");
}
if (!flagSetManufacturerId)
{
MessageBox.Show("写入厂商发生错误");
}
if (flagSetSuperDogType && flagSetMachineCode && flagSetExpireDate && flagSetManufacturerId)
{
var superDog = new SuperDog
{
SuperDogGuid = _keyWriterViewModel.SuperDogGuid,
SuperDogType = superDogType,
MachineCode = _keyWriterViewModel.MachineCode,
UpdateDate = _licenseHandler.GetSuperDogDate().ToString("yyyy-MM-dd"),
ExpireDate = _keyWriterViewModel.ExpireDate,
ManufacturerId = _keyWriterViewModel.ManufacturerId,
User = _keyWriterViewModel.User,
Remark = _keyWriterViewModel.Remark
};
_superDogDb.ModifySuperDog(superDog);
}
MessageBox.Show("写入完成");
}
catch
{
MessageBox.Show("写入超级狗信息发生错误");
}
}
