public bool IsExisted(WorkerClientListInfo info)
{
//db.Open();
String query = "select count(*) from WorkerClientList "
+ " where WorkerID = @WorkerID ";
var obj = (List <int>)db.Query <int>(query, info, this.transaction);
//db.Close();
return(obj[0] > 0);
}
public void Update(WorkerClientListInfo info)
{
//db.Open();
string query = " UPDATE [dbo].[WorkerClientList] SET "
+ " [ClientCode] = @ClientCode "
+ ", [StaffNo] = @StaffNo "
+ ", [EffectiveFrom] = @EffectiveFrom "
+ ", [EffectiveTo] = @EffectiveTo "
+ " where WorkerID = @WorkerID ";
db.Execute(query, info);
//db.Close();
}
public string IsStaffNoDuplicated(WorkerClientListInfo info)
{
//db.Open();
String query = @"
select top 1 * from WorkerClientList
where ClientCode = @ClientCode
and StaffNo = @StaffNo
and (@EffectiveFrom <= EffectiveTo and @EffectiveTo >= EffectiveFrom)
and WorkerID != @WorkerID
";
var obj = (List <WorkerClientListInfo>)db.Query <WorkerClientListInfo>(query, info, this.transaction);
//db.Close();
return(obj.Count > 0 ? obj[0].WorkerID : "");
}
