public static QueryBuilder find_DSPhieu_Object(PhieuInfo phieu, string obj_field, string obj_key)
{
QueryBuilder filter = new QueryBuilder("select * from " + phieu.TableName + " where 1=1");
filter.addCondition(obj_field + "='" + obj_key + "'");
return filter;
}
public List<PhieuInfo> getAllPhieu()
{
List<PhieuInfo> list = new List<PhieuInfo>();
QueryBuilder query = new QueryBuilder("select fp.form_class_name, fp.id, fp.caption, " +
"fp.key_field, fp.obj_field, fp.ma_field_name, fp.ngay_tao_fn, " +
"fp.ngay_cn_fn, fp.table_name, fp.class_name from fw_phieu fp " +
"inner join fw_obj_phieu fo on (fp.id=fo.phieu_id) " +
"where obj_id='" + Id + "'" + " and 1=1");
DataSet ds = DABase.getDatabase().LoadDataSet(query);
foreach (DataRow dr in ds.Tables[0].Rows)
{
PhieuInfo phieu = new PhieuInfo();
phieu.Id = (long)dr["ID"];
phieu.Title = dr["CAPTION"].ToString();
phieu.Key_field = dr["KEY_FIELD"].ToString();
phieu.Obj_field = dr["OBJ_FIELD"].ToString();
phieu.Ma_field_name = dr["MA_FIELD_NAME"].ToString();
phieu.Ngay_tao_fn = dr["NGAY_TAO_FN"].ToString();
phieu.Ngay_cn_fn = dr["NGAY_CN_FN"].ToString();
phieu.TableName = dr["TABLE_NAME"].ToString();
phieu.ClassName = dr["CLASS_NAME"].ToString();
phieu.Form_Class_Name = dr["FORM_CLASS_NAME"].ToString();
list.Add(phieu);
}
return list;
}
private QueryBuilder BuildFilterString_Phieu(PhieuInfo phieu, QueryBuilder query)
{
query.addSoPhieu(phieu.Ma_field_name, MaPhieu.Text);
query.addDateFromTo(phieu.Ngay_tao_fn, NgayTao_tu.DateTime, NgayTao_den.DateTime);
query.addDateFromTo(phieu.Ngay_cn_fn, NgayCN_tu.DateTime, NgayCN_den.DateTime);
return query;
}