public override string queue()
{
if (Item_ID > 1000)
{
string q = "update p set ";
if (!string.IsNullOrEmpty(ItemForma) && Regex.Matches(ItemForma, @"[\dN№]").Count >= 2)
{
q += "ItemForma = '" + ItemForma + "', ";
}
if (!string.IsNullOrEmpty(VendorName) && ItemForma.Length > 5)
{
q += "VendorName = '" + VendorName + "', ";
}
if (ItemUnit_ID > 0)
{
q += "ItemUnit_ID = " + ItemUnit_ID + ", ";
q += "ItemUnit = u.ShortName, ";
}
return(StrCnv.Normalize(q + string.Format(@" DTLastEditForUpdate = getdate()
from[xxx].dbo.ContractItems (nolock) p
left join[xxx].dbo.Units u (nolock) on p.ItemUnit_ID = {0}
where p.Item_ID = {1}", ItemUnit_ID, Item_ID)));
}
else
{
return(string.Empty);
}
}
public override string queue()
{
if (LotSpec_ID > 1000)
{
string q = "update [xxx].dbo.LotSpec set ";
if (!string.IsNullOrEmpty(Form) && Regex.Matches(Form, @"[\dN№]").Count >= 2)
{
q += "Form = '" + Form + "', ";
}
if (Unit_ID > 0)
{
q += "Unit_ID = " + Unit_ID + ", ";
}
return(StrCnv.Normalize(q + @" UPDDATE = getdate() where LotSpec_ID = " + LotSpec_ID));
}
else
{
return(string.Empty);
}
}