public int SaveChances(List <ChanceClass> list, string strDataOwner) { DbChanceList ret = new DbChanceList(); DbClass db = GlobalClass.getCurrDb(); string sql = string.Format("select top 0 * from {0}", strChanceTable); DataTable dt = db.getTableBySqlAndList <ChanceClass>(sql, list); if (dt == null) { ToLog("保存机会数据错误", "根据数据表结构和提供的列表返回的机会列表错误!"); return(-1); } if (strDataOwner == null || strDataOwner.Trim().Length == 0) { sql = string.Format("Select * from {0} where IsEnd=0", strChanceTable); } else { sql = string.Format("Select * from {0} where IsEnd=0 and UserId='{1}'", strChanceTable, strDataOwner); } return(db.UpdateOrNewList(sql, dt)); }
public DbChanceList getNoCloseChances(string strDataOwner) { DbChanceList ret = new DbChanceList(); DbClass db = GlobalClass.getCurrDb(); string sql = null; if (strDataOwner == null || strDataOwner.Trim().Length == 0) { sql = string.Format("Select * from {0} where IsEnd=0", strChanceTable); } else { sql = string.Format("Select * from {0} where IsEnd=0 and UserId='{1}'", strChanceTable, strDataOwner); } DataSet ds = db.Query(sql); if (ds == null) { return(null); } //ToLog("数据库结果",string.Format("未关闭机会数量为{0}",ds.Tables[0].Rows.Count)); ret = new DbChanceList(ds.Tables[0]); return(ret); }