public override StringBuilder SetTable(EquipmentProperty ep, ChangeID cid)
{
StringBuilder sb = new StringBuilder();
sb.AppendLine("-------------------------------------------------------------------------------------------------");
sb.AppendLine("--> Присвоим значения.");
if (cid.ID == null)
{
sb.AppendLine(String.Format("set @ID ={0};", ep.ID.ToString()));
}
else
{
sb.AppendLine(String.Format("set @ID ={0};", cid.ID.ToString()));
}
sb.AppendLine(String.Format("set @Description = {0};", String.IsNullOrWhiteSpace(ep.Description) ? "Null" : "N'" + ep.Description + "'"));
sb.AppendLine(String.Format("set @Value = {0};", String.IsNullOrWhiteSpace(ep.Value) ? "Null" : "N'" + ep.Value + "'"));
if (cid.ID == null)
{
sb.AppendLine(String.Format("set @EquipmentProperty = {0};", ep.EquipmentProperty1 == null ? "Null" : ep.EquipmentProperty1.ToString()));
}
else
{
sb.AppendLine(String.Format("set @EquipmentProperty = {0};", cid.IDParent == null ? "Null" : cid.IDParent.ToString()));
}
sb.AppendLine(String.Format("set @EquipmentCapabilityTestSpecification = {0};", String.IsNullOrWhiteSpace(ep.EquipmentCapabilityTestSpecification) ? "Null" : "N'" + ep.EquipmentCapabilityTestSpecification + "'"));
sb.AppendLine(String.Format("set @TestResult = {0};", String.IsNullOrWhiteSpace(ep.TestResult) ? "Null" : "N'" + ep.TestResult + "'"));
sb.AppendLine(String.Format("set @EquipmentID = {0};", ep.EquipmentID == null ? "Null" : ep.EquipmentID.ToString()));
sb.AppendLine(String.Format("set @ClassPropertyID = {0};", ep.ClassPropertyID == null ? "Null" : ep.ClassPropertyID.ToString()));
sb.AppendLine(String.Format("set @UnitID = {0};", ep.UnitID == null ? "Null" : ep.UnitID.ToString()));
return(sb);
}
public override StringBuilder SetTable(EquipmentClass ec, ChangeID cid)
{
StringBuilder sb = new StringBuilder();
sb.AppendLine("-------------------------------------------------------------------------------------------------");
sb.AppendLine("--> Присвоим значения.");
//sb.AppendLine(String.Format("set @ID ={0};", ec.ID.ToString()));
if (cid.ID == null)
{
sb.AppendLine(String.Format("set @ID ={0};", ec.ID.ToString()));
}
else
{
sb.AppendLine(String.Format("set @ID ={0};", cid.ID.ToString()));
}
sb.AppendLine(String.Format("set @Description = {0};", String.IsNullOrWhiteSpace(ec.Description) ? "Null" : "N'" + ec.Description + "'"));
sb.AppendLine(String.Format("set @EquipmentLevel = {0};", String.IsNullOrWhiteSpace(ec.EquipmentLevel) ? "Null" : "N'" + ec.EquipmentLevel + "'"));
sb.AppendLine(String.Format("set @HierarchyScope = {0};", ec.HierarchyScope == null ? "Null" : ec.HierarchyScope.ToString()));
//sb.AppendLine(String.Format("set @ParentID = {0};", ec.ParentID == null ? "Null" : ec.ParentID.ToString()));
if (cid.ID == null)
{
sb.AppendLine(String.Format("set @ParentID = {0};", ec.ParentID == null ? "Null" : ec.ParentID.ToString()));
}
else
{
sb.AppendLine(String.Format("set @ParentID = {0};", cid.IDParent == null ? "Null" : cid.IDParent.ToString()));
}
return(sb);
}
/// <summary>
/// Присвоить переменные скрипту
/// </summary>
/// <param name="type_data"></param>
/// <param name="cid"></param>
/// <returns></returns>
public virtual StringBuilder SetTable(T type_data, ChangeID cid)
{
StringBuilder swriter = new StringBuilder();
return(swriter);
}
