private void OutParentField(DataDiffItem def){
if (def.Fields.ContainsKey("set_parent") ){
var val = def.Fields["set_parent"].Split('-').Last();
var ival = val.ToInt();
if (val == "")
{ //сброс ссылки
_output.Write(", 0, null");
}
else if (ival != 0)
{
_output.Write(", {0}, null", ival);
}
else
{
_output.Write(", null, '{0}'", val.Replace("'", "''"));
}
}
else if (def.Fields.ContainsKey("parent")){
var val = def.Fields["parent"];
var ival = val.ToInt();
if (val == "")
{ //сброс ссылки
_output.Write(", 0, null");
}
else if (ival != 0)
{
_output.Write(", {0}, null", ival);
}
else
{
_output.Write(", null, '{0}'", val.Replace("'", "''"));
}
}
else{
_output.Write(", null, null");
}
}
private void OutUsualField(DataDiffItem def, string allfield){
if (def.Fields.ContainsKey(allfield)){
var val = def.Fields[allfield].Replace("'", "''").Trim();
if (val.IndexOf(',')!=0 && val.ToDecimal(safe:true) != 0){
val = val.Replace(",", ".");
}
_output.Write(", '" + val + "'");
}
else{
_output.Write(", null");
}
}
private void OutMappedField(DataDiffItem def, string allfield){
if (def.Fields.ContainsKey(allfield)){
var val = def.Fields[allfield];
var ival = val.ToInt();
if (val == ""){ //сброс ссылки
_output.Write(", 0, null");
}else if (ival != 0){
_output.Write(", {0}, null", ival);
}
else{
_output.Write(", null, '{0}'", val.Replace("'","''"));
}
}
else
{
_output.Write(", null, null");
}
}
