public int add(IConnection pConn, int pCreateUserID) { this._CreateBy = pCreateUserID; this._UpdateBy = pCreateUserID; this._CreateTime = DateTime.Now; this._UpdateTime = DateTime.Now; string SqlStr; int result = 0; SqlStr = "INSERT INTO goods_groups(GroupName, IsActive, TypeID, CreateTime, CreateBy, UpdateTime, UpdateBy) VALUES(" + DbMgr.formatDbString(_GroupName) + ", " + DbMgr.formatDbBool(_IsActive) + ", " + DbMgr.formatDbID(_TypeID) + ", " + DbMgr.formatDbDateTime(_CreateTime) + ", " + DbMgr.formatDbID(_CreateBy) + ", " + DbMgr.formatDbDateTime(_UpdateTime) + ", " + DbMgr.formatDbID(_UpdateBy) + ")"; result = pConn.exeInsertQuery(SqlStr,"goods_groups","GroupID"); _GroupID = result; return result; }