private CKGPartOrderDetail[] queryBySql(string p_sql)
{
DataView l_dv = ivContext.資料管理員.getDataViewBySql(p_sql);
List <CKGPartOrderDetail> l_datas = new List <CKGPartOrderDetail>();
if (l_dv.Count > 0)
{
for (int i = 0; i < l_dv.Count; i++)
{
CKGPartOrderDetail l_code = createCKGPartOrderDetail();
l_code.f_ExchangeID請購單號 = l_dv[i]["f_ExchangeID"].ToString();
//l_code.f_AssistantSmid助理員編 = l_dv[i]["f_AssistantSmid"].ToString();
//l_code.f_SalesSmid業代員編 = l_dv[i]["f_SalesSmid"].ToString();
l_code.f_ProductID產品編號 = l_dv[i]["f_ProductID"].ToString();
l_code.f_ProductName產品名稱 = l_dv[i]["f_ProductName"].ToString();
l_code.f_Amount選購數量 = Convert.ToInt32(l_dv[i]["f_Amount"].ToString());
l_code.f_Qty產品單位 = l_dv[i]["f_Qty"].ToString();
l_code.f_Cost產品成本價 = Convert.ToInt32(l_dv[i]["f_Cost"].ToString());
l_code.f_UnitPrice產品單價 = Convert.ToInt32(l_dv[i]["f_UnitPrice"].ToString());
l_code.f_ListPrice建議售價 = Convert.ToInt32(l_dv[i]["f_ListPrice"].ToString());
l_code.f_Total總計價格 = Convert.ToInt32(l_dv[i]["f_Total"].ToString());
l_code.f_EditDate編輯日期 = l_dv[i]["f_EditDate"].ToString();
l_code.f_SalePrice販賣價 = Convert.ToInt32("0" + l_dv[i]["f_SalePrice"].ToString());
l_datas.Add(l_code);
}
return(l_datas.ToArray());
}
else
{
return(null);
}
}
/// <summary>
/// (way 20130520) 取得請購明細By請購單號s
/// </summary>
/// <param name="p_strExchangeID">請購單號s</param>
/// <returns></returns>
public CKGPartOrderDetail[] get請購明細ByExchangeID(List <string> p_strExchangeIDs)
{
//string l_strSql = "SELECT * FROM [KG].[dbo].[tbKGPartOrderDetail] WHERE f_ExchangeID='" + p_strExchangeID + "'";
if (p_strExchangeIDs.Count <= 0)
{
return(null);
}
string l_strSql = "SELECT d.*,c.Name";
l_strSql += " FROM [KG].[dbo].[tbKGPartOrderDetail] d";
l_strSql += " inner join dbo.tbKGPartOrder p on d.f_ExchangeID = p.f_ExchangeID";
l_strSql += " left join kddb..orders o on o.EngNo = p.f_engineno";
l_strSql += " left join kddb..customer c on o.customerid = c.customerid";
string l_str = "";
for (int i = 0; i < p_strExchangeIDs.Count; i++)
{
l_str += "'" + p_strExchangeIDs[i] + "',";
}
l_strSql += " WHERE d.f_ExchangeID in (" + l_str.Substring(0, l_str.Length - 1) + ")";
l_strSql += " order by d.f_EditDate";
DataView l_dv = ivContext.資料管理員.getDataViewBySql(l_strSql);
List <CKGPartOrderDetail> l_datas = new List <CKGPartOrderDetail>();
if (l_dv.Count > 0)
{
for (int i = 0; i < l_dv.Count; i++)
{
CKGPartOrderDetail l_code = createCKGPartOrderDetail();
l_code.f_ExchangeID請購單號 = l_dv[i]["f_ExchangeID"].ToString();
//l_code.f_AssistantSmid助理員編 = l_dv[i]["f_AssistantSmid"].ToString();
//l_code.f_SalesSmid業代員編 = l_dv[i]["f_SalesSmid"].ToString();
l_code.f_ProductID產品編號 = l_dv[i]["f_ProductID"].ToString();
l_code.f_ProductName產品名稱 = l_dv[i]["f_ProductName"].ToString();
l_code.f_Amount選購數量 = Convert.ToInt32(l_dv[i]["f_Amount"].ToString());
l_code.f_Qty產品單位 = l_dv[i]["f_Qty"].ToString();
l_code.f_Cost產品成本價 = Convert.ToInt32(l_dv[i]["f_Cost"].ToString());
l_code.f_UnitPrice產品單價 = Convert.ToInt32(l_dv[i]["f_UnitPrice"].ToString());
l_code.f_ListPrice建議售價 = Convert.ToInt32(l_dv[i]["f_ListPrice"].ToString());
l_code.f_Total總計價格 = Convert.ToInt32(l_dv[i]["f_Total"].ToString());
l_code.f_EditDate編輯日期 = l_dv[i]["f_EditDate"].ToString();
l_code.f_SalePrice販賣價 = Convert.ToInt32("0" + l_dv[i]["f_SalePrice"].ToString());
l_code.顧客姓名 = l_dv[i]["Name"].ToString();
l_datas.Add(l_code);
}
return(l_datas.ToArray());
}
else
{
return(null);
}
}
public void updateCKGPartOrderDetail(CKGPartOrderDetail p_code)
{
string l_strSql = "UPDATE [kdnews].[dbo].[tbKGPartOrderDetail] SET ";
l_strSql += "[f_AssistantSmid] = '" + p_code.f_AssistantSmid助理員編 + "',";
l_strSql += "[f_SalesSmid] = '" + p_code.f_SalesSmid業代員編 + "',";
l_strSql += "[f_ProductID] = '" + p_code.f_ProductID產品編號 + "',";
l_strSql += "[f_ProductName] = '" + p_code.f_ProductName產品名稱.Replace("'", "''") + "',";
l_strSql += "[f_Amount] = '" + p_code.f_Amount選購數量 + "',";
l_strSql += "[f_Cost] = '" + p_code.f_Cost產品成本價 + "',";
l_strSql += "[f_UnitPrice] = '" + p_code.f_UnitPrice產品單價 + "',";
l_strSql += "[f_Total] = '" + p_code.f_Total總計價格 + "',";
l_strSql += "[f_EditDate] = '" + p_code.f_EditDate編輯日期 + "'";
l_strSql += " WHERE f_ExchangeID = '" + p_code.f_ExchangeID請購單號 + "'";
ivContext.資料管理員.excuteSqlNonquery(l_strSql);
}
