public bool IsExisted(WorkerAdjustmentInfo info)
{
// db.Open();
String query = "select count(*) from WorkerAdjustment "
+ " where WorkerID = @WorkerID and RowNo = @RowNo";
var obj = (List <int>)db.Query <int>(query, info, this.transaction);
//db.Close();
return(obj[0] > 0);
}
public void Save(WorkerAdjustmentInfo info)
{
if (this.IsExisted(info))
{
this.Update(info);
}
else
{
this.Insert(info);
}
}
public void Update(WorkerAdjustmentInfo info)
{
//db.Open();
string query = " UPDATE [dbo].[WorkerAdjustment] SET "
+ " [RowNo] = @RowNo "
+ ", [AdjustAmount] = @AdjustAmount "
+ ", [UpdateDate] = @UpdateDate "
+ " where WorkerID = @WorkerID and RowNo = @RowNo ";
db.Execute(query, info, this.transaction);
// db.Close();
}
public void Insert(WorkerAdjustmentInfo info)
{
string query = "INSERT INTO [dbo].[WorkerAdjustment] ( [WorkerID] "
+ ",[RowNo] "
+ ",[AdjustAmount] "
+ ",[UpdateDate] "
+ ") "
+ "VALUES ( @WorkerID "
+ ",@RowNo "
+ ",@AdjustAmount "
+ ",@UpdateDate "
+ ") ";
db.Execute(query, info, this.transaction);
}
