public void UpdateSysCode(string scode,string source="SHIFT")
{
var ta = new Syscfg1TableAdapter { Connection = { ConnectionString = _constr } };
ta.UpdateQuery(scode,source, Utils.Company);
}
public void CheckSysCode(string source)
{ var ta = new Syscfg1TableAdapter { Connection = { ConnectionString = _constr } };
var tt = ta.CheckSourceAvailable(source);
if (tt == 0)
{
ta.Insert(source, string.Empty,null, Utils.Company);
}
}
public string GetSysCode(string scode)
{
var ta = new Syscfg1TableAdapter {Connection = {ConnectionString = _constr}};
return (string) ta.GetShiftCode(scode, Utils.Company);
}
