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