public void MoChotBangChamCong(DateTime []dsNgayMoChot,string TableName)
{
//foreach (DateTime item in dsNgayMoChot)
//{
// DOChot info = new DOChot { Ngay = item };
// MoChot(info,TableName);
//}
QueryBuilder query = new QueryBuilder("DELETE FROM " + DAChamCongAutoChot.TABLE_MAP + " WHERE 1=1");
query.addDateFromTo("NGAY", dsNgayMoChot[0], dsNgayMoChot[dsNgayMoChot.Length - 1]);
DatabaseFB db = HelpDB.getDatabase();
DbCommand cmd = db.GetSQLStringCommand(query.generateParamSQL());
cmd.Parameters.AddRange(query.generateDbParam().ToArray());
db.ExecuteNonQuery(cmd);
}
private void frmHopDong_Load(object sender, EventArgs e)
{
QueryBuilder query = new QueryBuilder("delete from LOAI_DANH_BA where 1=1");
query.addID("ID", 10110);
DBService db = new DABaseFb().SQLStmt;
db.Begin();
try
{
db.DbCommand.Parameters.AddRange(query.generateDbParam().ToArray());
db.ExecuteCommand(query.generateParamSQL());
db.Commit();
}
catch (Exception ex)
{
db.RollBack();
}
}
/// <summary>
/// Lấy dữ liệu từ chuỗi Sql được dựng từ QueryBuilder
/// </summary>
public bool LoadDataSet(DataSet ds, QueryBuilder query, string tableName)
{
if (ds == null) return false;
if (tableName == null) tableName = "NO_NAME";
try
{
m_cmd.CommandText = query.generateParamSQL();
m_cmd.Parameters.AddRange(query.generateDbParam("PL").ToArray());
LoadDataSet(ds, tableName);
return true;
}
catch
{
return false;
}
finally { }
}
