public System.Data.DataSet GetListFile(string _projectNO, string ArchiveID)
{
String stmtId = "T_FileList.GetListFile";
MDL.T_FileList obj = new ERM.MDL.T_FileList();
obj.ProjectNO = _projectNO;
obj.ArchiveID = ArchiveID;
System.Data.DataSet result = DAL.MyBatis.QueryForDataSet(stmtId, obj);
return(result);
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <ERM.MDL.T_FileList> GetModelList(string strWhere)
{
DataSet ds = dal.GetList(strWhere);
List <ERM.MDL.T_FileList> modelList = new List <ERM.MDL.T_FileList>();
int rowsCount = ds.Tables[0].Rows.Count;
if (rowsCount > 0)
{
ERM.MDL.T_FileList model;
for (int n = 0; n < rowsCount; n++)
{
model = new ERM.MDL.T_FileList();
model.cjdag = ds.Tables[0].Rows[n]["cjdag"].ToString();
model.datawindow_id = ds.Tables[0].Rows[n]["datawindow_id"].ToString();
model.extension1 = ds.Tables[0].Rows[n]["extension1"].ToString();
model.extension2 = ds.Tables[0].Rows[n]["extension2"].ToString();
model.extension3 = ds.Tables[0].Rows[n]["extension3"].ToString();
model.gclx = ds.Tables[0].Rows[n]["gclx"].ToString();
model.gdwj = ds.Tables[0].Rows[n]["gdwj"].ToString();
model.id = ds.Tables[0].Rows[n]["id"].ToString();
if (ds.Tables[0].Rows[n]["isvisible"].ToString() != "")
{
model.isvisible = int.Parse(ds.Tables[0].Rows[n]["isvisible"].ToString());
}
model.jldw = ds.Tables[0].Rows[n]["jldw"].ToString();
model.jsdw = ds.Tables[0].Rows[n]["jsdw"].ToString();
if (ds.Tables[0].Rows[n]["orderindex"].ToString() != "")
{
model.OrderIndex = int.Parse(ds.Tables[0].Rows[n]["orderindex"].ToString());
}
model.ProjectNO = ds.Tables[0].Rows[n]["ProjectNO"].ToString();
model.pTreePath = ds.Tables[0].Rows[n]["pTreePath"].ToString();
if (ds.Tables[0].Rows[n]["selected"].ToString() != "")
{
model.selected = int.Parse(ds.Tables[0].Rows[n]["selected"].ToString());
}
model.sgdw = ds.Tables[0].Rows[n]["sgdw"].ToString();
model.sjdw = ds.Tables[0].Rows[n]["sjdw"].ToString();
model.table_name = ds.Tables[0].Rows[n]["table_name"].ToString();
model.table_standerd = ds.Tables[0].Rows[n]["table_standerd"].ToString();
model.TreePath = ds.Tables[0].Rows[n]["TreePath"].ToString();
model.wjmj = ds.Tables[0].Rows[n]["wjmj"].ToString();
model.zrr = ds.Tables[0].Rows[n]["zrr"].ToString();
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(ERM.MDL.T_FileList model)
{
dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(ERM.MDL.T_FileList model)
{
dal.Add(model);
}