public void updateCKGPoint(CKGPoint p_code) { string l_strSql = "UPDATE [KG].[dbo].[tbKGPoint] SET "; l_strSql += "[f_Name] = N'" + p_code.f_Name業代姓名 + "',"; l_strSql += "[f_Point] = '" + p_code.f_Point現有點數 + "'"; l_strSql += " WHERE [f_Smid] = '" + p_code.f_Smid業代員編 + "'"; ivContext.資料管理員.excuteSqlNonquery(l_strSql); }
public void updateOldCKGPoint(CKGPoint p_code) { string l_strSql = "UPDATE [KG].[dbo].[tbKGPoint] SET "; l_strSql += "[f_Point] = (f_Point + " + p_code.f_Point現有點數.ToString() + ") ,";//有點數資料的加上匯入的點數 l_strSql += "[f_Name] = N'" + p_code.f_Name業代姓名 + "'"; l_strSql += " WHERE f_Smid = '" + p_code.f_Smid業代員編 + "'"; ivContext.資料管理員.excuteSqlNonquery(l_strSql); }
public void insertCKGPoint(CKGPoint p_code) { string l_strSql = "INSERT INTO [KG].[dbo].[tbKGPoint] ([f_Smid],[f_Name],[f_Point])VALUES("; l_strSql += " '" + p_code.f_Smid業代員編 + "' "; l_strSql += ", N'" + p_code.f_Name業代姓名 + "' "; l_strSql += ", '" + p_code.f_Point現有點數 + "' "; l_strSql += ")"; ivContext.資料管理員.excuteSqlNonquery(l_strSql); }
private CKGPoint[] queryBySql(string p_sql) { DataView l_dv = ivContext.資料管理員.getDataViewBySql(p_sql); List <CKGPoint> l_datas = new List <CKGPoint>(); if (l_dv.Count > 0) { for (int i = 0; i < l_dv.Count; i++) { CKGPoint l_code = createCKGPoint(); l_code.f_Smid業代員編 = l_dv[i]["f_Smid"].ToString(); l_code.f_Name業代姓名 = l_dv[i]["f_Name"].ToString(); l_code.f_Point現有點數 = Convert.ToInt32(l_dv[i]["f_Point"].ToString()); l_datas.Add(l_code); } return(l_datas.ToArray()); } else { return(null); } }
/// <summary> /// //(Yu 20090617) 用Hashtable將點數匯入虛擬帳戶並寫入匯入記錄 /// </summary> /// <param name="p_codes"></param> public void insert點數與記錄ByHashtable(Hashtable p_ht) { foreach (string l_strSmid in p_ht.Keys) { string l_strSql = "SELECT * FROM [KG].[dbo].[tbKGPoint] WHERE f_Smid ='" + l_strSmid + "'"; DataView l_dv = ivContext.資料管理員.getDataViewBySql(l_strSql); CKGPoint l_code = createCKGPoint(); l_code.f_Smid業代員編 = l_strSmid; l_code.f_Name業代姓名 = ((List <CKGPointDetail>)p_ht[l_strSmid])[0].f_Name業代姓名; l_code.f_Point現有點數 = sum((List <CKGPointDetail>)p_ht[l_strSmid]); if (l_dv.Count > 0) { updateOldCKGPoint(l_code);; //有點數資料的加上匯入的點數 } else { insertCKGPoint(l_code);//沒有點數資料的直接新增 } CKGPointDetailFactory l_factory = new CKGPointDetailFactory(ivContext); l_factory.insertCKGPointDetailBy點數匯入(((List <CKGPointDetail>)p_ht[l_strSmid]).ToArray()); } }