public CConstruction[] get施工人員明細By單號(string p_strWorkid)
{
string l_Sql = "";
l_Sql += " select c.*,u.f_username";
l_Sql += " from [KG].[dbo].[tbConstruction] c";
l_Sql += " inner join [KG].[dbo].tbUser u on c.f_smid = u.f_userid";
l_Sql += " where f_workid='" + p_strWorkid + "'";
DataView l_dv = ivContext.資料管理員.getDataViewBySql(l_Sql);
CConstruction[] l_datas = new CConstruction[l_dv.Count];
if (l_dv != null)
{
for (int i = 0; i < l_datas.Length; i++)
{
l_datas[i] = createCConstruction();
l_datas[i].f_workid工單單號 = l_dv[i]["f_workid"].ToString();
l_datas[i].f_smid施工人員 = l_dv[i]["f_smid"].ToString();
l_datas[i].f_smid施工人員名稱 = l_dv[i]["f_username"].ToString();
}
return(l_datas);
}
return(null);
}
public void delete(CConstruction p_data)
{
string l_Sql = "";
l_Sql += "delete from [KG].[dbo].[tbConstruction]";
l_Sql += " WHERE [f_workid] = '" + p_data.f_workid工單單號 + "'";
ivContext.資料管理員.excuteSqlNonquery(l_Sql);
}
public void insert(CConstruction p_data)
{
string l_Sql = "";
l_Sql += "INSERT INTO [KG].[dbo].[tbConstruction](f_workid,f_smid) VALUES (";
l_Sql += " '" + p_data.f_workid工單單號 + "'";
l_Sql += ", '" + p_data.f_smid施工人員 + "'";
l_Sql += ")";
ivContext.資料管理員.excuteSqlNonquery(l_Sql);
}
private CConstruction[] queryBySql(string p_sql)
{
DataView l_dv = ivContext.資料管理員.getDataViewBySql(p_sql);
CConstruction[] l_datas = new CConstruction[l_dv.Count];
if (l_dv != null)
{
for (int i = 0; i < l_datas.Length; i++)
{
l_datas[i] = createCConstruction();
l_datas[i].f_workid工單單號 = l_dv[i]["f_workid"].ToString();
l_datas[i].f_smid施工人員 = l_dv[i]["f_smid"].ToString();
}
return(l_datas);
}
return(null);
}
