public void insert(CWorkType p_data) { string l_Sql = ""; l_Sql += "INSERT INTO [KG].[dbo].[tbWorkType] VALUES ("; l_Sql += " '" + p_data.f_typeid洗車種類代碼 + "'"; l_Sql += ", '" + p_data.f_typename洗車種類名稱 + "'"; l_Sql += ", " + p_data.f_money價錢 + ""; l_Sql += ", " + p_data.f_moneyBySmid員工價 + ""; l_Sql += ", " + p_data.f_moneyByIn內部員工薪資 + ""; l_Sql += ", " + p_data.f_moneyByOut外部員工薪資 + ""; l_Sql += ", " + p_data.f_boundByService服務獎金數 + ""; l_Sql += ", " + p_data.f_boundBySmid業代獎金數 + ""; l_Sql += ")"; ivContext.資料管理員.excuteSqlNonquery(l_Sql); }
public void update(CWorkType p_data) { string l_Sql = ""; l_Sql += "UPDATE [KG].[dbo].[tbWorkType]"; l_Sql += "SET [f_typename] =" + p_data.f_typename洗車種類名稱 + "'"; l_Sql += ",[f_money] =" + p_data.f_money價錢 + ""; l_Sql += ",[f_moneyBySmid] =" + p_data.f_moneyBySmid員工價 + ""; l_Sql += " ,[f_moneyByIn]=" + p_data.f_moneyByIn內部員工薪資 + ""; l_Sql += ",[f_moneyByOut] =" + p_data.f_moneyByOut外部員工薪資 + ""; l_Sql += ",[f_boundByService] =" + p_data.f_boundByService服務獎金數 + ""; l_Sql += ",[f_boundBySmid] =" + p_data.f_boundBySmid業代獎金數 + ""; l_Sql += " WHERE [f_typeid] = '" + p_data.f_typeid洗車種類代碼 + "'"; ivContext.資料管理員.excuteSqlNonquery(l_Sql); }
private CWorkType[] queryBySql(string p_sql) { DataView l_dv = ivContext.資料管理員.getDataViewBySql(p_sql); CWorkType[] l_datas = new CWorkType[l_dv.Count]; if (l_dv != null) { for (int i = 0; i < l_datas.Length; i++) { l_datas[i] = createCWorkType(); l_datas[i].f_typeid洗車種類代碼 = l_dv[i]["f_typeid"].ToString(); l_datas[i].f_typename洗車種類名稱 = l_dv[i]["f_typename"].ToString(); l_datas[i].f_money價錢 = Convert.ToInt32(l_dv[i]["f_money"].ToString()); l_datas[i].f_moneyBySmid員工價 = Convert.ToInt32(l_dv[i]["f_moneyBySmid"].ToString()); l_datas[i].f_moneyByIn內部員工薪資 = Convert.ToInt32(l_dv[i]["f_moneyByIn"].ToString()); l_datas[i].f_moneyByOut外部員工薪資 = Convert.ToInt32(l_dv[i]["f_moneyByOut"].ToString()); l_datas[i].f_boundByService服務獎金數 = Convert.ToDouble(l_dv[i]["f_boundByService"].ToString()); l_datas[i].f_boundBySmid業代獎金數 = Convert.ToDouble(l_dv[i]["f_boundBySmid"].ToString()); } return(l_datas); } return(null); }